Database error

Posted: Fri Jul 16, 2004 3:50 pm

I manually uploaded the sql file and even edited the config.php and i get the following when i type in admin.php:

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/nuke/header.php on line 31

Warning: head(): Failed opening 'themes//theme.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/nuke/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/nuke/header.php on line 47

Any idea?

Joe

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Did you transfer the themes folder with all its contents? If so, then your config table is not getting loaded from MySQL which would point to a connection problem

Involved Joined: Jul 15, 2004 Posts: 252 Location: OKC, OK

Did you do a search and replace on $prefix_ for $nuke_
in the ravennuke7325.sql?

I was getting the same error whhen I first started and that was my problem/fix

Posted: Fri Jul 16, 2004 4:30 pm

Tao_Man

There must me a hundred instances of $prefix_ in that file. Everyone has to be changed?

Joe

Posted: Fri Jul 16, 2004 4:35 pm

http://www.ravenphpscripts.com/postt2234.html

Just do a find/replace in a good text editor.

Posted: Fri Jul 16, 2004 4:51 pm

or you can use VI if you have shell access

:s/$prefix_/nuke_

should do the trick

Posted: Fri Jul 16, 2004 6:30 pm

I edited the sql file and replaced every instance of prefix with nuke.
I uploaded it no problem.

I then edited my config.php with my settings and i got the following:

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/nuke/header.php on line 31

Warning: head(): Failed opening 'themes//theme.php' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/nuke/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /usr/local/psa/home/vhosts/porcupinepc.com/httpdocs/nuke/header.php on line 47

All my files seem to have been uploaded. All the themes are there.

Joe

Posted: Fri Jul 16, 2004 6:48 pm

I don't know, did yu create a new database maybe you have two set of tables and that is messing it up.

it seems to be a database error as it is lookining for a theam with a null name.

Do you have phpmyadmin or something like that to check the tables?

the table you need to check is nuke_config and see if has a theam listed, the default is fiapple, make sure you have that theam uploaded.

Other then that, sorry no ideas

Posted: Fri Jul 16, 2004 6:49 pm

It's a connection issue with MySQL. Try this but substitute correct values.

Code:

<?


$db = mysql_connect($dbhost, $dbuname, $dbpass);


?>

Any errors?

Posted: Fri Jul 16, 2004 6:51 pm

The fact that it is null means there is no database connection or the selection of the database. That is definitely the problem.

Posted: Sun Jul 18, 2004 11:45 am

I can now access admin.php but when i click on home, i get:

MySQL said: You have an error in your SQL syntax near 'memory' at line 1

Joe

Posted: Sun Jul 18, 2004 1:10 pm

From the README in the Who-is-Where add-on

=========================================================================================================
WARNING!! The first time this script executes, there is no table. So, the script tries to create one. That implies that the dbuser setting in config.php has create table priveleges. If it does not, MySQL will GROAN and not make the table. In that case, use phpMyAdmin and create the table with this QUERY. If your prefix is not nuke, then adjust it accordingly.

CREATE TABLE `nuke_wiw_m` (
`who` varchar(20) default NULL,
`mn` varchar(20) default NULL
) TYPE=HEAP;

=========================================================================================================

Posted: Sun Jul 18, 2004 1:57 pm

thanks Raven

Works fine now

Joe