MYSQL error after server upgrade to php 5

[dominique]

So glad to find this site up and running!

My server has just upgraded from php4 to php5 and a site I developed with MX KART and Kollection Pro

The products used, according to my version.xml are:


<product name="Transaction Engine" version="3.7.1" />
<product name="MX Navigation Pack" version="1.8.6" />
<product name="XML Import-Export" version="1.8.6" />
<product name="KTML4 Developer" version="4.1.6" />
<product name="MX CSS Menus 2" version="2.1.1" />
<product name="MX Form Validation" version="Pro-3.7.1" />
<product name="MX Includes" version="Pro-3.7.1" />
<product name="MX Looper3" version="Pro-3.7.1" />
<product name="MX Send E-mail" version="Pro-3.7.1" />
<product name="MX User Login" version="Pro-3.7.1" />
<product name="MX Widgets" version="Pro-3.7.1" />
<product name="NeXTensio3" version="Pro-3.7.1" />
<product name="MX Query Builder" version="Pro-3.7.1" />
<product name="MX File Upload" version="Pro-3.7.1" />

After clicking my 'add to cart' link I get the following error:

Code: Select all

Unknown column 'states_sta.idcnt_sta' in 'on clause'

This column is definitely there in the datbase. I have spent hours trying to trace this and have just uploaded the patches for php5.3 from this site but as yet to no avail.

Any thoughts?

Many thanks

[Fred]

The issue is probably more mysql related than php5 related. I am sure your mysql was upgraded as well.

Bets would be to post the query here so we can take a look at it. There was a couple of "unknown column" issues with the upgrade

[dominique]

Ah - I hadn't thought of that.

But the actual query is being constructed by MXKart I imagine.

The column in question is from the table relating to shipping zones - the name of the column AND of the table are those that the product recommended. I think there was an sql file that shipped with MXKart which I ran to set up the table structure?

So it seems likely to me that the error comes from a query that the current MySQL version doesn't like/support. The MySQL version is 5.0.91-community.

But in which file(s) is this query created (in MXKart or in the /includes folder) I wonder?

Many thanks for any further pointers ...

[Fred]

You will have to start at the top of the page and look at each of them in turn.
No easy way unless someone else has the same issue and can give you a pointer.

Maybe you can search for the string states_sta.idcnt_sta in your files.
That should at least lead you to the query in question.

Someone that is registered on the website is using MX Cart, not sure who it is.