Ok, so I installed the latest under SQLite, then moved it to another server. I am CONFIDENT I have all the paths right, but when I go to the index, all it outputs is "not an error<br />"
What causes this? I searched all the the files for the string "not an error" but nothing came up?
Have you ran repair_settings.php?
I'll have a test of this myself i think.
That is the sqlite call, I believe. It is apparently caused when you tell sqlite to do stuff with a file that sqlite does not understand, or does not exist.
Or, at least, that is what google said.
Check your sqlite file permissions and paths and try again?
The database is 777. I tried exporting the database and reimporting it to another file with SQLiteManager and switching to that database, to make sure its read/writable.
As for the paths, they are fine -
QuoteiMac:~ Dave$ ssh [email protected]
[email protected]'s password:
Permission denied, please try again.
[email protected]'s password:
Last login: Tue Mar 18 16:40:33 2008 from 10.0.1.90
# cd /var/root/Media/WebServer/Documents/smf
# cd /var/root/Media/WebServer/Documents/smf/Sources
# cd /var/root/Media/WebServer/Documents/smf/cache
# cd /thisDoesntExistButIsAnErrorExample
cd: no such file or directory: /thisDoesntExistButIsAnErrorExample
#
As for repair_settings.php, I do not seem to have that.
Personally, I wouldn't recommend using Sqlite for anything other than very small forums.
If you can use mysql or postgresql you should use that instead.
Eg it might be possible to get away with it for a small intranet site.
Well its not really intended for use, just for checking it out..
Where do you have the .db file and what is the value for $db_name in the Settings.php file?
Its in the root smf directory, file is smfnew.db, and the settings file has
$db_name = 'smfnew.db';
Try setting the full path to the file. /public_html/smf/smfnew.db. Something like that. What ever your path is.
From the root of my drive or apache documentroot?
Edit: Tried both, same thing. :S If I put in an invalid path, Sqlite errors do come up (I have modified the file to show errors), so I think it is connecting to the database... Hmm
Post the .db file. Let me take a look at it and see if SMF was installed correctly. OR you can just try reinstalling SMF and see if it works.
When I use the installer on that server, I get...
SQL logic error or missing database
On install.php?step=1 after I submit the form with correct info and stuff...
And by playing with Subs-Db-sqlite.php, I found that it is trying to run the query...
INSERT INTO smf_settings(variable, value) VALUES
Followed by a blank query when I install....
Edit: Attached are the 2 different databases I tried - smf.db is a copy from the other server that worked, the other is a SQLiteManager export then imported copy.
Edit: More server info.
Apache 1.3.37
PHP 5.2.3
SQLite 2.8.17
Umm I just loaded those two files and they work file. I tested my SQLite install with those files and they work. What are the permissions on the files?
BTW what version of SQLite are you running?
EDIT: Are you running under safe mode?
SQLite 2.8.17
Both files were 777.
For safe mode, I am not sure. Is that an apache settings? Or smf?
PHP.
It would be shown a phpinfo
(eg create a .php file and add to it)
<?php
phpinfo();
?>
Ah.
Safe mode is off.
Umm can't think of anything. Try this.
<?php
error_reporting(E_ALL);
$open = sqlite_open('smfnew.sql', 0666, $error);
if ($open === true)
echo 'opened';
else
echo $error;
?>
Save that as sqlitetest.php and access it from your browser and tell me the output.
Nothing at all, just a blank page... :o
Enable display_errors. Usually can be done with a .htaccess file in the directory, containing:
php_flag display_errors on
Then try again?
Doing that gives me an error 500 internal server error...
Moptop650,
Did you solve this?
Was the path to the .db file correct in your Settings.php?