WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WP 20 can write posts to my DB but can not read them (15 posts)

  1. Frankenboy
    Member
    Posted 8 years ago #

    Hello
    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
    Frankenboy

  2. bob58
    Member
    Posted 8 years ago #

    Can you see the posts in the admin-panel ?

  3. Frankenboy
    Member
    Posted 8 years ago #

    No, the admin-panel is empty!

  4. bob58
    Member
    Posted 8 years ago #

    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 ...

  5. Phunky
    Member
    Posted 8 years ago #

    Im having similar problems but only with a users email.

    http://wordpress.org/support/topic/59930?replies=1

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

  6. Frankenboy
    Member
    Posted 8 years ago #

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

  7. bob58
    Member
    Posted 8 years ago #

    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) ?

  8. nmallory
    Member
    Posted 8 years ago #

    I upgraded three sites yesterday:

    http://www.nothingtastesasgood.com
    http://theweekendchef.exit-23.net
    http://nmallory.exit-23.net

    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?

  9. Frankenboy
    Member
    Posted 8 years ago #

    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?

  10. Frankenboy
    Member
    Posted 8 years ago #

    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

  11. nmallory
    Member
    Posted 8 years ago #

    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

  12. bob58
    Member
    Posted 8 years ago #

    @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.

  13. nmallory
    Member
    Posted 8 years ago #

    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.

  14. nmallory
    Member
    Posted 8 years ago #

    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. :P

  15. Frankenboy
    Member
    Posted 8 years ago #

    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:
    Frankenboy

    see: -> http://www.frankenberg.ch/blog/wordpress15/

Topic Closed

This topic has been closed to new replies.

About this Topic