Database Error In Script Needs Fixing

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=[url removed, login to view]) 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

[url removed, login to view]

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

[url removed, login to view]

user: mdr1463

password: 041463

Compétences : HTML, MySQL, PHP, Script Install

en voir plus : database error, error 0, script ads, php error fixing, mysql error, install database, fixing, error, error in php script, error fixing, database upgrade, ads database, admin error, invalid script, php mysql error unknown column, error exists page, mysql session halted, session script, unknown database, 1054 unknown column select

Concernant l'employeur :
( 64 commentaires ) salem, United States

Nº du projet : #1024713

Décerné à:


please check PM

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(137 Commentaires)

6 freelance font une offre moyenne de $45 pour ce travail


Hi, Lets start.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(162 Commentaires)

Lets get it done..jexplorer

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(160 Commentaires)

how this happen ,it is a new system or some script?

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(349 Commentaires)

Hi I can remove this error no time.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(1 Évaluation)

I have 8 yrs of IT experience. I can provide the best of the quality and in the promised time line.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)