Jump to content

[Resolvido] Erro de sintaxe no SQL


Recommended Posts

Olá, alguns dias para cá, meu prestashop dá tela branca, toda vez que salva algum produto, ou ativa um módulo, mas se voltar e der um refresh na página a alteração foi feita.

 

Verifiquei no log de erro e está acusando o seguinte erro: 

*ERROR* 	2013/11/14 - 17:07:49: Você tem um erro de sintaxe no seu SQL próximo a '= replace(replace(replace(`id_lang`, "\'", "'"), '\\"', '"'), "\\\\", "\\") INT(' na linha 2<br /><br /><pre>
		ALTER TABLE ps_mailalert_customer_oos 
		ADD `id_lang` = replace(replace(replace(`id_lang`, "\'", "'"), '\\"', '"'), "\\\\", "\\") INT( 10 ) UNSIGNED NOT NULL , 
		DROP PRIMARY KEY , 
		ADD PRIMARY KEY ( 
			`id_customer` = replace(replace(replace(`id_customer`, "\'", "'"), '\\"', '"'), "\\\\", "\\") , 
			`customer_email` = replace(replace(replace(`customer_email`, "\'", "'"), '\\"', '"'), "\\\\", "\\") , 
			`id_product` = replace(replace(replace(`id_product`, "\'", "'"), '\\"', '"'), "\\\\", "\\") , 
			`id_product_attribute` = replace(replace(replace(`id_product_attribute`, "\'", "'"), '\\"', '"'), "\\\\", "\\") , 
			`id_shop` = replace(replace(replace(`id_shop`, "\'", "'"), '\\"', '"'), "\\\\", "\\") 
		)</pre> at line 613 in file classes/db/Db.php

Alguém sabe interpretar esse erro? 

 

Obrigado.

Edited by ederwp (see edit history)
Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...