<?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 - Duplicate entry '34482' for key 'PRIMARY'</title>
<link>https://forum.selfoss.aditu.de/</link>
<description>selfoss support forum</description>
<language>en</language>
<item>
<title>Duplicate entry '34482' for key 'PRIMARY' (reply)</title>
<content:encoded><![CDATA[<p>Hi,</p>
<p>In case of someone else got this problem, I found a (brutal) solution:<br />
1) dump your selfoss database: mysqldump -u selfoss_user -p selfoss_database &gt; dump.sql<br />
2) drop your selfoss database (in mysql, root user): drop database selfoss_database<br />
3) recreate your selfoss database (in mysql, root user): create database selfoss_database<br />
4) restore your data: mysql -u root -p selfoss_database &lt; dump.sql</p>
<p>That worked for me, I didn't search further.<br />
jidey</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=1180</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=1180</guid>
<pubDate>Sun, 03 Apr 2016 15:04:30 +0000</pubDate>
<dc:creator>jidey</dc:creator>
</item>
<item>
<title>Duplicate entry '34482' for key 'PRIMARY'</title>
<content:encoded><![CDATA[<p>Hi,</p>
<p>My server had an electric failure and now selfoss do not read new articles anymore. I can see my olds articles.</p>
<p>I launched manually the following command :<br />
root@myserver:/var/www/selfoss# /usr/bin/php5 /var/www/selfoss/update.php<br />
PDOStatement: Duplicate entry '34482' for key 'PRIMARY'</p>
<p>I looked into my mysql database, and the last entry id in the items tables is 34481. I tried to remove this last entry of the items tables :<br />
MariaDB [selfoss]&gt; delete from items where id='34481';<br />
Query OK, 1 row affected (0.03 sec)</p>
<p>I still have the same error &quot;PDOStatement: Duplicate entry '34482' for key 'PRIMARY'&quot;. </p>
<p>Any help would be greatly appreciated.</p>
<p>PS : I'm french, sorry for my English mistakes :)</p>
]]></content:encoded>
<link>https://forum.selfoss.aditu.de/index.php?id=1176</link>
<guid>https://forum.selfoss.aditu.de/index.php?id=1176</guid>
<pubDate>Wed, 23 Mar 2016 16:49:48 +0000</pubDate>
<dc:creator>jidey</dc:creator>
</item>
</channel>
</rss>
