Forumer
Go Back   Forum Hosting > IPB Support > IPB General Support
Reload this Page ALL ERRORS like this: mySQL error: Can't open file:
Register vbBux / fStore Blogs FAQ Members List Calendar fArcade Mark Forums Read

IPB General Support Post your questions here, no bug reports.


Reply
Page 1 of 75 1 231151 > Last »
 
LinkBack Thread Tools Display Modes
Old 10-18-2005, 05:45 PM   #1 (permalink)
Junior Forumer
 
axeman's Avatar
 

Join Date: Jan 2004
Posts: 55
Rep Power: 0 axeman
fTrader: (0)
fBuck$: 573
Bank: 0
Total fBuck$: 573

My Forumer
My Country:
Default Board Error??
After the recent upgrading my board finally came online again this evening..now, after an hour or so I am getting this error message when I try to access any forum from the main site page:

Quote:
mySQL query error: SELECT DISTINCT(TalkFootball_posts.author_id), TalkFootball_topics.* FROM TalkFootball_topics
LEFT JOIN TalkFootball_posts ON
(TalkFootball_topics.tid=TalkFootball_posts.topic_id AND TalkFootball_posts.author_id=1)
WHERE TalkFootball_topics.forum_id=195
and TalkFootball_topics.approved=1
and (TalkFootball_topics.pinned=1 or TalkFootball_topics.last_post > 0) ORDER BY pinned DESC, last_post DESC LIMIT 0,30
mySQL error: Can't open file: 'TalkFootball_posts.MYI' (errno: 145)
mySQL error code:
Date: Wednesday 19th of October 2005 07:55:38 AM
Is this just teething problems or should I be concerned?

http://talkfootball.1.forumer.com

Any help appreciated.

axeman is offline   Reply With Quote
Old 10-18-2005, 05:48 PM   #2 (permalink)
Junior Forumer
 
axeman's Avatar
 

Join Date: Jan 2004
Posts: 55
Rep Power: 0 axeman
fTrader: (0)
fBuck$: 573
Bank: 0
Total fBuck$: 573

My Forumer
My Country:
Default Re: Board Error??
I have just noted that if I log out and become a 'guest' I am able to access the various boards...but not if I log on.

axeman is offline   Reply With Quote
Old 10-18-2005, 05:49 PM   #3 (permalink)
Junior Forumer
 
axeman's Avatar
 

Join Date: Jan 2004
Posts: 55
Rep Power: 0 axeman
fTrader: (0)
fBuck$: 573
Bank: 0
Total fBuck$: 573

My Forumer
My Country:
Default Re: Board Error??
Just deleted all cookies and it seems to be working again....??

axeman is offline   Reply With Quote
Old 10-18-2005, 05:51 PM   #4 (permalink)
Junior Forumer
 
axeman's Avatar
 

Join Date: Jan 2004
Posts: 55
Rep Power: 0 axeman
fTrader: (0)
fBuck$: 573
Bank: 0
Total fBuck$: 573

My Forumer
My Country:
Default Re: Board Error??
I spoke too soon...I can access the various boards but not individual threads...when I try I get this error message:

Quote:
mySQL query error: SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM TalkFootball_posts p
LEFT JOIN TalkFootball_members m ON (p.author_id=m.id)
LEFT JOIN TalkFootball_groups g ON (g.g_id=m.mgroup)

WHERE p.topic_id=13345 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 30
mySQL error: Can't open file: 'TalkFootball_posts.MYI' (errno: 145)
mySQL error code:
Date: Wednesday 19th of October 2005 08:05:31 AM


NB. This error is returned even if I log out and try to access as a guest.
Last edited by axeman : 10-18-2005 at 05:54 PM.

axeman is offline   Reply With Quote
Old 10-18-2005, 05:59 PM   #5 (permalink)
Junior Forumer
 
axeman's Avatar
 

Join Date: Jan 2004
Posts: 55
Rep Power: 0 axeman
fTrader: (0)
fBuck$: 573
Bank: 0
Total fBuck$: 573

My Forumer
My Country:
Default Re: Board Error??
I am posting a number of times on this thread so as to give as much information to 'the powers that be' in their endeavour to solve this problem.

It appears that if I log on to my site I can see the main board but as soon as I try to access a forum I receive an error message.

If I merely go to my site as a Guest then I can access any forum but not any of the posts within that forum.

Hope this helps.

axeman is offline   Reply With Quote
Old 10-18-2005, 10:49 PM   #6 (permalink)
Admin
 
Limez's Avatar
 

Join Date: Dec 2003
Posts: 2,921
Blog Entries: 2
Rep Power: 10 Limez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond reputeLimez has a reputation beyond repute
fTrader: (4)
fBuck$: 2,813,600
Bank: 614
Total fBuck$: 2,814,214

My Forumer
My Country:
Default Re: Board Error??
fixed.

FORUMER.com - Pioneering forum hosting since 2003. Why should you host with Forumer?

The Forumer network is powered by a robust cluster of 35 high-end servers.

Create your own forum NOW phpbb/IPB

phpBB3 is open to almost everyone


Forumer turns 4 YEARS OLD!!!


Free forum hosting < add me to your blog, get code here!
Limez is offline   Reply With Quote
Old 04-12-2006, 09:05 PM   #7 (permalink)
Junior Forumer
 
NeilaCity's Avatar
 

Join Date: Feb 2005
Posts: 111
Rep Power: 4 NeilaCity is on a distinguished road
fTrader: (0)
fBuck$: 184
Bank: 0
Total fBuck$: 184

My Forumer
My Country:
Default New mySQL errors and generally slow- help!
mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='ee9f6fd1c5e80c7d634110dee62244b5' and ip_address='**.***.***.***'

mySQL error: Too many connections
mySQL error code:
Date: Wednesday 12th of April 2006 10:04:19 PM


When it doesn't give this error, it runs really slowly, thanks for your help!




http://neilacity3.forumhoster.com

"Sometimes the dark side overcomes.....'the better angels of our nature.'"
NeilaCity is offline   Reply With Quote
Old 04-12-2006, 09:13 PM   #8 (permalink)
Junior Forumer
 
NeilaCity's Avatar
 

Join Date: Feb 2005
Posts: 111
Rep Power: 4 NeilaCity is on a distinguished road
fTrader: (0)
fBuck$: 184
Bank: 0
Total fBuck$: 184

My Forumer
My Country:
Default Re: New mySQL errors and generally slow- help!
no admin section either:


Quote:
mySQL query error: DELETE FROM ibf_admin_sessions WHERE RUNNING_TIME < 1144891054

mySQL error: Lost connection to MySQL server during query
mySQL error code:
Date: Wednesday 12th of April 2006 10:17:34 PM

other error messages on reg link:

Quote:
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, m.sub_end, 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=1

mySQL error: Lost connection to MySQL server during query
mySQL error code:
Date: Wednesday 12th of April 2006 10:17:06 PM

"Sometimes the dark side overcomes.....'the better angels of our nature.'"
NeilaCity is offline   Reply With Quote
Old 04-12-2006, 11:14 PM   #9 (permalink)
Junior Forumer
 
NeilaCity's Avatar
 

Join Date: Feb 2005
Posts: 111
Rep Power: 4 NeilaCity is on a distinguished road
fTrader: (0)
fBuck$: 184
Bank: 0
Total fBuck$: 184

My Forumer
My Country:
Default Re: New mySQL errors and generally slow- help!
better now, thanks so much! ^_^

( still have this problem though)

http://forum.forumer.com/showthread.php?t=35322

"Sometimes the dark side overcomes.....'the better angels of our nature.'"
NeilaCity is offline   Reply With Quote
Old 04-21-2006, 03:00 AM   #10 (permalink)
Member
 
Takumi's Avatar
 

Join Date: Dec 2005
Posts: 17
Rep Power: 0 Takumi is on a distinguished road
fTrader: (0)
fBuck$: 478
Bank: 0
Total fBuck$: 478

My Forumer
My Country:
Default mySQL error !????
My forum http://beatofboa.15.forumer.com is not working??? mySQL error.

I can't view forum

show message

Quote:
mySQL query error: SELECT pid, post_date FROM beatofboa_posts WHERE queued <> 1 AND topic_id='1586' AND post_date > '' ORDER BY post_date LIMIT 1

mySQL error: Can't open file: 'beatofboa_posts.MYI' (errno: 145)
mySQL error code:
Date: Friday 21st of April 2006 04:05:58 AM
and can't join Moderator's CP

show message

Quote:
mySQL query error: SELECT COUNT(pid) as qued, forum_id FROM beatofboa_posts
WHERE queued=1 AND new_topic <> 1 AND forum_id IN (1,4,3,5,6,7,8,9,10,11,12,13,14,15,16)
GROUP BY forum_id ORDER BY forum_id

