I just dealt with the exact same thing today. I fixed it by running update.php and refreshLinks.php from the command line. I don't know how you'd fix it without command line access.
On Thu, 13 Jul 2006 20:07:56 -0700 (PDT), Metaspheres metaspheres@yahoo.com wrote in Message-ID 20060714030756.34777.qmail@web38101.mail.mud.yahoo.com:
Hello,
I have just upgraded from 1.6.7 to 1.7.1 and everything works fine except for when I try to save an edit to an article, I get a database error that reads as such:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "LinksUpdate::getExistingInterlangs". MySQL returned error "1146: Table 'data_base.mx_langlinks' doesn't exist (localhost)".
My host server is running PHP 5.0.4 and MySQL 4.1.19-standard-log. I followed the instructions exactly as listed. Since I have no command-line access I had to go through the regular web-based installation and then restore my original LocalSettings.php.
Is there any way I can fix this or should I revert back to 1.6.7?
Thank you,
Sven