Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Update to version 2.2: Fatal error

ClémentClément
edited November 2015 in Vanilla 2.0 - 2.8

Hello,

I can not update the Vanilla 2.2b1 => 2.2

Here is the error message when I called the url /utility/update:

Fatal error: Duplicate entry '0-Garden.Update.LastTimestamp' for key 'PRIMARY'|Gdn_Database|Query|insert GDN_UserMeta (UserID,Name,Value) values (:UserID, :Name, :Value)

Thank you in advance for your help.

Comments

  • Options
    peregrineperegrine MVP
    edited November 2015

    for a kluge quick fix to allow you to run /utility/update

    you could goto phpmyadmin

    look in usermeta table of the database.

    and delete the row relating to userid 0 Garden.Update.LastTimestamp

    then run /utility/structure

    rescan

    and then run /utility/update

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options

    @Clément

    updated message above.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options

    Thank you for your help !

    Still the same error.

    1) delete Garden.Update.LastTimestamp
    2) /utility/structure
    3) scan
    3) rescan
    4) /utility/update

    == Fatal error (same message) => Garden.Update.LastTimestamp for user is there again :(

  • Options
    peregrineperegrine MVP
    edited November 2015

    I don't know why it doesn't update properly (perhaps cache related or something wrong with $Value in field).

    i.e. modify instead of trying create new entry.

    between step 3 and 4 you could manually delete the row.

    does the value have a valid unix timestamp?

    for that matter is it a version of linux.

    what is the value?
    or is the value field 0?

    sounds like an edge effect bug in vanilla.

    try

    1) delete Garden.Update.LastTimestamp
    2) /utility/update

    fi you don't get resolution.
    if all else fails you could always comment out the setting of Garden.Update.LastTimestamp
    then run /utility/update

    then uncomment.

    applications/dashboard/controllers/class.utilitycontroller.php

            Gdn::set('Garden.Update.LastTimestamp', $Now);
    

    https://github.com/vanilla/vanilla/search?utf8=✓&q=Garden.Update.LastTimestamp

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options

    Thank you for your help.

    The import of my forum phpBB3 doesn't work on Vanilla 2.2

    I've decided to install a new fresh Vanilla 2.1 => import phpBB3 => and update to Vanilla 2.2.

    Now, it works !!! :)

    I keep your solution for next update 2.2 => 2.3 ;)

Sign In or Register to comment.