Skip to content

Column count doesn't match value count  #21949

Closed
@ghost

Description

Describe the bug

During upgrade 1769 to 1770 i have this error

Column count doesn't match value count at row 14 and after


SQL 1.7.7.0 1136 in 

INSERT IGNORE INTO `ps_hook` (`id_hook`, `name`, `title`, `description`, `position`) 
VALUES (NULL, 'displayAdminOrderTop', 'Admin Order Top', 'This hook displays content at the top of the order view page', '1'), 

(NULL, 'displayAdminOrderSide', 'Admin Order Side Column', 'This hook displays content in the order view page in the side column under the customer view', '1'), 
(NULL, 'displayAdminOrderSideBottom', 'Admin Order Side Column Bottom', 'This hook displays content in the order view page at the bottom of the side column', '1'),
(NULL, 'displayAdminOrderMain', 'Admin Order Main Column', 'This hook displays content in the order view page in the main column under the details view', '1'),
(NULL, 'displayAdminOrderMainBottom', 'Admin Order Main Column Bottom', 'This hook displays content in the order view page at the bottom of the main column', '1'),
(NULL, 'displayAdminOrderTabLink', 'Admin Order Tab Link', 'This hook displays new tab links on the order view page', '1'), (NULL, 'displayAdminOrderTabContent', 'Admin Order Tab Content', 'This hook displays new tab contents on the order view page', '1'),
(NULL, 'actionGetAdminOrderButtons', 'Admin Order Buttons', 'This hook is used to generate the buttons collection on the order view page (see ActionsBarButtonsCollection)', '1'),
(NULL, 'displayFooterCategory', 'Category footer', 'This hook adds new blocks under the products listing in a category/search', '1'),
(NULL, 'displayBackOfficeOrderActions', 'Admin Order Actions', 'This hook displays content in the order view page after action buttons (or aliased to side column in migrated page)', '1'),
(NULL, 'actionAdminAdminPreferencesControllerPostProcessBefore', 'On post-process in Admin Preferences', 'This hook is called on Admin Preferences post-process before processing the form', '1'),
(NULL, 'displayAdditionalCustomerAddressFields', 'Display additional customer address fields', 'This hook allows to display extra field values added in an address form using hook ''additionalCustomerAddressFields''', '1'), 
(NULL, 'displayAdminProductsExtra', 'Admin Product Extra Module Tab', 'This hook displays extra content in the Module tab on the product edit page', '1'),
(NULL, 'actionFrontControllerInitBefore', 'Perform actions before front office controller initialization', 'This hook is launched before the initialization of all front office controllers'),
(NULL, 'actionFrontControllerInitAfter', 'Perform actions after front office controller initialization', 'This hook is launched after the initialization of all front office controllers'),
(NULL, 'actionAdminControllerInitAfter', 'Perform actions after admin controller initialization', 'This hook is launched after the initialization of all admin controllers'), 
(NULL, 'actionAdminControllerInitBefore', 'Perform actions before admin controller initialization', 'This hook is launched before the initialization of all admin controllers'), 
(NULL, 'actionControllerInitAfter', 'Perform actions after controller initialization', 'This hook is launched after the initialization of all controllers'),
(NULL, 'actionControllerInitBefore', 'Perform actions before controller initialization', 'This hook is launched before the initialization of all controllers'),
(NULL, 'actionAdminLoginControllerBefore', 'Perform actions before admin login controller initialization', 'This hook is launched before the initialization of the login controller'), 
(NULL, 'actionAdminLoginControllerLoginBefore', 'Perform actions before admin login controller login action initialization', 'This hook is launched before the initialization of the login action in login controller'), 
(NULL, 'actionAdminLoginControllerLoginAfter', 'Perform actions after admin login controller login action initialization', 'This hook is launched after the initialization of the login action in login controller'),
(NULL, 'actionAdminLoginControllerForgotBefore', 'Perform actions before admin login controller forgot action initialization', 'This hook is launched before the initialization of the forgot action in login controller'),
(NULL, 'actionAdminLoginControllerForgotAfter', 'Perform actions after admin login controller forgot action initialization', 'This hook is launched after the initialization of the forgot action in login controller'),
(NULL, 'actionAdminLoginControllerResetBefore', 'Perform actions before admin login controller reset action initialization', 'This hook is launched before the initialization of the reset action in login controller'), 
(NULL, 'actionAdminLoginControllerResetAfter', 'Perform actions after admin login controller reset action initialization', 'This hook is launched after the initialization of the reset action in login controller')
: Column count doesn't match value count at row 14

