Jump to content

[Server Error] Timeout:The request exceeded the max_time_limit


Recommended Posts

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

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. else
    2221. {
    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 form
    1445. 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 dispatcher
    344. if (isset($params_hook_action_dispatcher))
    345. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
    346.
    347. // Running controller
    348. $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 dispatcher
    49. Dispatcher::getInstance()->dispatch();

Link to comment
Share on other sites

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

  • Like 1
Link to comment
Share on other sites

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

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/

  • Like 1
Link to comment
Share on other sites

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 : )

  • Like 2
Link to comment
Share on other sites

  • 1 month later...
  • 3 months later...

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

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