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?

 

[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

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

image error.png

Share this post


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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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