Forum Hosting  

Go Back   Forum Hosting > IPB Support > IPB General Support

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


Reply
 
LinkBack Thread Tools Display Modes
Old 11-05-2006, 06:38 AM   #61 (permalink)
Member
 
immoRt4L's Avatar
 
Join Date: Jan 2006

Location: Koprivnica, Croatia
Posts: 23
Rep Power: 0 immoRt4L is on a distinguished road
fTrader: (0)
fBuck$: 148
Bank: 1
Total fBuck$: 149

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

I have mysql error on my forum and it looks like this:
mySQL query error: SELECT DISTINCT(gimnazijafg_posts.author_id), gimnazijafg_topics.* FROM gimnazijafg_topics
LEFT JOIN gimnazijafg_posts ON
(gimnazijafg_topics.tid=gimnazijafg_posts.topic_id AND gimnazijafg_posts.author_id=1)
WHERE gimnazijafg_topics.forum_id=27
and gimnazijafg_topics.approved=1
and (gimnazijafg_topics.pinned=1 or gimnazijafg_topics.last_post > 0) ORDER BY pinned DESC, last_post DESC LIMIT 0,15

mySQL error: Can't open file: 'gimnazijafg_posts.MYI' (errno: 145)
mySQL error code:
Date: Sunday 05th of November 2006 07:35:19 AM

Can you fix this? It shows for all registred users and it started showing when i deleted one of the topics.
Thanks.

http://gimnazijafg.1.forumer.com

Last edited by immoRt4L; 11-05-2006 at 06:44 AM.
immoRt4L is offline   Reply With Quote
Old 11-05-2006, 06:55 AM   #62 (permalink)
Errrrrrrrr
 
Nick's Avatar
 
Join Date: Feb 2005

Location: London
Posts: 1,423
Rep Power: 5 Nick is on a distinguished road
fTrader: (5)
fBuck$: 1,101
Bank: 118,120
Total fBuck$: 119,221

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Reported

Quote:
Originally Posted by immoRt4L View Post
I have mysql error on my forum and it looks like this:
mySQL query error: SELECT DISTINCT(gimnazijafg_posts.author_id), gimnazijafg_topics.* FROM gimnazijafg_topics
LEFT JOIN gimnazijafg_posts ON
(gimnazijafg_topics.tid=gimnazijafg_posts.topic_id AND gimnazijafg_posts.author_id=1)
WHERE gimnazijafg_topics.forum_id=27
and gimnazijafg_topics.approved=1
and (gimnazijafg_topics.pinned=1 or gimnazijafg_topics.last_post > 0) ORDER BY pinned DESC, last_post DESC LIMIT 0,15

mySQL error: Can't open file: 'gimnazijafg_posts.MYI' (errno: 145)
mySQL error code:
Date: Sunday 05th of November 2006 07:35:19 AM

Can you fix this? It shows for all registred users and it started showing when i deleted one of the topics.
Thanks.

http://gimnazijafg.1.forumer.com

[left]Nick - Retired FSupport


Tell your friends about forumer.com today!
Nick is offline   Reply With Quote
Old 11-24-2006, 10:01 AM   #63 (permalink)
Member
 
MagicWalker's Avatar
 
Join Date: Jan 2006

Posts: 3
Rep Power: 0 MagicWalker is on a distinguished road
fTrader: (0)
fBuck$: 274
Bank: 0
Total fBuck$: 274

My Forumer
My Country:
Default Mysql error

Hi,

I'm getting SQL errors, and so are my members,
when we attempt to access certain areas from my board:

mySQL query error: SELECT DISTINCT(aksiom_posts.author_id), aksiom_topics.* FROM aksiom_topics
LEFT JOIN aksiom_posts ON
(aksiom_topics.tid=aksiom_posts.topic_id AND aksiom_posts.author_id=1)
WHERE aksiom_topics.forum_id=11
and aksiom_topics.approved=1
and (aksiom_topics.pinned=1 or aksiom_topics.last_post > 0) ORDER BY pinned DESC, last_post DESC LIMIT 0,25

mySQL error: Can't open file: 'aksiom_posts.MYI' (errno: 145)
mySQL error code:
Date: Friday 24th of November 2006 10:19:50 AM

