![]() |
| |||||||
| IPB General Support Post your questions here, no bug reports. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #61 (permalink) |
| Member | 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. |
| | |
| | #62 (permalink) | |
| Errrrrrrrr ![]() | Reported Quote:
| |
![]()
[left]Nick - Retired FSupport Tell your friends about forumer.com today! | ||
| | |
| | #63 (permalink) |
| Member | 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! |
| | |
| | #64 (permalink) |
| Junior Forumer ![]() | 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. |
| | |
| | #65 (permalink) |
| Errrrrrrrr ![]() | Both have been reported. These will be fixed as soon as possible. Thanks |
![]()
[left]Nick - Retired FSupport Tell your friends about forumer.com today! | |
| | |
| | #66 (permalink) |
| Member | 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 |
| | |
| | #67 (permalink) | |
| Member | Quote:
help ![]() | |
| | |
| | #69 (permalink) |
| Member | 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. |
| | |
| | #72 (permalink) | |
| Member | Quote:
| |
| | |
| | #74 (permalink) |
| Member | 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 |
| | |
| | #75 (permalink) |
| Junior Forumer ![]() | 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 |
| | |
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
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 |