Hi Peter,
That’s because WordPress stores post categories in the term_relationships table, which works in conjunction with the terms and posts table. More info:
https://codex.ww.wp.xz.cn/Database_Description#Database_Diagram
Ok, thanks for the reply.
By the way, what’s the best way to clear the tables to start at the beginning again for post submissions?
The best way to delete submitted posts:
– Visit the Posts screen in the Admin Area
– Click the USP button at the top of the post list
– Select all filtered/USP posts and bulk delete them
It is not recommended to make any changes to the WP database unless you absolutely are 110% sure you know what you are doing.
Hello Jeff,
Thanks for your quick reply.
So out of curiousity, do you log %%post_author%% into the database anywhere?
Hi Peter,
Actually it works the other way around: all author data are stored in the database, then plugins like USP use different techniques to retrieve it. For example, %%post_author%%, et al.
Really?
I am having a difficult time looking for the table that stores the author data. May I ask which table is it?
Check out the users and usermeta tables. Again, all of this information is explained clearly in the official WP database description. And on that same page, you will find a complete overview of all the tables.
-
This reply was modified 8 years ago by
Jeff Starr. Reason: clarity
-
This reply was modified 8 years ago by Jeff Starr. Reason: add info
Whoa! That sounds complicated. I installed phpMyAdmin, but I cannot seem to find a table that has a record containing the author name.
Any user data that is displayed by WordPress *must* exist in the database. If you need help searching with phpMyAdmin or whatever, your web host or developer should be able to provide assistance.
Hello Jeff,
Thanks for your replies.
I finally found it. It was nested high up in the records. The records were displaying only 100 something until I bumped it up to show 300 records.
It is in the wp_postmeta table.
Thanks.
Peter
