Fórum OpenCart Brasil

[pauloamigoni]

galera instalei esse modulo

http://www.opencart.com/index.php?route ... ASC&page=6

Depois de instalado começo a bugar tudo
no CADASTRO DE PRODUTO aparece
Notice: Undefined index: addtext in E:\home\amigoni\Web\loja\vqmod\vqcache\vq2-admin_controller_catalog_product.php on line 785Notice: Undefined index: addtext in E:\home\amigoni\Web\loja\vqmod\vqcache\vq2-admin_controller_catalog_product.php on line 795

e na Loja

Notice: Undefined index: addtext in E:\home\amigoni\Web\loja\catalog\model\catalog\product.php on line 55Notice: Undefined index: addtext in E:\home\amigoni\Web\loja\catalog\model\catalog\product.php on line 55Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error No: 1064
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id IN (SELECT p2c.product_id FROM product_to_category p2c WHERE ) in E:\home\amigoni\Web\loja\system\database\mysql.php on line 49

[m.gimenez]

acesse o banco de dados e na aba sql execute este comando:
ALTER TABLE `product` ADD `addtext` text COLLATE utf8_bin NOT NULL

testei localmente e funcionou.

até mais,

[MARCDAT]

Olá.

Esse comando serviria para o meu caso também:

OC 1.5.3.1 ERROR LOG:

PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () in /home/content/55/7106477/html/loja/system/database/mysql.php on line 49

Desde já obrigado,
Marcelo