Serendipity and PostgreSQL - Fixing auto-increment errors

If you – for whatever reason – move your Serendipity installation to another machine or database, you may encounter the following error:

Error: Entries were not successfully inserted!

The reason for this error is a wrong value for the entry counter in the „serendipity_entries” table.

You can verify this very easily. Just connect to the database via „psql -d DATABASENAME” and issue the command SELECT MAX(id) FROM serendipity_entries; and SELECT nextval('serendipity_entries_id_seq');:

demo=# SELECT MAX(id) FROM serendipity_entries;
 max 
-----
 281
(1 Zeile)
 
demo=# SELECT nextval('serendipity_entries_id_seq');
 nextval 
---------
      11
(1 Zeile)

As you can see, the counter value for the next entry (11) is way lower than the actual counter value for the latest entry (281).

So, in order to fix this, we just have to set the counter to a „valid” value SELECT setval('serendipity_entries_id_seq', (SELECT MAX(id) FROM serendipity_entries)+1);:

demo=# SELECT setval('serendipity_entries_id_seq', (SELECT MAX(id) FROM serendipity_entries)+1);
 setval 
--------
    282
(1 Zeile)

So the next entry will get the number 282 and everything will be fine.

Replace „serendipity” with the database prefix you set for your Serendipity installation.

Now, if I would have been able to see the actual database error and not the useless ” Entries were not successfully inserted” text, I would have been able to fix this a lot faster. :(

Tagged as: auto-increment, database, how-to, postgresql, s9, serendipity | Author: Martin Leyrer
[Sonntag, 20121125, 13:59 | permanent link | 0 Kommentar(e)

Links from 2012-11-21

HP takes $8.8 billion writedown on Autonomy

Whitman said Apotheker and Shane Robison, HP’s former head of strategy, are to blame, and she noted that they are both gone. Whitman said that the board – of which she was a part at the time of the purchase – „feels terribly” about missing Autonomy’s accounting fraud. But she said the purchase was thoroughly audited by consulting giant Deloitte, which itself was audited by KPMG – and neither of those companies found anything suspicious about the deal.

Tagged as: delicious, links | Author: Martin Leyrer
[Donnerstag, 20121122, 04:00 | permanent link | 0 Kommentar(e)

Links from 2012-11-11

Process real-time big data with Twitter Storm

Storm is an open source, big-data processing system that differs from other systems in that it’s intended for distributed real-time processing and is language independent. Learn about Twitter Storm, its architecture, and the spectrum of batch and stream processing solutions.

Understand memory leaks in JavaScript applications

Garbage collection can be freeing. It lets us focus on application logic rather than memory management. However, garbage collection is not magic. Understanding how it works, and how it can be tricked into maintaining memory long after it should have been released, results in faster and more reliable applications. In this article, learn about a systematic approach for locating memory leaks in JavaScript applications, several common leaking patterns, and appropriate methods to address those leaks.

Tagged as: delicious, links | Author: Martin Leyrer
[Montag, 20121112, 04:00 | permanent link | 0 Kommentar(e)

This week (some parts nsfw)

Amanda Palmer Stagedive at Arena Vienna 5.11.2012:

Amanda Palmer and Neil Gaiman - „Psycho” (Leon Payne):

Neil Gaiman: „The Day the Saucers Came”

Amanda Palmer & The Grand Theft Orchestra „Do It With a Rockstar”
THE (NSFW) VIDEO… (and if you’re in germany and the embed doesn’t work, USE vimeo):

(trouble with the embed? here it is on youtube, and here it is it is on vimeo)

Tagged as: afp, life, nsfw, video | Author: Martin Leyrer
[Freitag, 20121109, 18:25 | permanent link | 0 Kommentar(e)