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 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)