search

rotelok / weblabyrinth

Automatically exported from code.google.com/p/weblabyrinth
0 stars 0 forks source link

Weblabryinth sqlite3 issues #3

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. unpack weblabyrinth to /home/whatever/www/weblabyrinth
2. mkdir /home/whatever/webydatabase 
3. cat labyrinth.sql | sqlite3 /home/whatever/webydatabase/labyrinth.db
3. Follow instructions for configuration changes as closely as possible

What is the expected output? What do you see instead?
Expected output: Weblabyrinth output
I see this instead:Uncaught exception 'SQLiteException' with message 
'SQLiteDatabase::__construct() [<a 
href='sqlitedatabase.--construct'>sqlitedatabase.--construct</a>]: file is 
encrypted or is not a database' in 
/home/ihack/public_html/admin/labyrinth.inc.php:48 Stack trace: #0 
/home/ihack/public_html/admin/labyrinth.inc.php(48): 
SQLiteDatabase->__construct('/home/ihack/web...') #1 
/home/ihack/public_html/admin/index.php(43): 
Labyrinth->Labyrinth('168.251.194.24', 'Mozilla/5.0 (Wi...') #2 {main} thrown 
in /home/ihack/public_html/admin/labyrinth.inc.php on line 48

What version of the product are you using? On what operating system?
Latest version of Weblabryinth, running CentOS, PHP5, SQLLite3

Please provide any additional information below.

Original issue reported on code.google.com by hevn...@gmail.com on 24 May 2011 at 3:39

GoogleCodeExporter commented 9 years ago 
Mind you, I'm no PHP guy, but in php5 the pdo sqlite lib should be used.  
Having said that if you are still using the sqlite lib then maybe try 
installing sqlite2 itself? this is what I'm about to try... blech

Original comment by Cummin...@gmail.com on 11 Jul 2011 at 5:05

GoogleCodeExporter commented 9 years ago 
I did try changing the code to use the pdo extension rather than the generic 
sqlite extension.. and it kinda works, but there are query constructors that 
also need to be modified.. and I just don't hve the time to do it.

As to installing sqlite 2 in addition to sqlite 3.. then creating the db with 
sqlite 2, that did the trick.

JJC

Original comment by Cummin...@gmail.com on 11 Jul 2011 at 5:33

GoogleCodeExporter commented 9 years ago 
I wish I had seen this issue a long time ago. I would have commented earlier. I 
forked this repo and changed the code to use PDO. 
(https://bitbucket.org/ethanr/weblabyrinth)

Ben, I would really like to start a dialog about the future of this project and 
its role in ADHD (http://sourceforge.net/projects/adhd)

Original comment by Ethan.Ro...@gmail.com on 18 Feb 2013 at 8:44