Log in

View Full Version : Error with my products

NLPLegacy
11-07-2010, 06:45 PM
Database error in vBulletin 3.8.6:

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 <= (1289162502 - IF(ISNULL(e.eventid), 0, e.delay)) ORDER BY t.transactionid ASC LIMIT 1;

MySQL Error : Table '*****_***.credits_transaction' doesn't exist
Error Number : 1146
Request Date : Sunday, November 7th 2010 @ 01:41:42 PM
Error Date : Sunday, November 7th 2010 @ 01:41:42 PM
Script : http://*********.com/forums/index.php
Referrer : http://*********.com/forums/******/index.php?do=head
IP Address : **********
Username : Legacy
Classname : vB_Database
MySQL Version : 5.0.91-community

I have no idea what's wrong and I don't know how to fix this. I've also tried another cash system and the same thing happens
Lynne
11-07-2010, 08:15 PM
Disable the product and then post in the modification thread for help. Help for modifications isn't provided out here in the main forums.
NLPLegacy
11-08-2010, 01:41 AM
Disable the product and then post in the modification thread for help. Help for modifications isn't provided out here in the main forums.

I've already done that. This db error comes with other mods as well so it's just not one mod
Lynne
11-08-2010, 02:07 AM
It might come on other pages and such, but it's not a default vbulletin table (there is no credits_transaction table in default vbulletin) so it's from a modification and you need to seek help in the modification thread.
Michael.A
11-08-2010, 03:48 AM
you can just add a Table in you DB with that same title but dont try it unless you backup first..
FreshFroot
11-08-2010, 07:05 AM
You need to provide more information.

What product are you using, which uses credits? There are a few and one of them didn't install or uninstall properly.

I can help if you provide more details or pop me a PM if you want.
NLPLegacy
11-08-2010, 06:37 PM
You need to provide more information.

What product are you using, which uses credits? There are a few and one of them didn't install or uninstall properly.

I can help if you provide more details or pop me a PM if you want.

I'm using vBCredits with vBShop. I've also tried vbPlaza

EDIT: Nevermind guys. I fixed it. I just added all files again and re-installed product