Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist

by radical.edward, Wednesday, March 20, 2013, 17:42 (4414 days ago) @ malcolmputer

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