elettroitaly Posted January 10, 2015 Share Posted January 10, 2015 I can not install the module 1Click upgrade to update my prestashop! clicking is installed, the following: The following module (s) have not been installed successfully: AutoUpgrade: Unable to create the tab "AdminSelfUpgrade" what can I do? Link to comment Share on other sites More sharing options...
NemoPS Posted January 12, 2015 Share Posted January 12, 2015 Prestashop and module version? Link to comment Share on other sites More sharing options...
elettroitaly Posted January 12, 2015 Author Share Posted January 12, 2015 Prestashop 1.6.0.9 1-Click Upgrade - AutoUpgrade v1.4.6 Link to comment Share on other sites More sharing options...
NemoPS Posted January 12, 2015 Share Posted January 12, 2015 Enable error reporting (see my signature). Also, what's your default language? Link to comment Share on other sites More sharing options...
elettroitaly Posted January 12, 2015 Author Share Posted January 12, 2015 regard language is italian . with dev true see this: Unknown column 'hide_host_mode' in 'field list' INSERT INTO `ps_tab` (`id_parent`, `position`, `module`, `class_name`, `active`, `hide_host_mode`) VALUES ('17', '9', 'autoupgrade', 'AdminSelfUpgrade', '1', '0')at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /** Link to comment Share on other sites More sharing options...
elettroitaly Posted January 12, 2015 Author Share Posted January 12, 2015 here my ps_tab Link to comment Share on other sites More sharing options...
NemoPS Posted January 13, 2015 Share Posted January 13, 2015 Add that column into the db, it's a tinyint I believe Link to comment Share on other sites More sharing options...
elettroitaly Posted January 13, 2015 Author Share Posted January 13, 2015 yes just done yesterday and worked! thank you for support! regard Link to comment Share on other sites More sharing options...
FMR Posted January 21, 2015 Share Posted January 21, 2015 Can you explain exactly what was the solution, please ?It's not easy to understand, here. I know someone who has this problem too.Thank you very much. Link to comment Share on other sites More sharing options...
NemoPS Posted January 23, 2015 Share Posted January 23, 2015 Since this is the issue Unknown column 'hide_host_mode' in 'field list' Login to phpMyAdmin, navigate to ps_tab table and then structure -> add a new column Link to comment Share on other sites More sharing options...
Madking Posted September 18, 2015 Share Posted September 18, 2015 Hi i have about the same problem in a Presta Shop. When i try to install the OneClick Update module, i get this error [PrestaShopDatabaseException]Duplicate entry '0' for key 'PRIMARY' INSERT INTO `ps_tab` (`id_parent`, `position`, `module`, `class_name`, `active`, `hide_host_mode`) VALUES ('17', '11', 'autoupgrade', 'AdminSelfUpgrade', '1', '0')at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638.639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments] DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments] DbCore->insert - [line 464 - classes/ObjectModel.php] - [3 Arguments] ObjectModelCore->add - [line 103 - classes/Tab.php] - [2 Arguments] TabCore->add - [line 425 - classes/ObjectModel.php] - [2 Arguments] ObjectModelCore->save - [line 115 - classes/Tab.php] TabCore->save - [line 74 - modules/autoupgrade/autoupgrade.php] Autoupgrade->install - [line 805 - controllers/admin/AdminModulesController.php] AdminModulesControllerCore->postProcessCallback - [line 1045 - 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] I also try to manage the blog module (Smart Blog) and i get this error [PrestaShopException]Admin tab AdminAboutUsController is not a module tabat line 45 in file classes/controller/ModuleAdminController.php39. 40. parent::__construct();41.42. $tab = new Tab($this->id);43. if (!$tab->module)44. throw new PrestaShopException('Admin tab '.get_class($this).' is not a module tab');45.46. $this->module = Module::getInstanceByName($tab->module);47. if (!$this->module->id)48. throw new PrestaShopException("Module {$tab->module} not found");49. } ModuleAdminControllerCore->__construct - [line 11 - modules/smartblog/controllers/admin/AdminAboutUsController.php] AdminAboutUsController->__construct - [line 524 - modules/smartblog/smartblog.php] smartblog->getContent - [line 805 - controllers/admin/AdminModulesController.php] AdminModulesControllerCore->postProcessCallback - [line 1045 - 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] I have recently move my Prestahop to a new host, but i cant have support, they say its not any permission, or a server error, Link to comment Share on other sites More sharing options...
NemoPS Posted September 19, 2015 Share Posted September 19, 2015 Open that ps_tab table in the database, and make sure the primary key (id_tab) has AUTO_INCREMENT set 1 Link to comment Share on other sites More sharing options...
Madking Posted September 20, 2015 Share Posted September 20, 2015 (edited) Thanks for answer my friend.. well i think im gonna need some help here...ok here's a shot of my DB http://imgur.com/kF5uAK0 I think i need help over here.. how im gonna AUTO_INCREMENT ? Edited September 20, 2015 by Madking (see edit history) Link to comment Share on other sites More sharing options...
Madking Posted September 20, 2015 Share Posted September 20, 2015 Οκ i already did that, set to AUTO_INCREMENT but still the problem is the shame... Link to comment Share on other sites More sharing options...
NemoPS Posted September 21, 2015 Share Posted September 21, 2015 This is really odd, what if you try resetting the module now? It's not adding a duplicate entry there anymore now. It should auto increment the primary key 1 Link to comment Share on other sites More sharing options...
Madking Posted September 21, 2015 Share Posted September 21, 2015 Nothing happens, i still got the same errors.......this is so strange. i removed the database, uploaded an older one, i delete the module, resinstall it, now i can see the blog page in my theme and the control panel also the module is fine, i can see the blog admin in my admin page, but. 1. I cant add a new article, i got the error " An error has occurred: Can't save the current object " 2. im navigating through modules, i find the smart blog module, clicking to configure the module and i get this: [PrestaShopException] Admin tab AdminAboutUsController is not a module tabat line 45 in file classes/controller/ModuleAdminController.php 3. I m trying to add discounts, not working, again.......................................... and all the previous discounts not anymore... (it was the same thing with the other database, nothing changed.......) im getting a little mad with this situation, i cant figure out what is going on.. Link to comment Share on other sites More sharing options...
deel Posted December 18, 2015 Share Posted December 18, 2015 Hello everyone - I have a problem after upgrading with 1click module - i reload the sql database and get this error - can anyone help me? [PrestaShopDatabaseException]Unknown column 'last_connection_date' in 'where clause' UPDATE `ps16_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 0 AND `last_connection_date`< CURRENT_DATE() 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 494 - classes/Employee.php] - [1 Arguments] EmployeeCore::setLastConnectionDate - [line 2729 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->init - [line 170 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 58 - admin/index.php] Link to comment Share on other sites More sharing options...
NemoPS Posted December 19, 2015 Share Posted December 19, 2015 Just login to phpmyadmin and add that column as datetime type Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now