Database upgrade fails upon upgrade

  • Resolved shamakern

    (@shamakern)


    5 years, 10 months ago

    I upgraded from version 5 to version 6.6. As suggested, I did this in a staging environment. I followed your upgrade instructions precisely, but when I get to the database upgrade, it fails. I had a tech person check it out, and he said that the problem was with the plugin. Here is what he told me:

    “Indeed, at the latest stage (Forum > Upgrade Simple:Press) the task goes on indefinitely.The error in the logs is as follows:
    Code:

    [Mon Jan 07 07:59:15.857457 2019] [:error] [pid 7953] [client 195.24.55.58:43666] WordPress database error Unknown column ‘permalink_slug’ in ‘field list’ for query SELECT forum_slug, permalink_slug FROM wp_sfforums made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/simplepress/sp-control.php’), SP, spcSimplePress::instance, spcSimplePress->startup, spcCoreLoader->load, spcPermalinks->__construct, spcPermalinks->load, spcDB->select, spcDB->executeSelect, referer: https://staging2.thaihealingmassage.com/wp-admin/admin.php?page=simplepress%2Fsp-startup%2Fsp-load-install.php

    This looks like a development error, related to the package that was downloaded.

    There is no column “permalink_slug” in the database, but apparently the update script looks for one.

    I would recommend that you contact the plugin developers and forward the error to them. They should be able to tell what exactly goes wrong.”

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Mr Papa

    (@usermrpapa)

    No, that is not correct… it doesnt go on forever – stops on the error… and that error is specific to your set up…

    the first thing that upgrade section does is add the permalink_slug column to the database table for forums…

    SP()->DB->execute(‘ALTER TABLE ‘.SP_PREFIX.’sfforums ADD (permalink_slug VARCHAR(1000) NOT NULL)’);

    then it attempts to build the permalink slugs for your forums by executing the code where it errors out…

    so this means for that some reason, that alter table code failed to execute on your server and did not create the new column… you should check with your host and see if your db user has ALTER permission on the server… the overwhelming majority of hosts provide that permission standard, but perhaps you have customized your db user…

    Plugin Contributor Mr Papa

    (@usermrpapa)

    you may have to manually create that column in your db and let the upgrade script run again…

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