Error in SQL database after ebay module update

[secursystem]

Hello,

 

    I have updated EBAY native prestashop module, I got this error:

 

Site is working but  when I click on "module" tab, I have this error. Anyone can help me in fixing it?

[PrestaShopDatabaseException]

Duplicate column name 'is_reference'
 

ALTER TABLE `ps_ebay_category_specific` ADD `is_reference` tinyint(1) NULL
at line 646 in file classes/db/Db.php

 

641.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 480 - classes/db/Db.php] - [1 Arguments]
• DbCore->execute - [line 36 - modules/ebay/upgrade/Upgrade-1.12.3.php] - [1 Arguments]
• upgrade_module_1_12_3 - [line 442 - classes/module/Module.php] - [1 Arguments]
• ModuleCore->runUpgradeModule - [line 1443 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

[tuk66]

That module doesn't check if the table field exists. Try to comment out this (and other similar) table modification in mentioned file (modules/ebay/upgrade/Upgrade-1.12.3.php).

[secursystem]

Thank you for your reply.

 

I have commented the file in ftp: /ebay/upgradeUpgrade-1.12.3.php and now I can show module list without error

 

But if I try to open ebay module, I have this error:

 

[PrestaShopDatabaseException]

Table 'Sql649258_1.ps_ebay_business_policies' doesn't exist
 

DELETE FROM `ps_ebay_business_policies`
WHERE `id_ebay_profile` = 1
at line 646 in file classes/db/Db.php

 

641.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 480 - classes/db/Db.php] - [1 Arguments]
• DbCore->execute - [line 1432 - modules/ebay/classes/EbayRequest.php] - [1 Arguments]
• EbayRequest->importBusinessPolicies - [line 350 - modules/ebay/classes/EbayRequest.php]
• EbayRequest->getUserProfile - [line 2192 - modules/ebay/ebay.php] - [1 Arguments]
• Ebay->__getAlerts - [line 1565 - modules/ebay/ebay.php]
• Ebay->__displayForm - [line 1546 - modules/ebay/ebay.php]
• Ebay->getContent - [line 846 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->postProcessCallback - [line 1094 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

[secursystem]

Any idea? I must solve this issue asap