alain.roger
-
Posts
17 -
Joined
-
Last visited
alain.roger's Achievements
Newbie (1/14)
5
Reputation
-
Hi, i would like to get your feedback on e-shop features for a small e-shop of 100-150 products max. i need to create a professional website with e-shop features. 1. at first, e-shop should be disable and only works as CATALOG. Later on e-shop will be used for selling products. 2. it should allow 3 or 4 different languages interface 3. on each product page, visitor should be able to send a product information request to me, to get a price offer (as long as the catalog mode will be activated) 4. speed of page display should be fast to avoid loosing potential customers. 5. SEO should be fully covered. i would like what would be the best solution ? should i work with prestashop or isn't it a huge and complex solution for a such small e-shop ? moreover, to get what i want, should i purchase some extra modules ? if yes, which ones ? because i need to have a create overview of additional costs. thx for your feedback A.
-
Ok, so for those who have the same issue, i have a solution. in fact the problem is located at 2 places. 1. on some Linux web server, owner of web site (files/folders) should be apache. so as a group and user >> chown -R apache:apache 2. on some linux server like Fedora SELinux Alert Browser also play a role and to allow apache to perform some actions read/write, change permissions etc... you need to allow them. so to check what is needed to do on "httpd" you can use: getsebool -a | grep httpd or directly: setsebool -P httpd_enable_cgi on setsebool -P httpd_unified on setsebool -P httpd_builtin_scripting on now you can give a 644 to all files and 705 to folders. It should work perfectly. Hope it will help you Have a nice day. Alain
-
Unfortunatelly no... i already tried it. usually i use 644 for files and 705 for folders but here i don't know what's wrong.
-
Hi, i've just finished to install a brand new webserver based on Fedora 18/apache 2.4.4/MySQL 5.5.30/openssl 1.0.1e and PHP 5.4.14. during installation of Prestashop 1.5.4 i got the following error screen so for testing purpose i set all files and folders to 0777 but nothing changed, then i change user:group to apache...but once again nothing changed. any idea where could be located the problem ? thx. Alain
-
It could be great if Prestashop developers point me where this steps starts and how are split default shop installation from language installation, in order to not waste time to analyse the whole code.
-
I even tried with MyISAM engine, nothing changed.... maybe somewhere there is written a SELECT OPTION sql statement... i know that it doesn't exist anymore in MySQL 5.6...i already had such issue also under an Joomla extension.... i guess problem is once again with MySQL as i didn't change anything on our remote server and it works well...but there it's MySQL 5.5
-
Hi, all my folders have 0705 as permissions and files 0777. i tried to install with InnoDB...same result as previously. so nothing changed
-
Hi Benjamin, i'm going there right now and submit my idea. What about the 2 other files ? because you suggested only 1 file change... If i can further help no problem... that's my goal Alain
-
Hi, I decided to create an individual post for this topic. i faced this issue with MySQL 5.6.10 but not on MySQL 5.5, however i don't know if there is something else that we need to take care because MySQL 5.6 is on our local development server whereas MySQL 5.5 is on our remote production server. The issue is the following one (and has nothing in common with MySQL Engine type - in both case, MyISAM or InnoB, the error raises): - During installation of PrestaShop 1.5.4 at 25% (default Shop and Languages installation), i get an error as the attached file. Am I the only one ? I don't think so... however how did other solve it ? What was the problem ? thx.
-
so here it is how i fixed it for MySQL v5.6.10: if (strtolower($engine) == 'innodb') { //$sql = 'SHOW VARIABLES WHERE Variable_name = \'have_innodb\''; $sql='SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE \'INNODB\''; $result = $link->query($sql); if (!$result) return 4; $row = $result->fetch(); if (!$row || (strtolower($row['SUPPORT']) != 'yes' && strtolower($row['SUPPORT']) != 'default')) //if (!$row || strtolower($row['Value']) != 'yes') return 4; for sure, in order to improve back compatibility i invite prestashop developers to do an additional check on MySQL version and based on return to change the $sql as also the test : !$row || Hope that it help other developers
- 10 replies
-
- 1
-
-
- language
- installation
- (and 3 more)
-
to be more accurate, in fact we can use $sql = "SELECT SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE LIKE 'INNO%'"; and check if return DEFAULT or YES... and that's it
-
Ok, so i found some interesting things. 1. validation test First of all, i use MySQL v5.6.10 and since v5.1 'have_innodb' name doesn't exist anymore. Therefore, the test to check if innoDB engine is supported (in file /prestashop_1.5.4.0/prestashop/classes/db/DbMySQLi.php line 177) is not anymore valid... function to check can't be: $sql = 'SHOW VARIABLES WHERE Variable_name = \'have_innodb\''; now it's SHOW ENGINES; the same issue in file /prestashop_1.5.4.0/prestashop/classes/db/DbPDO.php line 212. the same issue in file /prestashop_1.5.4.0/prestashop/classes/db/MySQL.php line 171.
-
In this case, why default installation of prestashop offers to select between 2 engines: MyISAM and InnoDB ? this should be removed and administrator informed that ONLY InnoDB engine is allowed. I checked in Apache logs and there's nothing special about an error
-
Hi, During my first installation of prestashop using MySQL MyiSAM engine i got an error message as in the attached file. I tried to find a log somewhere, but i didn't find some file written by prestashop. Any idea where could i look for or what is it ? thx.
