Đang Thực Hiện

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 thêm: 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

Mã Dự Án: #1024713

Đã trao cho:

rajawi9999

please check PM

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

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

naumanrandhawa

Hi, Lets start.

$30 USD trong 0 ngày
(162 Đánh Giá)
7.4
jexplorer

Lets get it done..jexplorer

$30 USD trong 0 ngày
(160 Đánh Giá)
7.1
eelance

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

$50 USD trong 1 ngày
(349 Đánh Giá)
6.8
Guru300

Hi I can remove this error no time.

$30 USD trong 0 ngày
(1 Đánh Giá)
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 trong 7 ngày
(0 Đánh Giá)
0.0