categories Plugin shows 2 entries (there is only one)

[Lars Heppert]

Hey,

I just tryed out Serendipity and probably found one minor bug. By the way I like it a lot and will get the book as well

How to reproduce it?
1. I created several categories (two are enough to see the bug).
2. I created an entry in some category. (for testing one in each of two total)
3. I was looking at the blog and choosing one category.

-> 2 entries were shown - the second is empty.
-> actually this bug disappears for more the exactly one entry
-> the second entry holds the current time
(looks like an empty set gets printed)

I know it looks like perfectionism,
but I like to know that everything is just fine
(I realy like it - if there is any need for more developers, I could help out.)

My Blog is located under: www.rabotten.com

Thanks in advance and
Kind Regards
Lars

[garvinhicking]

Hi!

Thanks for reporting this. Actually, I've never seen such a bug before!

It is not related to the sidebar categories plugin though, that one only displays categories. There seems to be another bug. It could either be template related, or event-plugin related or even related to you rdatabase.

Which database are you using? To me it seems as if the resultset contains another empty entry. Maybe even there's a PHP bug, which PHP version are you using?

Also you could temporarily try to change your template and see if that makes a difference. Also if you could name which event plugins you are using, that might lead me right on track.

(I realy like it - if there is any need for more developers, I could help out.)

Developers are ALWAYS wanted!

We actually even have some kind of wishlist if new people want to get involved: http://www.s9y.org/238.html and http://sourceforge.net/tracker/?group_i ... tid=542825.

But also of course, anything is wanted that people might want to improve or contribute.

Best regards,
Garvin

[Lars Heppert]

Thanks for your fast reply

I tried out several templates - its not related to any template.

Everything is just like it comes - no additional event plugins.

I use the sqlite version with php 4.x - but could change this to mysql and php 5.x

If you like I could just give you access to the admin part or even the ftp-server.

By the way - I changed the location to: my-thinktank.com

Is it possible to open the sqlite db with the regarding sqlite explorer?
(I tried it, but it did not work with the password / md5(password) -> even so it looks like it would be hashed in something 32 bytes long like md5)

Thanks and
Kind Regards
Lars

[garvinhicking]

Hi!

I bet this is an SQLite oddity.

How are you using SQLite with PHP4? Did you compile that as a PECL extension? Did you make sure to use a recent SQLite one? I guess it could be an outdated sqlite extension.

MySQL would definitely be a safer choice to go with when you're not on PHP5. But you cannot easily convert from sqlite to mysql, usually you have to create a new installation, or you need a utuility to convert the .db file to MySQL.

If you like I could just give you access to the admin part or even the ftp-server.

sure, I could try to have a look at it! I'm quite sure the serendipity_fetchEntries() function is returning a strange PHP array.

Is it possible to open the sqlite db with the regarding sqlite explorer?
(I tried it, but it did not work with the password / md5(password) -> even so it looks like it would be hashed in something 32 bytes long like md5)

The s9y .db file can be read by any SQLite tool. There is no password encryption on SQLite files! That's why s9y names the file with a random string, so that it cannot easily be guessed.

Regards,
Garvin

[Lars Heppert]

Hey,

I will just switch to mysql
(everything works fine with it - so its some issue regarding sqlite)


Thanks
Lars