Database Error In Script Needs Fixing
I need the database error fixed so the Earnings Area page works
The error:
Database error: Invalid SQL: SELECT count(id) as total FROM ads WHERE NOT EXISTS (SELECT * FROM click_history WHERE click_history.type='ptc' AND click_history.username='admin' AND click_history.ad_id=[login to view URL]) and credits>=1 and (country='' or country='') and (daily_limit>views_today or daily_limit=0) and (upgrade='0' )
MySQL Error: 1054 (Unknown column 'click_history.ad_id' in 'where clause')
Session halted
To see the error login to the site here as member
[login to view URL]
user: admin
password: admin
then on the left click the Earnings Area
You can see what the earning page looks like on this older version of the script
[login to view URL]
user: mdr1463
password: 041463