sql errors after upgrading xampp version 1.4.2

Problems with the Windows version of XAMPP, questions, comments, and anything related.

sql errors after upgrading xampp version 1.4.2

Postby russlock » 26. September 2006 12:54

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]
russlock
 
Posts: 4
Joined: 26. September 2006 12:41

Postby Wiedmann » 26. September 2006 13:04

Have I done something wrong,

Sure, your SQL is wrong ;-)

--> Use an older MySQL-Server or correct the Code.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby russlock » 26. September 2006 13:29

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
russlock
 
Posts: 4
Joined: 26. September 2006 12:41

Postby Wiedmann » 26. September 2006 14:54

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby russlock » 26. September 2006 22:17

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
russlock
 
Posts: 4
Joined: 26. September 2006 12:41


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 38 guests