Question Vbcredits runs unnormal

[lengockhoa]

Hi, I get in last few days problem, please help.

Sometimes the VBcredits not appears in the postbit, and if I want to see the log in admincp at this time, i get this problem

Database error in vBulletin 3.8.x:

Invalid SQL:

SELECT
COUNT(*) AS total,
,

FROM credits_transaction AS t
LEFT JOIN user AS u ON (u.userid = t.userid)
WHERE t.eventid != 0 AND t.status IN (1, 2) AND t.timestamp >= 1203970500 AND t.timestamp <= 1319360143;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '

FROM credits_transaction AS t
LEFT JOIN user AS u ON (u.userid = t.user' at line 3
Error Number : 1064
Request Date : Sunday, October 23rd 2011 @ 03:55:43 PM
Error Date : Sunday, October 23rd 2011 @ 03:55:43 PM
Script : http://xxxxxx/forum/admincp/credits_...o=transactions
Referrer : http://xxxxxx/forum/admincp/index.php?do=nav
IP Address : xxx.xxx.xxx.xxx
Username : administrator
Classname : vB_Database_MySQLi
MySQL Version : 5.1.52

In this error time, if I click into "Activity Configuration Amount" this will come to "Multiple currecy Integration" and I have to create new currency. but I didn't do anything more

After few hours, they will work without any problem. This problem I got every day, please help me to fix it

Tks

 

[Darkwaltz4]

The problem is you need to create a currency (which the system was trying to get you to do). Do you need help doing this?

 

[lengockhoa]

hi, I have created a currency, and it worked ok. After few minutes, the currency got this problem again. Sometimes currency is not appear in postbit and currency didn't work anymore. After that currency work ok.

Maybe mysql config is not really good?? Do you have experience with this problem??

 

[lengockhoa]

I have created until now 5 currencies with the same field credits, but it get until now the same problem

Plz help

 

[Darkwaltz4]

Sorry for the delay; please PM me an admin login and FTP so I can debug your issue