Jump to content

compuman1112

Members
  • Posts

    11
  • Joined

  • Last visited

Profile Information

  • First Name
    Willem-Jan
  • Last Name
    Waterman

compuman1112's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. How can i change the depth of the main menu? In other words, how can i hide some subcatogories from the main menu? I'm using the latest prestashop build 1.7.X If you look at my shop, www.compu4u.nl and hover over the main menu bar, you will see that it is very very large. I want to downsize it, so its easier to use. But i dont know how to do it.
  2. I did enable it and it tells me this: Warning: mcrypt_decrypt(): Received initialization vector of size 7, but size 16 is required for this encryption mode in /mnt/webs/e3/84/54570284/htdocs/Prestashop_01/classes/Rijndael.php on line 68 Warning: Cannot modify header information - headers already sent by (output started at /mnt/webs/e3/84/54570284/htdocs/Prestashop_01/classes/Rijndael.php:68) in /mnt/webs/e3/84/54570284/htdocs/Prestashop_01/classes/Cookie.php on line 343 As soon as i open the backoffice login page it tells me this. Any idea?
  3. Hello, After upgrading to Prestashop version 1.6.1.12 the backoffice isn't working. I can't login in backoffice, after filling in the credentials it just refreshes itself and make the field empty again. Any solotions? Things i tried so far; Cleared browser cache Cleared history Reset username/password Different browsers (Chrome, Edge, Firefox) Incognito mode within Chrome Please help!
  4. Version now: 1.6.0.9 i'm trying to upgrade to the newest version availible. In some lines it tells "doesnt exist", can that be the problem?
  5. Upgrading under localhost doesn't work either. But i was able to found some of the error message; SQL 1.6.0.10 1286 in CREATE TABLE `prstshp_smarty_cache` ( `id_smarty_cache` char(40) NOT NULL, `name` char(40), `cache_id` varchar(254) DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `content` longtext NOT NULL, PRIMARY KEY (`id_smarty_cache`), KEY `name` (`name`), KEY `cache_id` (`cache_id`), KEY `modified` (`modified`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.0.10 1286 in CREATE TABLE IF NOT EXISTS `prstshp_order_slip_detail_tax` ( `id_order_slip_detail` int(11) unsigned NOT NULL, `id_tax` int(11) unsigned NOT NULL, `unit_amount` decimal(16,6) NOT NULL DEFAULT '0.000000', `total_amount` decimal(16,6) NOT NULL DEFAULT '0.000000', KEY (`id_order_slip_detail`), KEY `id_tax` (`id_tax`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.0.10 1286 in CREATE TABLE IF NOT EXISTS `prstshp_mail` ( `id_mail` int(11) unsigned NOT NULL AUTO_INCREMENT, `recipient` varchar(126) NOT NULL, `template` varchar(62) NOT NULL, `subject` varchar(254) NOT NULL, `id_lang` int(11) unsigned NOT NULL, `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id_mail`), KEY `recipient` (`recipient`(10)) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.0.12 1286 in CREATE TABLE `prstshp_cms_category_shop` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_cms_category`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_tag_count` ( `id_group` int(10) unsigned NOT NULL DEFAULT 0, `id_tag` int(10) unsigned NOT NULL DEFAULT 0, `id_lang` int(10) unsigned NOT NULL DEFAULT 0, `id_shop` int(11) unsigned NOT NULL DEFAULT 0, `counter` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id_group`, `id_tag`), KEY (`id_group`, `id_lang`, `id_shop`, `counter`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.0 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt LEFT JOIN `prstshp_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `prstshp_product` p ON (p.id_product = pt.id_product) INNER JOIN `prstshp_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_group FROM `prstshp_category_group`) cg JOIN (SELECT DISTINCT id_shop FROM `prstshp_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND p.`id_product` = cp.`id_product`) AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag, cg.id_group: Table 'prestashop.prstshp_tag_count' doesn't exist SQL 1.6.1.0 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt LEFT JOIN `prstshp_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `prstshp_product` p ON (p.id_product = pt.id_product) INNER JOIN `prstshp_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_shop FROM `prstshp_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag: Table 'prestashop.prstshp_tag_count' doesn't exist SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_smarty_lazy_cache` ( `template_hash` varchar(32) NOT NULL DEFAULT '', `cache_id` varchar(255) NOT NULL DEFAULT '', `compile_id` varchar(32) NOT NULL DEFAULT '', `filepath` varchar(255) NOT NULL DEFAULT '', `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`template_hash`, `cache_id`, `compile_id`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_smarty_last_flush` ( `type` ENUM('compile', 'template'), `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`type`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.0 1286 in CREATE TABLE `prstshp_modules_perfs` ( `id_modules_perfs` int(11) unsigned NOT NULL AUTO_INCREMENT, `session` int(11) unsigned NOT NULL, `module` varchar(62) NOT NULL, `method` varchar(126) NOT NULL, `time_start` double unsigned NOT NULL, `time_end` double unsigned NOT NULL, `memory_start` int unsigned NOT NULL, `memory_end` int unsigned NOT NULL, PRIMARY KEY (`id_modules_perfs`), KEY (`session`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.0 1146 in ALTER TABLE `prstshp_smarty_lazy_cache` CHANGE `cache_id` `cache_id` varchar(255) NOT NULL DEFAULT '': Table 'prestashop.prstshp_smarty_lazy_cache' doesn't exist SQL 1.6.1.0 1146 in TRUNCATE TABLE `prstshp_smarty_lazy_cache`: Table 'prestashop.prstshp_smarty_lazy_cache' doesn't exist SQL 1.6.1.0 1286 in /* Advanced EU Compliance tables */ CREATE TABLE IF NOT EXISTS `prstshp_cms_role` ( `id_cms_role` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `id_cms` int(11) unsigned NOT NULL, PRIMARY KEY (`id_cms_role`, `id_cms`), UNIQUE KEY `name` (`name`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.0 1286 in CREATE TABLE IF NOT EXISTS `prstshp_cms_role_lang` ( `id_cms_role` int(11) unsigned NOT NULL, `id_lang` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, PRIMARY KEY (`id_cms_role`,`id_lang`, `id_shop`) ) ENGINE=MariaDB DEFAULT CHARSET=utf8: Unknown storage engine 'MariaDB' SQL 1.6.1.2 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt INNER JOIN `prstshp_product_shop` product_shop USING (id_product) JOIN (SELECT DISTINCT id_group FROM `prstshp_category_group`) cg WHERE product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `prstshp_category_product` cp LEFT JOIN `prstshp_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND product_shop.`id_product` = cp.`id_product`) GROUP BY pt.id_tag, pt.id_lang, cg.id_group, id_shop ORDER BY NULL: Table 'prestashop.prstshp_tag_count' doesn't exist SQL 1.6.1.2 1146 in REPLACE INTO `prstshp_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `prstshp_product_tag` pt INNER JOIN `prstshp_product_shop` product_shop USING (id_product) WHERE product_shop.`active` = 1 GROUP BY pt.id_tag, pt.id_lang, id_shop ORDER BY NULL: Table 'prestashop.prstshp_tag_count' doesn't exist SQL 1.6.1.2 1146 in TRUNCATE TABLE `prstshp_smarty_last_flush`: Table 'prestashop.prstshp_smarty_last_flush' doesn't exist
  6. Nope i did not get any more specific error after changing those values.... So do you have any other idea?
  7. Hi! I edited the value but the error is still the same.... Any other ideas? Also tried this (i found somewhere on this forum): -> Make a full backup first -> Download the latest stable Prestashop version -> Extract the folder -> Open the folder and you will get 2 subfoders: Prestashop and Install_PrestaShop.html -> Copy/Paste ONLY the Prestashop subfolder here: /admin/autoupgrade/latest/ -> Go to 1 Click Upgrade module -> On Start your Upgrade field click the button on the right named More options (Expert mode) -> Go to Expert mode -> Channel -> select Local directory -> write the presta version you are ungradeing to (ex: 1.6.1.1) -> Save -> On Backup Options field -> Back up my files and database -> select No -> Save -> On Upgrade Options fiend -> Disable non-native modules -> select No -> Save -> Check if above settings are made -> then Upgrade the version
  8. Hey all! When i try to update my Prestashop with the 1 click upgrade module it keeps failing. Everything goes fine until the very last step. The error says: [Ajax / Server Error for action upgradeComplete] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. " I don't know how to fix it. Please help!
×
×
  • Create New...