oscommerce2.2 ms2 doesn't fully support mysql4.1?

[NerioDavid]

In the past couple days, I installed oscommerce with mysql4.1, and I found that there some problems in admin panel, such as Customers->Orders or Reports->Customer Orders-Total, has a mysql sytanx error:

 

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 '-20, 20' at line 1

"cangeceiro"says this would a bug personally, but I don't think so.

And when I try to install the "wolfen featured sets" contribution, I can't run the sql on my database.

 

Finally I install the mysql 4.0.23, the problems are all go away.

Is it something that oscommerce has not fully compatible with the mysql4.1?

[nickswf]

In the past couple days, I installed oscommerce with mysql4.1, and I found that there some problems in admin panel, such as Customers->Orders or Reports->Customer Orders-Total, has a mysql sytanx error:

   

    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 '-20, 20' at line 1

  "cangeceiro"says this would a bug personally, but I don't think so.

    And when I try to install the "wolfen featured sets" contribution, I can't run the sql on my database.

 

  Finally I install the mysql 4.0.23, the problems are all go away.

  Is it something that oscommerce has not fully compatible with the mysql4.1?

<{POST_SNAPBACK}>

 

I've run into the same error. I don't know the differences in syntax to pinpoint the error. I guess we just have to wait for an upgrade.

[boxtel]

I've run into the same error. I don't know the differences in syntax to pinpoint the error. I guess we just have to wait for an upgrade.

<{POST_SNAPBACK}>

 

there is a fix for that in the knowledge base I think.