Apache Friends Support Forum

I have just upgraded xampp from version 1.4.2 to version 1.5.4 and i copied over the websites i am working on into the htdocs folder as well as the database files into the correct folder, but now when i start a website on my hard drive that contains a daabase i get a SQL error as follows.

INVALID SQL: 1054 : Unknown column 'xcart_classes.classid' in 'on clause'
SQL QUERY FAILURE:

this isn't just on this xcart script but on all my databases, which are various scripts.

Have I done something wrong, or should I have copied over something else.

If anyone can help, that would be great.

Thanks

Russ[/b]

Have I done something wrong,

Sure, your SQL is wrong

--> Use an older MySQL-Server or correct the Code.

do i have to re-install an older version of xampp or can i just get hold of an older version of mySQL, and if so, do i just over-write the version that is in the xampp folder at the moment.

thanks

do i have to re-install an older version of xampp

You must not do this, but you can.

can i just get hold of an older version of mySQL,

That's possible. Just install in another dir and start this MySQL server and not the one from XAMPP.

and if so, do i just over-write the version that is in the xampp folder at the moment.

That's also possible. But be carefull of the MySQL system tables. (they have a different layout between the MySQL versions).

BTW:
The best way is to correct the SQL. Then your querys are working with all MySQL versions.

thanks, I think I'll just get an older version as it does seem to be screwing up the tables, so I'll start it seperatly and see how that works.

will keep you informed how it works ( or not !! )

cheers

Russ