Jump to content

Recommended Posts

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?



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. }
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }


Grazie mille


Share this post

Link to post
Share on other sites


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 ...

Share this post

Link to post
Share on other sites



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.             }
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

Share this post

Link to post
Share on other sites


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


image error.png

Share this post

Link to post
Share on other sites
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 by E-Genti (see edit history)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More