Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2005, 02:31 PM
taffy056 taffy056 is offline
 
Join Date: Sep 2004
Location: In a house in Wales ;)
Posts: 254
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default mysql error number: 1136

Hi,

I have a problem with people regisitering on my forums, it is probably related to a hack, can someone determine which hack is the problem from the info below, or maybe have a solution.

thanks
taffy

installed hacks:

Petz
Arcade
RPG
Vbookie
vbchat
Shoutbox Ver 1.04
vstocks


Code:
Database error in vBulletin 3.0.5:
 
Invalid SQL: 
 
INSERT INTO user
 
(username, salt, password, passworddate, email, parentemail,
 
showvbcode, usertitle, joindate, daysprune, lastvisit, lastactivity, usergroupid, timezoneoffset,
 
options, maxposts, threadedmode, startofweek, ipaddress, pmpopup, referrerid,
 
reputationlevelid, reputation, autosubscribe, birthday, birthday_search)
 
VALUES
 
('testing',
 
'}u`',
 
'2f24bed5f62b0cd5c1f17568fcbe7f1d',
 
NOW(),
 
'testing@DOMAIN.net.uk',
 
7,
 
'',
 
1,
 
'Junior Member',
 
1105541745,
 
0,
 
1105541745,
 
1105541745,
 
3,
 
'0',
 
3159,
 
-1,
 
0,
 
1,
 
'84.*.*.*',
 
0,
 
0,
 
5,
 
10,
 
-1,
 
'05-05-0000',
 
'0000-05-05'
 
)
 
 
 
mysql error: Column count doesn't match value count at row 1
 
mysql error number: 1136
 
Date: Wednesday 12th of January 2005 03:55:45 PM
 
Script: http://domain.com/forum/register.php
 
Referer: http://domain.com/forum/register.php
 
Username: testing
 
IP Address: 84.*.*.*
 
Reply With Quote
  #2  
Old 01-12-2005, 03:46 PM
manguish manguish is offline
 
Join Date: Apr 2003
Location: UK
Posts: 204
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

When did the problem occur?

What was the last hack installed?

Think about these - if all was well until you installed something (i'm guessing you didn't hack them all at once without testing) then that'll point the finger.
Reply With Quote
  #3  
Old 01-12-2005, 03:53 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Check the changes you made to register.php.

The query which generates the error tries to insert a value (7) between email and parentemail for which the columnname is not defined.
Reply With Quote
  #4  
Old 01-12-2005, 10:09 PM
taffy056 taffy056 is offline
 
Join Date: Sep 2004
Location: In a house in Wales ;)
Posts: 254
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi Kirby,

Thanks for the answer to the problem, after checking register.php I discovered a stray line of code from a hack I removed, once deleted everything is fine

taffy
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:25 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03678 seconds
  • Memory Usage 2,186KB
  • Queries Executed 13 (?)
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)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete