Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist
I have unzipped selfoss, set up nginx using the suggested config, used phpmyadmin to set up the user and tables (and to test my PHP/MYSQL set ups).
When I visit the virtual host I have set up in nginx, I get:
Internal Server Error
PDO: Table 'selfoss.tags' doesn't exist
Any ideas? When I look at the tables in mysql, I see that selfoss has created three tables, so it would seem that permissions/configuration are correct.
Also, possibly part of the same issue, when I visit http://url/update I get:
Internal Server Error
date(): 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 'Europe/Moscow' for 'MSK/4.0/no DST' instead
Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist
I have unzipped selfoss, set up nginx using the suggested config, used phpmyadmin to set up the user and tables (and to test my PHP/MYSQL set ups).
When I visit the virtual host I have set up in nginx, I get:
Internal Server Error
PDO: Table 'selfoss.tags' doesn't exist
Any ideas? When I look at the tables in mysql, I see that selfoss has created three tables, so it would seem that permissions/configuration are correct.
As I have found in /daos/mysql/Database.php (https://github.com/SSilence/selfoss/blob/master/daos/mysql/Database.php), I run manualy in the mysql-client
mysql> CREATE TABLE tags (tag TEXT NOT NULL, color VARCHAR(7) NOT NULL) DEFAULT CHARSET=utf8;
Afterwards I also got the same date error. Even after changing libs/f3/base.php
221 case 'TZ':
222 /* date_default_timezone_set($val); */
223 date.timezone = "Europe/Berlin";
224 break;
Also, possibly part of the same issue, when I visit http://url/update I get:Internal Server Error
date(): 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 'Europe/Moscow' for 'MSK/4.0/no DST' instead
Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist
i actually had the same problem.
after manually creating the table tags in mysql, selfoss stopped with the same timezone message.
changing the line
date_default_timezone_set($val);
to
date_default_timezone_set("Europe/Berlin");
removed the message, but selfoss stopped with a blank page.
however, going back to the original code and adding the line
date.timezone = "Europe/Berlin";
to the php.ini did it!
so selfoss seems to work for me for now 