News:

Wondering if this will always be free?  See why free is better.

Main Menu

Error: "not an error<br />"

Started by Moptop650, March 18, 2008, 04:35:10 PM

Previous topic - Next topic

Moptop650

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?

karlbenson

Have you ran repair_settings.php?

I'll have a test of this myself i think.

CmptrWz

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?

Moptop650

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.

karlbenson

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.

Moptop650

Well its not really intended for use, just for checking it out..

JayBachatero

Where do you have the .db file and what is the value for $db_name in the Settings.php file?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Moptop650

Its in the root smf directory, file is smfnew.db, and the settings file has

$db_name = 'smfnew.db';

JayBachatero

Try setting the full path to the file.  /public_html/smf/smfnew.db.  Something like that.  What ever your path is.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Moptop650

#9
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

JayBachatero

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Moptop650

#11
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

JayBachatero

#12
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?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Moptop650

SQLite 2.8.17

Both files were 777.

For safe mode, I am not sure. Is that an apache settings? Or smf?

karlbenson

PHP.
It would be shown a phpinfo

(eg create a .php file and add to it)
<?php 
phpinfo
();
?>

Moptop650


JayBachatero

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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Moptop650

Nothing at all, just a blank page...  :o

CmptrWz

Enable display_errors. Usually can be done with a .htaccess file in the directory, containing:

php_flag display_errors on

Then try again?

Moptop650

Doing that gives me an error 500 internal server error...

Advertisement: