Page 1 of 1
sqlite problem
Posted: Fri Jun 01, 2007 11:14 am
by costa
a problem with sqlite
when editing an already posted entry which has some links in it - i got warnings like this:
Code: Select all
Warning: sqlite_query() [function.sqlite-query]: PRIMARY KEY must be unique in /MY_PATH/db/sqlite.inc.php on line 229
bool(false) string(179) "INSERT INTO serendipity_references (id, entry_id, name, link) VALUES(2512, 1016, 'MacRumors.com', 'http://www.macrumors.com/2007/06/01/youtube-for-apple-tv-uses-h-264-not-flash/')"
Re: sqlite problem
Posted: Fri Jun 01, 2007 1:16 pm
by garvinhicking
Hi!
We've had this with postgresql before:
http://board.s9y.org/viewtopic.php?t=9833&highlight=
You are using the most recent snapshot? What is the 'type' column set in those SQLite table in that column?
Regards,
Garvin
Posted: Fri Jun 01, 2007 4:42 pm
by costa
i used this snapshot: s9y_200705252342.tar.gz and most recent additional plugins from that day. as for "types", "columns" and other things i don't understand
- as soon as i come back to home from work, i'll try to figure out how to collect this data. man, that's a hard task...
it does not happen with new entries. it happens only saving edited entries. maybe that would help a little...
Posted: Fri Jun 01, 2007 5:41 pm
by garvinhicking
Hi!
That would be nice.
You'll need something like phpMyAdmin, but for SQLite databases.
Regards,
Garvin
Posted: Fri Jun 01, 2007 7:10 pm
by costa
shell account here and linux on my serwer. so basically i should use sqlite i suppose. ok, i dumped this table, maybe it will be of help to you.
i'm crossing fingers to work this problem out
Posted: Sun Jun 03, 2007 5:08 pm
by costa
just to mention: i upgraded today to latest nightly - the same problem remains.