Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Install on Debian with MariaDB 10 failes #430

Closed
xundeenergie opened this issue Jan 27, 2021 · 3 comments
Closed

Install on Debian with MariaDB 10 failes #430

xundeenergie opened this issue Jan 27, 2021 · 3 comments
Labels

Comments

@xundeenergie
Copy link

@xundeenergie xundeenergie commented Jan 27, 2021

Describe the bug

On Debian there is only MariaDB and no Mysql (any more). Requirement ist mysql 5.6+
MariaDB is 10.3.27
Installer can not create tables in database

Steps to reproduce (if necessary)

Steps to reproduce the behavior:

  1. Install on debian apt install mariadb
  2. follow the install instructions for writefreely
  3. run writefreely config start
  4. fill out all neccessary informations
  5. See the result
    2021/01/27 14:56:28 Connecting to mysql database... ERROR: 2021/01/27 14:56:28 database.go:2631: Couldn't SHOW TABLES: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table accesstokens... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table appcontent... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table appmigrations... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table collectionattributes... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table collectionkeys... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table collectionpasswords... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table collectionredirects... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table collections... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table posts... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table remotefollows... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table remoteuserkeys... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table remoteusers... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table userattributes... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table userinvites... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table users... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Creating table usersinvited... ERROR: 2021/01/27 14:56:28 app.go:866: commands out of sync. Did you run multiple statements at once? 2021/01/27 14:56:28 Initializing appmigrations table... ERROR: 2021/01/27 14:56:28 app.go:575: Unable to set initial migrations: commands out of sync. Did you run multiple statements at once?

Expected behavior

Installer should create all tables and finish installation

Application configuration

  • Single mode or Multi-user mode? Multi-user mode
  • Database? [mariadb 10.3]
  • Open registration? [yes]
  • Federation enabled? [yes]

Version or last commit: from compiled package "writefreely_0.12.0_linux_amd64.tar.gz"

@xundeenergie xundeenergie changed the title Install on Debian with MariaDB 10 Install on Debian with MariaDB 10 failes Jan 27, 2021
@cjeller1592
Copy link
Contributor

@cjeller1592 cjeller1592 commented Jan 29, 2021

So I tried to replicate your issue on Debian with Mariadb 10.3 but was able to create all the tables & finish the installation.

It makes me wonder if the issue is with the database setup. Have you tried setting Mariadb up again and trying the install process? I'm curious if this issue occurs again.

@thebaer
Copy link
Contributor

@thebaer thebaer commented Mar 9, 2021

Any update on this, @xundeenergie? Anyone else seeing this issue?

@thebaer thebaer added the bug? label Mar 9, 2021
@thebaer
Copy link
Contributor

@thebaer thebaer commented Apr 7, 2021

Closing this since we can't determine if this is a bug in WriteFreely or not. Please feel free to reopen if you have any other information to add!

@thebaer thebaer closed this Apr 7, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants