Status
Not open for further replies.

datoneer

New member
Hello,

i have a database error on recalculate user accounts:

Database error in vBulletin 4.2.2:

Invalid SQL:
DELETE FROM credits_transaction t WHERE userid = 2025 AND timestamp >= 1320887100 AND timestamp <= 1384554120 AND eventid IN (19, 25, 37, 35, 36, 28, 29, 18, 24, 20, 21, 34, 33, 23, 30, 32, 31, 27, 22, 17, 26);

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 't WHERE userid = 2025 AND timestamp >= 1320887100 AND timestamp <= 1384554120 AN' at line 1
Error Number : 1064
Request Date : Friday, November 15th 2013 @ 10:25:15 PM
Error Date : Friday, November 15th 2013 @ 10:25:15 PM
Script : Log in - IMSpot - Top Internet Marketing Forum - vBulletin Admin Control Panel
Referrer : Log in - IMSpot - Top Internet Marketing Forum - vBulletin Admin Control Panel
IP Address : 94.253.220.175
Username : enigma
Classname : vB_Database
MySQL Version : 5.5.32-cll

Can you help me with this?
 
I've applied a potential hotfix to /admincp/credits_admin.php - can you try re-downloading and re-uploading it?
 
Could you please create and PM me with a temporary FTP and AdminCP account?

For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues.

The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved.

If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved.

Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with.

Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided.

When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches.

Thank you for helping us debug our products and allowing us to assist you, we appreciate it :D
 
I am unable to replicate this issue on your site.

Please provide step-by-step details for replicating this issue.
 
Recalculate user accounts
show advanced options
select all actions
start date november 10 2011
stop date - today
calculate events and prune existing transactions to Yes
Update users
 
Okay, I took care of it - you're running MySQL 5.5 which changed syntax that has been valid for donkey's years, which was causing the issue.

Thanks :)
 
The fix was incorporated into the live product on this site at the time. If you believe the issue still exists, please post a new thread.

Thank you :)
 
Status
Not open for further replies.

Legacy vBCredits II Deluxe

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
845
Customer rating
0.00 star(s) 0 ratings
Back
Top