• Resolved desatir7316

    (@desatir7316)


    hi
    i work on a portal, every thing is ok unless the place of new posts in db
    when i add a new post, it stored somewhere and i can see it in my portal, but nowhere in db
    i used phpmyadmin search also to search whole db’s tables, but nothing return
    what should i do
    thanks

Viewing 15 replies - 1 through 15 (of 23 total)
  • All posts, and most other content, is stored in the wp_posts table. new posts will be at the highest ID. If it’s not in the database that you’re looking at, check to see which database the site is using as it migth be connected to a different database then the one that you’re looking at.

    Thread Starter desatir7316

    (@desatir7316)

    thanks for reply
    no, i checked the config file and the db name, and for be more sure, i Temporarily changed the db name in the config file ( only for check) then i got db connecting error
    i dont know what to do, its related to my job and it will make a problem to me if not solve ??

    The posts are all stored in the database table names wp_posts – assuming that you have the DB prefix set as wp_ in your configuration file.

    If you can’t find the content in that table, there’s also a possibility that something is stored in the wp_postmeta table, but that depends on exactly what it is tha tyou’re looking for.

    So can you give us an example of what you are looking for and where you are looking for it?

    Thread Starter desatir7316

    (@desatir7316)

    i looking for new posts in the portal
    i can see them in the browser but cant find them in db
    i did a whole search in my db, in all tables with phpmyadmin search tool but nothing found

    Then your not looking in the right place.

    Theres a very easy way to find the post in the database. Log into the admin area and find the post in the list. Hover over the edit link and you will see the ID as part of the query. Use that ID and you’ll be able to get the record from the database. The main information is in the wp_posts table and anything else will be in the wp_postmeta table under the same post ID.

    If you still can’t find it your site could be using some sort of custom post type that we don’t know about. Really there’s no other options.

    Thread Starter desatir7316

    (@desatir7316)

    If you still can’t find it your site could be using some sort of custom post type that we don’t know about. Really there’s no other options.

    how should i know about this

    If the content is in the ‘Posts’ area in your admin, it’s a standard post, and it is stored in the wp_posts table. There is no other possibility. That’s where they are stored, so if you can’t find them there is something wrong with your local system.

    Thread Starter desatir7316

    (@desatir7316)

    If the content is in the ‘Posts’ area

    actually it is :((
    but why is not in mysql db =((

    Thread Starter desatir7316

    (@desatir7316)

    my blog is in another language other than eng
    my menus item are in diff lang
    but in this url, i can see all posts:
    blogname.sth/wp-admin/edit.php

    I’ve told you everything that I can. I don’t know what else can be said now.

    You can still get the ID from that page, and you can use that to find the post in the database. Please try that. It seems like you haven’t done that so far.

    Thread Starter desatir7316

    (@desatir7316)

    It seems like you haven’t done that so far.

    i checked everything before a start posting here
    only posts from some months ago are in the db, for example for 4 months ago

    Then the only explanation is that you are not looking in the right database. If the post exists, but it’s not in that database it has to be somewhere else. Again, there is no other possibility.

    Thread Starter desatir7316

    (@desatir7316)

    but in the second post i explain how to check db connection

    another reason is a can find posts from one year ago in db but not new posts
    is it possible to connect to multiple dbs ? i know its not unreasonable but i dont know any reason

    WordPress only connects to one database.

    You are looking at the wrong database. I am 100% sure of that.

    Thread Starter desatir7316

    (@desatir7316)

    thanks for ur answers
    but im sure im not, because
    1- i check older posts that are in both db and my blog page
    2- i check the config file and db name
    by the way what else to check db connectivity for my blog

    again thanks for ur time

Viewing 15 replies - 1 through 15 (of 23 total)
  • The topic ‘where is new post's place in db’ is closed to new replies.