Comments (5)
As CentOS still ships MariaDB 5.5, some users might still have an issue initializing schema.sql.
For the reference, here is what would
./writefreely --init-db
return:
2019/03/02 02:14:49 Loading config.ini configuration...
2019/03/02 02:14:49 Connecting to mysql database...
2019/03/02 02:14:49 Creating table accesstokens...
ERROR: 2019/03/02 02:14:49 log.go:26: Error 1067: Invalid default value for 'created'
2019/03/02 02:14:49 Creating table appcontent...
ERROR: 2019/03/02 02:14:49 log.go:26: Error 1067: Invalid default value for 'updated'
2019/03/02 02:14:49 Creating table appmigrations...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table collectionattributes...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table collectionkeys...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table collectionpasswords...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table collectionredirects...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table collections...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table posts...
ERROR: 2019/03/02 02:14:49 log.go:26: Error 1293: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
2019/03/02 02:14:49 Creating table remotefollows...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table remoteuserkeys...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table remoteusers...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table userattributes...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table userinvites...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Creating table users...
ERROR: 2019/03/02 02:14:49 log.go:26: Error 1067: Invalid default value for 'created'
2019/03/02 02:14:49 Creating table usersinvited...
2019/03/02 02:14:49 Created.
2019/03/02 02:14:49 Updating appmigrations table...
2019/03/02 02:14:49 Done.
In my initial installation on fedi.dev I have modified tables accesstokens, appcontent, posts and users to match MariaDB 5.5 requirements, but probably it makes no sense request them pulled as newer MariaDB/MySQL versions doesn't need any modifications to original schema.sql.
I can confirm that with MariaDB 10.x there are no issues - tables gets created successfully.
from writefreely.
Great catch, thanks. I'll update the docs.
I know some people are using MariaDB, but I'm not sure what the minimum version would be to support this. Does anyone else know?
from writefreely.
Updated the site. Closing this now, and I'll update with MariaDB information if we figure that out.
from writefreely.
This note appears to have been removed. There's no mention of it on the site, or in the readme. I ran into this issue as CentOS 7 uses MariaDB 5.5 as the default MySQL implementation, so it still seems noteworthy to me. Consider pointing the user here.
from writefreely.
Added it back on that page again -- thanks for the reminder!
from writefreely.
Related Issues (20)
- wrong date on subscribers page HOT 4
- Version not available in Docker image HOT 1
- Font toggle isn't working in classics editor HOT 2
- Post attributed to non-existent collection
- RSS doesn't maintain formatting HOT 1
- Error setting up GotoSocial as OAuth provider: unable to exchange code for access token
- Server down error HOT 1
- Complaint: Unable to sign-up HOT 2
- View with the list of drafts doesn't render the markdown correctly HOT 6
- Unable to register "Server Error" HOT 1
- Viewing Customize -page causes error HOT 1
- mv-24
- Docker image for production
- The types of extractable image are very limited
- This page contains the following errors: error on line 1 at column 1: Start tag expected, '<' not found Below is a rendering of the page up to the first error.
- Errors when setting up Email newsletter HOT 2
- support work over proxy HTTP/HTTPS/SOCKS
- No spacing between different paragraphs
- i need account postheaven HOT 1
- Limited post size on MySQL backend
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from writefreely.