30 Posts
phil03
8 years ago
Topic

Hi Seblod,

When performing the update, the following error occurs:

Erreur de syntaxe près de 'IGNORE TABLE `#__cck_store_item_users` ADD `company` VARCHAR( 255 ) NOT NULL ' à la ligne 1 SQL=ALTER IGNORE TABLE `#__cck_store_item_users` ADD `company` VARCHAR( 255 ) NOT NULL AFTER `birthplace`;

As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error.

 I try to develop my version  in PHP7 and  MySql is 5.7.9!

You planned to take account of these changes?

Thank's

Get a VIP membership
30 Posts
phil03
8 years ago
0
Level 1

Hi,

To install without error you must change the files in the zip.
/extensions/com_cck/admin/install/upgrades/3.20.sql 60- 61 lines and 3.80.sql 61-62 lines.
Comment them.
Recreate the zip
Before starting the update take these queries without IGNORE put in  console to create the missing columns.


The update will until his term without error!

Thank's

Get a VIP membership