Wicked Anime Kid
March 27th, 2004, 12:41 AM
Ok i installed a mod on my website but it won't work cause of an SQL querry error:(
Here's the error:
General Error
Error updating users/employed table!
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'as t1, phpbb_users as t2 SET t1.last_paid = '1080376827', t2.user_poi' at line 2
UPDATE phpbb_employed as t1, phpbb_users as t2 SET t1.last_paid = '1080376827', t2.user_points = t2.user_points + t1.job_pay WHERE (1080376827 - t1.last_paid) > t1.job_length AND t1.user_id = '2' AND t2.user_id = t1.user_id
Line : 148
File : /data/members/paid/d/-/d-nation.org/htdocs/www/jobs.php
Can anyone help me out with this?
Here's the error:
General Error
Error updating users/employed table!
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'as t1, phpbb_users as t2 SET t1.last_paid = '1080376827', t2.user_poi' at line 2
UPDATE phpbb_employed as t1, phpbb_users as t2 SET t1.last_paid = '1080376827', t2.user_points = t2.user_points + t1.job_pay WHERE (1080376827 - t1.last_paid) > t1.job_length AND t1.user_id = '2' AND t2.user_id = t1.user_id
Line : 148
File : /data/members/paid/d/-/d-nation.org/htdocs/www/jobs.php
Can anyone help me out with this?