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

by malcolmputer, Monday, March 18, 2013, 18:03 (4090 days ago)

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

by Carcadons, Tuesday, March 19, 2013, 01:03 (4090 days ago) @ malcolmputer

I have the exact same problem

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

by Tompi, Wednesday, March 20, 2013, 11:38 (4089 days ago) @ malcolmputer

Same problem here. No matter which database-type I choose, I always get the "Internal Server Error - date()...." first and after reload "PDO: Table 'selfoss.tags' doesn't exist".

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

by kofl, Wednesday, March 20, 2013, 13:43 (4089 days ago) @ malcolmputer

Same problem here. Even sqlite database is not working ...

Which versions are you running?

php 5.4.13
httpd-2.2.3-76
php-pecl-sqlite-2.0.0-0.1

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

by malcolmputer, Wednesday, March 20, 2013, 14:04 (4089 days ago) @ kofl

Here are the versions I am running.
Also, further development, when enabling sqlite, I get "driver not found", though I assume that is a server configuration on my end.

PHP 5.3.22-1~dotdeb.0 (fpm-fcgi) (built: Mar 3 2013 00:11:39)
php5-sqlite (5.3.22-1~dotdeb.0)
php5-mysql (5.3.22-1~dotdeb.0)
nginx (1.2.7-1~dotdeb.1)

Let me know if I can give you any more information that would aid in troubleshooting.

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

by malcolmputer, Wednesday, March 20, 2013, 14:17 (4089 days ago) @ malcolmputer

Further update, with respect to the sqlite. It looks like for some reason when selfoss created the sqlite db, it did so with 444 permissions. When I fixed that, and changed to sqlite with the config file, and visit http://url; I get:

PDO: no such table: tags

Which is slightly different than the error received from using mysql.

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

by kofl, Saturday, March 23, 2013, 17:47 (4085 days ago) @ kofl

Okay, got it to work for me so far.

It seems there is a problem with running under php-fpm, adding the timezone to php.ini seems not to work.

I configured the php-fpm config file for that webspace with:

php_value[date.timezone] = "Europe/Vienna"

Then the time zone error went away.

Additionally I switched to Mysql and created the missing table tags as suggested here in the forum.

Maybe the information helps somebody else.

Thoma

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

by radical.edward, Wednesday, March 20, 2013, 17:42 (4088 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

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

by ric, Thursday, March 21, 2013, 11:02 (4088 days ago) @ radical.edward

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 :-D

RSS Feed of thread
powered by my little forum