Bug MySQL Error

[rocket]

Hello! I've been using this system for over 1 year and everything was good. Until this morning, when I got a database error. I disabled all mods and enabled one by one to see which is causing the issue. Each time when I enable vBCredits II Deluxe, the database error is back, with this message:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT t.* FROM credits_transaction AS t LEFT JOIN credits_event AS e ON (t.eventid = e.eventid) WHERE t.userid = 1 AND t.status = 0 AND t.timestamp <= 1341055086 ORDER BY t.transactionid ASC LIMIT 1;

MySQL Error : Incorrect information in file: './mydatabase/credits_transaction.frm'
Error Number : 1033
Request Date : Saturday, June 30th 2012 @ 07:18:06 AM
Error Date : Saturday, June 30th 2012 @ 07:18:07 AM

I tried to run the Repair/Optimize tables function in vBulletin, it detects there's an error in credits_transaction.frm, but it can't fix it.

I tried to reinstall the mod, but the error is still there:

Database error in vBulletin 4.2.0:

Invalid SQL:
SHOW COLUMNS FROM credits_transaction;

MySQL Error : Incorrect information in file: './mydatabase/credits_transaction.frm'
Error Number : 1033

What can I do? Is there any way to fix this?

 

[Cosmic]

Hi there,

Your site is actually listed on our piracy tracker as having an illegal version of vBShop - we checked manually and there are indeed unlicensed pro files for vBShop on your server though the mod itself appears to be disabled.

Please remove any stolen DBTech files from your server. It's up to Darkwaltz4 if he wants to provide you support for your issue, though it's likely he will choose not to for obvious reasons.

Regards,

Cosmic

 

[rocket]

I wanted to decide if to buy the Pro Version, that's why I tried it first, but I'm not using it, I'm using a Point Market version, that's the shop I'm using, not the vBShop.

Of course, I deleted it completely.

UPDATE: I fixed the error anyway, so, nevermind. Thank you for answering.

 

[vonamson]

Hi,
I have a problem with database error when I upgrade my forum from VBB3 (with VBcredits old mod) to VBB4 (with VBCredits II Deluxe mod).
Many people aslo have same problem.
I want to keep old vbcredits data.
I dont want to uninstall Old mod before install VBcredits II Deluxe.
Help me!
Thanks.

 

[Ozzy47]

You should start your own thread as this one has been marked as Won't Fix and will go unseen, by posting your own thread the dev is notified of the issue.