PDA

View Full Version : SQL Database Error vb_cron


abroad
04-16-2008, 02:00 PM
Does anybody know what I have to do here:

Database error in vBulletin 3.7.0 Release Candidate 2:

Invalid SQL:

SELECT cron.*
FROM vb_cron AS cron
LEFT JOIN vb_product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1208357494 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;

MySQL Error : Got error 124 from storage engine
Error Number : 1030
Date : Wednesday, April 16th 2008 @ 04:51:34 PM
Script : http://www.abc.com/cron.php?rand=47481
Referrer : http://www.abc.com/group.php?groupid=4
IP Address : 62.237.224.154

snakes1100
04-16-2008, 05:06 PM
Run a repair on your db from the admincp maintenance section and also rebuild your indexes, which is right under the repair in the same location, you need to have the mysql-schema.php file uploaded to the /install directory for the index rebuild, that file is located in the vbulletin/do_not_upload directory of your original zip from vbulletin.

SEOvB
04-16-2008, 05:08 PM
Should also be located in the install folder if you didn't delete that entire folder :D

Buy MySQL error: 124 = Wrong index given to function. So if repairing the DB doesnt solve the issue, you may need to disable all your plugins and products and then try to run the cron again.

snakes1100
04-16-2008, 05:10 PM
doh, thats correct, that file is in the install folder, long morning....