Jump to content
Detective Conan World
Nara-chan

SQL Error

By Nara-chan, in Ideas and feedback

Recommended Posts

Nara-chan    38

Nara-chan
Posted

Lately when I click certain topics, a page entitled "SQL Error" pops up. Sometimes it goes away when I refresh the page, but some pages, like the New Content of the Forums, always show that message. I assumed it to be a problem about our server. But when I used DCW on another computer, the message still shows up. Later, astraculpa said that she couldn't view the forums except her messages because the "SQL Error" page keeps showing up.

I just wanted to ask if any of you encounter the same thing, and if you find a way to fix this, Arigato gozaimasu in advance!

Share this post

Link to post
Share on other sites

Chekhov MacGuffin    1089

Chekhov MacGuffin
Posted

Here are some of the error messages and contexts:

I was trying to search posts in general that contained the word "silver" and got the following error:

An error occured with the SQL server:

mySQL query error: SELECT p.*,t.*,m.member_id, m.members_display_name, m.members_seo_name,cca.*,ccb.cache_content as

cache_content_sig, ccb.cache_updated as cache_updated_sig,xxx.* FROM ips_posts p LEFT JOIN ips_topics t ON (

t.tid=p.topic_id )
LEFT JOIN ips_members m ON ( m.member_id=p.author_id )
LEFT JOIN ips_content_cache_posts cca ON ( cca.cache_content_id=p.pid )
LEFT JOIN ips_content_cache_sigs ccb ON ( ccb.cache_content_id=p.author_id )
LEFT JOIN ips_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE p.pid

IN(

97550,6659,4535,307674,301946,297769,4876,293905,292298,287255,377,23691,283972,277953,276173,275408,272957,269527,2

59448,259165,250272,222556,111519,214995,213678)

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and

copy the message shown above.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Refreshing the forums


There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is

temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator

before the site will become accessible again.

You can try to refresh the page by clicking here

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Refreshing on the Wiki

Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Can't contact the database server: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

(2) (localhost))

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Occasionally, when refreshing the wiki, instead of receiving an
error, I get a blank page

<html>
<head>
</head>
<body>
</body>
</html>

++++++
Another wiki error

A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See:

https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: SELECT lc_value FROM `wkdc_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:ancientpages' LIMIT 1
Function: LCStore_DB::get
Error: 2013 Lost connection to MySQL server during query (localhost)

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Main webpage www.detectiveconanworld.com


A Database Error Occurred

Error Number: 2013

Lost connection to MySQL server during query

SELECT `tid`, `title`, `title_seo`, `posts`, `start_date`, `last_post` FROM (`ips_topics`) WHERE `forum_id` = 4

ORDER BY `start_date` DESC LIMIT 5

Filename: models/forum_model.php

Line Number: 14

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Trying to load movie 18 page on wiki

 


For the past week or so, there have been lots of temporary outages that seem to relate to failed connections to the

mySQL server. It affects both the forums and the wiki.

Unexpected non-MediaWiki exception encountered, of type "Exception"
exception 'Exception' with message 'Unable to view external table<br />MySQL Error Number: 2013<br />MySQL Error Message: Lost connection to MySQL server during query<br /><br />' in /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php:353
Stack trace:
#0 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(173): Auth_IPB->mySQLError('Unable to view ...')
#1 [internal function]: Auth_IPB_AutoLogin_Hook(Object(User), NULL)
#2 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Hooks.php(216): call_user_func_array('Auth_IPB_AutoLo...', Array)
#3 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/GlobalFunctions.php(3823): Hooks::run('UserLoadFromSes...', Array)
#4 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(944): wfRunHooks('UserLoadFromSes...', Array)
#5 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(289): User->loadFromSession()
#6 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(4057): User->load()
#7 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(2224): User->loadOptions()
#8 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/context/RequestContext.php(274): User->getOption('language')
#9 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/cache/HTMLFileCache.php(116): RequestContext->getLanguage()
#10 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(515): HTMLFileCache::useFileCache(Object(RequestContext))
#11 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(446): MediaWiki->main()
#12 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/index.php(59): MediaWiki->run()
#13 {main}

#0 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(173): Auth_IPB->mySQLError('Unable to view ...')
#1 [internal function]: Auth_IPB_AutoLogin_Hook(Object(User), NULL)
#2 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Hooks.php(216): call_user_func_array('Auth_IPB_AutoLo...', Array)
#3 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/GlobalFunctions.php(3823): Hooks::run('UserLoadFromSes...', Array)
#4 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(944): wfRunHooks('UserLoadFromSes...', Array)
#5 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(289): User->loadFromSession()
#6 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(4057): User->load()
#7 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(2224): User->loadOptions()
#8 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/context/RequestContext.php(274): User->getOption('language')
#9 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/cache/HTMLFileCache.php(116): RequestContext->getLanguage()
#10 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(515): HTMLFileCache::useFileCache(Object(RequestContext))
#11 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(446): MediaWiki->main()
#12 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/index.php(59): MediaWiki->run()
#13 {main}

Unexpected non-MediaWiki exception encountered, of type "Exception"
exception 'Exception' with message 'There was a problem when connecting to the IPB database.<br />Check your Host, Username, and Password settings.<br /><br />MySQL Error Number: 2002<br />MySQL Error Message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br /><br />' in /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php:353
Stack trace:
#0 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(327): Auth_IPB->mySQLError('There was a pro...')
#1 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(163): Auth_IPB->connect()
#2 [internal function]: Auth_IPB_AutoLogin_Hook(Object(User), NULL)
#3 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Hooks.php(216): call_user_func_array('Auth_IPB_AutoLo...', Array)
#4 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/GlobalFunctions.php(3823): Hooks::run('UserLoadFromSes...', Array)
#5 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(944): wfRunHooks('UserLoadFromSes...', Array)
#6 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(289): User->loadFromSession()
#7 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(4057): User->load()
#8 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(2224): User->loadOptions()
#9 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/context/RequestContext.php(274): User->getOption('language')
#10 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/cache/HTMLFileCache.php(116): RequestContext->getLanguage()
#11 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(515): HTMLFileCache::useFileCache(Object(RequestContext))
#12 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(446): MediaWiki->main()
#13 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/index.php(59): MediaWiki->run()
#14 {main}

#0 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(327): Auth_IPB->mySQLError('There was a pro...')
#1 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(163): Auth_IPB->connect()
#2 [internal function]: Auth_IPB_AutoLogin_Hook(Object(User), NULL)
#3 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Hooks.php(216): call_user_func_array('Auth_IPB_AutoLo...', Array)
#4 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/GlobalFunctions.php(3823): Hooks::run('UserLoadFromSes...', Array)
#5 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(944): wfRunHooks('UserLoadFromSes...', Array)
#6 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(289): User->loadFromSession()
#7 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(4057): User->load()
#8 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(2224): User->loadOptions()
#9 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/context/RequestContext.php(274): User->getOption('language')
#10 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/cache/HTMLFileCache.php(116): RequestContext->getLanguage()
#11 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(515): HTMLFileCache::useFileCache(Object(RequestContext))
#12 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(446): MediaWiki->main()
#13 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/index.php(59): MediaWiki->run()
#14 {main}

Unexpected non-MediaWiki exception encountered, of type "Exception"
exception 'Exception' with message 'Unable to view external table<br />MySQL Error Number: 2013<br />MySQL Error Message: Lost connection to MySQL server during query<br /><br />' in /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php:353
Stack trace:
#0 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(173): Auth_IPB->mySQLError('Unable to view ...')
#1 [internal function]: Auth_IPB_AutoLogin_Hook(Object(User), NULL)
#2 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Hooks.php(216): call_user_func_array('Auth_IPB_AutoLo...', Array)
#3 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/GlobalFunctions.php(3823): Hooks::run('UserLoadFromSes...', Array)
#4 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(944): wfRunHooks('UserLoadFromSes...', Array)
#5 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(289): User->loadFromSession()
#6 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(4057): User->load()
#7 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(2224): User->loadOptions()
#8 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/context/RequestContext.php(274): User->getOption('language')
#9 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/cache/HTMLFileCache.php(116): RequestContext->getLanguage()
#10 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(515): HTMLFileCache::useFileCache(Object(RequestContext))
#11 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(446): MediaWiki->main()
#12 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/index.php(59): MediaWiki->run()
#13 {main}

#0 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/extensions/Auth_IPB/Auth_IPB.php(173): Auth_IPB->mySQLError('Unable to view ...')
#1 [internal function]: Auth_IPB_AutoLogin_Hook(Object(User), NULL)
#2 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Hooks.php(216): call_user_func_array('Auth_IPB_AutoLo...', Array)
#3 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/GlobalFunctions.php(3823): Hooks::run('UserLoadFromSes...', Array)
#4 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(944): wfRunHooks('UserLoadFromSes...', Array)
#5 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(289): User->loadFromSession()
#6 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(4057): User->load()
#7 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/User.php(2224): User->loadOptions()
#8 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/context/RequestContext.php(274): User->getOption('language')
#9 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/cache/HTMLFileCache.php(116): RequestContext->getLanguage()
#10 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(515): HTMLFileCache::useFileCache(Object(RequestContext))
#11 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/includes/Wiki.php(446): MediaWiki->main()
#12 /var/www/vhosts/mlebon.net/detectiveconanworld.com/wiki/index.php(59): MediaWiki->run()
#13 {main}
 

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
Go To Topic Listing
×
  • Create New...