There is no position 5th argument

Steps to Reproduce

Steps to reproduce the behavior:

Make an upgrade 1769 to 1770 and check SQL error

Additional information

Informations sur votre serveur
Informations sur votre serveur Linux #799710 SMP Wed Jul 10 08:31:28 UTC 2019 x86_64

Version du logiciel serveur : Apache

Version de PHP : 7.2.34
Limite de mémoire : 2048M
Temps maximal d'exécution : 18000
Taille max. pour envoi de fichiers : 10M
info_outline Informations sur la base de données

Version de MySQL : 10.1.45-MariaDB-0+deb9u1
Serveur MySQL : localhost
Nom MySQL : 176
Utilisateur MySQL : 176
Préfixe des tables : ps_
Moteur MySQL : InnoDB
Connecteur MySQL : DbPDO

Activity

hibatallahAouadni

hibatallahAouadni commented on Nov 17, 2020

@hibatallahAouadni
Contributor

Related to #21948

hibatallahAouadni

hibatallahAouadni commented on Nov 17, 2020

@hibatallahAouadni
Contributor

Hello @okom3pom

Could you please modify original issue #21948 as there is no need to open a new one as long as all issues you are having are related.
And edit the Fixed ticket? block on your PR #21953.

Thanks!

hibatallahAouadni

hibatallahAouadni commented on Nov 17, 2020

@hibatallahAouadni
Contributor

Duplicate of #21948

ghost

ghost commented on Nov 17, 2020

@ghost

It's not the same :) or duplicate :) Regards !

hibatallahAouadni

hibatallahAouadni commented on Nov 17, 2020

@hibatallahAouadni
Contributor

Ping @matks wdyt?

hibatallahAouadni

hibatallahAouadni commented on Nov 17, 2020

@hibatallahAouadni
Contributor

Hello @okom3pom

As discussed with @PierreRambaud it seems this topic is totally different from this issue #21948
So I reopen it.

PS: sorry for the misunderstanding.

Thanks!

added
Waiting for devStatus: action required, waiting for tech feedback
and removed
DuplicateResolution: issue closed because already reported
on Nov 17, 2020

5 remaining items

Progi1984

Progi1984 commented on Nov 18, 2020

@Progi1984
Member

Bug approved : some lines have position and not another.

So it's a problem for upgrade.

Ping @PrestaShop/product-team

added
Must-haveKanban prioritization: issue must be included in next version
and removed
Waiting for devStatus: action required, waiting for tech feedback
on Nov 18, 2020
added this to the 1.7.7.0 milestone on Nov 18, 2020
hibatallahAouadni

hibatallahAouadni commented on Nov 18, 2020

@hibatallahAouadni
Contributor

Ping @marionf what is the status of this ticket? TBS or To Do ?

eternoendless

eternoendless commented on Nov 18, 2020

@eternoendless
Member

Fixed by #21953

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    1.7.7.0Affects versionsAutoupgradeModule: autoupgradeBugType: BugFixedResolution: issue closed because fixedMust-haveKanban prioritization: issue must be included in next versionPR availableSolution: issue is being addressed

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

      Development

      Participants

      @eternoendless@Progi1984@hibatallahAouadni

      Issue actions

        Column count doesn't match value count · Issue #21949 · PrestaShop/PrestaShop