search

Yushe / myimouto-plus

A Moebooru port to PHP, you should probably just use moebooru as this isn't supported or worked on.
MIT License
15 stars 14 forks source link

Breaks on new MySQL implementations #10

Open tecknojock opened 6 years ago

tecknojock commented 6 years ago

By default MySQL 5.7 adds the mode "STRICT_TRANS_TABLES" and because the tables in mysql are not setup with default values, and because not everything is provided when creating a new record all the time, various things around the site will break if you leave this setting on, such as adding tags.

I propose adding default values to the various columns on the DB tables, such as 'group_by_id' 'remote_id' and any others that aren't always created.

Windows98FE commented 5 years ago

This repo is dead according to the repo creator. Feel free to fork it if you want and make those changes.

I'll test on PHP 7.3 and MariaDB 10.1 on Debian soon, in case this issue persists (I want to run a Touhou imageboard soon)...

sayyidyofa commented 5 years ago

@Windows98FE please kindly reply to my comment if you have successfully implemented your imageboard, i have been trying for days to install myimouto on my server.

I followed all the steps, but the webpage on my browser shows nothing but a blank page, the icon still appear though.

I have no experiences on MySQL, PHP or Ruby on Rails but i want to run an imageboard

Windows98FE commented 5 years ago

what webserver are you using @sayyidyofa (in this particular case you might find it wise to use nginx so that you can specifically set php 7.0 or 7.1 for this project)

also, I forgot how I got it to work, composer is a pain. it will work on mariadb 10.1, haven't tested anything newer, and php must be below 7.2 or won't work

and also, the webroot must be set to one of the subdirs (I forgot which)

querwurzel commented 5 years ago

Hey guys, I'm running myimouto on PHP 7.3.1 and MySQL 5.7 .. I'll have a look into the default values. Installed the board on MySQL 5.5 and migrated to 5.7 by dumping .. so no reinstallation. get back to you soon.

€dit: got installation to run, have to sort and cleanup things .. stay tuned

€dit2: Please have a try https://github.com/querwurzelt/myimouto-plus

UiharuKazari2008 commented 4 years ago

In the coming weeks ill be implementing the new SQL statements to hopefully account for this issue as well as publish a guide for BSD installs

I have been maintaining my port sense the deletion of the source, its out of date at this exact moment but ill be pushing updates sense I have a need for it again. and Ubuntu 14.04 is dead https://code.acr.moe/kazari/sequenzia