Error Messages

[simplybago]

I have gotten A LOT of these over the past two days....

An error was encountered during execution of the query:

SELECT id,username,userid,date,rating,comment,approved,ipaddress FROM pp_comments WHERE photo=18683 AND LENGTH(comment) > 0 ORDER BY date ASC

The query returned with an errorcode of:

File './asimplyb_PhotoP/pp_comments.MYD' not found (Errcode: 2)

Any idea?

[simplybago]

and now I've done the update to 6.11 and am now getting this

"; $Style['lastphocol'] = "lastphocol"; $Style['lastcommcol'] = "lastcommcol"; $Style['small'] = "small"; $Style['medium'] = "medium"; $Style['large'] = "large"; $Style['welcome'] = "welcome"; $Style['lighttable'] = "lighttable"; $Style['alternatetable'] = "alternatetable"; $Style['formboxes'] = "formboxes"; $Style['blockquote'] = "blockquote"; // Now lets include the forum integration require "{$Globals['PP_PATH']}/forums/{$Globals['vbversion']}.php"; include "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/ppopen.tmpl"; include "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/ppclose.tmpl"; ?> /adm-index.php" ); exit; } ?>


arrgghhh

[Chuck S]

Well let me respond to each one

1. File './asimplyb_PhotoP/pp_comments.MYD' not found (Errcode: 2)

Your comments table for photopost is either crashed or you deleted it. If it is crashed running this query in phpmyadmin should help you

REPAIR TABLE pp_comments;

If that does not help you can reinstall a comments table like so but doing so you lose any comments because your table is gone.

Content visible to verified customers only.

2. Make sure to reupload your core php files except the config files. You have had a problem with your ftp client and one or more of your files are corrupt.

[simplybago]

In regards to the comments table, I am a bit new to phpmyadmin but when I attempt to create it tells me there is already a table called pp_comments.

[Chuck S]

What happens if you run the REPAIR COMMAND?

[simplybago]

It says for status not found and corrupt

[Chuck S]

I would suggest you contact your host if your having issues fixing a hosting service on their server. You either need to repair the table or delete it and recreate it. I have provided both of those solutions to you. If you want to drop the comments table to recreate a new one you can use the command

DROP TABLE pp_comments

As I noted you will loose your comments if you do that. I fail to see why running a repair on the table is not working but your host should be able to assist you.