search

requarks / wiki

Wiki.js | A modern and powerful wiki app built on Node.js
https://js.wiki
GNU Affero General Public License v3.0
24.33k stars 2.69k forks source link

Unable to run 2.0 dev branch #607

Closed pth0rn closed 5 years ago

pth0rn commented 6 years ago

Pulled the current dev branch and I'm not able to run the server, nor able to run it in dev mode -- receive SQL error (see bottom of post).

Edit:

Made an sqlite3 db file and switched to that, and that runs, however I get this now

2018-08-15T19:27:07.695Z [MASTER] warn: DB Configuration is empty or incomplete. Switching to Setup mode...
2018-08-15T19:27:07.848Z [MASTER] info: Purging old queue jobs: [ OK ]
2018-08-15T19:27:07.849Z [MASTER] info: Starting setup wizard...
2018-08-15T19:27:07.964Z [MASTER] info: HTTP Server on port: [ 3030 ]
2018-08-15T19:27:07.965Z [MASTER] info: HTTP Server: [ RUNNING ]
2018-08-15T19:28:31.469Z [MASTER] error: Failed to lookup view "main/setup" in views directory "/home/p/wikijsdev/wiki/server/views"

mysql Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) node v8.11.3

config.yml

port: 3030

# ---------------------------------------------------------------------
# Data Directories
# ---------------------------------------------------------------------

paths:
  content: ./content
  data: ./data

# ---------------------------------------------------------------------
# Database
# ---------------------------------------------------------------------
# Supported Database Engines:
# - postgres = PostgreSQL 9.5 or later
# - mysql = MySQL 8.0 / MariaDB 10.2.7 or later
# - mssql = MS SQL Server 2012 or later
# - sqlite = SQLite 3.9 or later

db:
  type: mysql
  # PostgreSQL / MySQL / MariaDB / MS SQL Server only:
  host: localhost
  port: 3306
  user: wikijs
  pass: wikijs
  db: wiki
  # SQLite only:
  storage: /home/p/wikijsdev/wiki/database.sqlite

# ---------------------------------------------------------------------
# Redis
# ---------------------------------------------------------------------
# Redis 3.2 or later required

redis:
  host: redis-12926.c9.us-east-1-4.ec2.cloud.redislabs.com
  port: 12926
  db: 0
  password: ******

# ---------------------------------------------------------------------
# Log Level
# ---------------------------------------------------------------------
# Possible values: error, warn, info (default), verbose, debug, silly

logLevel: verbose

Running server

# node wiki start 3030 ✔ Wiki.js has started successfully. # curl localhost:3030

curl: (7) Failed to connect to localhost port 3030: Connection refused

Starting in dev mode

# yarn run dev
yarn run v1.9.4
$ node wiki dev
Webpack: Starting ...
Webpack: Starting ...

  ✔ Compile modules
  ✔ Build modules
  ✔ Optimize modules
  ✔ Emit files

Webpack: Finished after 20.908 seconds.

