WordPress.org

Support

Support » Plugins and Hacks » [Plugin: Mailing List] database errors, subscriptions failing

[Plugin: Mailing List] database errors, subscriptions failing

  • aly22
    Participant

    @aly22

    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/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author zingiri
    Member

    @zingiri

    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.

    aly22
    Participant

    @aly22

    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?

    aly22
    Participant

    @aly22

    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

    Plugin Author zingiri
    Member

    @zingiri

    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?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: Mailing List] database errors, subscriptions failing’ is closed to new replies.