Announcement

Collapse
No announcement yet.

Database error when updating Navigation manager

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mark.B
    replied
    You're welcome. Glad you got it sorted.

    Leave a comment:


  • Mr Jolly
    replied
    OK, everything seems to be working fine now, thanks for your assistance Mark.

    Leave a comment:


  • Mr Jolly
    replied
    It was the chuffin' vBSEO, even though it was all switched off. I have disabled the rewrites in the .htaccess file and I think I can now do the upgrade. Fingers crossed.

    Leave a comment:


  • Mr Jolly
    replied
    Even though I've uploaded everything when I go to mydomain/forum/install/upgrade.php I get a page not found message.

    Leave a comment:


  • Mark.B
    replied
    If you're using 4.2.2 files but the database is an earlier version then that will explain the error.

    The upgrade script needs to be run in order for a site to be upgraded.

    Close the site, Upload a fresh copy of the 4.2.2 files, then run /install/upgrade.php.
    Once it's complete, reopen the site and remove the /install folder.

    As with all upgrades, backup the database first.

    Leave a comment:


  • Mr Jolly
    replied
    No, I had trouble with the upgrade so I don't think it did upgrade properly. I've not been able to run the upgrade script though. Even if I upload all the files I get an error message saying the page is missing.

    The upgrade went badly and I asked my hosts to restore from a back up. I wasn't expecting it to be upgraded at all. Will I have to do the install again from the start?

    Leave a comment:


  • Mark.B
    replied
    Did the upgrade script complete fully, right the way to the "Upgrade Complete" message?

    Leave a comment:


  • Mr Jolly
    replied
    OK, I've done that.

    I'm running version 5.3.27 PHP and 5.0.95 - community MySQL.

    Leave a comment:


  • Mark.B
    replied
    Add the following lines to your config.php under the <?php line:
    PHP Code:
    define('SKIP_ALL_ERRORS'true);
    define('DISABLE_HOOKS'true); 

    Also, what versions of php and MySQL are you running?

    Leave a comment:


  • Mr Jolly
    replied
    Yeah, it does. I disabled all plug ins and used the default style and it still occurs.

    Leave a comment:


  • Mark.B
    replied
    Does this happen if you disable vBSEO?

    Leave a comment:


  • Mr Jolly
    started a topic [Forum] Database error when updating Navigation manager

    Database error when updating Navigation manager

    I've recently updated to vB 4.2 and members can no longer mark forums read, they get an error message saying the security token was invalid.

    After a bit of research it looks like it's because the mark forums read link in the navigation manager is incorrect, but when I try to edit it I get this database error message:

    Invalid SQL:

    UPDATE navigation
    SET state = 19,
    displayorder = 90,
    productid = 'vbulletin',
    scripts = '',
    showperm = 'canviewforums',
    url = 'forumdisplay.php?{session.sessionurl}do=markread&amp;markreadhash={bbuserinfo.securitytok en}',
    menuid = ''

    WHERE navid = 76;

    MySQL Error : Unknown column 'menuid' in 'field list'
    Error Number : 1054

    Can anyone figure out how to solve this?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X