webpack built 4c7fc550005f3d748a5d in 20913ms
ℹ ｢wdm｣: Hash: 4c7fc550005f3d748a5d
Version: webpack 4.16.5
Time: 20913ms
Built at: 2018-08-15 14:43:53
                              Asset        Size                        Chunks             Chunk Names
      favicons/apple-icon-60x60.png    3.22 KiB                                [emitted]
             svg/login-bg-motif.svg   587 bytes                                [emitted]
                    js/admin-dev.js    34.4 KiB                     admin-dev  [emitted]  admin-dev
                       js/client.js    4.53 MiB                        client  [emitted]  client
                       js/editor.js     109 KiB                        editor  [emitted]  editor
                  js/editor-code.js     137 KiB                   editor-code  [emitted]  editor-code
                        js/icons.js    61.6 KiB                         icons  [emitted]  icons
                      js/profile.js     146 KiB                       profile  [emitted]  profile
                      js/runtime.js    34.1 KiB                       runtime  [emitted]  runtime
                        js/setup.js    90.7 KiB                         setup  [emitted]  setup
                   js/theme-page.js    41.6 KiB                    theme-page  [emitted]  theme-page
                js/vendors~admin.js     482 KiB                 vendors~admin  [emitted]  vendors~admin
            js/vendors~admin-dev.js    3.96 MiB             vendors~admin-dev  [emitted]  vendors~admin-dev
          js/vendors~editor-code.js     487 KiB           vendors~editor-code  [emitted]  vendors~editor-code
                js/vendors~setup.js    51.4 KiB                 vendors~setup  [emitted]  vendors~setup
 js/vendor~admin-dev~editor-code.js     510 KiB  vendor~admin-dev~editor-code  [emitted]  vendor~admin-dev~editor-code
    js/vendor~admin~editor~setup.js     795 KiB     vendor~admin~editor~setup  [emitted]  vendor~admin~editor~setup
               js/voyager.worker.js     2.3 MiB                                [emitted]
                  browserconfig.xml   353 bytes                                [emitted]
  favicons/android-icon-144x144.png    8.82 KiB                                [emitted]
  favicons/android-icon-192x192.png    12.2 KiB                                [emitted]
                        favicon.ico    1.12 KiB                                [emitted]
    favicons/android-icon-36x36.png    2.03 KiB                                [emitted]
    favicons/android-icon-48x48.png    2.64 KiB                                [emitted]
    favicons/android-icon-72x72.png    3.88 KiB                                [emitted]
    favicons/android-icon-96x96.png     5.4 KiB                                [emitted]
    favicons/apple-icon-114x114.png    6.42 KiB                                [emitted]
    favicons/apple-icon-120x120.png    6.92 KiB                                [emitted]
    favicons/apple-icon-144x144.png    8.82 KiB                                [emitted]
    favicons/apple-icon-152x152.png    9.56 KiB                                [emitted]
    favicons/apple-icon-180x180.png    12.2 KiB                                [emitted]
      favicons/apple-icon-57x57.png    3.04 KiB                                [emitted]
                        js/admin.js     984 KiB                         admin  [emitted]  admin
      favicons/apple-icon-72x72.png    3.88 KiB                                [emitted]
      favicons/apple-icon-76x76.png    4.06 KiB                                [emitted]
favicons/apple-icon-precomposed.png    12.8 KiB                                [emitted]
            favicons/apple-icon.png    12.8 KiB                                [emitted]
         favicons/favicon-16x16.png    1.43 KiB                                [emitted]
         favicons/favicon-32x32.png    1.84 KiB                                [emitted]
         favicons/favicon-96x96.png     5.4 KiB                                [emitted]
       favicons/ms-icon-144x144.png    8.82 KiB                                [emitted]
       favicons/ms-icon-150x150.png     9.3 KiB                                [emitted]
       favicons/ms-icon-310x310.png    26.8 KiB                                [emitted]
         favicons/ms-icon-70x70.png    3.78 KiB                                [emitted]
                      manifest.json  1010 bytes                                [emitted]
            svg/auth-icon-auth0.svg   522 bytes                                [emitted]
            svg/auth-icon-azure.svg    1.85 KiB                                [emitted]
          svg/auth-icon-discord.svg    1.49 KiB                                [emitted]
          svg/auth-icon-dropbox.svg   340 bytes                                [emitted]
         svg/auth-icon-facebook.svg   434 bytes                                [emitted]
           svg/auth-icon-github.svg    2.02 KiB                                [emitted]
           svg/auth-icon-google.svg  1020 bytes                                [emitted]
             svg/auth-icon-ldap.svg   626 bytes                                [emitted]
            svg/auth-icon-local.svg   729 bytes                                [emitted]
        svg/auth-icon-microsoft.svg   389 bytes                                [emitted]
           svg/auth-icon-oauth2.svg   242 bytes                                [emitted]
            svg/auth-icon-slack.svg     1.5 KiB                                [emitted]
           svg/auth-icon-twitch.svg   395 bytes                                [emitted]
                  svg/config-bg.svg    1.64 KiB                                [emitted]
                   svg/login-bg.svg    1.54 KiB                                [emitted]
              svg/henry-reading.svg    34.8 KiB                                [emitted]
                   svg/logo-git.svg    2.16 KiB                                [emitted]
                svg/logo-wikijs.svg    15.5 KiB                                [emitted]
         ../server/views/master.pug     1.6 KiB                                [emitted]
