WordPress.org

Ready to get started?Download WordPress

Forums

Mailing List
database errors, subscriptions failing (5 posts)

  1. aly22
    Member
    Posted 2 years ago #

    Since the upgrade this week (9/13?) I have major database errors showing tables don't exist (but they do if I look in PHPMyAdmin under my wordpress installation):

    Database error 1146 while doing query Table 'mysite_wrdp1.wp_user' doesn't exist
    Database error 1146 while doing query Table 'mysite_wrdp1.wp_user_history' doesn't exist
    Database error 1146 while doing query Table 'mysite_wrdp1.wp_attribute' doesn't exist
    Database error 1146 while doing query Table 'mysite_wrdp1.wp_user_attribute' doesn't exist

    http://wordpress.org/extend/plugins/mailz/

  2. zingiri
    Member
    Plugin Author

    Posted 2 years ago #

    Can you please try to upgrade to version 1.3.5, those 4 tables were using a different prefix from the other ones. In version 1.3.5 those tables will be renamed to use the correct prefix.
    1.3.5 was just released and may take a few hours to appear on your plugins page.

  3. aly22
    Member
    Posted 2 years ago #

    Ok, after running the upgrade (but before realizing I hadn't updated the database) it seemed to have resolved all issues.

    Am about to upgrade my PHP installation from 5.2 to your required 5.3 and hopeful this will not then break other scripts/sites on my server..

    is this absolutely necessary?

  4. aly22
    Member
    Posted 2 years ago #

    I was just warned not to update PHP as several sites on my (dedicated/hosting-reseller) server are not compatible.

    I guess this means I am no longer able to run Mailing List via WordPress. I updated the Mailing List DB just now and:

    WordPress database error: [Can't find file: './mysite_wrdp1/wp_user.frm' (errno: 2)]
    RENAME TABLE wp_user TO wp_zing_user

    WordPress database error: [Can't find file: './mysite_wrdp1/wp_user_history.frm' (errno: 2)]
    RENAME TABLE wp_user_history TO wp_zing_user_history

    WordPress database error: [Can't find file: './mysite_wrdp1/wp_attribute.frm' (errno: 2)]
    RENAME TABLE wp_attribute TO wp_zing_attribute

    WordPress database error: [Can't find file: './mysite_wrdp1/wp_user_attribute.frm' (errno: 2)]
    RENAME TABLE wp_user_attribute TO wp_zing_user_attribute

  5. zingiri
    Member
    Plugin Author

    Posted 2 years ago #

    PHP 5.3 is not strictly necessary right now, it might be a good idea to upgrade at some stage.

    The database errors you mention, can you check if those tables exist in your database?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags