<?xml version="1.0" encoding="utf-8"?><rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>selfoss support forum - Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist</title>
<link>https://forum.selfoss.aditu.de/</link>
<description>selfoss support forum</description>
<language>en</language>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>Okay, got it to work for me so far.</p>
<p>It seems there is a problem with running under php-fpm, adding the timezone to php.ini seems not to work.</p>
<p>I configured the php-fpm config file for that webspace with:</p>
<p>php_value[date.timezone] = &quot;Europe/Vienna&quot;</p>
<p>Then the time zone error went away.</p>
<p>Additionally I switched to Mysql and created the missing table tags as suggested here in the forum.</p>
<p>Maybe the information helps somebody else.</p>
<p>Thoma</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=215</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=215</guid>
<pubDate>Sat, 23 Mar 2013 16:47:50 +0000</pubDate>
<dc:creator>kofl</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>i actually had the same problem.<br />
after manually creating the table tags in mysql, selfoss stopped with the same timezone message.</p>
<p>changing the line<br />
<strong>date_default_timezone_set($val);</strong><br />
to<br />
<strong>date_default_timezone_set(&quot;Europe/Berlin&quot;);</strong><br />
removed the message, but selfoss stopped with a blank page.</p>
<p>however, going back to the original code and adding the line<br />
<strong>date.timezone = &quot;Europe/Berlin&quot;;</strong><br />
to the php.ini did it!</p>
<p>so selfoss seems to work for me for now <img src="https://forum.selfoss.aditu.de/images/smilies/biggrin.png" alt=":-D" /></p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=188</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=188</guid>
<pubDate>Thu, 21 Mar 2013 10:02:20 +0000</pubDate>
<dc:creator>ric</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<blockquote><p>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). </p>
<p>When I visit the virtual host I have set up in nginx, I get:</p>
<p>Internal Server Error</p>
<p>PDO: Table 'selfoss.tags' doesn't exist</p>
<p>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.</p>
</blockquote><p>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</p>
<p>mysql&gt;  CREATE TABLE tags (tag TEXT NOT NULL, color VARCHAR(7) NOT NULL) DEFAULT CHARSET=utf8;</p>
<p>Afterwards I also got the same date error. Even after changing libs/f3/base.php <br />
 221             case 'TZ':<br />
 222                 /* date_default_timezone_set($val); */<br />
 223                 date.timezone = &quot;Europe/Berlin&quot;;<br />
 224                 break;</p>
<blockquote><p><br />
Also, possibly part of the same issue, when I visit <a href="http://url/update">http://url/update</a> I get:</p>
<p>Internal Server Error</p>
<p>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</p>
</blockquote>]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=181</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=181</guid>
<pubDate>Wed, 20 Mar 2013 16:42:00 +0000</pubDate>
<dc:creator>radical.edward</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>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 <a href="http://url;">http://url;</a> I get:</p>
<p>PDO: no such table: tags</p>
<p>Which is slightly different than the error received from using mysql.</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=177</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=177</guid>
<pubDate>Wed, 20 Mar 2013 13:17:36 +0000</pubDate>
<dc:creator>malcolmputer</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>Here are the versions I am running. <br />
Also, further development, when enabling sqlite, I get &quot;driver not found&quot;, though I assume that is a server configuration on my end.</p>
<p>PHP 5.3.22-1~dotdeb.0 (fpm-fcgi) (built: Mar  3 2013 00:11:39)<br />
php5-sqlite (5.3.22-1~dotdeb.0)<br />
php5-mysql (5.3.22-1~dotdeb.0)<br />
nginx (1.2.7-1~dotdeb.1)</p>
<p>Let me know if I can give you any more information that would aid in troubleshooting.</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=176</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=176</guid>
<pubDate>Wed, 20 Mar 2013 13:04:20 +0000</pubDate>
<dc:creator>malcolmputer</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>Same problem here. Even sqlite database is not working ...</p>
<p>Which versions are you running?</p>
<p>php 5.4.13<br />
httpd-2.2.3-76<br />
php-pecl-sqlite-2.0.0-0.1</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=173</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=173</guid>
<pubDate>Wed, 20 Mar 2013 12:43:59 +0000</pubDate>
<dc:creator>kofl</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>Same problem here. No matter which database-type I choose, I always get the &quot;Internal Server Error - date()....&quot; first and after reload &quot;PDO: Table 'selfoss.tags' doesn't exist&quot;.</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=171</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=171</guid>
<pubDate>Wed, 20 Mar 2013 10:38:32 +0000</pubDate>
<dc:creator>Tompi</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist (reply)</title>
<content:encoded><![CDATA[<p>I have the exact same problem</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=142</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=142</guid>
<pubDate>Tue, 19 Mar 2013 00:03:20 +0000</pubDate>
<dc:creator>Carcadons</dc:creator>
</item>
<item>
<title>Troubleshooting: PDO: Table 'selfoss.tags' doesn't exist</title>
<content:encoded><![CDATA[<p>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). </p>
<p>When I visit the virtual host I have set up in nginx, I get:</p>
<p>Internal Server Error</p>
<p>PDO: Table 'selfoss.tags' doesn't exist</p>
<p>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.</p>
<p>Also, possibly part of the same issue, when I visit <a href="http://url/update">http://url/update</a> I get:</p>
<p>Internal Server Error</p>
<p>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</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=126</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=126</guid>
<pubDate>Mon, 18 Mar 2013 17:03:25 +0000</pubDate>
<dc:creator>malcolmputer</dc:creator>
</item>
</channel>
</rss>
