XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / IPB error : xoops_ipb_posts.MYI
Register
1
alyussiu
IPB error : xoops_ipb_posts.MYI

  • 2006/5/7 17:21

  • alyussiu

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/4/9 9


Hello.

I don't know why but for some reasons, when I want to go on a user profile, I get this error:

mySQL query error: SELECT DISTINCT(p.forum_id), f.name, COUNT(p.author_id) as f_posts FROM xoops_ipb_posts p, xoops_ipb_forums f WHERE p.forum_id IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,19,17,18,20) AND p.author_id='1' AND p.forum_id=f.id GROUP BY p.forum_id ORDER BY f_posts DESC

mySQL error: Can't open file: 'xoops_ipb_posts.MYI' (errno: 145)
mySQL error code: 
Date: Sunday 07th of May 2006 01:31:49 PM


I don't think I've changed something recently but as my host changed to phpsuexec and changed all permission on files, it could come from here. Anyway, I can't find this file anywhere, so, I'm wondering how to correct this problem.

Thanks in advance for your help!
2
alyussiu
Re: IPB error : xoops_ipb_posts.MYI

  • 2006/5/7 17:33

  • alyussiu

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/4/9 9


Arggg... And now, I've another problem O_O...

mySQL query error: SELECT p.*,
                    m.uid,m.uname,m.mgroup,m.email,m.user_regdate,m.user_avatar,m.avatar_size,m.posts,m.user_aim,m.user_icq,
                    m.user_sig as signature, m.url,m.user_yim,m.integ_msg,m.title,m.user_viewemail,m.user_msnm, m.warn_level, m.warn_lastwarn,
                    g.g_id, g.g_title, g.g_icon, g.g_dohtml 
                    FROM xoops_ipb_posts p
                      LEFT JOIN xoops_users m ON (p.author_id=m.uid)
                      LEFT JOIN xoops_ipb_groups g ON (g.g_id=m.mgroup)
                      
                    WHERE p.topic_id=244 and p.queued != 1
                    ORDER BY p.pid asc LIMIT 0, 15

mySQL error: Can't open file: 'xoops_ipb_posts.MYI' (errno: 145)
mySQL error code: 
Date: Sunday 07th of May 2006 01:41:50 PM


The only thing I changed today is to update wfdownload module. And now, it seems that my whole forum won't work >_<.

Help me >_<
3
m0nty
Re: IPB error : xoops_ipb_posts.MYI

  • 2006/5/7 18:28

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


your database has corrupt tables

goto phpmyadmin, and do a check/analyse tables, then tick all the ones it shows problems with and then do a repair..
4
Herko
Re: IPB error : xoops_ipb_posts.MYI

  • 2006/5/7 18:30

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


Youhave a database problem, the MYI files are where MySQL stores the data. Use phpmyadmin or a similar database management tool to repair the database tables, as they are (physically) corrupt. Also, I'd check with your hostinf provider and see if they can't help you there. The problem seems to be spreading anyway (first one table then another). Maybe something is causing this (not XOOPS, it cannot affect database table files).

Herko
5
alyussiu
Re: IPB error : xoops_ipb_posts.MYI

  • 2006/5/7 18:39

  • alyussiu

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/4/9 9


Monty and Herko, hello and thanks to both of you.

I didn't know it was a database file, and I actually saw it when I wanted to save my database (it couldn't do it because of this missing file and I understood it was a database file).

I did the check, and had 3 tables corrupted.

I did the repair command, and it seems it repaired all of it! Hopefully... I was kinda nervous O_O.

Thanks for your help, your explanation and your quick reply ^_^.

(I just can't use the ipb setting to view user profile because it causes errors, but that's not a problem, I just changed to XOOPS ^^).

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

257 user(s) are online (151 user(s) are browsing Support Forums)

Members: 0

Guests: 257

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits