XML-RPC and SQLite

carp3 · Post by **carp3** » Mon Jul 21, 2008 5:39 am

Hi,I have tried to post via Gnome-Blog( XML RPC ) but after posting i got this error
Warning: sqlite_query() [function.sqlite-query]: columns host, day, entry_id are not unique in /home/gnudownload/people/pedram/blog/include/db/sqlite.inc.php on line 229

i removed my XML-RPC post but nothing happen..

Whats wrong ?

judebert · Post by **judebert** » Mon Jul 21, 2008 5:59 pm

I'm a Linux user, too. I'd love to see this fixed, even though I don't use XML-RPC myself.

I want to clarify the problem: you tried to post via XML-RPC using Gnome-Blog; it submitted the entry without errors; when you visited your blog, you got the indicated error; when you removed the entry in question, the error didn't go away.

It looks like SQLite isn't autoincrementing the entry IDs. Is this your second post? Can you examine the database directly and verify that there are multiple entries with the same unique_id in the serendipity_entries table?

Post by **garvinhicking** » Tue Jul 22, 2008 10:39 am

Hi!

Hm, the error output rather seems to me as if it stems from the Referrer/Statistics plugin?

Which event/sidebar plugins do you have installed?

Judebert: Autoincrementing of the ID should actually work properly in SQLite, I believe.

Regards,
Garvin

judebert · Post by **judebert** » Tue Jul 22, 2008 7:05 pm

garvinhicking wrote:Hm, the error output rather seems to me as if it stems from the Referrer/Statistics plugin?

How in the world can you tell? I need to learn your diagnostic methods!

garvinhicking wrote:Judebert: Autoincrementing of the ID should actually work properly in SQLite, I believe.

I would hope so! I was just postulating based on the "{fields} are not unique" message, which led me to believe something was wrong with this particular installation, not every SQLite database.

Post by **garvinhicking** » Wed Jul 23, 2008 9:57 am

Hi!

How in the world can you tell? I need to learn your diagnostic methods!

It's simply the "columns host, day, entry_id are not unique" error. I thought about where a "day" column exists, and this only is in the serendipity_referrers DB table, so it must be related to that table/plugin...

Regards,
Garvin

carp3 · Post by **carp3** » Wed Jul 23, 2008 12:05 pm

garvinhicking wrote:Hi!

Hm, the error output rather seems to me as if it stems from the Referrer/Statistics plugin?

Which event/sidebar plugins do you have installed?

Judebert: Autoincrementing of the ID should actually work properly in SQLite, I believe.

Regards,
Garvin

Sidebar:Calendar,search,archive,category,rss,license,Powered by
Event Plugin: Markup: Serendipity , Markup: Emoticate , Markup: NL2BR , Browser Compatibility , Spam Protector , Creative Commons License

Post by **garvinhicking** » Wed Jul 23, 2008 12:10 pm

Hi carp!

Can you check your s9y configuration and see if "Track Referrers" is enabled? Please disable it, if it's enabled, to test if that changes your problem.

Regards,
Garvin

carp3 · Post by **carp3** » Sun Jul 27, 2008 5:11 pm

hmmm i think error_reporting(0); i s better solution