ERRORE [PrestaShopDatabaseException]

[Mediaideashop]

Buongiorno a tutti,

dopo aver aggiornato dei moduli, cliccando su Moduli e servizi - Moduli e servizi, non riesco ad aprire questa sezione ma compare un errore, come in allegato.

Cosa posso fare?

 

[PrestaShopDatabaseException]

Duplicate column name 'is_reference'
 

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

 

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 601 - 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 499 - classes/module/Module.php] - [1 Arguments]
• ModuleCore->runUpgradeModule - [line 1494 - controllers/admin/AdminModulesController.php]
• AdminModulesControllerCore->initContent - [line 189 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 58 - admin/index.php]

 

Grazie mille

[ariom]

Ciao,

l'errore è dato da un modulo ebay, che non uso e quindi non conosco, non ti posso quindi aiutare nello specifico, ma se vuoi avere indietro il tuo BO io non vedo altre soluzioni che eliminare il modulo in questione e cancellare il file class.index.php nella cartella cache del sito (magari prima prova ad eliminare solo questo file e aggiorna per vedere se risolve)

non vedo soluzioni altre ...

[SherryM]

Hi

 

Can someone please tell me how I make my own forum for help? I have a big issue and not sure what is going on here is what happens [PrestaShopDatabaseException]
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'like'
INSERT INTO ps_referrer_cache (id_referrer, id_connections_source) (
                    SELECT id_referrer, id_connections_source
                    FROM ps_referrer r
                    LEFT JOIN ps_connections_source cs ON ((r.http_referer_like IS NULL OR r.http_referer_like = '' OR cs.http_referer LIKE r.http_referer_like)
            AND (r.request_uri_like IS NULL OR r.request_uri_like = '' OR cs.request_uri LIKE r.request_uri_like)
            AND (r.http_referer_like_not IS NULL OR r.http_referer_like_not = '' OR cs.http_referer NOT LIKE r.http_referer_like_not)
            AND (r.request_uri_like_not IS NULL OR r.request_uri_like_not = '' OR cs.request_uri NOT LIKE r.request_uri_like_not)
            AND (r.http_referer_regexp IS NULL OR r.http_referer_regexp = '' OR cs.http_referer REGEXP r.http_referer_regexp)
            AND (r.request_uri_regexp IS NULL OR r.request_uri_regexp = '' OR cs.request_uri REGEXP r.request_uri_regexp)
            AND (r.http_referer_regexp_not IS NULL OR r.http_referer_regexp_not = '' OR cs.http_referer NOT REGEXP r.http_referer_regexp_not)
            AND (r.request_uri_regexp_not IS NULL OR r.request_uri_regexp_not = '' OR cs.request_uri NOT REGEXP r.request_uri_regexp_not))
                    WHERE id_connections_source = 7935
                )

at line 791 in file classes/db/Db.php
786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793.
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }
DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 601 - classes/db/Db.php] - [1 Arguments]
DbCore->execute - [line 103 - classes/Referrer.php] - [1 Arguments]
ReferrerCore::cacheNewSource - [line 54 - classes/ConnectionsSource.php] - [1 Arguments]
ConnectionsSourceCore->add - [line 110 - classes/ConnectionsSource.php]
ConnectionsSourceCore::logHttpReferer - [line 105 - modules/statsdata/statsdata.php]
StatsData->hookFooter - [line 587 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 1022 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->initFooter - [line 195 - classes/controller/Controller.php]
ControllerCore->run - [line 367 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]
 

 

I have been trying to get my host to help me on this I have ehost and I really dont understand how to fix this and not sure if they understand what is going on. Thanks

[jhon111]

Hello;

I'm getting the same error that you SherryM    but trying to solve the errors that have the moudule tmsociallogin,check my image

thanks

[jhon111]

can anybody here help us to solve the error?

[E-Genti]

Quote

On 1/5/2019 at 7:40 PM, jhon111 said:

can anybody here help us to solve the error?

 

jhon111 did you solve this problem?

Edited October 12, 2019 by E-Genti (see edit history)