En cours

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

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, 1054 php, needs, 1054 unknown, sql script mysql, need fixing

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

N° du projet : #1024713

Décerné à :

rajawi9999

please check PM

30 $ USD en 0 jours
(137 Commentaires)
6.3

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

naumanrandhawa

Hi, Lets start.

30 $ USD en 0 jours
(162 Commentaires)
7.4
jexplorer

Lets get it done..jexplorer

30 $ USD en 0 jours
(160 Commentaires)
7.1
eelance

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

50 $ USD en 1 jour
(349 Commentaires)
6.8
Guru300

Hi I can remove this error no time.

30 $ USD en 0 jours
(1 Commentaire)
0.0
jafaraalia

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

100 $ USD en 7 jours
(0 Commentaires)
0.0