When i create multiple links to the same URL in an article entry, a postgresql error complaining violation of uniqueness is shown. Only one of the links is being saved (which is not so a big problem)

[...]
Warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique ...

Hi!

I get a SQL error in freetag when previewing an article.
ERROR: syntax error at or near ")" at character 66
STATEMENT: SELECT entryid, tag from serendipity_entrytags WHERE entryid IN () order by entryid, tag

It comes from the query in line 1221 of plugins/serendipity_event_freetag ...

No Problem, i´am always "available" when online.

Kann ich gerne machen. Kannst du dich heute abend über einen Instant Messenger melden, dann richt ich dir alles so ein, wie du es brauchst. Ich glaub, das geht bei direkter Kommunikation besser.

The plugin's versions and order are as written in the post before. No updates in the last time.

During the saving of the article no error occurred. But i found some other SQL errors in the PostgreSQL log but they must happened before the last two update. I will check them if they occur again.

It does complete.
Sitemap Update an www.google.com gemeldet.
• Überprüfe http://www.kernel.org auf mögliche Trackbacks ...
• Trackback gescheitert: Keine Trackback-URI gefunden.
• Überprüfe http://www.s9y.org auf mögliche Trackbacks ...
• Trackback gescheitert: Keine Trackback-URI gefunden.
Der ...

I hope, i don´t bug you, but fixing the constraint problem has not helped getting the exit tracking work. It still keeps creating whose hashed links.
Oh i´ve tested that with the nighty from 2007-05-13.

The problem is rather easy. The value in the type column is NULL by default and it is not set, when a value is inserted which specifies no type. '' (empty string) and NULL are two distinct values. I think mysql does not distinguish these two values.
Replacing "type = ''" with "type IS NULL" works ...

I will check that this evening, need to get to work. i can help you with pgsql and provide you an account on my homeserver if you want. -> ICQ

I put the full sql log of a "save new entry" session at http://evilazrael.net/pg_error.log . I hope this helps you.

Just for curiosity, is it normal that the user information is retrieved multiple times?

Fine. But may i assume that this is a new bug not related to the old one?

addendum :

This is the list from the Pluginmanager. It´s not so reliable as it should be. Untilt recently the exit tracker didn´t show up in it. i had to remove the line from pluginslist in the database in order to reinstall it.

Hi

I get the following error since the Nightly version of 2007-05-03. It happens when saving a new entry. Looks like it uses an generated id multiple times.

Sitemap Update an www.google.com gemeldet.

Warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique ...

i tried it. currently an error reporting a violated constraint is being reported while the entry is still being generated, i was just writing a bug report for that but have been interrupted by the phone. (my nerves are down...)

installed event plugins

Textformatierung: Externe Links zählen ...

Nope, this table is complete empty. The generated links contain only the scrambled url and the entry_id.