Forum:SH Archive/Problems with my account

Forums &gt; Senate Hall &gt; 

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:
 * 1) 0 /usr/wikia/source/wiki16svn/includes/Database.php(607): Database->reportQueryError('You have an err...', 1064, 'SELECT city_tit...', 'HOOK > Retrieve...', false)
 * 2) 1 /usr/wikia/source/wiki16svn/extensions/wikia_newtalk.php(76): Database->query('SELECT city_tit...', 'HOOK > Retrieve...')
 * 3) 2 [internal function]: wfWikiaRetrieveSharedNewTalk(Object(User), Array)
 * 4) 3 /usr/wikia/source/wiki16svn/includes/Hooks.php(114): call_user_func_array('wfWikiaRetrieve...', Array)
 * 5) 4 /usr/wikia/source/wiki16svn/includes/User.php(867): wfRunHooks('UserRetrieveNew...', Array)
 * 6) 5 /usr/wikia/source/wiki16svn/includes/SkinTemplate.php(271): User->getNewMessageLinks
 * 7) 6 /usr/wikia/source/wiki16svn/includes/OutputPage.php(604): SkinTemplate->outputPage(Object(OutputPage))
 * 8) 7 /usr/wikia/source/wiki16svn/includes/Wiki.php(252): OutputPage->output
 * 9) 8 /usr/wikia/source/wiki16svn/index.php(124): MediaWiki->finalCleanup(Array, Object(LoadBalancer), Object(OutputPage))
 * 10) 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:
 * 1) 0 /usr/wikia/source/wiki16svn/extensions/wikia_newtalk.php(78): Database->numRows(false)
 * 2) 1 [internal function]: wfWikiaRetrieveSharedNewTalk(Object(User), Array)
 * 3) 2 /usr/wikia/source/wiki16svn/includes/Hooks.php(114): call_user_func_array('wfWikiaRetrieve...', Array)
 * 4) 3 /usr/wikia/source/wiki16svn/includes/User.php(867): wfRunHooks('UserRetrieveNew...', Array)
 * 5) 4 /usr/wikia/source/wiki16svn/includes/SkinTemplate.php(271): User->getNewMessageLinks
 * 6) 5 /usr/wikia/source/wiki16svn/includes/OutputPage.php(604): SkinTemplate->outputPage(Object(OutputPage))
 * 7) 6 /usr/wikia/source/wiki16svn/includes/Exception.php(53): OutputPage->output
 * 8) 7 /usr/wikia/source/wiki16svn/includes/Exception.php(70): MWException->reportHTML
 * 9) 8 /usr/wikia/source/wiki16svn/includes/Exception.php(145): MWException->report
 * 10) 9 /usr/wikia/source/wiki16svn/includes/Exception.php(179): wfReportException(Object(DBQueryError))
 * 11) 10 [internal function]: wfExceptionHandler(Object(DBQueryError))
 * 12) 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)