Events Made Easy Forums Generic Unknow column 'xxx' in 'fields list' after upgrade to 1.3.3

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #44225
    Anonymous
    Inactive

    When creating new location:

    WordPress database error: [Unknown column ‘location_attributes’ in ‘field list’]

    The column ‘location_attributes’ is “new” and it seems not to have been created at update.

    Eme plugin has been de-/reactivated.

    I’ve had this kind of malfunction before, and corrected it by creating missing database field manually (guessing field properties).

    It worked when making new insert action.

    Now is seems to be a more ”permanent” issue, where corrections are needed.

    – Missing “add if not exists” function?

    Best reguards

    Stig

    #51492
    Franky
    Keymaster

    The column location_attributes has been added in 1.2.6. And the code foresees to add it if not there, see events_manager.php:

    maybe_add_column($table_name, ‘location_attributes’, “alter table $table_name add location_attributes text NULL;”);

    Which means that the mysql user you have defined for wordpress probably doesn’t have the rights to create new tables or columns.

    #51493
    Anonymous
    Inactive

    Is this possible when installing the plugin works?

    – I assumed this was done by “the same mysql user(built-in)”.

    – It works manually

    – Is manual correction done by another user?

    #51494
    Franky
    Keymaster

    No, it is not. That means something else is wrong, do you sometimes manually update using the trunk version? The DB actions are based upon a variable compared with a wordpress option, so if that variable is already the same, no DB action takes place.

    #51495
    Anonymous
    Inactive

    Well, I wish to understand this better.

    Using standard update procedure causes malfunction of script(s).

    Manual update of specific field in database was made in phpAdmin client.

    – This is (of course you know that, sorry) not a script, but a direct DB action.

    If one can install a plugin, it should be possible to update the very same plugin without getting problems due to permission settings?

    – Furthermore, trunk version??

    – – I never install a folder with a plugin content by FTP client.

    – – I used phpAdmin to create the missing field(s), guessing properties.

    Kind reguards.

    //Stig

    #51496
    Franky
    Keymaster

    You’re right that if you can install a plugin, you should be able to update it. I updated several sites without issues to EME 1.3.4, even multisites. So I can’t imagine why it doesn’t seem to be working for you, unless the DB is not allowing you to update tables from the website.

    Do you use phpmyadmin from the same server and using the same db user?

    When you updated the plugin, did you see the deactivation/reactivation message for the EME database warning?

    #51497
    Anonymous
    Inactive

    Correct, I did use the phpadmin at my web site, so user and credentials should be the same as they are supplied by the web hotel.

    And now, quoting my self:

    “The column ‘location_attributes’ is new and it seems not to have been created at update.

    Eme plugin has been de-/reactivated.”

    This indicates a probable error in permissions.

    Next step is to contact them to see if there are anything in their log files.

    So:

    I am looking forward to next plugin update

    – if there is another new field in it,

    – and otherwise too!

    I really like your plugin!

    I have used it for over a year now at my choires web site.

    Best reguards.

    #51498
    Franky
    Keymaster

    Well, the next version won’t ask for de/reactivation any more, and is a bit more simple in that matter. So it might just solve your issues.

    The next version will (hopefully) have an extra field in it (normally it will: “cancel registration format” will be a new event column, and maybe some language columns for bookings and people) 🙂

    #51541
    Anonymous
    Inactive

    Solved!
    Basic (hrmm) error in MySQL privileges.
    My web hotel uses 2 MySQL users by default.
    One for initial installing of CMS, with all privileges
    and one for maintaining the site, with reduced privileges, so it managed to upgrade plugin but did not INSERT new fields.
    Now corrected and it works.
    Thanks a lot for your rapid and courtious support.

Viewing 9 posts - 1 through 9 (of 9 total)
  • The forum ‘Generic’ is closed to new topics and replies.
Scroll to Top