MySql 5

[fumocamel]

I installed xt commerce on mysql 5
but i have some problem

i read on internet that xt commerce have some problem with mysql 5 join function

this is one of the errors

1064 - 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 ') on p.manufacturers_id = m.manufacturers_id' at line

how can i resolve this?

thanks!

[nrrlh]

Version off the Shop ???

[fumocamel]

version 3.x

.....

[nrrlh]

With mysql 5 appear by the stricter SQL 03 standardumsetzungen fehler.
The following Datein substitute:

~/includes/modules/default.php
~/products_new.php
~/product_reviews_info.php

http://www.xt-commerce.com/forums/in...howtopic=27302

By
Norbert

[fumocamel]

thanks but your link don't work or i can't get in?

thanks

[nrrlh]

Oh you can use him only as a sponsor to

By Norbert

[fumocamel]

Thanks but now i can not be a sponsor, cause don't have money.

So how can i resolve this problem?

I translate the admin section in italian if u want.

Marco

[polkhigh33]

So how can i resolve this problem?

use mysql4.

[fumocamel]

I installed xt commerce on a shared server.
I don't know if i can ask a downgrading, from MySql 5 to MySql 4.
Believe me, it's not a problem about money, but i just start to make this kind of things (delevoping php, installing this software, ecc...) and now i don't have money to be a sponsor.

Thanks

[polkhigh33]

normally you can decide if you create a database using mysql 5 or 4, on all providers i have seen so far.