Đã hoàn thành

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

Kĩ năng: HTML, MySQL, PHP, Thiết lập Bản thảo

Xem nhiều hơn: 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

Về Bên Thuê:
( 64 nhận xét ) salem, United States

ID dự án: #1024713

Được trao cho:


please check PM

$30 USD trong 0 ngày
(137 Đánh Giá)

6 freelancer đang chào giá trung bình $45 cho công việc này


Hi, Lets start.

$30 USD trong 0 ngày
(162 Nhận xét)

Lets get it done..jexplorer

$30 USD trong 0 ngày
(160 Nhận xét)

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

$50 USD trong 1 ngày
(349 Nhận xét)

Hi I can remove this error no time.

$30 USD trong 0 ngày
(1 Nhận xét)

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

$100 USD trong 7 ngày
(0 Nhận xét)