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/index.php?showtopic=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.

[fumocamel]

I have to ask to service provider.

In this case is Aruba www.aruba.it

very cheap service but not so good.

Thanks

[fumocamel]

u can see my errors

1054 - Unknown column 'p.products_vpe' in 'field list'

http://lnx.italsiam.biz

[fumocamel]

I think i resolve....

i think....

bye :tongue:

[fumocamel]

i have this problem

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 'products_description pd left join specials s on (p.products_id = s.products_id) ' at line 1

in advanced_search_result.php

i don't understand the difference between mysql 5.x to 4.x

thanks

[fumocamel]

i resolve this problem in

advanced_search_result.php

from

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " .

TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " .

TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";

to

$from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) INNER JOIN " .

TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id INNER JOIN " .

TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";