Page 1 of 1

CMSM 1.08 and SQLite

Posted: Tue Jul 10, 2007 1:55 pm
by sirluke
I'm trying to install cmsms on a new QNAP TS-201 NAS, equipped with php and SQLite.
I installed SQLite manager and created the cms.dat db.
I followed the procedure in this thread:
http://forum.cmsmadesimple.org/index.php/topic,7354.0.html
and installed cmsms 1.08.
The install goes fine but opening pages gives me the following warning:

Warning: sqlite_create_function() expects parameter 1 to be resource, null given in /share/MD0_DATA/Qweb/lib/adodb.functions.php on line 76

How can I solve it?
Thanks.

Luca

Re: CMSM 1.08 and SQLite

Posted: Wed Jul 11, 2007 6:23 am
by cyberman
Do you are using AdoDB lite (default) or AdoDB?

Re: CMSM 1.08 and SQLite

Posted: Mon Jul 16, 2007 4:19 pm
by TheSentry
I did the same as SirLuke described above and I ended up with the same error.

Warning: sqlite_create_function() expects parameter 1 to be resource, null given in /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php on line 76

I should mention, that I am using AdoDB full, NOT lite, but I had to copy the AdoDB into the 'adodb_lite' folder to make it work (I deleted the original 'adodb_lite' folder before).
The pages are display fine, but there is always this warning above.

Help would be appreciated ...

Edit:
The admin login page shows this additional warnings:

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/admin/lang.php on line 100

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/admin/login.php on line 164

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/admin/login.php on line 165



Other pages in the admin section show this additional warnings:

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/admin/lang.php on line 100

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/lib/classes/class.admintheme.inc.php on line 161

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/lib/classes/class.admintheme.inc.php on line 164

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/lib/classes/class.admintheme.inc.php on line 167

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/lib/classes/class.admintheme.inc.php on line 168

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/lib/classes/class.admintheme.inc.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at /var/www/cmsmadesimple-1.0.8/lib/adodb.functions.php:76) in /var/www/cmsmadesimple-1.0.8/lib/classes/class.admintheme.inc.php on line 176

Re: CMSM 1.08 and SQLite

Posted: Mon Jul 16, 2007 7:12 pm
by piratos
1. open lib/adodb.functions.php
2. delete  this part/line/  sqlite_create_function .......
3. get the big adodb , lite does not work
4. copy it over the lib/adodb_lite
5. if you install choose instead  of Database host address the full path with the name of your database
  example on xampp windows C:\xampp\xampp\htdocs\cmstest\localhost  --- localhost is the name of the Database you will create
you can take another name C:\xampp\xampp\htdocs\cmstest\mydatabasename
6. Database name, username and password are not in use
7. Install
8. Wait - the last step needs time because of init search

Now Sqlite works and you can be happy.

Bye Bye

Re: CMSM 1.08 and SQLite

Posted: Mon Jul 16, 2007 8:47 pm
by TheSentry
Step 2 did it!
Now, there are no warnings anymore.

Thanks alot!