Em Andamento

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

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.

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

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

Regards,

Kevin.

Habilidades: PHP

Ver mais: 1054 unknown column pproducts_id clause, 1054 unknown column pproducts clause, 1054 unknown column clause, 1054 unknown column pproducts_id clause advanced_search_resultphp, 1054 unknown column, advanced_search_resultphp 1054 unknown column pproducts_id clause, unknown column pproducts_id clause, unknown column clause, 1054 unknown column pproducts_id clause cre loaded, 1054 unknown column pproducts_id clause creloaded, 1054 unknown column pproducts_id clause search, cre 1054 unknown column pproducts_id clause, unknown column pproducts_id clause advanced_search_resultphp, sql 1054 unknown column, 1054 clause, clause, unknown column clause join, to p, sql code standards, problem approach, approach problem, unknown column kevin clause, cre loaded serach 1054 unknown column pproducts_id clause, oscommerce advanced_search_resultphp 1054, mysql unknown column clause workaround

Acerca do Empregador:
( 15 comentários ) Wiclow, Ireland

ID do Projeto: #121352