Jump to content

ERRORE [PrestaShopDatabaseException]


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?

 

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

 

Grazie mille

post-1212327-0-88829400-1480431959_thumb.jpg

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

  • 2 years later...
  • 9 months later...

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
 Share

×
×
  • Create New...

Important Information

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