EMERA Posted April 13, 2014 Share Posted April 13, 2014 Hello all, after the last update, I cannot access the Modules module, can anyone tell me what to do to fix this problem? thanks!!! Link to comment Share on other sites More sharing options...
vekia Posted April 13, 2014 Share Posted April 13, 2014 hello what you see instead of "modules" page? some errors? white page? Link to comment Share on other sites More sharing options...
EMERA Posted April 13, 2014 Author Share Posted April 13, 2014 Thanks for the reply. When Modules is clicked, the page tries to load for about three (3) minutes, then it goes into an HTTP Error 500 - Page not found. Please let me know if you need any additional information or access to the admin pane, also; I am having problems at checkout with NO CARRIERS AVAILABLE and finally; Uploading products via CVS, uploads incomplete data, I will have to delete some of the products that were uploaded without their NAMES, no big deal, but thought I mention it. thanks again! Link to comment Share on other sites More sharing options...
vekia Posted April 13, 2014 Share Posted April 13, 2014 turn on error reporting in your prestashop, then try to open modules page. do you see some errors with detailed description then? if not - have you got an access to php error log? Link to comment Share on other sites More sharing options...
EMERA Posted April 13, 2014 Author Share Posted April 13, 2014 (edited) Hello again, following is the error: [PrestaShop] Fatal error in module smarty_internal_cacheresource_file:Maximum execution time of 300 seconds exceeded If you still need the error log file, please let me know where to find it! PS 1.6+ thanks! Edited April 13, 2014 by EMERA (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted April 14, 2014 Share Posted April 14, 2014 noo, it's enough btw. Hello all, after the last update you mean that after update of prestashop, or after update of modules? Link to comment Share on other sites More sharing options...
EMERA Posted April 14, 2014 Author Share Posted April 14, 2014 The last PrestaShop update were sent with about 5 or 6 different modules update, including an update for the "Image Slider" which also got messed up, but I fixed that one after doing a search yesterday. To answer your question, it was after running the updates send to the 'Modules Page' from PrestaShop! thanks. Link to comment Share on other sites More sharing options...
EMERA Posted April 16, 2014 Author Share Posted April 16, 2014 Hi vekia, can you still help me out with this problem? Link to comment Share on other sites More sharing options...
vekia Posted April 16, 2014 Share Posted April 16, 2014 sure, im still available to help so, let's clarify what we have got now. error log file is a simple .txt file named log.txt or error.txt located in root dir of your hosting account (FTP) or in subdirectory like /tmp/ or /log/ can you verify it? Link to comment Share on other sites More sharing options...
EMERA Posted April 16, 2014 Author Share Posted April 16, 2014 Hey vekia, there are not .txt or .log file on the root directory, there is a /log directory that contains 3 files 1 - .htaccess, 2 - index.php and 20140416_exception.log file with the following lines; *ERROR* 2014/04/16 - 01:50:01: Duplicate entry '34-25-1' for key 'PRIMARY'<br /><br /><pre>INSERT INTO `et_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('25', '34', '1', '1', '1')</pre> at line 623 in file classes/db/Db.php*ERROR* 2014/04/16 - 01:50:01: Duplicate entry '34-25-1' for key 'PRIMARY'<br /><br /><pre>INSERT INTO `et_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('25', '34', '1', '1', '1')</pre> at line 623 in file classes/db/Db.php*ERROR* 2014/04/16 - 01:50:01: Duplicate entry '34-25-1' for key 'PRIMARY'<br /><br /><pre>INSERT INTO `et_page_viewed` (`id_date_range`, `id_page`, `counter`, `id_shop`, `id_shop_group`) VALUES ('25', '34', '1', '1', '1')</pre> at line 623 in file classes/db/Db.php Please let me know if I need to look somewhere else! Thanks! Link to comment Share on other sites More sharing options...
vekia Posted April 16, 2014 Share Posted April 16, 2014 ok so we have got error log file. is more than possible that these errors are a part of your problems. have you got an access to some database manager software like phpmyadmin? Link to comment Share on other sites More sharing options...
EMERA Posted April 16, 2014 Author Share Posted April 16, 2014 I can access it via my hosting control panel via "phpMyAdmin" MySQL panel Link to comment Share on other sites More sharing options...
vekia Posted April 16, 2014 Share Posted April 16, 2014 okay so open table named "et_page_viewed" and remove entry with: id_date_range = 25 id_page = 34 counter = 1 id_shop = 1 id_shop_group = 1 Link to comment Share on other sites More sharing options...
EMERA Posted April 16, 2014 Author Share Posted April 16, 2014 Done, entry removed! Double checked! Link to comment Share on other sites More sharing options...
EMERA Posted April 23, 2014 Author Share Posted April 23, 2014 hello again vekia, this is the error i'm getting when updating a Category: Fatal error: Maximum execution time of 300 seconds exceeded in E:\Spaces\emeratec\emeratech.com\wwwroot\tools\smarty\sysplugins\smarty_internal_cacheresource_file.php on line 180 and this is the smarty_internal_cacheresource_file.php file that is throwing the errors: <?php /** * Smarty Internal Plugin CacheResource File * * @package Smarty * @subpackage Cacher * @author Uwe Tews * @author Rodney Rehm */ /** * This class does contain all necessary methods for the HTML cache on file system * * Implements the file system as resource for the HTML cache Version ussing nocache inserts. * * @package Smarty * @subpackage Cacher */ class Smarty_Internal_CacheResource_File extends Smarty_CacheResource { /** * populate Cached Object with meta data from Resource * * @param Smarty_Template_Cached $cached cached object * @param Smarty_Internal_Template $_template template object * @return void */ public function populate(Smarty_Template_Cached $cached, Smarty_Internal_Template $_template) { $_source_file_path = str_replace(':', '.', $_template->source->filepath); $_cache_id = isset($_template->cache_id) ? preg_replace('![^\w\|]+!', '_', $_template->cache_id) : null; $_compile_id = isset($_template->compile_id) ? preg_replace('![^\w\|]+!', '_', $_template->compile_id) : null; $_filepath = $_template->source->uid; // if use_sub_dirs, break file into directories if ($_template->smarty->use_sub_dirs) { $_filepath = substr($_filepath, 0, 2) . DS . substr($_filepath, 2, 2) . DS . substr($_filepath, 4, 2) . DS . $_filepath; } $_compile_dir_sep = $_template->smarty->use_sub_dirs ? DS : '^'; if (isset($_cache_id)) { $_cache_id = str_replace('|', $_compile_dir_sep, $_cache_id) . $_compile_dir_sep; } else { $_cache_id = ''; } if (isset($_compile_id)) { $_compile_id = $_compile_id . $_compile_dir_sep; } else { $_compile_id = ''; } $_cache_dir = $_template->smarty->getCacheDir(); if ($_template->smarty->cache_locking) { // create locking file name // relative file name? if (!preg_match('/^([\/\\\\]|[a-zA-Z]:[\/\\\\])/', $_cache_dir)) { $_lock_dir = rtrim(getcwd(), '/\\') . DS . $_cache_dir; } else { $_lock_dir = $_cache_dir; } $cached->lock_id = $_lock_dir.sha1($_cache_id.$_compile_id.$_template->source->uid).'.lock'; } $cached->filepath = $_cache_dir . $_cache_id . $_compile_id . $_filepath . '.' . basename($_source_file_path) . '.php'; $cached->timestamp = @filemtime($cached->filepath); $cached->exists = !!$cached->timestamp; } /** * populate Cached Object with timestamp and exists from Resource * * @param Smarty_Template_Cached $cached cached object * @return void */ public function populateTimestamp(Smarty_Template_Cached $cached) { $cached->timestamp = @filemtime($cached->filepath); $cached->exists = !!$cached->timestamp; } /** * Read the cached template and process its header * * @param Smarty_Internal_Template $_template template object * @param Smarty_Template_Cached $cached cached object * @return booelan true or false if the cached content does not exist */ public function process(Smarty_Internal_Template $_template, Smarty_Template_Cached $cached=null) { $_smarty_tpl = $_template; return @include $_template->cached->filepath; } /** * Write the rendered template output to cache * * @param Smarty_Internal_Template $_template template object * @param string $content content to cache * @return boolean success */ public function writeCachedContent(Smarty_Internal_Template $_template, $content) { if (Smarty_Internal_Write_File::writeFile($_template->cached->filepath, $content, $_template->smarty) === true) { $_template->cached->timestamp = @filemtime($_template->cached->filepath); $_template->cached->exists = !!$_template->cached->timestamp; if ($_template->cached->exists) { return true; } } return false; } /** * Empty cache * * @param Smarty_Internal_Template $_template template object * @param integer $exp_time expiration time (number of seconds, not timestamp) * @return integer number of cache files deleted */ public function clearAll(Smarty $smarty, $exp_time = null) { return $this->clear($smarty, null, null, null, $exp_time); } /** * Empty cache for a specific template * * @param Smarty $_template template object * @param string $resource_name template name * @param string $cache_id cache id * @param string $compile_id compile id * @param integer $exp_time expiration time (number of seconds, not timestamp) * @return integer number of cache files deleted */ public function clear(Smarty $smarty, $resource_name, $cache_id, $compile_id, $exp_time) { $_cache_id = isset($cache_id) ? preg_replace('![^\w\|]+!', '_', $cache_id) : null; $_compile_id = isset($compile_id) ? preg_replace('![^\w\|]+!', '_', $compile_id) : null; $_dir_sep = $smarty->use_sub_dirs ? '/' : '^'; $_compile_id_offset = $smarty->use_sub_dirs ? 3 : 0; $_dir = $smarty->getCacheDir(); $_dir_length = strlen($_dir); if (isset($_cache_id)) { $_cache_id_parts = explode('|', $_cache_id); $_cache_id_parts_count = count($_cache_id_parts); if ($smarty->use_sub_dirs) { foreach ($_cache_id_parts as $id_part) { $_dir .= $id_part . DS; } } } if (isset($resource_name)) { $_save_stat = $smarty->caching; $smarty->caching = true; $tpl = new $smarty->template_class($resource_name, $smarty); $smarty->caching = $_save_stat; // remove from template cache $tpl->source; // have the template registered before unset() if ($smarty->allow_ambiguous_resources) { $_templateId = $tpl->source->unique_resource . $tpl->cache_id . $tpl->compile_id; } else { $_templateId = $smarty->joined_template_dir . '#' . $resource_name . $tpl->cache_id . $tpl->compile_id; } if (isset($_templateId[150])) { $_templateId = sha1($_templateId); } unset($smarty->template_objects[$_templateId]); if ($tpl->source->exists) { $_resourcename_parts = basename(str_replace('^', '/', $tpl->cached->filepath)); } else { return 0; } } $_count = 0; $_time = time(); if (file_exists($_dir)) { $_cacheDirs = new RecursiveDirectoryIterator($_dir); $_cache = new RecursiveIteratorIterator($_cacheDirs, RecursiveIteratorIterator::CHILD_FIRST); foreach ($_cache as $_file) { if (substr(basename($_file->getPathname()),0,1) == '.' || strpos($_file, '.svn') !== false || strpos($_file, 'index.php') !== false) continue; // directory ? if ($_file->isDir()) { if (!$_cache->isDot()) { // delete folder if empty @rmdir($_file->getPathname()); } } else { $_parts = explode($_dir_sep, str_replace('\\', '/', substr((string)$_file, $_dir_length))); $_parts_count = count($_parts); // check name if (isset($resource_name)) { if ($_parts[$_parts_count-1] != $_resourcename_parts) { continue; } } // check compile id if (isset($_compile_id) && (!isset($_parts[$_parts_count-2 - $_compile_id_offset]) || $_parts[$_parts_count-2 - $_compile_id_offset] != $_compile_id)) { continue; } // check cache id if (isset($_cache_id)) { // count of cache id parts $_parts_count = (isset($_compile_id)) ? $_parts_count - 2 - $_compile_id_offset : $_parts_count - 1 - $_compile_id_offset; if ($_parts_count < $_cache_id_parts_count) { continue; } for ($i = 0; $i < $_cache_id_parts_count; $i++) { if ($_parts[$i] != $_cache_id_parts[$i]) continue 2; } } // expired ? if (isset($exp_time)) { if ($exp_time < 0) { preg_match('#\'cache_lifetime\' =>\s*(\d*)#', file_get_contents($_file), $match); if ($_time < (@filemtime($_file) + $match[1])) { continue; } } else { if ($_time - @filemtime($_file) < $exp_time) { continue; } } } $_count += @unlink((string) $_file) ? 1 : 0; } } } return $_count; } /** * Check is cache is locked for this template * * @param Smarty $smarty Smarty object * @param Smarty_Template_Cached $cached cached object * @return booelan true or false if cache is locked */ public function hasLock(Smarty $smarty, Smarty_Template_Cached $cached) { if (version_compare(PHP_VERSION, '5.3.0', '>=')) { clearstatcache(true, $cached->lock_id); } else { clearstatcache(); } $t = @filemtime($cached->lock_id); return $t && (time() - $t < $smarty->locking_timeout); } /** * Lock cache for this template * * @param Smarty $smarty Smarty object * @param Smarty_Template_Cached $cached cached object */ public function acquireLock(Smarty $smarty, Smarty_Template_Cached $cached) { $cached->is_locked = true; touch($cached->lock_id); } /** * Unlock cache for this template * * @param Smarty $smarty Smarty object * @param Smarty_Template_Cached $cached cached object */ public function releaseLock(Smarty $smarty, Smarty_Template_Cached $cached) { $cached->is_locked = false; @unlink($cached->lock_id); } } ?> Please let me know what can I do to fix this error! Thanks! Link to comment Share on other sites More sharing options...
vekia Posted April 23, 2014 Share Posted April 23, 2014 how many categories you've got? (problem is not related to file that you pasted) Link to comment Share on other sites More sharing options...
EMERA Posted April 24, 2014 Author Share Posted April 24, 2014 (edited) I have 60 categories so far, planning to add more as I have a very diverse shop. Is that an issue? Edited April 24, 2014 by EMERA (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted April 24, 2014 Share Posted April 24, 2014 no, it's not issue, and in fact - issue is somewhere else. something causing very long execution time of scripts. are you able to see, or perhaps you can ask your hoster about that: mysql slow queries log ? Link to comment Share on other sites More sharing options...
EMERA Posted April 29, 2014 Author Share Posted April 29, 2014 Hello again vekia, still don't have access to modules page, still get the http error 500 and the host says he cannot provide a slow query log. What else can we do? Please! Link to comment Share on other sites More sharing options...
NioGio Posted October 18, 2014 Share Posted October 18, 2014 I too am having trouble accessing the modules page in 1.6. Just upgraded, and that is the only problem I am having so far. This is what I get when I try to go to "Modules" from the dashboard: [PrestaShop] Fatal error in module smarty_internal_templateparser:Allowed memory size of 33554432 bytes exhausted (tried to allocate 19456 bytes) How do I correct this so I can work with the modules?! Link to comment Share on other sites More sharing options...
Recommended Posts