install problem

[axel_afp]

Hello,
Microsoft Windows server 2003 R2 Enterprise Edition SP 2
IIS6
MySQL client version: 5.0.51a
php 5

"Error while inserting data into the database:
‘INSERT INTO `ps_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`) VALUES (1, 7, 23, 1)’
Field \‘date_add\’ doesn\‘t have a default value(Error: : 1364)"

manage to solve it with this

INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`, `date_add`) VALUES (1, 7, 23, 1, NOW());
INSERT INTO `PREFIX_cart_product` (`id_cart`, `id_product`, `id_product_attribute`, `quantity`, `date_add`) VALUES (1, 9, 0, 1, NOW());

now when i try to install prestashop 1.1 full mode i cant pass step 3, database conected...and after i hit next nothing happens just the progress bar in right corner and then stops......delete everything drop database....installed again but now simple mode....now another error

"PHP Warning: require_once(/tools/smarty/Smarty.class.php) [function.require-once]: failed to open stream: No such file or directory in C:\Hxxx\axxx\eshop.arcanacomputers.ro\wwwroot\config\smarty.config.inc.php on line 3 PHP Fatal error: require_once() [function.require]: Failed opening required '/tools/smarty/Smarty.class.php' (include_path='.;C:\php5\pear') in C:\Hxxxs\axxx\eshop.arcanacomputers.ro\wwwroot\config\smarty.config.inc.php on line 3"

if i install cre loade...or os commerce...or zencart...or another commerce everything its ok ... before that i had installed prestashop 1.0 and was fine now i cant install them. Some help? pls..........

[Guest]

Double check files/dolders permission again...

[axel_afp]

i have check them over and over again...i even give full rights over entire site and on all folders still same problem....

[axel_afp]

no one knows how to manage this error?

[ruilong]

I get this error in FIREFOX during upgrades so I use IE for upgrades.. try switch to different browser.

[axel_afp]

i did try to install with IE, Safari, firefox...same thing...still not working...

[axel_afp]

with firebug i get this error

result="fail"
error="11"
sqlMsgError="You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near \'SET NAMES \'utf8\'\' at line
1"
sqlNumberError="1064"
sqlQuery="SET NAMES \'utf8\'"
/>

[axel_afp]

c'mon help me with this one pls

[axel_afp]

i have installed magento shop without any prob. but i still want to install presta shop its that hard to give me some answers for my problems?....i have latest php cgi/fastcgi ....latest mysql.... all permissions are full granted .... stil same errors

“PHP Warning: require_once(/tools/smarty/Smarty.class.php) [function.require-once]: failed to open stream: No such file or directory in C:\Hxxx\axxx\eshop.arcanacomputers.ro\wwwroot\config\smarty.config.inc.php on line 3 PHP Fatal error: require_once() [function.require]: Failed opening required ‘/tools/smarty/Smarty.class.php’ (include_path=’.;C:\php5\pear’) in C:\Hxxxs\axxx\eshop.arcanacomputers.ro\wwwroot\config\smarty.config.inc.php on line 3”

and with firebug

""

and i see so many on forum with this 3 step install problem .... i tried full mode...simplemode.....wtf its so hard to install it?


look on www.eshop.arcanacomputers.ro and see the magento working and they dont even support iis 6.0 .... and its working...pfff......Help meeeee plsss

[TropischBruin]

i have installed magento shop without any prob. but i still want to install presta shop

What is the problem with people who have problem trying to install PS but succeed in installing Magento or any other cart.

Do you really think that the installation is the same?
Try installing osCommerce or VP-ASP!

So shut up and look at you server error-logs to see what the problem could be but DO-NOT compare apples with pears!

And if Magneto does work and you are not willing to invest on what the problem is with installing PS then stick to Magneto and good luck!

[Gregory Roussac]

Ok please take it easy guys

sqlQuery="SET NAMES \'utf8\'"/>

Your mysql client has clearly a problem with the .sql files. Probably their encoding changed. ( while FTP transfering ?) as the three "" are strange.

And then you have a second problem, it can not find the smarty project in the Tools folder....strange too....Sure you have that file (/tools/smarty/Smarty.class.php) in your folders ?

[axel_afp]

TropischBruin maybe you have to go and sleep...dont post if you cant help..ok?/// i said in first post

"if i install cre loade…or os commerce…or zencart…or another commerce everything its ok … before that i had installed prestashop 1.0 and was fine now i cant install them. Some help? pls………."

so before that i had prestashop1.0 installed and that works fine untill i deleted and install 1.1...i didnt change anything..and no success i have mysql and php updated to latest version and still same thing....and yes the file is in /tools/smarty/Smarty.class.php and permissions are set for that folder and files and i didnt do ftp transfering of files to server anyway thx Gregory for answer ...and about sqlQuery=“SET NAMES \‘utf8\’”>
i said i insalled that other shopcarts to see if they work becouse they required utf8 support and that error was about utf8 and not to someone like TropischBruin who insted of help its telling me to shut up...pfff. I will try to manage this by my self and excusse me for posting here.

[Gregory Roussac]

You are very welcome to post here moreover that your debug diagnostic is very good

This look like this ... http://www.prestashop.com/forums/viewthread/11944/installation_configuration___upgrade/windowsiis_server_install___fileimage_upload_fix