This morning, I’m working on installing open source ecommerce packages on my Windows Server 2008 box. This is mainly for experimental and learning purposes.
My first step was to read through the most current PrestaShop User Guide. The most current stable version as of this writing is PrestaShop v.1.3.5. PrestaShop uses a MySql Database, so my first task is to install the current release of MySql (5.5.8) on my Windows 2008 server.
Since I’m not currently using MySql on a daily basis, I also made sure all of my workstation components (i.e. workbench, connector, etc.) are also up to date.
I ran into a glitch installing MySql. The Configuration Wizard has an identified bug in it as reported to the MySql Bug database as, Bug #59038 mysql.user.authentication_string column causes configuration wizard to fail. To overcome this bug, I executed the following command from the MySql Workbench:
use mysql; alter table user change authentication_string authentication_string text null;
I then clicked on the re-try for the Wizard and it completed normally. After this, I ran the following commands:
use mysql; update user set authentication_string = '' where authentication_string is null; alter table user change authentication_string authentication_string text not null;
<?php echo md5("xae0u0c9kzEGgPFJWgGtgJa8PG1STZubGmeI57482nPwmzTkEowdbBth"."admin"); ?>
"C:\Program Files (x86)\PHP\php.exe" -f .\password.php
Manual Setup of PrestaShop
# go away User-agent: * Disallow: /
I then logged into the shop and set the home time zone, the default currency, the default country, etc. This was a little more difficult than I first thought it would be. However, most of the problems I encountered were due to the Windows and PHP environment settings. Once I ironed those out, everything else went fine.