Hi, the table "serendipity_referrers" contains all referrers which ever visited a blog. During performance analysis of my blog i found out, that the runtime for this query: SELECT scheme, host, SUM(count) AS total FROM serendipity_referrers GROUP BY scheme, host ORDER BY total DESC, host L...

Hello, i get the following error in my database logfile: 2010-03-28 15:14:39 CEST ERROR: function unix_timestamp(timestamp with time zone) does not exist at character 199 2010-03-28 15:14:39 CEST HINT: No function matches the given name and argument types. You may need to add explicit type casts. 20...

Oh, got 0.44 now. The warnings are still there.

I'l try to debug this later, CeBIt keeps me busy right now.

Version 3.10.4 is installed here. Should there be a newer version?

Ok, the SQL bug is gone. There is still the PHP warning: Warning: Invalid argument supplied for foreach() in /www/blog/plugins/serendipity_event_microformats/serendipity_event_microformats.php on line 137 Warning: Invalid argument supplied for foreach() in /www/blog/plugins/serendipity_event_microfo...

Ah, fine

I will wait for the module update and then check again if the php warnings are gone.


Andreas

I moved away the "freetag" directory and added some debugging code. From what i can see, this happens if i press the "preview" button:

Both contain the array checks which garvin posted earlier in this thread.
I don't know which one get's used - and/or if the other one get's used if i remove one.

Which one is the official one?

First of all, before i try to debug and add your code: I found two serendipity_event_freetag.php files: ./plugins/freetag/serendipity_event_freetag.php ./plugins/serendipity_event_freetag/serendipity_event_freetag.php The first one is: $Id: serendipity_event_freetag.php,v 1.124 2008/12/10 10:34:52 l...

Yes, plugins are up to date, according to spartacus (i wrote this script which checks regularly for plugin updates). For what code should i look to find out, if the changes you mentioned are applied to my plugins? Note that the database in question is PostgreSQL and the "()" really looks l...

Hi, i'm using the freetag plugin and can see the following error in my database log: 2010-02-24 13:27:08 CET ERROR: syntax error at or near ")" at character 66 2010-02-24 13:27:08 CET STATEMENT: SELECT entryid, tag from serendipity_entrytags WHERE entryid IN () order by entryid, tag In add...

dsp_syntaxhighlight is not an option because it requires Javascript.

But Geshi did the job.


Thank you

So, nobody ever posted Latex sourcecode in his blog?

Hello, i want to post some code examples in my blog and use the [code] tag. Now the example is latex source and each \t< more text> get's expanded to a tab + <more text>. I tried \\ but it get's expanded to a \ and the following 't' still expands to the tab. How can i avoid this and post code exampl...

The plugin "Last Google search" has a problem with PostgreSQL as database backend. The functions query_references() and query_visitors() build a query like: where (0 or (host like '%.google.%' and path like '/search')) First: i don't know why there is the "0 or" at all, because t...