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!