wp_get_comments isnt the problem, and I dont know why you would think that it is — thats not even a wordpress tag.
Well, there seems to be a line in edit-comments.php that calls this, but I might be completely at sea here since my knowledge of php is minimal.
unless youre typo’ing the actual function, youre mistaken.
[root@boxx wordpress]# grep -r wp_get_comments *
[root@boxx wordpress]#
Not that matters, since if there was an issue with a function, you would be seeing a verbose error instead of nothing.
“Seems to be”? It’s either there or it isn’t. On line 142 of edit-comments.php, there’s this: _wp_get_comment_list and no other string containing wp_get …
But all this is a red herring. What error messages are you getting when you try to view/edit comments from the dashboard? Have you installed any plugins that mess around with the Admin Panel or Comments? Have you tried disabling all your plugins to see if the problem goes away? And then re-enabling them, ONE BY ONE, and CHECKING AFTER EACH, to see which plugin might be problematic?
You don’t have to know PHP, but you should be able to provide enough information on this forum so that people who want to help you can.
I get the manage comments page in dashboard with ‘no comments found’ although there are plenty of comments. The only plugin active is akismet. no others are activated. Wpstats is deactivated (see my other thread). Those are the only two in the directory.
Does this clarify?
its more than likely a consequence of your upgrade. Take a look at the standard wp_comments table .. compare that to what you see on yours. do you have all the fields? do you have any and all of the indexes?
do this:
edit your wp-config.php, add this to it:
define('WP_DEBUG',true);
load up the edit-comments page or whatever. betcha you see MySQL errors.
ok, i’ve uploaded a screenshot of what i see when I open manage comments in dashboard. Am I overlooking something obvious? Please please tell me this is a simple problem and easily fixed.
OK, thanks, whooami, will do and report.
Brilliant suggestion. I got this error. Please translate for me and if possible suggest how to fix.
WordPress database error: [Key column 'comment_date_gmt' doesn't exist in table]
SELECT SQL_CALC_FOUND_ROWS * FROM wp_comments USE INDEX (comment_date_gmt) WHERE ( comment_approved = '0' OR comment_approved = '1' ) ORDER BY comment_date_gmt DESC LIMIT 0, 25
can I leave that WP debug line in wp-config so i can check the rest of the install? just asking in case there’s a change it might conflict somewhere and mess something up.
I already translated it, and told you what to do.
Take a look at the standard wp_comments table .. compare that to what you see on yours.
do you have any and all of the indexes?
You dont.
alright, next silly question: where do I find the standard wp_comments table?
Sorry if this is obvious. Where do the indexes live? can i get them back? should i try?
pasting from your own reply:
WordPress database error ...
where do I find the standard wp_comments table?
in your database.
Where do the indexes live? can i get them back?
yes, and yes, you just have to add them.
OK when I log on to phpMyAdmin I don’t see a pull down menu of databases on the left hand side. There is just my domain name in bold but no links or other text of any kind. Should my databases be in a particular directory to be able to display here? they’re in my site root right now.
if you haven’t noticed ive been going out of My way to not reteach fundamentals — since this is ALL covered in the documentation.
You would NOT have posts showing up on your site, if the database flat files were not where they belonged.
An SQL dump is NOT a database file. Its a dumpfile.
Now, Ive told you what you need to do. Ive told you what the problem is. ive told you that you need to compare the structure of a standard brand new install of 2.6.1’s wp_comments to what your wp_comments.
Indexes are shown at the bottom of the screen when looking at the structure in phpmyadmin.
I charge people to fix these kinds of problems and it “costs” me less than time than what Ive put into this thread, thusly.
