installation error.

paktua

i already at installation page, afetr enter the name, database credentials, and administrator credentials, then click on the installation button. I get the error

Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'notifications_read_time' (SQL: ALTER TABLE bli_users CHANGE notification_read_time notifications_read_time DATETIME DEFAULT 'NULL')

try to drop and make a new db, the error still persist.

i've read jason post here: https://discuss.flarum.org/d/7461-mariadb-error-on-new-installation

but seem no solution. please help. thank you

--
update. i checked the database. there are some tabels, and if i try keep click the installation button, the error become like this

Something went wrong: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'bli_migrations' already exists (SQL: create table bli_migrations (migration varchar(255) not null, extension varchar(255) null) default character set utf8mb4 collate utf8mb4_unicode_ci)

try to drop and make a new db, the error become like the first one above

datitisev

paktua What version of MariaDB & PHP are you using?

paktua

datitisev i'm using PHP 5.6 (ea-php56) and mysql

datitisev

paktua Hm, if you are using MySQL, then that shouldn't be an issue... what version of MySQL?

paktua

datitisev i'm sorry, just check my database. i'm using mariaDB

Server type: MariaDB
Server version: 10.2.17-MariaDB-cll-lve - MariaDB Server

datitisev

paktua Try this workaround.

paktua

datitisev will try. Thanks!

paktua

datitisev em.. can't found the file. i'm using a shared hosting.

any sugesstion?

datitisev

paktua Where did you look for it? That path should be found in the Flarum installation, i.e. <forum>/vendor/....

paktua

datitisev ah.. i'm soryy,. super newbie.

i edited the file. make new db. assign as flarum db. no error. but i cant open the site. it's always get
Connection Timed Out

the url is: http://blisaham.com , any suggestion?

datitisev

paktua Did it work fine before installation? Or did it break after?

Turn on debug mode & look at php & web server logs.

paktua

datitisev

this some of error logs at flarum folder

[30-Sep-2018 15:43:19 UTC] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0
[30-Sep-2018 15:44:00 UTC] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0
[30-Sep-2018 15:45:49 UTC] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0
[30-Sep-2018 15:45:50 UTC] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0
[30-Sep-2018 15:55:32 UTC] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0
[30-Sep-2018 15:55:51 UTC] PHP Fatal error: Cannot destroy active lambda function in [no active file] on line 0

paktua

datitisev

these are from php logs

[paktuaid@iix60 log]$ php --info | grep error
display_errors => Off => Off
display_startup_errors => Off => Off
error_append_string => no value => no value
error_log => error_log => error_log
error_prepend_string => no value => no value
error_reporting => 32767 => 32767
html_errors => Off => Off
ignore_repeated_errors => Off => Off
log_errors => On => On
log_errors_max_len => 1024 => 1024
track_errors => Off => Off
xmlrpc_error_number => 0 => 0
xmlrpc_errors => Off => Off
PHP Warning: Unknown: It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in Unknown on line 0
intl.error_level => 0 => 0
opcache.error_log => no value => no value
zend_optimizerplus.error_log => no value => no value

datitisev

paktua Hm, not sure about that, sorry. Hopefully someone else can help you with that.

paktua

datitisev

i edited back the workround back to original. the conecction time out error still exist.

paktua

datitisev

hi. just little info. i update my php to 7.2 and the web seems working, but not perfect. please visit

http://blisaham.com/index.php

"Something went wrong while trying to load the full version of this site"

if you have any suggestion, i really appreciate it. thankyou

datitisev

paktua I don't think php 7.2 is fully supported. But here's the issue: you need to update config.php url property and remove the index.php from it.

You may want to set an internal redirect in your webserver from /* to index.php as well.

[deleted]

paktua I suggest downgrading to php 7.1 as flarum doesn’t currently support php 7.2 so you will run into issues.

paktua

datitisev i removed the index.php and it's working now

and about set an internal redirect in webserver from /* to index.php.
can you give me a guide.

thanks

datitisev

paktua It depends on the web server that you are using.

Nginx:

location / { try_files $uri $uri/ /index.php?$query_string; }

Apache:

url.rewrite-if-not-file = (
    "/admin.*" => "/admin.php",
    "/api.*"   => "/api.php",
    "/.*"      => "/index.php"
)

paktua

[deleted] i got HTTP 500 error if using 7.1, already got an issue. cant login, the debug says 'null'.

paktua

datitisev

all seems working now. thank you very much for your help.