Đã hoàn thành

136542 CRE Loaded 6.15 - MySQL 5 Prob

I have been running a website using CRE Loade 6.15, the only section of this i am using is the newsdesk facility. I want to move this site to a new server that is running mysql 5 and php 5, when i put it on to test i get an error(Error Below) in the [url removed, login to view] file. I know that this is due to MySQL 5 as i have had a similar error in other stores i have moved, i have found fixes for the query codes for these online. If anyone can fix this get in touch


1054 - Unknown column 'p.newsdesk_id' in 'on clause'

select count(p.newsdesk_id) as total from newsdesk_description pd, newsdesk p left join manufacturers m on p.newsdesk_id = m.manufacturers_id, newsdesk_to_categories p2c left join specials s on p.newsdesk_id = s.products_id where p.newsdesk_status = '1' and p.newsdesk_id = p2c.newsdesk_id and pd.newsdesk_id = p2c.newsdesk_id and pd.language_id = '1' and p2c.categories_id = '09'

-End Of Error-

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: php and mysql no codes, 5 and below, mysql 5.1, prob, mysql test, fix mysql query, mysql running, php mysql error unknown column, column found unknown column, column found 1054, 1054 unknown column select, php prob, 1054 php, column found 1054 unknown column, 1054 unknown, 1054, column found 1054 unknown, move website server mysql, 1054 unknown column language_id clause, mysql total online, unknown column php, mysql join, online query, mysql server error, unknown column clause 1054

Về Bên Thuê:
( 67 nhận xét ) Argyll, United Kingdom

ID dự án: #1882714

Được trao cho:


Hi, I work mainly with osCommerce based stores like CreLoaded and can help you fix the MySQL error. I can start away. Communication through MSN.

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