Thread: Add-On Releases - afterfl0w's Advanced Banlist
View Single Post
  #2  
Old 08-12-2006, 09:55 PM
Jesus05uk Jesus05uk is offline
 
Join Date: Feb 2006
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm getting this:
Code:
Database error in vBulletin 3.6.0 Release Candidate 3:

Invalid SQL:
CREATE TABLE banlist (
         banid int(10) unsigned NOT NULL auto_increment,
         userid smallint(5) NOT NULL DEFAULT '',
		 usergroupid smallint(5) NOT NULL DEFAULT '',
         username varchar(50) NOT NULL DEFAULT '',
         dateline int(10) unsigned NOT NULL DEFAULT '',
         bannedpost varchar(255) NOT NULL DEFAULT '',
         reason varchar(255) NOT NULL DEFAULT '',
         sentbywhom varchar(50) NOT NULL DEFAULT '',
         howlong int(10) unsigned NOT NULL DEFAULT '',
         INDEX (banid, userid)
                );

MySQL Error  : Invalid default value for 'userid'
Error Number : 1067
Date         : Saturday, August 12th 2006 @ 03:49:32 PM
Script       : http://forums.gmodcentral.com/admincp/plugin.php?do=productimport
Referrer     : http://forums.gmodcentral.com/admincp/plugin.php?do=productadd
IP Address   : 82.44.204.98
Username     : Jesus
Classname    : vb_database
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01392 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete