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

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2003, 09:19 AM
007's Avatar
007 007 is offline
 
Join Date: Jan 2003
Location: United States
Posts: 872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default PLEASE HELP! SQL error in forgot password / member.php

First of all, I originally posted this here so sorry if I'm not supposed to post it again, but I REALLY need help with this. Here's my error message:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'1','1046047937','48267631',1)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

It said this was in my member.php and here is what I have:
PHP Code:
$DB_site->query("INSERT INTO useractivation VALUES (NULL,'$user[userid]','".time()."','$user[activationid]',1)"); 
What should I do now? Can somebody help please?

Also, how do I reset the userid's

I have 11 users that show up. I made another user (would have had userid 12) but before that I had changed one user to 99 temprarily so I could switch two id's. the user that was supposed to be #12 was then made to 100. how do I reset this so this user is 12, and that he shows up in the lsit of users in admin cp? I have changed his id to 12 in phpMyAdmin and now he does not show up at all in admin cp... I want it so the next person who signs up will be #13, and non 101. Any help here would also be appreciated. Thank you.
Reply With Quote
  #2  
Old 02-24-2003, 09:56 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

reupload the original member.php

since the useractivation part has changed within 2.3.0 you have to do so..

id question: it doesn't hurt as it is, just remeber it.
there is an sql query to reset the autoincrese (search around a bit, i don't know it from mind now..)

if you change an userid in usertable, you have to change his id in unserfield table, too or you cant edit him anymore
Reply With Quote
  #3  
Old 02-24-2003, 11:43 AM
007's Avatar
007 007 is offline
 
Join Date: Jan 2003
Location: United States
Posts: 872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Xenon. That ID thing worked great.

As for my other problem.. I actually started to upgrade to 3.0 and I decided not to for now because I wouldn't have time right now to reinstall all my hacks.

So I am supposedly back to 2.2.9, although my version number is still 3.0.. I screwed something up.. Anyway, I still get the same SQL error when reuploading the 2.2.9 member.php

Would it help if I attached it? You can remove it once you look at it if that would help. Thanks a lot for helping me out
Reply With Quote
  #4  
Old 02-24-2003, 11:55 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

well, you had already run the upgradeXX.php so you have to upload th 2.3.0 member.php not the 229 one
Reply With Quote
  #5  
Old 02-24-2003, 01:20 PM
007's Avatar
007 007 is offline
 
Join Date: Jan 2003
Location: United States
Posts: 872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

cool, thanks. Actually, I just restored from my last 2.2.9 backup (which was only like a day old) and everything is fine now. I'll probably upgrade once I get that araxis merge software.
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 03:51 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03508 seconds
  • Memory Usage 2,198KB
  • 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)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete