1054 - Unknown column MySQL 5 / PHP Creloaded 6.2 error

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

I have recently installed a cre loaded v6.2 template on my server (simlar to oscommerce) only to find that it is not compatable with the current version of mySQL running on the server.


MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode.

Due to this new setting, MySQL fails on certain SQL queries and produces error messages on the screen.


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

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%1001%' or p.products_model like '%1001%' or m.manufacturers_name like '%1001%') )


I am looking to pay for a valid fix or work around. Please see the one below - that does not work because Part of the work around requires that:

Lines 213-223 in [url removed, login to view] must be changed from:

$from_str = "from " ...


$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS ...

However, lines 213-223 in [url removed, login to view], don't exist on my cre loaded template [url removed, login to view] - Do you know where I can

locate these lines of code, and or how I can modify the template to work with mySQL 5.0

Running on

MySQL [url removed, login to view]

HP Version 4.4.4

CRE Loaded6 v6.2 Pro with patch:10.1

Habilidades: PHP

Veja mais: mysql unknown column left join, unknown column mysql, advanced_search_resultphp unknown column, 1054 unknown column advanced_search_result, 1054 unknown column pproducts_id clause cre, creloaded mysql, cre loaded mysql, mysql count unknown column, mysql 1054 unknown column, mysql left join unknown column, 1054 unknown column mysql, 1054 unknown column pproducts_id clause advanced_search_resultphp, 1054 advanced_search_resultphp, advanced_search_resultphp 1054, 1054 unknown column pproducts_id clause creloaded, where can i find a pro, sql code standards, products manufacturers, problem categories, problem approach, pay php, manufacturers products, find php, find manufacturers i, do 5

Acerca do Empregador:
( 38 comentários ) Rotterdam, Netherlands

ID do Projeto: #145303

Concedido a:


Hi, I just do this for other buyer. You can see it in my reviews. Thanks, Lester.

$30 USD em 0 dias
(33 Comentários)

4 freelancers estão ofertando em média $31 para esse trabalho


I can help you. Please contact.

$30 USD em 1 dia
(120 Comentários)

Let me fix it for you. regards.

$35 USD em 1 dia
(246 Comentários)

i can help

$30 USD em 1 dia
(5 Comentários)