The Arcive of Official vBulletin Modifications Site.

khobar · #11 06-07-2002, 08:23 PM

thanks alot Logician for replying. I have to tell you that I'm so bad in MYSQL and I'm afraid if I touch anything I will miss it up.
in this reply, I included most of the tables that have to do with users from phpmyadmin. and if you can point for me what you were talking about. I hope you'll catch the error and makes it easy for me

======================
Database alkhobar_vb - table user running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
userid int(10) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
usergroupid smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
username varchar(50) No Change Drop Primary Index Unique Fulltext
password varchar(50) No Change Drop Primary Index Unique Fulltext
email varchar(50) No Change Drop Primary Index Unique Fulltext
styleid smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
parentemail varchar(50) No Change Drop Primary Index Unique Fulltext
coppauser smallint(6) No 0 Change Drop Primary Index Unique Fulltext
homepage varchar(100) No Change Drop Primary Index Unique Fulltext
icq varchar(20) No Change Drop Primary Index Unique Fulltext
aim varchar(20) No Change Drop Primary Index Unique Fulltext
yahoo varchar(20) No Change Drop Primary Index Unique Fulltext
signature mediumtext No Change Drop Primary Index Unique Fulltext
adminemail smallint(6) No 0 Change Drop Primary Index Unique Fulltext
showemail smallint(6) No 0 Change Drop Primary Index Unique Fulltext
invisible smallint(6) No 0 Change Drop Primary Index Unique Fulltext
usertitle varchar(250) No Change Drop Primary Index Unique Fulltext
customtitle smallint(6) No 0 Change Drop Primary Index Unique Fulltext
joindate int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
cookieuser smallint(6) No 0 Change Drop Primary Index Unique Fulltext
daysprune smallint(6) No 0 Change Drop Primary Index Unique Fulltext
lastvisit int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
lastactivity int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
lastpost int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
posts smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
timezoneoffset varchar(4) No Change Drop Primary Index Unique Fulltext
emailnotification smallint(6) No 0 Change Drop Primary Index Unique Fulltext
buddylist mediumtext No Change Drop Primary Index Unique Fulltext
ignorelist mediumtext No Change Drop Primary Index Unique Fulltext
pmfolders mediumtext No Change Drop Primary Index Unique Fulltext
receivepm smallint(6) No 0 Change Drop Primary Index Unique Fulltext
emailonpm smallint(6) No 0 Change Drop Primary Index Unique Fulltext
pmpopup smallint(6) No 0 Change Drop Primary Index Unique Fulltext
avatarid smallint(6) No 0 Change Drop Primary Index Unique Fulltext
options smallint(6) No 15 Change Drop Primary Index Unique Fulltext
birthday date No 0000-00-00 Change Drop Primary Index Unique Fulltext
maxposts smallint(6) No -1 Change Drop Primary Index Unique Fulltext
startofweek smallint(6) No 1 Change Drop Primary Index Unique Fulltext
ipaddress varchar(20) No Change Drop Primary Index Unique Fulltext
referrerid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
nosessionhash smallint(6) No 0 Change Drop Primary Index Unique Fulltext
inforum smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
receivebulletin smallint(5) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext
award tinytext No Change Drop Primary Index Unique Fulltext
========================
Database alkhobar_vb - table useractivation running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
useractivationid int(10) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
userid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
dateline int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
activationid char(20) No Change Drop Primary Index Unique Fulltext
type smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
==========================
Database alkhobar_vb - table useraward running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
id smallint(5) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
awardsid smallint(5) No 0 Change Drop Primary Index Unique Fulltext
userid smallint(5) No 0 Change Drop Primary Index Unique Fulltext
name varchar(60) No Change Drop Primary Index Unique Fulltext
url varchar(100) No Change Drop Primary Index Unique Fulltext
aw smallint(4) No 0 Change Drop Primary Index Unique Fulltext
===========================
Database alkhobar_vb - table userfield running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
userid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
field1 char(250) No Change Drop Primary Index Unique Fulltext
field2 char(250) No Change Drop Primary Index Unique Fulltext
field3 char(250) No Change Drop Primary Index Unique Fulltext
field4 char(250) No Change Drop Primary Index Unique Fulltext
field5 char(250) No Change Drop Primary Index Unique Fulltext
===========================
Database alkhobar_vb - table usergroup running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
usergroupid smallint(5) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
title char(100) No Change Drop Primary Index Unique Fulltext
usertitle char(100) No Change Drop Primary Index Unique Fulltext
cancontrolpanel smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canmodifyprofile smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canviewmembers smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canview smallint(6) No 0 Change Drop Primary Index Unique Fulltext
cansearch smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canemail smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpostnew smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canmove smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canopenclose smallint(6) No 0 Change Drop Primary Index Unique Fulltext
candeletethread smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canreplyown smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canreplyothers smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canviewothers smallint(6) No 0 Change Drop Primary Index Unique Fulltext
caneditpost smallint(6) No 0 Change Drop Primary Index Unique Fulltext
candeletepost smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canusepm smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpostpoll smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canvote smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpostattachment smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpublicevent smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpublicedit smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canthreadrate smallint(6) No 1 Change Drop Primary Index Unique Fulltext
maxbuddypm smallint(6) UNSIGNED No 5 Change Drop Primary Index Unique Fulltext
maxforwardpm smallint(6) UNSIGNED No 5 Change Drop Primary Index Unique Fulltext
cantrackpm smallint(6) No 1 Change Drop Primary Index Unique Fulltext
candenypmreceipts smallint(6) No 1 Change Drop Primary Index Unique Fulltext
ismoderator smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canwhosonline smallint(6) No 1 Change Drop Primary Index Unique Fulltext
canwhosonlineip smallint(6) No 0 Change Drop Primary Index Unique Fulltext
showgroup smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
cangetattachment smallint(6) No 1 Change Drop Primary Index Unique Fulltext
==============================
Database alkhobar_vb - table usertitle running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
usertitleid smallint(5) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
minposts smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
title char(250) No Change Drop Primary Index Unique Fulltext
==============================

I know this looks funny but it's more safe for me this way .

best regards

Logician · #12 06-07-2002, 09:11 PM

Look at your query:

INSERT INTO user (userid,usergroupid,........) VALUES (NULL,'2',....)

With this query you command MYSQL to insert to user table:
for userid field VALUE null,
for usergroupid field VALUE 2
etc.
etc.

Now count the fields between the first ()s. (They are your fields) and then count the values between second ()s, (They are your values to insert into these fields), they simply dont match. You either miss a field name or value.

If you are applying a hack, this query is wrong so it means that you didnt apply it correctly. If you formed the query by yourself it either means you added a field to an existing query but you didnt add its value OR you added a value without mentioning its field.

You have to check them one by one and see which value or field is missing or extra. Your table structure has nothing to do with this error.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08693 seconds Memory Usage 2,187KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (2)post_thanks_box (2)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (2)post_thanks_postbit_info (2)postbit (2)postbit_onlinestatus (2)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory 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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!