Can't restore nodebb

[chas]

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

[julian]

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!

[chas]

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!
   

[chas]

@julian said:

git rev-parse HEAD

also

1. Ubuntu Server
2. 4bcf7792f826a42e21df08847926feb75da1f2c5

[julian]

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

[chas]

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
[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)
chas@vps192892:~/nodebb$

[chas]

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

[chas]

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"

[chas]

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