Nenhuma resposta neste tópico

[Nak kaballa]

A instalação do OSCOMMERCE foi completada com sucesso, mas quando clico em qualquer link vem as seguintes msgs de erro:

EXEMPLOS:

1406 - Data too long for column 'last_page_url' at row 1

update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '127.0.0.1', time_last_click = '1166123362', last_page_url = '/pets/catalog/index.php?cPath=53&osCsid=cb89d875173916738f17a3f5d1cee240' where session_id = 'cb89d875173916738f17a3f5d1cee240'


1406 - Data too long for column 'last_page_url' at row 7

update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '127.0.0.1', time_last_click = '1166125448', last_page_url = '/pets/catalog/product_info.php?products_id=57&osCsid=9070cb02b2c4f28006dfff319a2374cc' where session_id = '9070cb02b2c4f28006dfff319a2374cc'



Agradeço de coração...semper fidelis

Atenciosamente,

Kaballa

Resolvido:

administation tools/configuration/sessions/

force cookies use --> true


Espero ajudar, algum iniciante como eu.


semper fidelis

Começou a dar problemas em castata.

O problema é a versão antiga do OSCOMMERCE com o MYSQL 5, eu descobri que até a versão 4 não dava pau.

Conforme eu for resolvendo os paus, eu vou colocando as soluções logo em seguida.

PROBLEMA:

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

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '51'

[TEP STOP]

SOLUÇÃO:

For 1. I altered line 186 in index.php from:

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

to

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p2c.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";


semper fidelis