The Arcive of Official vBulletin Modifications Site.

Can't add a user · **Released**: 03-12-2002

Kind of a weird problem and I'm stumped on it.

I'm running v 2.2.4 at britpack.com

Users can register just fine, but when I try to Add a user via the admin cp, I get this error:

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) VALUES (NULL,'2','Jonny Lee Miller','17f1df9f24dcdbbad02ae0f620e4ca53','jonny@ britpack.com','2','','0','http://www.','','','','','1','1','1','0','','0',101593846 4,'1','-1',1015938464,1015938464,1015938464,'0','0','1','1 ','0','','0','15','')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 12th of March 2002 06:07:44 AM
Script: http://www.britpack.com/admin/user.php
Referer: http://www.britpack.com/admin/user.php?action=add

Can anyone shed a little light on this for me? Thanks!

Admin · #2 03-12-2002, 11:57 AM

Did you install any hacks?

Sadie Frost · #3 03-12-2002, 01:47 PM

Yes, sorry - here is a list of the ones installed. Some of the names might not be exactly as they appear on here though - sorry about that.

1. Welcome Panel
2. Avatar categories
3. threads/posts since your last visit
4. Signature Editor w/ preview
5. clickable avatar on main page (links to edit avatar)
6. Top Referrer
7. Top Poster
8. Top Thread Starter
9. Quick Reply Box
10. Static Post Count
11. Link to edit member's sig in post
12. Community Bulletin Generator
13. Happy Birthday emails
14. Edit Reason
15. Away Reason
16. VBstats
17. quote box
18. number of users online today
19. pm popup
20. popup for guests (logout to see this one once boards are open)
21. stealth moderators on who's online
22. return to forum after post
23. bump without post
24. what style are we using
25. Today's events on main page
26. pm thread starter on thread move
27. total thread views
28. total posts today
29. remove location if none is given
30. gender image hack

The only thing I could think of is that for some reason it's not assigning a userid number when I'm adding members manually.

Admin · #4 03-12-2002, 01:48 PM

Can you run a DESCRIBE user; query from phpMyAdmin, and tell me what you get?

Sadie Frost · #5 03-12-2002, 01:55 PM

Not sure how you wanted me to give this to you - hope it's okay

Admin · #6 03-12-2002, 01:59 PM

Damn you got lots of field there... one more thing, look at user.php for this:

Code:

  $options+=iif($showvbcode==1,SHOWVBCODE,0);

right after that, you should have a HUUUUUGE line that starts with $DB_site, paste that line here.

(sorry for asking so many questions

)

Sadie Frost · #7 03-12-2002, 02:13 PM

No problem - I really appreciate your help with this!

$DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepa ge,icq,aim,yahoo,signature,adminemail,receivebulle tin,receivebulletin_type,showe mail,invisible,usertitle,customtitle,joindate,cook ieuser,daysprune,lastvisit,las tactivity,lastpost,posts,timezoneoffset,emailnotif ication,receivepm,emailonpm,ip address,pmpopup,options,birthday) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchar s($ausername))."','".addslashe s(md5($apassword))."','".addslashes(htmlspecialcha rs($email))."','$userstyleid', '".addslashes(htmlspecialchars($parentemail))."',' $coppauser','".addslashes(html specialchars($homepage))."','".addslashes(htmlspec ialchars($icq))."','".addslash es(htmlspecialchars($aim))."','".addslashes(htmlsp ecialchars($yahoo))."','".adds lashes($signature)."','$adminemail','$receivebulle tin','$showemail','$invisible' ,'".addslashes($usertitle)."','$customtitle',$join date,'$cookieuser','$daysprune ',$lastvisit,$lastactivity,$lastpost,'$posts','$ti mezoneoffset','$emailnotificat ion','$receivepm','$emailonpm','".addslashes($aipa ddress)."','$pmpopup','$option s','$birthday')");

Admin · #8 03-12-2002, 02:20 PM

Ok, in that line, add

Code:

,'$receivebulletin_type'

right after:

Code:

'$receivebulletin'

(note the commas!)

Sadie Frost · #9 03-12-2002, 03:00 PM

That fixed it! Thank you so much Firefly - you're the best!

Admin · #10 03-12-2002, 03:02 PM

No probs Sadie.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04371 seconds Memory Usage 2,311KB Queries Executed 24 (?)
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 (3)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (1)postbit_attachment (10)postbit_onlinestatus (10)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 postbit_attachment 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!