SQL error after update from 1.4.6.3 to 1.4.7.1

[Feri77]

Hi,

 

After update from 1.4.6.3 to 1.4.7.1 I got the following SQL error:

 

ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`)

(1062) Duplicate entry '1' for key 'PRIMARY'

 

Similar to http://www.prestashop.com/forums/topic/145590-upgrade-from-1441-to-1462-get-sql-error/

 

Is it a serious error? Can I fix it somehow? Or can I use PS without any problem?

[bellini13]

if that is the only error you got, i think you can ignore it. it is just telling you that the primary key already exists on the address format, so it could not add it again.

[nilady]

when i upgrade it, the same error happen, but in my BO, when i click module, it doesnt show any modul there

[Carl Favre]

Hi nilady,

 

You should turn on debug mode in config\config.inc.php :

 

/* Debug only */

@ini_set('display_errors', 'off');

define('_PS_DEBUG_SQL_', false);

 

change to 'display_errors', 'on'

 

Then you should have an error message when you go in modules. If it is a memory issue, you have to modify your php.ini and increase the memory_limit