Support » Fixing WordPress » WP 20 can write posts to my DB but can not read them

  • Resolved Frankenboy


    I’ve switched to WordPress Release2.0.1 using a completely new environment (“localhost”, folder-prefix “wordpress20” and dbase-name “wordpress”). I can write posts to my DB but the data written in my blog are not displayed: There is a “not found” returned. Part of my sidebar is shown, the data which comes from the DB like categories and links are not shown too.
    Please can somebody help me!
    Thank you very much

Viewing 14 replies - 1 through 14 (of 14 total)
  • Can you see the posts in the admin-panel ?

    No, the admin-panel is empty!

    That sounds very strange. Are the DB rights set properly ? Has the user (for some tables) write but no read access ?
    The options seem to be available for reading …

    Im having similar problems but only with a users email.

    There in MySQL but not displaying in the front or backend of the site im working on

    I’m the administrator and (I hope) I’ve all privileges.
    Where can I set these priviliges for my database?

    You can do that by SQL or in the users view of phpmyadmin (in the database) … I don’t have it available.

    Have you tried a new install, it sounds like somethings gone terribly wrong. What Versions are you using (php, mySQL, OS) ?

    I upgraded three sites yesterday:

    I had some issues getting the first one to take but I didn’t seem to have issues with either of the other two. However, the third one is having a similar issue to the OP. When I log in as the admin, I cannot see any posts to manage. From the front page, all links lead to a page that looks identical to the index page. However, I can write new posts.

    From the dashboard, there are posts listed under “posts” however.

    Any ideas?

    I’ve installed wordpress20 completely new .
    These are the Versions I’m using:
    MySql -> 4.0.24
    phpP-> 4.3.8
    phpMyAdmin -> 2.6.4
    Windows -> XP/SP2 (genuine)
    Are there some debugging feature for wordpress available?

    Now I’ve found an error-message in the header section of my blog:

    WordPress database error: [Can’t create/write to file ‘C:\Programme\TSW\DB\MySQL4\tmp\#sql_120_0.MYI’ (Errcode: 2)]

    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2006-02-06 16:38:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

    Oh! Found an error at the bottom of the manage posts page:

    WordPress database error: [Unknown column ‘user_level’ in ‘where clause’]
    SELECT * FROM nt_users WHERE user_level > 0 ORDER BY user_nickname

    @frankenboy: The Database has to create a temp file for the result of the select. Maybe there’s no space available there or the user under which mysql is running is not allowed to create / update files there … or: there’s no space left 😉

    @nmallory: It seems like some parts of the admin app are not correctly updated. User Level is no longer available with wp 2.0. Check your plugins, maybe they need to be updated.

    OK I got rid of the user_level error. It was part of a plugin, which I deactivated.

    I also cleanly reloaded the wp-admin and wp-includes directories.

    I still, even as admin, cannot see posts under manage posts.

    Also, all of my links on my index.php page load as if it were the index.php page. It shows the correct permalink in the url but you can’t see pages, individual posts, category archives, etc.

    The database looks like it upgraded correctly so I don’t know what the issue is.

    OK Nevermind. Apparently it was the Adhesive plugin as well as the Enhanced Post List plugin.

    Very frustrating, but at least resolved. Now everyone can read about my crazy uncle and my liberal views and my quest for truth in religion again. 😛

    Hi bob58
    That was the solution! After creating a /tmp subfolder in the mysql-folder, my WordPress 2.0 Database runs. I can now see all my posts und they are displayed in my “Rentnerblog”!
    Thank you very much for spending your time to resolve my problem:

    see: ->

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘WP 20 can write posts to my DB but can not read them’ is closed to new replies.