Entrypoint client = js/runtime.js js/client.js
[./client/app.js] 7.32 KiB {client} [built]
[./client/helpers/compatibility.js] 249 bytes {client} [built]
[./client/index.js] 278 bytes {client} [built]
[./client/modules/localization.js] 2.13 KiB {client} [built]
[./client/scss/app.scss] 1.54 KiB {client} [built]
[./client/themes/default/js/app.js] 45 bytes {client} [built]
[./client/themes/default/scss/app.scss] 1.62 KiB {client} [built]
[./node_modules/css-loader/index.js!./node_modules/postcss-loader/lib/index.js!./node_modules/sass-loader/lib/loader.js?!./node_modules/sass-resources-loader/lib/loader.js?!./client/scss/app.scss] ./node_modules/css-loader!./node_modules/postcss-loader/lib!./node_modules/sass-loader/lib/loader.js??ref--2-4!./node_modules/sass-resources-loader/lib/loader.js??ref--2-5!./client/scss/app.scss 63.7 KiB {client} [built]
[./node_modules/vuetify/src/stylus/main.styl] 1.22 KiB {client} [built]
[0] multi ./client/index.js webpack-hot-middleware/client 40 bytes {client} [built]
[./node_modules/webpack-hot-middleware/client-overlay.js] (webpack)-hot-middleware/client-overlay.js 2.16 KiB {client} [built]
[./node_modules/webpack-hot-middleware/client.js] (webpack)-hot-middleware/client.js 7.59 KiB {client} [built]
[./node_modules/webpack-hot-middleware/node_modules/strip-ansi/index.js] (webpack)-hot-middleware/node_modules/strip-ansi/index.js 161 bytes {client} [built]
[./node_modules/webpack-hot-middleware/process-update.js] (webpack)-hot-middleware/process-update.js 4.23 KiB {client} [built]
[./node_modules/webpack/buildin/module.js] (webpack)/buildin/module.js 497 bytes {client} [built]
    + 1804 hidden modules
Child html-webpack-plugin for "../server/views/master.pug":
                         Asset     Size  Chunks  Chunk Names
    ../server/views/master.pug  576 KiB       0
    Entrypoint undefined = ../server/views/master.pug
    [./node_modules/html-webpack-plugin/lib/loader.js!./dev/templates/master.pug] 1.76 KiB {0} [built]
    [./node_modules/lodash/lodash.js] 527 KiB {0} [built]
    [./node_modules/webpack/buildin/global.js] (webpack)/buildin/global.js 489 bytes {0} [built]
    [./node_modules/webpack/buildin/module.js] (webpack)/buildin/module.js 497 bytes {0} [built]
ℹ ｢wdm｣: Compiled successfully.
>>> Starting Wiki.js in DEVELOPER mode...
Loading configuration from /home/p/wikijsdev/wiki/config.yml... OK
2018-08-15T18:43:53.380Z [MASTER] info: =======================================
2018-08-15T18:43:53.381Z [MASTER] info: = Wiki.js 2.0.0 =======================
2018-08-15T18:43:53.381Z [MASTER] info: =======================================
Ignoring invalid configuration option passed to Connection: filename. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration options to a Connection
[ { sql: 'select * from information_schema.tables where table_name = ? and table_schema = database()',
    bindings: [ 'migrations' ],
    output: [Function: output] } ]
[ { sql: 'select * from information_schema.tables where table_name = ? and table_schema = database()',
    bindings: [ 'migrations_lock' ],
    output: [Function: output] } ]
{ method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [],
  __knexQueryUid: '34b81c70-037c-4cbc-9a0a-030f0e772fd6',
  sql: 'select * from `migrations_lock`' }
{ method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [],
  __knexQueryUid: '08c3070f-ea44-4788-b76c-ad3054955967',
  sql: 'select `name` from `migrations` order by `id` asc' }
{ method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [],
  __knexQueryUid: 'a7b6092a-d90a-403c-bfd2-87de88dce317',
  sql: 'select * from `migrations_lock` for update' }
{ method: 'update',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [ 1 ],
  __knexQueryUid: '1191beb1-fc24-44f3-9a6f-6b60c8f8f26f',
  sql: 'update `migrations_lock` set `is_locked` = ?' }
[ { sql: 'select * from information_schema.tables where table_name = ? and table_schema = database()',
    bindings: [ 'migrations' ],
    output: [Function: output] } ]
