Database Failure

[StreamersConnected]

I've done the below steps, and they have not fixed the issue.

• [x] Run npm run build-server to regenerate lib/ from src/
• [x] Run rm -rf node_modules && npm install to get a fresh install of dependencies
• [x] Restarted the server

Description of the Problem

• Channel creation, promoting/demoting users on channels
• When I create a channel it says "Channel Registration Failed, Database Failure" and all though it still creates the channel and shows after you refresh, it still shows that error when trying to create a channel.
  • When I try to promote or demote a user in any of the channels (i.e Mod, Admin, Owner) it gives me the same "Updating User Rank Failed, Database Failure" message.
• For it to go through and be successful, but they all keep saying "Database Failure"

System Information

• Ubuntu 16.04.2 LTS (GNU/Linux 4.4.0-79-generic x86_64)
  • v6.10.3
  • CyTube 3.0.0
  • "Channel Registration Failued, Database Failure" - Then just "Updating User Rank Failed, Database Failure"

I've provided some screenshots to maybe help the process. Channel Creation: https://gyazo.com/9af1118c39563d1ff867370329143c86 User Promotion: https://gyazo.com/012d5ec77d698551b6e92bf5b5d9bc60

[Xaekai]

The database code is in the process of being ported to Knex.js, a generic query builder so the server can support using MySQL, Sqlite3 and Postgres. This is probably due to that.

Your first issue should have already been fixed as of this commit https://github.com/calzoneman/sync/commit/830486bc4f073e148a763afca9d7ab08b241abfd 2 days ago. The rest will have to wait until @calzoneman is available, but I believe he is out of town for a few days.

You can either wait or try revert to commit 22a9acfc90bbc9c3434770528210b079d7870cb3

[StreamersConnected]

We'll wait, I appreciate this. Thank you for your help.

[calzoneman]

Actually both of the above symptoms match up with the issue fixed in https://github.com/calzoneman/sync/commit/830486bc4f073e148a763afca9d7ab08b241abfd. Have you tried with the latest commit?

[StreamersConnected]

I have and it didn't work unfortunately.

[calzoneman]

I'm unable to reproduce the issue. First, please check that your server is fully updated:

» git rev-parse HEAD                                                                                                                                                                             
00a65a1584bf3e2dd78efb1a678829b935814ee0
» rm -rf lib/ && npm run build-server

If you've verified above that (1) you're at the current commit, (2) you have re-build the source files into lib, and (3) you restarted the server after doing this, then please attach the contents of error.log.

[StreamersConnected]

Ill do that right away.

[StreamersConnected]

I've rebuilt it and that seemed to have fixed it, no error, it just creates the channel, but there's no dialog when creating the channel so I don't know if that's intentional.

Although after deleting channels and refreshing it gives me this so I just though I'd let you know. https://gyazo.com/9c5818e83cf76064eb7dc4c958254660 Screenshot^ And I can confirm I'm on the latest version.

Here's my error logs. https://pastebin.com/qPc7Ky6V

[calzoneman]

Although after deleting channels and refreshing it gives me this so I just though I'd let you know.

Is your browser prompting you to resubmit the form? If so, you're not simply reloading the page, you're actually sending the delete request again, and the server is correctly reporting that the channel you deleted doesn't exist anymore.

Marking this issue as resolved.