Update Problem, Database errors

[ocpistol]

when manually updating, it errors on updating database.

 

 

Server information

Prestashop version: 1.4.5.1

[/left]

Server information: Linux #1 SMP Tue Jan 10 18:05:48 EST 2012 i686

[/left]

Server software version: Apache/2.2.21 (CentOS)

[/left]

PHP version: 5.2.17

[/left]

MySQL version: 5.0.92

[/left]

 

Mysql:

Server: Localhost via UNIX socket

Server version: 5.0.92

Protocol version: 10

User: *******@localhost

MySQL charset: UTF-8 Unicode (utf8)

 

 

Error:

 

Your shop version is now 1.4.6.2

 

Unfortunately, 4 SQL errors have occurred.

 

SET NAMES ''utf8''

(1115) Unknown character set: ''

/* PHP:update_order_canada(); */

CREATE TABLE IF NOT EXISTS `p2s_compare` ( `id_compare` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_customer` int(10) unsigned NOT NULL, PRIMARY KEY (`id_compare`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

ALTER TABLE `p2s_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

ALTER TABLE `p2s_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`)

ALTER TABLE `p2s_store` CHANGE `latitude` `latitude` DECIMAL(11, 8) NULL DEFAULT NULL

ALTER TABLE `p2s_store` CHANGE `longitude` `longitude` DECIMAL(11, 8) NULL DEFAULT NULL

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

ALTER TABLE `p2s_address_format` DROP INDEX `country`

/* PHP:hook_blocksearch_on_header(); */

SET NAMES ''utf8''

(1115) Unknown character set: ''

/* PHP:add_module_to_hook(authorizeaim, header); */

SET NAMES ''utf8''

(1115) Unknown character set: ''

INSERT IGNORE INTO `p2s_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES (''PS_LIMIT_UPLOAD_IMAGE_VALUE'', ''2'', NOW(), NOW()), (''PS_LIMIT_UPLOAD_FILE_VALUE'', ''2'', NOW(), NOW())

(1064) 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 'PS_LIMIT_UPLOAD_IMAGE_VALUE'', ''2'', NOW(), NOW()), (''PS_LIMIT_UPLOAD_FILE_VAL' at line 2