http://hardkap.net/forums/topic/sqlite-data-base-error Macpup, Pritlog, Pritdeals discussion forums en-US Fri, 10 Feb 2012 02:05:21 +0000 http://bbpress.org/?v=1.0.3 q http://hardkap.net/forums/search.php http://hardkap.net/forums/topic/sqlite-data-base-error#post-1494 Sat, 23 Jan 2010 05:21:06 +0000 mastr 1494@http://hardkap.net/forums/ <p>Hi, I've cleared the database, and replaced by the original of pritlog. The weblog now works perfectly. Thank you for the support, we not only know what went wrong. Sorry if if I've bothered with it.</p> <p>Greetings martin struik </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1478 Tue, 19 Jan 2010 12:42:53 +0000 Prit 1478@http://hardkap.net/forums/ <p>The database is in the folder "data&gt;user". The database name is postdb.sqlite. With the sqlite database administration program you must be able to locate the duplicate record and fix it. </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1477 Tue, 19 Jan 2010 12:01:25 +0000 mastr 1477@http://hardkap.net/forums/ <p>I never got this problem before installing pritlog... after a 10 messages i got the error.<br /> I have installed a php based sqlite database administer... but where can i find the data base? </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1470 Mon, 18 Jan 2010 17:12:06 +0000 Prit 1470@http://hardkap.net/forums/ <p>The auto increment should be taken care by the script without any issues. Several folks have used Pritlog for their blogs and I have never heard this problem before. Did you notice any error before this started happening? </p> <p>For administering sqlite database from php, there are some solutions available on the internet. Would recommend to get one of those and try. Providing this functionality is beyond the scope of Pritlog at this point. </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1450 Tue, 12 Jan 2010 10:41:06 +0000 mastr 1450@http://hardkap.net/forums/ <p>Thank you for your reply so quickly, and yes great pictures ha ha :) , i want to put more but wont let me haha....</p> <p>And yes, i wanted to administer the Sqlite Database from pritlog, but i have the idea that it is nog possible.. </p> <p>I ask to much, the thing that is most importend, is to fix the problem now on my blog, and it would be great if it works with a "auto increment", so it is not necessary to send the data base an ID, one mistake and the site shows great errors, hahaha.. joking<br /> I will see your reply soon, and thank you for helping so far.</p> <p>(excuse for my englisch, its not 100% but i hope you can read this well.. ;) )</p> <p>Greetings Martin Struik </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1449 Mon, 11 Jan 2010 20:24:38 +0000 Prit 1449@http://hardkap.net/forums/ <p>I will look into this problem. Will check to see if we can convert this to auto-increment easily without breaking anything else. I took a look at your blog. Good photos. I like that theme too. </p> <p>Did you mean that you wanted to administer the Sqlite database from Pritlog? I am sorry if I did not understand the question correctly. </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1448 Mon, 11 Jan 2010 11:52:25 +0000 mastr 1448@http://hardkap.net/forums/ <p>Ok, I've tried, and the error in the screen was gone, but i could sent a post.. there nothing happends. Maybe i must delete the 'postdb.sqlite' file, and replease the original from Pritlog? than the db is empty, and then i try again?</p> <p>Is it posible to set the database on'auto increment'?<br /> And how can i admin the database from the pritlog working on my site.</p> <p>My pritlog is working on adres:<br /> <a href="http://rubenstruik.nl/Blog/" rel="nofollow">http://rubenstruik.nl/Blog/</a><br /> If u want to try to post a message, i will put the orriginal login and password back.</p> <p>Greetings martin struik from the netherlands, and tanks for helping so far. </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1446 Sun, 10 Jan 2010 21:26:27 +0000 Prit 1446@http://hardkap.net/forums/ <p>The column postid in this table must be a unique value and Pritlog takes care of doing this. But, looks like in your case some action has caused this to have duplicate values. I am not sure if something in Pritlog has caused this error or something else. </p> <p>One easy way to avoid seeing the warning for now is to open index.php in Pritlog and locate the line number 2872 and add an @ before the "sqlite_query" function. </p> http://hardkap.net/forums/topic/sqlite-data-base-error#post-1445 Sun, 10 Jan 2010 10:50:42 +0000 mastr 1445@http://hardkap.net/forums/ <p>hello,<br /> i have a problem.<br /> the blog is working fine, until now, i cant write and send a message without this error:</p> <p>Warning: sqlite_query() [function.sqlite-query]: column postid is not unique in /var/www/g32851/rubenstruik.nl/HTML/Blog/index.php on line 2872</p> <p>Who can tell me wat to do, or what i have doing wrong?</p> <p>Greetings Martin </p>