Page 1 of 1
XML-RPC and SQLite
Posted: Mon Jul 21, 2008 5:39 am
by carp3
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 ?
Posted: Mon Jul 21, 2008 5:59 pm
by judebert
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?
Posted: Tue Jul 22, 2008 10:39 am
by garvinhicking
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
Posted: Tue Jul 22, 2008 7:05 pm
by judebert
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.
Posted: Wed Jul 23, 2008 9:57 am
by garvinhicking
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
Posted: Wed Jul 23, 2008 12:05 pm
by carp3
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
Posted: Wed Jul 23, 2008 12:10 pm
by garvinhicking
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
Posted: Sun Jul 27, 2008 5:11 pm
by carp3
hmmm i think error_reporting(0); i s better solution
