Printable Version of Topic

Click here to view this topic in its original format

Dumpshock Forums _ Dumpshock News, Bug Reports, Feature Requests, & Discussion _ mySQL error

Posted by: Austere Emancipator Sep 9 2004, 02:34 AM

mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=5222

mySQL error: Can't connect to MySQL server on 'localhost' (10049)
mySQL error code:
Date: Wednesday 08th of September 2004 10:57:26 AM

Posted by: Austere Emancipator Sep 16 2004, 02:56 PM

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='b075e227110ceb899b39e0c4b542caf9' and ip_address='[my IP address]'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Thursday 16th of September 2004 10:51:12 AM

I've been getting these (or very similar-looking errors) quite a bit recently, usually when going Back from a topic to the forum, or from the forum to the index. It nearly always goes away when I reload the page, but a few minutes back it kept coming up for about a minute before I could open the page again.

Posted by: Kanada Ten Sep 18 2004, 04:45 AM

mySQL query error: SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html,
f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms,
f.show_rules, f.rules_text, f.rules_title,
c.name as cat_name, c.id as cat_id
FROM ibf_topics t, ibf_forums f , ibf_categories c
WHERE t.tid=5193 and f.id = t.forum_id and f.category=c.id

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Saturday 18th of September 2004 12:45:23 AM

Posted by: Ecclesiastes Sep 20 2004, 08:46 PM

mySQL query error: SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html,
f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms,
f.show_rules, f.rules_text, f.rules_title,
c.name as cat_name, c.id as cat_id
FROM ibf_topics t, ibf_forums f , ibf_categories c
WHERE t.tid=5520 and f.id = t.forum_id and f.category=c.id

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Monday 20th of September 2004 04:46:12 PM

Posted by: Kanada Ten Sep 21 2004, 12:47 AM

Warning: mysql_connect(): Unknown MySQL Server Host 'cortana.dumpshock.com' (2) in /home/sites/forums.dumpshock.com/htdocs/sources/Drivers/mySQL.php on line 65

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/sites/forums.dumpshock.com/htdocs/sources/Drivers/mySQL.php on line 68
ERROR: Cannot find database invision
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/sites/forums.dumpshock.com/htdocs/sources/Drivers/mySQL.php on line 101

There appears to be an error with the Dumpshock Forums database.
You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here

QUOTE

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='7c35e6a257b7fc69e1d98b9dbc895cc5' and ip_address='65.42.89.20'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Monday 20th of September 2004 08:46:09 PM

Posted by: BishopMcQ Sep 24 2004, 04:49 PM

CODE

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='3c0e255c03cf91ac94c9b22f25b2a1a1' and ip_address=EDITED

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Friday 24th of September 2004 12:47:10 PM

Posted by: Austere Emancipator Sep 25 2004, 08:50 AM

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='8545ec8bb16267fc50f06fa1bcaf0900' and ip_address='[my IP address]'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Saturday 25th of September 2004 04:47:36 AM

Still getting the same error every now and then, it seems.

Posted by: Ecclesiastes Sep 28 2004, 12:48 AM

mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=6274

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Monday 27th of September 2004 08:47:40 PM

Posted by: Kanada Ten Oct 13 2004, 12:55 AM

Warning: mysql_connect(): Unknown MySQL Server Host 'cortana.dumpshock.com' (2) in /home/sites/forums.dumpshock.com/htdocs/sources/Drivers/mySQL.php on line 65

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/sites/forums.dumpshock.com/htdocs/sources/Drivers/mySQL.php on line 68
ERROR: Cannot find database invision
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/sites/forums.dumpshock.com/htdocs/sources/Drivers/mySQL.php on line 101

There appears to be an error with the Dumpshock Forums database.
You can try to refresh the page by clicking here, if this does not fix the error, you can contact the board administrator by clicking here

Error Returned

QUOTE

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='b43eeb28a2fb47fa672f8f3ac95ef8f4' and ip_address='66.73.161.244'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Tuesday 12th of October 2004 08:51:38 PM

We apologise for any inconvenience

Posted by: Fortune Oct 13 2004, 12:58 AM

I get them on occasion as well, but find that hitting 'Refresh' (not necessarily the link) usually works.

Posted by: Kanada Ten Oct 14 2004, 04:48 AM

QUOTE

mySQL query error: SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html,
f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms,
f.show_rules, f.rules_text, f.rules_title,
c.name as cat_name, c.id as cat_id
FROM ibf_topics t, ibf_forums f , ibf_categories c
WHERE t.tid=5774 and f.id = t.forum_id and f.category=c.id

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Thursday 14th of October 2004 12:47:05 AM

Posted by: Ecclesiastes Oct 16 2004, 08:48 PM

mySQL query error: SELECT t.*, f.topic_mm_id, f.name as forum_name, f.quick_reply, f.id as forum_id, f.read_perms, f.reply_perms, f.parent_id, f.use_html,
f.start_perms, f.allow_poll, f.password, f.posts as forum_posts, f.topics as forum_topics, f.upload_perms,
f.show_rules, f.rules_text, f.rules_title,
c.name as cat_name, c.id as cat_id
FROM ibf_topics t, ibf_forums f , ibf_categories c
WHERE t.tid=5875 and f.id = t.forum_id and f.category=c.id

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Saturday 16th of October 2004 04:47:51 PM

Posted by: Kanada Ten Oct 29 2004, 01:06 AM

QUOTE

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='5b9932c8db5ba5edff64c40625fcecb4' and ip_address='66.73.161.244'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Thursday 28th of October 2004 08:51:02 PM

We apologise for any inconvenience

Posted by: Kagetenshi Nov 24 2004, 10:51 PM

CODE

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='f1a7f5529dd0220f8d1ea8e3ed6a107e' and ip_address='64.119.128.98'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Wednesday 24th of November 2004 05:49:46 PM

Nearly identical to K10's, but there were a bunch of mySQL errors right before the most recent downtime so I thought it might do with another posting.

~J

Posted by: Doctor Funkenstein Nov 25 2004, 12:27 AM

I get that one on a semi-regular basis, too. At least once a day.

Posted by: Fortune Nov 25 2004, 01:00 AM

I do as well. I just hit refresh and it seems to sort itself out.

Posted by: Fenris Jan 28 2005, 09:07 AM

New one for you:

mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='1f58ea197057c35d313bc5e526759dd8' and ip_address='66.166.188.62'

mySQL error: Unknown MySQL Server Host 'cortana.dumpshock.com' (2)
mySQL error code:
Date: Friday 28th of January 2005 04:05:25 AM

Haven't gotten one myself in a few months, so I figured you guys mught want to know about it.