|
lapo4ka18
|
 |
« on: April 15, 2003, 07:58:28 PM » |
|
Hello,
I think something wrong with one of my tables.
I didn't touch anything and just now I noticed that my web site is not working. It's giving me a message
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/sexyor1/public_html/index.php on line 217
No images in database. Add some images and have the moderator
approve them.
I went to php mydmin and when I clicked on imagetable it showes an error
Can't open file: 'imagetable.MYI'. (errno: 145)
What is going on?
Please help.
My web site is sexyornasty.com
|
|
|
|
|
Logged
|
|
|
|
|
stephan
Guest
|
|
« Reply #1 on: April 15, 2003, 11:28:31 PM » |
|
Please e-mail support@lunarpages.com and ask them to fix your .MYI files. |
|
|
|
|
Logged
|
|
|
|
|
TWebMan
|
|
« Reply #2 on: April 16, 2003, 12:59:58 AM » |
|
Did you try checking/repairing/optimizing the table?
|
|
|
|
|
Logged
|
"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila." - Unknown "Liberty of any kind is seldom lost all at once." - D. Hume Every day is an Ode to JoyThe planet will be fine... and so will your site |
|
|
|
JamesYap
|
|
« Reply #3 on: April 16, 2003, 09:00:00 AM » |
|
MySQL has been upgraded from 3.x to 4.x last week. This is the cause I think.
If you have backup, try to restore the database to see if it works.
|
|
|
|
|
Logged
|
|
|
|
|
stephan
Guest
|
|
« Reply #4 on: April 16, 2003, 11:10:08 AM » |
|
It has happened to a few other users. You can e-mail support@lunarpages.com and ask them to fix your .MYI files. |
|
|
|
|
Logged
|
|
|
|
|
stlouisraver.com
|
|
« Reply #5 on: April 17, 2003, 10:35:01 AM » |
|
This is an ongoing problem with any PHP application that uses the MySQL database.
My site has been up and down everyday since the upgrade because of this, and no one has a clear answer or solution yet.
Its very frustrating, and the only thing I can tell you is to keep an eye on it, and repair that specific table when the problem happens, however it will happen again until a permanent solution is found.
|
|
|
|
|
Logged
|
|
|
|
|
Max
|
|
« Reply #6 on: April 17, 2003, 10:48:41 AM » |
|
It only happens to phpNuke sites now. Make sure you have it upgraded to 6.5 or later.
|
|
|
|
|
Logged
|
|
|
|
|
stlouisraver.com
|
|
« Reply #7 on: April 17, 2003, 10:50:54 AM » |
|
Max,
It does it for the latest version of PostNuke as well....which is what I'm running.
|
|
|
|
|
Logged
|
|
|
|
|
Max
|
|
« Reply #8 on: April 17, 2003, 10:55:46 AM » |
|
And it is the seesion table always..
stloui2_slr.nuke_phpbb_sessions
error : The handler for the table doesn't support check
|
|
|
|
|
Logged
|
|
|
|
|
stlouisraver.com
|
|
« Reply #9 on: April 17, 2003, 10:58:32 AM » |
|
And it is the seesion table always..
stloui2_slr.nuke_phpbb_sessions
error : The handler for the table doesn't support check Not always, I've had a number of tables get corrupted after I have spoken with you in e-mail the last few days. My nuke_user_perms got totally screwed and had to be restored from my backups. I also had the same problem with my nuke_users table as well. |
|
|
|
|
Logged
|
|
|
|
|
stlouisraver.com
|
|
« Reply #10 on: April 17, 2003, 11:00:13 AM » |
|
And it is the seesion table always..
stloui2_slr.nuke_phpbb_sessions
error : The handler for the table doesn't support check its my nuke_session_info table, not the phpbb table, I know the phpBB table doesn't support check, its a HEAP table. |
|
|
|
|
Logged
|
|
|
|
|
Max
|
|
« Reply #11 on: April 17, 2003, 09:36:58 PM » |
|
We downgraded europa to 3.x again. If you have any issues with your tables being corrupted. I can move your website there. Just mail me at max@lunarpages.com |
|
|
|
|
Logged
|
|
|
|
|
