sqlite problem

Found a bug? Tell us!!
Post Reply
costa
Regular
Posts: 110
Joined: Wed Feb 08, 2006 5:29 pm
Location: Poland
Contact:

sqlite problem

Post 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/')"
"everything is under control" - kasparov demo
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: sqlite problem

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
costa
Regular
Posts: 110
Joined: Wed Feb 08, 2006 5:29 pm
Location: Poland
Contact:

Post 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...
"everything is under control" - kasparov demo
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

That would be nice. :) You'll need something like phpMyAdmin, but for SQLite databases. :-)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
costa
Regular
Posts: 110
Joined: Wed Feb 08, 2006 5:29 pm
Location: Poland
Contact:

Post 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 :)
"everything is under control" - kasparov demo
costa
Regular
Posts: 110
Joined: Wed Feb 08, 2006 5:29 pm
Location: Poland
Contact:

Post by costa »

just to mention: i upgraded today to latest nightly - the same problem remains.
"everything is under control" - kasparov demo
Post Reply