• 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 ?

    [email protected]:~/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!
      

    [email protected]:~/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
    [email protected] node_modules/redis

    [email protected] node_modules/connect-redis
    ā””ā”€ā”€ [email protected] ([email protected])
    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)
    [email protected]:~/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


Suggested Topics

  • 4
  • 7
  • 8
  • 1
  • 3
| | | |