WordPress.org

1. philtronics
   Member
   Posted 1 year ago #

   Comments were not saving... I figured out how to turn on the debug messages, and here's what it said:

   WordPress database error: [Table 'wordpress.wp_comments' doesn't exist]
   SELECT * FROM wp_comments WHERE comment_post_ID = 481 AND (comment_approved = '1' OR ( user_id = 1 AND comment_approved = '0' ) ) ORDER BY comment_date_gmt

   The table must have got deleted by accident, how can I reconstruct it? I can issue whatever MySql commands are needed, etc.

2. Ad Lagendijk
   Member
   Posted 1 year ago #

   Do you have a backup?
   Manipulation with the database directly is best done using phpAdmin.

3. philtronics
   Member
   Posted 1 year ago #

   I think it was gone before I backed it up... maybe I can find something on Google about how to recreate it.

   I use mysql.exe (or something like that) from a command prompt - to execute MySQL commands. How do I run phpAdmin?

   Keep in mind this is an IIS server and php was an add-on. It felt like a juryrig.

4. Ad Lagendijk
   Member
   Posted 1 year ago #

   You can find all information here. It is a free opensource collection of php scripts with one convenient browser interface to manage MySQL databases.

5. philtronics
   Member
   Posted 1 year ago #

   It's fixed! I made a new wp_comments table using a giant MySQL Create Table statement. I used the MySQL command shell, so I wouldn't say phpAdmin is best necessarily.

   The create table statement was worked out by somebody at this URL, which I really appreciate:

   http://www.crazybulb.com/blogging/wordpress-blank-page-after-posting-a-comment-wp-comment-post-php/

Topic Closed

This topic has been closed to new replies.