CMSM 1.08 and SQLite

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
sirluke
Forum Members
Forum Members
Posts: 15
Joined: Tue Jul 10, 2007 1:49 pm

CMSM 1.08 and SQLite

Post 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
cyberman

Re: CMSM 1.08 and SQLite

Post by cyberman »

Do you are using AdoDB lite (default) or AdoDB?
TheSentry

Re: CMSM 1.08 and SQLite

Post 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
Last edited by TheSentry on Mon Jul 16, 2007 5:05 pm, edited 1 time in total.
piratos

Re: CMSM 1.08 and SQLite

Post 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
TheSentry

Re: CMSM 1.08 and SQLite

Post by TheSentry »

Step 2 did it!
Now, there are no warnings anymore.

Thanks alot!
Locked

Return to “[locked] Installation, Setup and Upgrade”