FANDOM


Forums > Senate Hall archive > SH Archive/Problems with my account


Hi, I didn't know where to put this, so I hope this is the right place. There seems to be a problem with my Wookieepedia-account. Everytime I try to log in, some kind of error occurs. This is happening for the last three days. I'm not an expert with all this codes and stuff, so I'm kind of desperate right now and don't know what to do next (if there even is something I can do about it.)

So, hopefully someone knows what to do, when this appears on your screen:

MediaWiki internal error.
Original exception: exception 'DBQueryError' with message 'A database error has occurred
Query: SELECT city_title, city_dbname, city_url, COUNT(city_dbname) AS sn_count FROM `wikicities`.`shared_newtalks`, `wikicities`.`city_list` WHERE sn_wiki = city_dbname AND sn_user_id = 12113 AND sn_user_ip = 'Borsk Fey'lya' GROUP BY city_dbname;
Function: HOOK > RetrieveSharedNewTalk
Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lya' GROUP BY city_dbname' at line 1 (216.224.121.137)
' in /usr/wikia/source/wiki16svn/includes/Database.php:650
Stack trace:
#0 /usr/wikia/source/wiki16svn/includes/Database.php(607): Database->reportQueryError('You have an err...', 1064, 'SELECT city_tit...', 'HOOK > Retrieve...', false)
#1 /usr/wikia/source/wiki16svn/extensions/wikia_newtalk.php(76): Database->query('SELECT city_tit...', 'HOOK > Retrieve...')
#2 [internal function]: wfWikiaRetrieveSharedNewTalk(Object(User), Array)
#3 /usr/wikia/source/wiki16svn/includes/Hooks.php(114): call_user_func_array('wfWikiaRetrieve...', Array)
#4 /usr/wikia/source/wiki16svn/includes/User.php(867): wfRunHooks('UserRetrieveNew...', Array)
#5 /usr/wikia/source/wiki16svn/includes/SkinTemplate.php(271): User->getNewMessageLinks()
#6 /usr/wikia/source/wiki16svn/includes/OutputPage.php(604): SkinTemplate->outputPage(Object(OutputPage))
#7 /usr/wikia/source/wiki16svn/includes/Wiki.php(252): OutputPage->output()
#8 /usr/wikia/source/wiki16svn/index.php(124): MediaWiki->finalCleanup(Array, Object(LoadBalancer), Object(OutputPage))
#9 {main}
Exception caught inside exception handler: exception 'DBUnexpectedError' with message 'Error in numRows(): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'lya' GROUP BY city_dbname' at line 1' in /usr/wikia/source/wiki16svn/includes/Database.php:790
Stack trace:
#0 /usr/wikia/source/wiki16svn/extensions/wikia_newtalk.php(78): Database->numRows(false)
#1 [internal function]: wfWikiaRetrieveSharedNewTalk(Object(User), Array)
#2 /usr/wikia/source/wiki16svn/includes/Hooks.php(114): call_user_func_array('wfWikiaRetrieve...', Array)
#3 /usr/wikia/source/wiki16svn/includes/User.php(867): wfRunHooks('UserRetrieveNew...', Array)
#4 /usr/wikia/source/wiki16svn/includes/SkinTemplate.php(271): User->getNewMessageLinks()
#5 /usr/wikia/source/wiki16svn/includes/OutputPage.php(604): SkinTemplate->outputPage(Object(OutputPage))
#6 /usr/wikia/source/wiki16svn/includes/Exception.php(53): OutputPage->output()
#7 /usr/wikia/source/wiki16svn/includes/Exception.php(70): MWException->reportHTML()
#8 /usr/wikia/source/wiki16svn/includes/Exception.php(145): MWException->report()
#9 /usr/wikia/source/wiki16svn/includes/Exception.php(179): wfReportException(Object(DBQueryError))
#10 [internal function]: wfExceptionHandler(Object(DBQueryError))
#11 {main}

(I guess it is okay to post this here. Isn't it?)

As far as I understand, it has something to do with the "'lya" in my username. But that's pretty much all I can read out of that gibberish. Is this just a temporary error, do I have to create a new account or is there another solution? Please help me. Thank you!

84.169.3.62 21:03, 25 December 2006 (UTC) (The Wookieepedian fomerly known as User: Borsk Fey'lya)

  • It's the apostrophe in your name, yes. See the part where it says AND sn_user_ip = 'Borsk Fey'lya' ? The apostophe is effectively making it tell the system that your username is Borsk Fey and then interpreting 'lya' as garbage which breaks the rest of the SQL statement and screws up your login. Long story short, it's a problem on Wikia's side, there's nothing you can do about it except wait for them to fix it (though you could send them an email or something to point out this error, obviously). Uxviii 21:30, 26 December 2006 (UTC)
    • Thank you very much for your advice! As you can see, it's working again! =) Borsk Fey'lya 15:27, 28 December 2006 (UTC)

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.