Em Andamento

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.

Problem:

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.

ERROR:

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%') )

TEP_DB_ERRORR

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 " ...

to:

$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

Ver mais: unknown column mysql, creloaded mysql, cre loaded mysql, mysql count unknown column, mysql 1054 unknown column, 1054 unknown column mysql, sql code standards, products manufacturers, problem categories, problem approach, pay php, manufacturers products, find php, do 5, approach problem, 5 do, 5 below, mysql unknown column 1054, unknown column mysql fix, mysql count 1054, join unknown column mysql, mysql left join 1054, full join unknown column, error 1054 mysql, php error 1054

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

ID do Projeto: #145303

Premiar a:

lestervan

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

$30 USD em 0 dias
(33 Avaliações)
5.7

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

soner

I can help you. Please contact.

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

Let me fix it for you. regards.

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

i can help

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