Forum:Database error

I have just created my new wikia (http://fr.maths.wikia.com) and when I edit articles, I have an database error

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

SELECT ll_lang,ll_title FROM `langlinks` WHERE ll_from = '22' FOR UPDATE

from within function "LinksUpdate::getExistingInterlangs". MySQL returned error "1146: Table 'frmath.langlinks' doesn't exist (paris.wikia.com)".

Well, the article is well posted but that obstructs with the update of the bonds (sometimes they don't update). The error is :

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

SELECT COUNT(*) FROM `filearchive` WHERE fa_name = 'Mathswikia.jpg' LIMIT 1

from within function "Title::isDeleted". MySQL returned error "1146: Table 'frmath.filearchive' doesn't exist (paris.wikia.com)".

With the same kind of errors, I can't post images whereas for a site of mathematics, the images are capital (especially in geometry).

Please Wikia, can you repair me rather quickly this problem ? Thank you Clembou


 * It should be http://fr.math.wikia.com/ (not maths). Are you still having this problem? Angela (talk) 06:04, 14 July 2006 (UTC)
 * Oh ! Sorry ! Yes, I have still this problem on my website. Clembou 07:50, 14 July 2006 (UTC)


 * I just got it too. I've reported it at bug:385. Angela (talk) 08:16, 14 July 2006 (UTC)


 * I saw that you deferred the error of the database for the not-posted pages. But did you also defer the error of the database of the images? I leave on holiday during two weeks so I could not answer your messages. Thank you still for your assistance to repair the problem. Clembou 11:57, 14 July 2006 (UTC)


 * The problem of the data base was repaired. Thank you very much for your assistance and your repair. Clembou 07:09, 1 August 2006 (UTC)

Hi, I figured I'd use the search function and bump this old topic as opposed to starting a new one. I'm having this horrid message all the time, no matter how I try to edit my pages:


 * 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 "efUpdateCheckUserData". MySQL returned error "1146: Table 'superfriends.cu_changes' doesn't exist (216.151.156.9)".

It's frustrating me to no end. Please help. :o) Thanks. -- MichaelMogg 02:31, 20 December 2007 (UTC)
 * Ok, I received an email about this. Apparently the problem is on that end.  Thanks for the email.-- MichaelMogg 07:54, 20 December 2007 (UTC)

Hi, I have the same problem on the visualkei wikia. I can't create or edit any page because of that bug, so I'm totally unable to do anything on the wiki. I found this topic but I didn't get how to solve the problem. This is the error message it gives anytime, it's very frustrating:

Database error 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 "efUpdateCheckUserData". MySQL returned error "1146: Table 'visualkei.cu_changes' doesn't exist (216.151.156.9)".

Thank you for your help.

Hi, I'm having a 1146 error too when trying to publish any edit (the website is http://es.furry.wikia.com/). The error message is the following:

Ha ocurrido un error de sintaxis en una consulta a la base de datos. Esto puede indicar un error en el software. La última consulta que se intentó fue:

(Consulta SQL oculta)

dentro de la función «efUpdateCheckUserData». El error devuelto por la base de datos MySQL fue «1146: Table 'esfurry.cu_changes' doesn't exist (10.8.2.9)».

Is there any way to solve this problem? I can't edit nothing at all, it really frustrating. I am looking forward for your answer.

Thanks you very much. facundov@gmail.com 18:59, 10 September 2008 (UTC)

I can confirm the comment made by the previous poster. Whenever one tries to save an edit at http://es.furry.wikia.com/, the following error message is displayed:
 * A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
 * from within function " ". MySQL returned error " ".
 * from within function " ". MySQL returned error " ".

--Fibonacci 10:01, 11 September 2008 (UTC)


 * The same happens when trying to upload an image to the aforementioned wiki. --Fibonacci 20:02, 11 September 2008 (UTC)


 * These errors are rooted in the MediaWiki 1.13 upgrade. We're working on deploying fixes for them as soon as possible. Sorry about the trouble. Please continue to report new errors and we'll fix them as soon as possible. -- JSharp (talk) 23:23, 11 September 2008 (UTC)