http://aksiom.1.forumer.com

Thank you!
MagicWalker is offline   Reply With Quote
Old 11-25-2006, 07:37 PM   #64 (permalink)
Junior Forumer
 
cosyinrocket's Avatar
 
Join Date: Mar 2006

Posts: 61
Rep Power: 3 cosyinrocket is on a distinguished road
fTrader: (0)
fBuck$: 492
Bank: 0
Total fBuck$: 492

My Forumer
My Country:
Default Re: Mysql error

My members and myself are also getting SQL errors everytime we attempt to post. It just started a couple of minutes ago.

mySQL query error: SELECT pid, post_date FROM fanficga_posts WHERE queued <> 1 AND topic_id='201' AND post_date > '1164506085' ORDER BY post_date LIMIT 1

mySQL error: Can't open file: 'fanficga_posts.MYI' (errno: 145)
mySQL error code:
Date: Saturday 25th of November 2006 08:35:50 PM

http://fanficga.5.forumer.com/

Last edited by cosyinrocket; 11-25-2006 at 07:42 PM.
cosyinrocket is offline   Reply With Quote
Old 11-27-2006, 01:01 AM   #65 (permalink)
Errrrrrrrr
 
Nick's Avatar
 
Join Date: Feb 2005

Location: London
Posts: 1,423
Rep Power: 5 Nick is on a distinguished road
fTrader: (5)
fBuck$: 1,101
Bank: 118,120
Total fBuck$: 119,221

My Forumer
My Country:
Default Re: Mysql error

Both have been reported. These will be fixed as soon as possible.

Thanks

[left]Nick - Retired FSupport


Tell your friends about forumer.com today!
Nick is offline   Reply With Quote
Old 12-16-2006, 09:36 PM   #66 (permalink)
Member
 
darkjosuhe's Avatar
 
Join Date: Aug 2006

Posts: 2
Rep Power: 0 darkjosuhe is on a distinguished road
fTrader: (0)
fBuck$: 35
Bank: 0
Total fBuck$: 35

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

This one is my error

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1016 Can't open file: 'l2corsairs_users.MYI' (errno: 145)

SELECT * FROM l2corsairs_users WHERE user_id = -1

Line : 136
File : sessions.php

my site : http://l2corsairs.16.forumer.com/

havent work from like a month now plz help me
darkjosuhe is offline   Reply With Quote
Old 01-02-2007, 10:26 AM   #67 (permalink)
Member
 
morteTM's Avatar
 
Join Date: Mar 2005

Posts: 10
Rep Power: 0 morteTM is on a distinguished road
fTrader: (0)
fBuck$: 219
Bank: 0
Total fBuck$: 219

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

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

mySQL error: Can't open file: 'gimnazija_posts.MYI' (errno: 145)
mySQL error code:
Date: Tuesday 02nd of January 2007 11:21:31 AM
http://gimnazija.2.forumer.com

help
morteTM is offline   Reply With Quote
Old 01-05-2007, 06:30 AM   #68 (permalink)
Junior Forumer
 
Jercouzen's Avatar
 
Join Date: Apr 2005

Posts: 82
Rep Power: 4 Jercouzen is on a distinguished road
fTrader: (0)
fBuck$: 87
Bank: 143
Total fBuck$: 230

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

here's mine:
http://feuea.1.forumer.com/

thanks in advance
Jercouzen is offline   Reply With Quote
Old 01-05-2007, 06:33 AM   #69 (permalink)
Member
 
FrozenSoul's Avatar
 
Join Date: Jul 2006

Posts: 10
Rep Power: 0 FrozenSoul is on a distinguished road
fTrader: (0)
fBuck$: 75
Bank: 0
Total fBuck$: 75

My Forumer
My Country:
Send a message via MSN to FrozenSoul Send a message via Yahoo to FrozenSoul Send a message via Skype™ to FrozenSoul
Default Re: Mysql error

I don’t know if it’s the same problem, but every time me, or anyone from my forum try to access , we see this:

mySQL query error: SELECT id, member_id, running_time, location FROM darkheaven_sessions WHERE id='b3b91306af73d2a6e95183e9b5e23c80' and ip_address='89.190.200.142'

