I have a quick question.....
I installed the product and found that when i click on my timeslips database link, i now get this error:
HTML Code:
Database error in vBulletin 3.7.0 Beta 5:
Invalid SQL:
SELECT *
FROM vb3user AS user
LEFT JOIN vb3customfile AS customfile ON (customfile.userid = user.userid)
LEFT JOIN vb3userfield AS userfield ON (userfield.userid = user.userid)
WHERE user.userid = userfield.userid
WHERE payment_status='Completed' AND item_number='Donation' AND userfield.field55>0
ORDER BY userfield.field55 ASC
LIMIT 0,25;
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 'WHERE payment_status='Completed' AND item_number='Donation' AND userfield.field5' at line 6
Error Number : 1064
Date : Friday, May 30th 2008 @ 05:24:43 AM
Script : http://www.insanemustangs.com/forums/timeslips.php?
Referrer : http://www.insanemustangs.com/forums/timeslips.php?
IP Address : ********
Username : ********
Classname : vb_database
MySQL Version : 5.0.45-community
When i disable your product, my timeslips database starts working again.........
From looking at the error, the one of the fields in your product match's the same one i have in timeslips database........
My question is, what userfields or customuserfields are you using in our code that are either a field5 or field55? I would like to change that on my site to like 75 or some number higher then what i am using in my timeslip database........
thanks, hotwheels