Author Topic: Error 1f4 using sqlite  (Read 5965 times)

Offline brad97229

  • Newbie
  • *
  • Posts: 2
Error 1f4 using sqlite
« on: January 20, 2007, 04:03:10 PM »
I just downloaded 0.1beta2.2 and "installed" it. I am trying to use sqlite as the database. My db.inc.php file contains the line:
$rcmain_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';

My docroot: /opt/web/htdocs
RoundCube installed: /opt/web/htdocs/RoundCube
The sqlite.db: /opt/web/htdocs/RoundCube/sqlite.db

The sqlite.db was created with 'sqlite -init SQL/sqlite.initial.sql sqlite.db'. The version of sqlite is 2.8.17.

The version of PHP that I'm using is 5.2.0.

I don't know if this is a common problem or I'm just more stupid that most but it would help if the error message gave a little more information about exactly what the problem is. Could it not find the database file? Could it find the database file but not open it? Could it find and open the database file but the schema is invalid?

Any pointers would be appreciated.

Thanks,
Brad

Offline brad97229

  • Newbie
  • *
  • Posts: 2
Re: Error 1f4 using sqlite
« Reply #1 on: January 20, 2007, 05:22:16 PM »
The problem was that I had moved/copied my db.inc.php and main.inc.php files from the config directory to the RoundCube root directory. Once I moved them back everything worked just fine.

One thing to note: the $dsn being passed around to the various database classes was empty/null which should have been checked for and is probably a good indication of a problem.


Thanks,
Brad