mySQL error

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...

[DigitalDesktops]

you're missing the "usergroupid" column

[Mijae]

And to fix that...? I dont really know why its not there...

[DigitalDesktops]

search for this in email.php(Unhacked):

PHP Code:

                                INSERT INTO useractivation 


make sure below that it says:

PHP Code:

                                    (useractivationid, userid, dateline, activationid, type, usergroupid)
                                VALUES
                                    (NULL, $activate[activationid], ".time().", '$user[activationid]', 0, 2)
                            "); 


if it doesn't say that, replace the query, with the one above. hope this helps.

[Mijae]

					  //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

[DigitalDesktops]

Today at 06:23 PM v0id said this in Post #5

					  //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]', 0, 2)");