Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
mySQL error Details »»
mySQL error
Version: , by Mijae Mijae is offline
Developer Last Online: Aug 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-23-2003 Last Update: Never Installs: 0
 
No support by the author.

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'1498','1051062010','91932666',0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 22nd of April 2003 07:40:10 PM
Script: http://www.url.com/forum/forum/admin/email.php
Referer: http://www.url.com/forum/admin/email.php?action=start&

It has never happened to me before, I've been trying to email users their activation codes...

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 04-23-2003, 01:35 AM
DigitalDesktops DigitalDesktops is offline
 
Join Date: Mar 2003
Location: Scotland, UK
Posts: 161
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you're missing the "usergroupid" column
Reply With Quote
  #3  
Old 04-23-2003, 03:57 AM
Mijae's Avatar
Mijae Mijae is offline
 
Join Date: Nov 2001
Location: Russia
Posts: 523
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

And to fix that...? I dont really know why its not there...
Reply With Quote
  #4  
Old 04-23-2003, 04:01 AM
DigitalDesktops DigitalDesktops is offline
 
Join Date: Mar 2003
Location: Scotland, UK
Posts: 161
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

search for this in email.php(Unhacked):

PHP Code:
                                INSERT INTO useractivation 
make sure below that it says:

PHP Code:
                                    (useractivationiduseriddatelineactivationidtypeusergroupid)
                                
VALUES
                                    
(NULL$activate[activationid], ".time()."'$user[activationid]'02)
                            
"); 
if it doesn't say that, replace the query, with the one above. hope this helps.
Reply With Quote
  #5  
Old 04-23-2003, 05:23 PM
Mijae's Avatar
Mijae Mijae is offline
 
Join Date: Nov 2001
Location: Russia
Posts: 523
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
					  //check for existing one...if not generate new one
						if (!$activate=$DB_site->query_first("SELECT activationid FROM useractivation WHERE userid='$user[userid]' AND type=0")) {
							// or generate new one!
							// delete old activation id
							$DB_site->query("DELETE FROM useractivation WHERE userid='$user[userid]' AND type=0");

							// make random number
							mt_srand ((double) microtime() * 1000000);
							$activate[activationid]=mt_rand(0,100000000);

							//save to DB
							$DB_site->query("INSERT INTO useractivation VALUES (NULL,'$user[userid]','".time()."','$activate[activationid]',0)");
						}
					}

					$sendmessage=str_replace("\$activateid",$activate[activationid],$sendmessage);
				}
				$sendmessage=str_replace("\$bburl",$bburl,$sendmessage);
				$sendmessage=str_replace("\$bbtitle",$bbtitle,$sendmessage);

				if (!$test) {
					echo "sending ... \n";
					vbmail($user['email'], $subject, $sendmessage, $from);
				} else {
					echo "testing ... \n";
				}

				echo "ok<br>\n";
Thats the code that has the INSERT INTO useractivation and yes this is an unhacked email.php from vb2.3.0
Reply With Quote
  #6  
Old 04-23-2003, 10:47 PM
DigitalDesktops DigitalDesktops is offline
 
Join Date: Mar 2003
Location: Scotland, UK
Posts: 161
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 06:23 PM v0id said this in Post #5
Code:
					  //check for existing one...if not generate new one
						if (!$activate=$DB_site->query_first("SELECT activationid FROM useractivation WHERE userid='$user[userid]' AND type=0")) {
							// or generate new one!
							// delete old activation id
							$DB_site->query("DELETE FROM useractivation WHERE userid='$user[userid]' AND type=0");

							// make random number
							mt_srand ((double) microtime() * 1000000);
							$activate[activationid]=mt_rand(0,100000000);

							//save to DB
							$DB_site->query("INSERT INTO useractivation VALUES (NULL,'$user[userid]','".time()."','$activate[activationid]',0)");
						}
					}

					$sendmessage=str_replace("\$activateid",$activate[activationid],$sendmessage);
				}
				$sendmessage=str_replace("\$bburl",$bburl,$sendmessage);
				$sendmessage=str_replace("\$bbtitle",$bbtitle,$sendmessage);

				if (!$test) {
					echo "sending ... \n";
					vbmail($user['email'], $subject, $sendmessage, $from);
				} else {
					echo "testing ... \n";
				}

				echo "ok<br>\n";
Thats the code that has the INSERT INTO useractivation and yes this is an unhacked email.php from vb2.3.0
VB - 2.3.0

Replace This:
PHP Code:
(NULL,'$user[userid]','".time()."','$activate[activationid]',0)"); 
With this code:
PHP Code:
(NULL$activate[activationid], ".time()."'$user[activationid]'02)"); 
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 01:15 AM.


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.04113 seconds
  • Memory Usage 2,266KB
  • Queries Executed 21 (?)
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
  • (2)bbcode_code
  • (4)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (5)postbit
  • (6)postbit_onlinestatus
  • (6)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