Database error during manual upgrade

  • Resolved Mick Levin

    (@mick-levin)


    8 years, 11 months ago

    Hello,

    I just updated the plugin on a DEV server from v 2.0.6 to 3.6.2

    It prompted for a manual update of the databases.

    The AJAX call in a Console got an error page, which contains repeating errors, 2 kinds of them.

    Error #2 was that one:

    [Column 'user_id' cannot be null]
INSERT INTO wp_awpcp_payments (id, user_id, status, payment_status, payment_gateway, payer_email, items, data, errors, created, updated, version)
VALUES ('f32221c393ab8ae53306ea4313ad7076', NULL, 'New', 'Not Required', '', '', 'a:0:{}', 'a:4:{s:7:\"user-id\";i:0;s:4:\"free\";b:1;s:11:\"__created__\";s:19:\"2012-04-23 00:33:28\";s:11:\"__updated__\";s:19:\"2012-04-23 00:33:28\";}', 'a:0:{}', '2012-04-23 00:33:28', '2015-12-20 02:47:09', '1')

    I am not sure, if it’s a broken logic, or just the database structure needs an update and allow the NULL in user_id column?

    Sincerely,
    Mick

    https://www.ads-software.com/plugins/another-wordpress-classifieds-plugin/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Mick Levin

    (@mick-levin)

    Workaround:

    ALTER TABLE wp_awpcp_payments CHANGE user_id user_id INT( 10 ) NULL

    I wonder if that had to be accounted for before doing a DB manipulation?

    Hi Mick,

    Sorry that you ran into issues here!

    The AJAX issue is one we’re already looking into–we’ve had a couple of reports but every time we investigate, we try it ourselves and it just works. You might consider trying that from another browser if you haven’t resolved it already. That seems to help.

    Since you upgraded from an earlier version (very earlier) the DB issue could very well be a glitch that was manually handled during one of the upgrades done between then and now. We’ll double check, but you’re the first to report this issue.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database error during manual upgrade’ is closed to new replies.