• Resolved tbclark3

    (@tbclark3)


    You might want to take a look at the following snippet:
    private function create_phone_number_digits_column( $oldversion ) {
    $this->columns->create(
    AWPCP_TABLE_ADS,
    ‘phone_number_digits’,
    $this->database_helper->replace_charset_and_collate(
    “VARCHAR(25) CHARACTER SET <charset> COLLATE <collate> NOT NULL DEFAULT ” AFTER ad_contact_phone
    )
    );
    }

    It fails because you can’t have not null default null. There probably should be a blank between the two single quotes.

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

    (@tbclark3)

    Additional info:
    I realize that it isn’t the default that is the problem, and I’m not sure what is. My database did not get upgraded, and it didn’t have a phone_number_digits field. When I added the field manually, it is working again.

    Hi tbclark3,

    Sorry that you ran into issues here!

    Sounds like at some point, an upgrade failed to run correctly, leaving a column in an improper state or something. And you’ve worked it out–at least that’s what I’m hearing above.

    If not, we’d be happy to continue this conversation offline– Contact us here: https://awpcp.com/contact/

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘mistake in upgrade script’ is closed to new replies.