[ { sql: 'select * from information_schema.tables where table_name = ? and table_schema = database()',
    bindings: [ 'migrations_lock' ],
    output: [Function: output] } ]
{ method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [],
  __knexQueryUid: '74019fc8-cddd-42b9-89ef-0b5704d346dc',
  sql: 'select * from `migrations_lock`' }
{ method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [],
  __knexQueryUid: '03e71e0a-e5ea-4532-9b0e-15ebcd6303d2',
  sql: 'select `name` from `migrations` order by `id` asc' }
{ method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [],
  __knexQueryUid: '3aa9e357-ef78-4409-9e5f-456fb7b809dc',
  sql: 'select max(`batch`) as `max_batch` from `migrations`' }
[ { sql: 'create table `assets` (`id` int unsigned not null auto_increment primary key, `filename` varchar(255) not null, `basename` varchar(255) not null, `ext` varchar(255) not null, `kind` enum(\'binary\', \'image\') not null default \'binary\', `mime` varchar(255) not null default \'application/octet-stream\', `fileSize` int unsigned comment \'In kilobytes\', `metadata` undefined, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'create table `assetFolders` (`id` int unsigned not null auto_increment primary key, `name` varchar(255) not null, `slug` varchar(255) not null, `parentId` int unsigned)',
    bindings: [] },
  { sql: 'alter table `assetFolders` add constraint `assetfolders_parentid_foreign` foreign key (`parentId`) references `assetFolders` (`id`)',
    bindings: [] },
  { sql: 'create table `authentication` (`id` int unsigned not null auto_increment primary key, `key` varchar(255) not null, `isEnabled` boolean not null default \'0\', `config` undefined not null, `selfRegistration` boolean not null default \'0\', `domainWhitelist` undefined not null, `autoEnrollGroups` undefined not null)',
    bindings: [] },
  { sql: 'alter table `authentication` add unique `authentication_key_unique`(`key`)',
    bindings: [] },
  { sql: 'create table `comments` (`id` int unsigned not null auto_increment primary key, `content` text not null, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'create table `editors` (`id` int unsigned not null auto_increment primary key, `key` varchar(255) not null, `isEnabled` boolean not null default \'0\', `config` undefined not null)',
    bindings: [] },
  { sql: 'alter table `editors` add unique `editors_key_unique`(`key`)',
    bindings: [] },
  { sql: 'create table `groups` (`id` int unsigned not null auto_increment primary key, `name` varchar(255) not null, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'create table `locales` (`id` int unsigned not null auto_increment primary key, `code` varchar(2) not null, `strings` undefined, `isRTL` boolean not null default \'0\', `name` varchar(255) not null, `nativeName` varchar(255) not null, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'alter table `locales` add unique `locales_code_unique`(`code`)',
    bindings: [] },
  { sql: 'create table `pageHistory` (`id` int unsigned not null auto_increment primary key, `path` varchar(255) not null, `title` varchar(255) not null, `description` varchar(255), `isPrivate` boolean not null default \'0\', `isPublished` boolean not null default \'0\', `publishStartDate` varchar(255), `publishEndDate` varchar(255), `content` text, `contentType` varchar(255) not null, `createdAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'create table `pages` (`id` int unsigned not null auto_increment primary key, `path` varchar(255) not null, `title` varchar(255) not null, `description` varchar(255), `isPrivate` boolean not null default \'0\', `isPublished` boolean not null default \'0\', `publishStartDate` varchar(255), `publishEndDate` varchar(255), `content` text, `render` text, `contentType` varchar(255) not null, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'create table `settings` (`id` int unsigned not null auto_increment primary key, `key` varchar(255) not null, `value` undefined, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'alter table `settings` add unique `settings_key_unique`(`key`)',
    bindings: [] },
  { sql: 'create table `storage` (`id` int unsigned not null auto_increment primary key, `key` varchar(255) not null, `isEnabled` boolean not null default \'0\', `mode` enum(\'sync\', \'push\', \'pull\') not null default \'push\', `config` undefined)',
    bindings: [] },
  { sql: 'alter table `storage` add unique `storage_key_unique`(`key`)',
    bindings: [] },
  { sql: 'create table `tags` (`id` int unsigned not null auto_increment primary key, `tag` varchar(255) not null, `title` varchar(255), `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'alter table `tags` add unique `tags_tag_unique`(`tag`)',
    bindings: [] },
  { sql: 'create table `users` (`id` int unsigned not null auto_increment primary key, `email` varchar(255) not null, `name` varchar(255) not null, `providerId` varchar(255), `password` varchar(255), `tfaIsActive` boolean not null default \'0\', `tfaSecret` varchar(255), `role` enum(\'admin\', \'guest\', \'user\') not null default \'guest\', `jobTitle` varchar(255) default \'\', `location` varchar(255) default \'\', `pictureUrl` varchar(255), `timezone` varchar(255) not null default \'America/New_York\', `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)',
    bindings: [] },
  { sql: 'create table `pageHistoryTags` (`id` int unsigned not null auto_increment primary key, `pageId` int unsigned, `tagId` int unsigned)',
    bindings: [] },
  { sql: 'alter table `pageHistoryTags` add constraint `pagehistorytags_pageid_foreign` foreign key (`pageId`) references `pageHistory` (`id`) on delete CASCADE',
    bindings: [] },
  { sql: 'alter table `pageHistoryTags` add constraint `pagehistorytags_tagid_foreign` foreign key (`tagId`) references `tags` (`id`) on delete CASCADE',
    bindings: [] },
  { sql: 'create table `pageTags` (`id` int unsigned not null auto_increment primary key, `pageId` int unsigned, `tagId` int unsigned)',
    bindings: [] },
  { sql: 'alter table `pageTags` add constraint `pagetags_pageid_foreign` foreign key (`pageId`) references `pages` (`id`) on delete CASCADE',
    bindings: [] },
  { sql: 'alter table `pageTags` add constraint `pagetags_tagid_foreign` foreign key (`tagId`) references `tags` (`id`) on delete CASCADE',
    bindings: [] },
  { sql: 'create table `userGroups` (`id` int unsigned not null auto_increment primary key, `userId` int unsigned, `groupId` int unsigned)',
    bindings: [] },
  { sql: 'alter table `userGroups` add constraint `usergroups_userid_foreign` foreign key (`userId`) references `users` (`id`) on delete CASCADE',
    bindings: [] },
  { sql: 'alter table `userGroups` add constraint `usergroups_groupid_foreign` foreign key (`groupId`) references `groups` (`id`) on delete CASCADE',
    bindings: [] },
  { sql: 'alter table `assets` add `folderId` int unsigned, add `authorId` int unsigned',
    bindings: [] },
  { sql: 'alter table `assets` add constraint `assets_folderid_foreign` foreign key (`folderId`) references `assetFolders` (`id`)',
    bindings: [] },
  { sql: 'alter table `assets` add constraint `assets_authorid_foreign` foreign key (`authorId`) references `users` (`id`)',
    bindings: [] },
  { sql: 'alter table `comments` add `pageId` int unsigned, add `authorId` int unsigned',
    bindings: [] },
  { sql: 'alter table `comments` add constraint `comments_pageid_foreign` foreign key (`pageId`) references `pages` (`id`)',
    bindings: [] },
  { sql: 'alter table `comments` add constraint `comments_authorid_foreign` foreign key (`authorId`) references `users` (`id`)',
    bindings: [] },
  { sql: 'alter table `pageHistory` add `pageId` int unsigned, add `editorKey` varchar(255), add `localeCode` varchar(2), add `authorId` int unsigned',
    bindings: [] },
  { sql: 'alter table `pageHistory` add constraint `pagehistory_pageid_foreign` foreign key (`pageId`) references `pages` (`id`)',
    bindings: [] },
  { sql: 'alter table `pageHistory` add constraint `pagehistory_editorkey_foreign` foreign key (`editorKey`) references `editors` (`key`)',
    bindings: [] },
  { sql: 'alter table `pageHistory` add constraint `pagehistory_localecode_foreign` foreign key (`localeCode`) references `locales` (`code`)',
    bindings: [] },
  { sql: 'alter table `pageHistory` add constraint `pagehistory_authorid_foreign` foreign key (`authorId`) references `users` (`id`)',
    bindings: [] },
  { sql: 'alter table `pages` add `editorKey` varchar(255), add `localeCode` varchar(2), add `authorId` int unsigned, add `creatorId` int unsigned',
    bindings: [] },
  { sql: 'alter table `pages` add constraint `pages_editorkey_foreign` foreign key (`editorKey`) references `editors` (`key`)',
    bindings: [] },
  { sql: 'alter table `pages` add constraint `pages_localecode_foreign` foreign key (`localeCode`) references `locales` (`code`)',
    bindings: [] },
  { sql: 'alter table `pages` add constraint `pages_authorid_foreign` foreign key (`authorId`) references `users` (`id`)',
    bindings: [] },
  { sql: 'alter table `pages` add constraint `pages_creatorid_foreign` foreign key (`creatorId`) references `users` (`id`)',
    bindings: [] },
  { sql: 'alter table `users` add `providerKey` varchar(255) not null default \'local\', add `localeCode` varchar(2) not null default \'en\', add `defaultEditor` varchar(255) not null default \'markdown\'',
    bindings: [] },
  { sql: 'alter table `users` add constraint `users_providerkey_foreign` foreign key (`providerKey`) references `authentication` (`key`)',
    bindings: [] },
  { sql: 'alter table `users` add constraint `users_localecode_foreign` foreign key (`localeCode`) references `locales` (`code`)',
    bindings: [] },
  { sql: 'alter table `users` add constraint `users_defaulteditor_foreign` foreign key (`defaultEditor`) references `editors` (`key`)',
    bindings: [] },
  { sql: 'alter table `users` add unique `users_providerkey_email_unique`(`providerKey`, `email`)',
    bindings: [] } ]
migration file "2.0.0.js" failed
migration failed with error: create table `assets` (`id` int unsigned not null auto_increment primary key, `filename` varchar(255) not null, `basename` varchar(255) not null, `ext` varchar(255) not null, `kind` enum('binary', 'image') not null default 'binary', `mime` varchar(255) not null default 'application/octet-stream', `fileSize` int unsigned comment 'In kilobytes', `metadata` undefined, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'undefined, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)' at line 1
{ method: 'update',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [ 0 ],
  __knexQueryUid: 'fed41dcc-7091-40f8-aa7d-11bc5e3be94d',
  sql: 'update `migrations_lock` set `is_locked` = ?' }
2018-08-15T18:43:53.733Z [MASTER] info: Redis connection: [ OK ]
2018-08-15T18:43:53.766Z [MASTER] error: create table `assets` (`id` int unsigned not null auto_increment primary key, `filename` varchar(255) not null, `basename` varchar(255) not null, `ext` varchar(255) not null, `kind` enum('binary', 'image') not null default 'binary', `mime` varchar(255) not null default 'application/octet-stream', `fileSize` int unsigned comment 'In kilobytes', `metadata` undefined, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'undefined, `createdAt` varchar(255) not null, `updatedAt` varchar(255) not null)' at line 1
error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

Error

migration failed with error: create table assets (id int unsigned not null auto_increment primary key, filename varchar(255) not null, basename varchar(255) not null, ext varchar(255) not null, kind enum('binary', 'image') not null default 'binary', mime varchar(255) not null default 'application/octet-stream', fileSize int unsigned comment 'In kilobytes', metadata undefined, createdAt varchar(255) not null, updatedAt varchar(255) not null) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'undefined, createdAt varchar(255) not null, updatedAt varchar(255) not null)' at line 1

pth0rn commented 6 years ago

After switching to sqlite, and changing line 73 in setup.js from res.render('main/setup', { to tores.render('setup', { to fix the view not found error. Now I can't login with the account I made during the setup, I get the error Invalid authentication provider.

dev log shows this

2018-08-15T22:50:18.413Z [MASTER] error: Failed to scan or load new authentication providers: [ FAILED ] 2018-08-15T22:50:18.413Z [MASTER] error: batch insert only works with Postgresql

NGPixel commented 6 years ago

Pull the latest changes, it should be fixed now. Tested both MySQL and SQLite.

Note that MySQL 8 will throw an error if you're using the default caching_sha2_password. Either use MySQL 5.7 or make sure to create users using the old authentication method for now. This is a bug in the mysql2 connector.

pth0rn commented 6 years ago

Thanks, Got it up and running still using sqlite. I'm not able to create the home page though GraphQL error: Cannot read property 'add' of undefined

Edit: due to WIKI.queue.job.renderPage in models/pages.js line 137 not being defined. Is this just something that's unfinished in the alphas current state?