Can't restore nodebb



  • i have installed nodebb on a new machine,

    I have copied my previous working .rdb file back into /var/lib/redis/dump.rdb

    but when i run sudo ./nodebb upgrade ... i get the following error:

    error: [upgrade] Errors were encountered while updating the NodeBB schema: ERR value is not a valid float

    and when i Run nodebb dev i get

    warn: Your NodeBB schema is out-of-date. Please run the following command to bring your dataset up to spec:
    12/8 12:05 [14923] - warn: ./nodebb upgrade

    Please help!

    Thanks


  • GNU/Linux Admin

    Hi there,

    Can you please provide the following information to help us debug?

    1. Server or client operating system (if applicable)
    2. NodeBB version and hash
      • To get the hash, run git rev-parse HEAD from the root of your NodeBB folder

    Thanks!



  • I got it kind of working on 0.6x but only by after resetting all plugins... i then upgraded to 0.7x, tried resetting all plugins and still doesn't work, i deleted the node_modules folder and tried npm update/install again and still get this error Ahhhhhhhh!!!!

    1. Bringing base dependencies up to date

    2. Updating NodeBB data store schema
      12/8 14:58 [23035] - info: Beginning database schema update
      12/8 14:58 [23035] - info: [2015/02/08] Clearing reset tokens skipped
      12/8 14:58 [23035] - info: [2015/02/17] renaming home.tpl to categories.tpl skipped
      12/8 14:58 [23035] - info: [2015/2/23] Activating NodeBB Essential Rewards - skipped
      12/8 14:58 [23035] - info: [2015/02/24] Upgrading plugins:active to sorted set skipped
      12/8 14:58 [23035] - info: [2015/02/24] Upgrading privilege groups to system groups skipped
      12/8 14:58 [23035] - info: [2015/02/25] Upgrading menu items to dynamic navigation system skipped
      12/8 14:58 [23035] - info: [2015/05/07] Upgrading uid mappings to sorted set skipped
      12/8 14:58 [23035] - info: [2015/05/08] Fixing emails skipped
      12/8 14:58 [23035] - info: [2015/05/11] Updating widgets to tjs 0.2x skipped
      12/8 14:58 [23035] - info: [2015/05/20] Adding username:sorted and email:sorted skipped
      12/8 14:58 [23035] - info: [2015/06/02] Creating group sorted sets
      12/8 14:58 [23035] - error: [upgrade] Errors were encountered while updating the NodeBB schema: ERR value is not a valid float

    3. Storing upgrade date in "package.json"

                     NodeBB Upgrade Complete!


  • @julian said:

    git rev-parse HEAD

    also

    1. Ubuntu Server
    2. 4bcf7792f826a42e21df08847926feb75da1f2c5

  • GNU/Linux Admin

    Hm, okay... can you paste the lines around it, so I can see which upgrade script caused the error?



  • Like this ?

    chas@vps192892:~/nodebb$ ./nodebb upgrade

    1. Bringing base dependencies up to date

    2. Updating NodeBB data store schema
      12/8 14:59 [1987] - info: Beginning database schema update
      12/8 14:59 [1987] - info: [2015/02/08] Clearing reset tokens skipped
      12/8 14:59 [1987] - info: [2015/02/17] renaming home.tpl to categories.tpl skipped
      12/8 14:59 [1987] - info: [2015/2/23] Activating NodeBB Essential Rewards - skipped
      12/8 14:59 [1987] - info: [2015/02/24] Upgrading plugins:active to sorted set skipped
      12/8 14:59 [1987] - info: [2015/02/24] Upgrading privilege groups to system groups skipped
      12/8 14:59 [1987] - info: [2015/02/25] Upgrading menu items to dynamic navigation system skipped
      12/8 14:59 [1987] - info: [2015/05/07] Upgrading uid mappings to sorted set skipped
      12/8 14:59 [1987] - info: [2015/05/08] Fixing emails skipped
      12/8 14:59 [1987] - info: [2015/05/11] Updating widgets to tjs 0.2x skipped
      12/8 14:59 [1987] - info: [2015/05/20] Adding username:sorted and email:sorted skipped
      12/8 14:59 [1987] - info: [2015/06/02] Creating group sorted sets
      12/8 14:59 [1987] - error: [upgrade] Errors were encountered while updating the NodeBB schema: ERR value is not a valid float

    3. Storing upgrade date in "package.json"

                     NodeBB Upgrade Complete!
      

    chas@vps192892:~/nodebb$

    Also while i try do a nodebb Setup

    12/8 15:00 [1994] - info: Now configuring redis database:
    Host IP or address of your Redis instance (127.0.0.1)
    Host port of your Redis instance (6379)
    Password of your Redis database
    Which database to use (0..n) (0)
    Configuration Saved OK
    redis@0.10.3 node_modules/redis

    connect-redis@2.0.0 node_modules/connect-redis
    └── debug@2.2.0 (ms@0.7.1)
    Populating database with default configs, if not already set...
    Previous theme detected, skipping enabling default theme
    Categories OK. Found 27 categories.
    Administrator found, skipping Admin setup
    Enabling default plugins
    12/8 15:00 [1994] - warn: NodeBB Setup Aborted.
    Error: schema-out-of-date
    at /home/chas/nodebb/src/upgrade.js:43:29
    at try_callback (/home/chas/nodebb/node_modules/redis/index.js:573:9)
    at RedisClient.return_reply (/home/chas/nodebb/node_modules/redis/index.js:661:13)
    at ReplyParser.<anonymous> (/home/chas/nodebb/node_modules/redis/index.js:309:14)
    at ReplyParser.EventEmitter.emit (events.js:95:17)
    at ReplyParser.send_reply (/home/chas/nodebb/node_modules/redis/lib/parser/javascript.js:300:10)
    at ReplyParser.execute (/home/chas/nodebb/node_modules/redis/lib/parser/javascript.js:203:22)
    at RedisClient.on_data (/home/chas/nodebb/node_modules/redis/index.js:534:27)
    at Socket.<anonymous> (/home/chas/nodebb/node_modules/redis/index.js:91:14)
    at Socket.EventEmitter.emit (events.js:95:17)
    chas@vps192892:~/nodebb$



  • Would it help if i send you my rdb file? or do you think this could be fixable via the script? I dont really want to have to downgrade to 0.6.x



  • Does this help?

    127.0.0.1:6379> get schemaDate
    "1432080000000"

    127.0.0.1:6379> zrange categories:cid 0 -1

    1. "1"
    2. "2"
    3. "3"
    4. "13"
    5. "14"
    6. "4"
    7. "25"
    8. "16"
    9. "5"
    10. "6"
    11. "17"
    12. "7"
    13. "9"
    14. "10"
    15. "18"
    16. "8"
    17. "11"
    18. "19"
    19. "12"
    20. "20"
    21. "26"
    22. "21"
    23. "22"
    24. "23"
    25. "24"
    26. "27"
    27. "28"


  • I fixed it using https://github.com/NodeBB/NodeBB/issues/1163

    and setting to todays date, so now it says "Schema is up-to-date" and all works perfectly.

    I hope its ok now? xD

    tedr56 created this issue in NodeBB/NodeBB

    closed Error on last db schema change. #1163


Log in to reply
 

Suggested Topics

| |