mySQL error:
mySQL error code:
Date: Friday 05th of January 2007 07:23:47 AM


I can really use some help...

http://darkheaven.1.forumer.com

Last edited by FrozenSoul; 01-05-2007 at 06:37 AM.
FrozenSoul is offline   Reply With Quote
Old 01-05-2007, 06:37 AM   #70 (permalink)
Member
 
Christmasbitch's Avatar
 
Join Date: May 2006

Posts: 13
Rep Power: 0 Christmasbitch is on a distinguished road
fTrader: (0)
fBuck$: 182
Bank: 0
Total fBuck$: 182

My Forumer
My Country:
Exclamation Re: ALL ERRORS like this: mySQL error: Can't open file:

Same problem...

http://theaussies.1.forumer.com/

Thx in advance
Christmasbitch is offline   Reply With Quote
Old 01-05-2007, 06:41 AM   #71 (permalink)
Member
 
jimbob11's Avatar
 
Join Date: Oct 2006

Posts: 3
Rep Power: 0 jimbob11 is on a distinguished road
fTrader: (0)
fBuck$: 81
Bank: 0
Total fBuck$: 81

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

http://torgulf.1.forumer.com/

Thanks in advance, and such jibber.
jimbob11 is offline   Reply With Quote
Old 01-05-2007, 06:42 AM   #72 (permalink)
Member
 
Stitchface's Avatar
 
Join Date: Jan 2006

Posts: 8
Rep Power: 0 Stitchface is on a distinguished road
fTrader: (0)
fBuck$: 420
Bank: 0
Total fBuck$: 420

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

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 stitchface_members m
LEFT JOIN stitchface_groups g ON (g.g_id=m.mgroup)
LEFT JOIN stitchface_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=1

mySQL error:
mySQL error code:
Date: Friday 05th of January 2007 07:39:15 AM
http://stitchface.1.forumer.com/index.php?act=idx
Stitchface is offline   Reply With Quote
Old 01-05-2007, 06:52 AM   #73 (permalink)
Member
 
supica's Avatar
 
Join Date: Feb 2006

Posts: 18
Rep Power: 0 supica is on a distinguished road
fTrader: (0)
fBuck$: 237
Bank: 0
Total fBuck$: 237

My Forumer
My Country:
Send a message via ICQ to supica Send a message via MSN to supica
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

clubbmw.1.forumer.com
supica is offline   Reply With Quote
Old 01-05-2007, 06:54 AM   #74 (permalink)
Member
 
Lamia's Avatar
 
Join Date: Oct 2006

Posts: 5
Rep Power: 0 Lamia is on a distinguished road
fTrader: (0)
fBuck$: 89
Bank: 0
Total fBuck$: 89

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

Yes, we've got it too
http://britwriters.1.forumer.com/index.php?

mySQL query error: SELECT id, member_id, running_time, location FROM britwriters_sessions WHERE id='6ef098c417a9191a1475a942095432ab' and ip_address='81.154.205.11'

mySQL error:
mySQL error code:
Date: Friday 05th of January 2007 07:50:25 AM

and then when I try again

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 britwriters_members m
LEFT JOIN britwriters_groups g ON (g.g_id=m.mgroup)
LEFT JOIN britwriters_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=4

mySQL error:
mySQL error code:
Date: Friday 05th of January 2007 07:51:17 AM
Lamia is offline   Reply With Quote
Old 01-05-2007, 06:59 AM   #75 (permalink)
Junior Forumer
 
Elowine's Avatar
 
Join Date: Feb 2006

Posts: 51
Rep Power: 3 Elowine is on a distinguished road
fTrader: (0)
fBuck$: 1,171
Bank: 0
Total fBuck$: 1,171

My Forumer
My Country:
Default Re: ALL ERRORS like this: mySQL error: Can't open file:

And we as well...
http://starcainam.1.forumer.com/

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 starcainam_members m
LEFT JOIN starcainam_groups g ON (g.g_id=m.mgroup)
LEFT JOIN starcainam_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=1

mySQL error:
mySQL error code:
Date: Friday 05th of January 2007 07:57:47 AM
Elowine is offline   Reply With Quote
Reply



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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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