Floobynooby Posted May 25, 2013 Share Posted May 25, 2013 Hi Im Trying to upgrade from Prestashop 1.4.4.1 on a Wamp Server to hopefully the latest version of Prestashop 1.5.4.1 have tried numerous times to upgrade using various versions, manual upgrade and 1 click upgrade. Have been using Prestashop for a number of years and never had any problems upgrading in the past, but just finding it an impossible task to jump from 1.4 to 1.5. Each Time I try the 1 click upgrade I get to the Now upgrading database and then the message "[server Error] Timeout:The request exceeded the max_time_limit. Please change your server configuration." and then it hangs. Having read previous posts advise I have: Changed the php.ini (+ restarted) as follows: memory_limit = 1280M default_socket_timeout = 6000 max_execution_time = 3000 max_input_time = 600000 mysql.connect_timeout = -1 post_max_size = 1024M upload_max_filesize = 1024M (I'm not a programmer and the above doesn't really mean that much to me but tried upping the memory or time based on other comments in the forum to the problem) Tried Firefox and Google Chrome Browsers. Tried upgrading to 1.4.5 (success) Then upgrade to 1.5.4.1 Fail Tried upgrading to 1.4.5 (success) Then upgrade to 1.5.3.1 Fail Tried upgrading to 1.4.10 (success) Then upgrade to 1.5.4.1 Fail Tried upgrading to 1.4.10 (success) Then upgrade to 1.5.3.1 Fail Tried upgrading to 1.4.10 (success) Then upgrade to 1.5.4.0 Fail Tried Upgrading Manually 1.5.4.1 Fail Tried Upgrading Manually 1.5.3.1 Fail Tried Upgrading Manually 1.5.1.0 Fail Tried Deleting connections to reduce database size / Upgrade Fail Tried turning off backup on each of the previous / Upgrade Fail Tried the Low, Medium and High settings for dedicated server / Upgrade Fail Really not sure where to go from here and any advise would be greatly appreciated if anyone has run into the same problem and managed to find the solution. Link to comment Share on other sites More sharing options...
Bill Dalton Posted May 26, 2013 Share Posted May 26, 2013 Take a look at this thread, let me know if it helps, http://www.prestashop.com/forums/topic/244753-sql-error-upgrading-143-to-154/ Link to comment Share on other sites More sharing options...
Floobynooby Posted May 26, 2013 Author Share Posted May 26, 2013 Hi Bill Many thanks for the advise tried and it still timed out when I try to access the sit I then get this code: [PrestaShopException] No access reference in table module_access for id_module 192. at line 1743 in file classes/module/Module.php 1737. self::$cache_permissions[$employee->id_profile][$row['id_module']]['configure'] = $row['configure']; 1738. } 1739. } 1740. 1741. if (!isset(self::$cache_permissions[$employee->id_profile][$id_module])) 1742. throw new PrestaShopException('No access reference in table module_access for id_module '.$id_module.'.'); 1743. 1744. return (bool)self::$cache_permissions[$employee->id_profile][$id_module][$variable]; 1745. } 1746. 1747. /** ModuleCore::getPermissionStatic - [line 2220 - classes/controller/AdminController.php] - [2 Arguments] 2214. $this->modules_list = array();2215. foreach($all_modules as $module)2216. {2217. $perm = true;2218. if ($module->id)2219. $perm &= Module::getPermissionStatic($module->id, 'configure');2220. else2221. {2222. $id_admin_module = Tab::getIdFromClassName('AdminModules');2223. $access = Profile::getProfileAccess($this->context->employee->id_profile, $id_admin_module);2224. if (!$access['edit']) AdminControllerCore->getModulesList - [line 1518 - classes/controller/AdminController.php] - [1 Arguments] 1512. }1513. 1514. public function renderModulesList()1515. {1516. 1517. if ($this->getModulesList($this->filter_modules_list))1518. {1519. $helper = new Helper();1520. return $helper->renderModulesList($this->modules_list);1521. }1522. } AdminControllerCore->renderModulesList - [line 1441 - classes/controller/AdminController.php] - [0 Argument] 1435. $this->loadObject(true);1436. $this->content .= $this->renderView();1437. }1438. elseif (!$this->ajax)1439. {1440. $this->content .= $this->renderModulesList();1441. $this->content .= $this->renderList();1442. $this->content .= $this->renderOptions();1443. 1444. // if we have to display the required fields form1445. if ($this->required_database) AdminControllerCore->initContent - [line 111 - controllers/admin/AdminLoginController.php] - [0 Argument] 105. 'disableDefaultErrorOutPut' => true,106. ));107. 108. $this->setMedia();109. $this->initHeader();110. parent::initContent();111. $this->initFooter();112. }113. 114. public function checkToken()115. { AdminLoginControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] 161. 162. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))163. $this->initHeader();164. 165. if ($this->viewAccess())166. $this->initContent();167. else 168. $this->errors[] = Tools::displayError('Access denied.'); 169. 170. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) 171. $this->initFooter(); ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument] 343. // Execute hook dispatcher344. if (isset($params_hook_action_dispatcher))345. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);346. 347. // Running controller348. $controller->run();349. }350. catch (PrestaShopException $e)351. {352. $e->displayMessage();353. } DispatcherCore->dispatch - [line 50 - admin1066/index.php] - [0 Argument] 44. $_POST['controller'] = strtolower($_POST['tab']);45. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab']))46. $_REQUEST['controller'] = strtolower($_REQUEST['tab']);47. 48. // Prepare and trigger admin dispatcher49. Dispatcher::getInstance()->dispatch(); Link to comment Share on other sites More sharing options...
Floobynooby Posted May 26, 2013 Author Share Posted May 26, 2013 Is it at all possible to do a fresh install and then import all the information from 1.4.4.1 database into the 1.5.4.1 as I cant see any other way around the problem. 1 Link to comment Share on other sites More sharing options...
Bill Dalton Posted May 26, 2013 Share Posted May 26, 2013 The database in 1.5 because of multistore is not compatible with 1.4. so will not support an SQL dump import. 1. 1.4 themes are not compatible with 1.5 so your theme is left behind regardless of upgrade method. 2. You could export your product and category data to CSV and import the CSV data to 1.5. It is possible to upgrade 1.4 to 1.5, however something in your sever environment is not allowing this to happen. I agree you have done all you can. You could try installing XAMPP on your local machine and giving it a "go" in that environment. I am very confident you will find a way. 1 Link to comment Share on other sites More sharing options...
Floobynooby Posted May 26, 2013 Author Share Posted May 26, 2013 Thanks for the suggestion Will give that a try now as regards upgrading upgrading is there a particular version of 1.5 I should be aiming at that is most stable for a live site. I have over 1700 products on our site so don't know if that will effect me upgrading to any of the 1.5+ versions. The 1.4 theme incompatibility is fine the main reason for upgrading is to use a Responsive theme that comes with the 1.5+ versions of Prestashop. If I export my products and categories can I also export the customers data so that they are able to log in when the new site takes over? Link to comment Share on other sites More sharing options...
Bill Dalton Posted May 26, 2013 Share Posted May 26, 2013 I should mention that exporting to CSV is not built into Prestashop. You need to know how to create MySQL query's and use a tool like phpmyadmin. You can look at the sample CSV files to get the proper format to import. Back Office > Tools > CSV Import If you have a large amount of products I'd go with setting up XAMPP and trying the upgrade in that environment. That lets you give it all the memory and time the scripts need to run. Another option is to make a post in the paid help forum. Just state you need help upgrading from 1.4 to 1.5 and link back to this thread. http://www.prestasho...ffers-services/ 1 Link to comment Share on other sites More sharing options...
Floobynooby Posted May 31, 2013 Author Share Posted May 31, 2013 Hi Bill managed to get to work thanks the advice was much appreciated. Thought I would post the solution maybe will help someone else who is having a similar problem: In "my.ini" change: [mysqld] max_allowed_packet=2400M (Don't think it needs to be so high but its a local setup so won't harm for my purposes + it worked) Upgrades to 1.5.4.1 no timeouts : ) 2 Link to comment Share on other sites More sharing options...
vargaz Posted July 19, 2013 Share Posted July 19, 2013 what is the fix of the problem??? didnt find a my.ini where can i find that to change the parameters? thx 4 answer Link to comment Share on other sites More sharing options...
rinanaik Posted October 31, 2013 Share Posted October 31, 2013 I have a same error message display.each Time I try the 1 click upgrade I get to the Now upgrading database and then the message "[server Error] Timeout:The request exceeded the max_time_limit. Please change your server configuration." and then it hangs. 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