SQL Error

[abroad]

Hi, I get this SQL Error. What do I have to do?

Invalid SQL:
SELECT cron.*
FROM vb_cron AS cron
LEFT JOIN vb_product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1208465999 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

[Steve Machol]

That error means one of the following:

System error: 124 = Wrong medium type
MySQL error: 124 = Wrong index given to function

Try this. run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

If you still have this problem after that, run this:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Fix Unique Indexes

[abroad]

tried both but still get an error!

Invalid SQL:

SELECT cron.*
FROM vb_cron AS cron
LEFT JOIN vb_product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1208586473 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

[Steve Machol]

Then I'm afraid you are going to have to ask your host to fix this.

[abroad]

how should my host fix this? There is something wrong with the cronjob and I get every minute an email

[Steve Machol]

Sorry, I don't know how your host can fix this. If I knew more about that specific error then I would certainly not hesitate to share this information with you. Since repair does not work, then it's a more serious problem that your host will need to investigate and fix.

[abroad]

but it worked before without having this error. I tried to integrate vbulletin with drupal but reverted it. Now i get this error the whole time...so it should be something with the Database...just dont know what ...

[Jose Amaral Rego]

Post the exact steps in what you have done to "integrate vbulletin with drupal" and maybe someone here can tell you the steps into reversing this for you. You might need to contact the author of that 'Tutorial' and explain that you are receiving errors and wish to revert back to normal state.

[abroad]

it created in the same database I use vor vbulletin drupal tables so that I can log in either via vbulletin or via drupal. I have just deleted those drupal tables...and not I get every minute an email :cool:

[abroad]

as I expected...my host said that it is not a mistake from their site. Is there a file which is doing this SQL? They said that this might be the case.

would be nice if somebody could help me.

[Jose Amaral Rego]

Get a tech from your host to read this if it helps.
http://bugs.mysql.com/bug.php?id=14616