mySQL error: Can't open file: 'beatofboa_posts.MYI' (errno: 145)
mySQL error code:
Date: Sunday 16th of April 2006 06:26:30 AM
help me please... Thanks so much
Takumi is offline   Reply With Quote
Old 04-21-2006, 03:15 AM   #11 (permalink)
Banned User
 
crimsyhs's Avatar
 

Join Date: Jun 2005
Posts: 3,516
Rep Power: 0 crimsyhs is on a distinguished road
fTrader: (23)
fBuck$: 382
Bank: 2
Total fBuck$: 384

My Forumer
My Country:
Default Re: mySQL error !????
There seems to be a bug in server 15. I guess that the ySQL database is down at the moment. It should clear in a few hours...If not, please come back and post about it again

~crimsyhs
crimsyhs is offline   Reply With Quote
Old 04-22-2006, 04:51 AM   #12 (permalink)
Member
 
Takumi's Avatar
 

Join Date: Dec 2005
Posts: 17
Rep Power: 0 Takumi is on a distinguished road
fTrader: (0)
fBuck$: 478
Bank: 0
Total fBuck$: 478

My Forumer
My Country:
Default Re: mySQL error !????
Today "mySQL error: Can't open file: 'beatofboa_posts.MYI " ????

I can't join forum in my webbord.show messege

Quote:
mySQL query error: SELECT p.*,
m.id,m.name,m.mgroup,m.email,m.joined,m.avatar,m.avatar_size,m.posts,m.aim_name,m.icq_number,
m.signature, m.website,m.yahoo,m.integ_msg,m.title,m.hide_email,m.msnname, m.warn_level, m.warn_lastwarn,
g.g_id, g.g_title, g.g_icon, g.g_dohtml
FROM beatofboa_posts p
LEFT JOIN beatofboa_members m ON (p.author_id=m.id)
LEFT JOIN beatofboa_groups g ON (g.g_id=m.mgroup)

WHERE p.topic_id=146 and p.queued != 1
ORDER BY p.pid asc LIMIT 0, 10

mySQL error: Can't open file: 'beatofboa_posts.MYI' (errno: 145)
mySQL error code:
Date: Saturday 22nd of April 2006 05:54:50 AM
please fix bug .help me
Takumi is offline   Reply With Quote
Old 04-22-2006, 06:39 AM   #13 (permalink)
Member
 
avfcgoodie's Avatar
 

Join Date: Dec 2005
Posts: 35
Rep Power: 0 avfcgoodie is on a distinguished road
fTrader: (0)
fBuck$: 329
Bank: 0
Total fBuck$: 329

My Forumer
My Country:
Default Re: mySQL error !????
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11
avfcgoodie is offline   Reply With Quote
Old 04-22-2006, 06:46 AM   #14 (permalink)
Junior Forumer
 
Sudifice's Avatar
 

Join Date: Dec 2005
Posts: 117
Rep Power: 3 Sudifice is on a distinguished road
fTrader: (3)
fBuck$: 149
Bank: 0
Total fBuck$: 149

My Forumer
My Country:
Send a message via AIM to Sudifice Send a message via MSN to Sudifice
Default Re: mySQL error !????
The same thing happened to me in the ACP, but when I refreshed, it was gone.


-Promoted to PWNAG3 on July 21, 1991.
Sudifice is offline   Reply With Quote
Old 04-22-2006, 07:23 AM   #15 (permalink)
Member
 
Shakermaker's Avatar
 

Join Date: Apr 2006
Posts: 1
Rep Power: 0 Shakermaker is on a distinguished road
fTrader: (0)
fBuck$: 82
Bank: 0
Total fBuck$: 82

My Forumer
My Country:
Default Re: mySQL error !????
Why always server 15 down??
Shakermaker is offline   Reply With Quote
Reply
Page 1 of 75 1 231151 > Last »

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
fBuck$ Per Thread View: 1
fBuck$ Per Thread: 15
fBuck$ Per Post: 5

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql errors Again The Blindman IPB General Support 8 04-26-2006 11:55 AM
[resolved] Mysql Errors? XIII IPB General Support 3 09-20-2004 01:08 PM
[resolved] [being Worked On] mysql Errors :( Daz IPB General Support 1 05-16-2004 12:47 PM
[resolved] Mysql Errors? cmk2034 IPB General Support 0 12-31-1969 06:00 PM