Crash and burn

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

well so far no go. did a new install, could not use the install.php script as cannot creeate db, but created a dba and ran ravennuke7325.sql in mysql and it seemed to creeate all the tables just fin, then uploaded everything in the html dir and ran and got this error

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /usr/www/users/dwdugg65/dwdugger.com/header.php on line 31

Warning: head(): Failed opening 'themes//theme.php' for inclusion (include_path='.:/usr/local/lib/php') in /usr/www/users/dwdugg65/dwdugger.com/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /usr/www/users/dwdugg65/dwdugger.com/header.php on line 47

any ideas??

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

Before manually loading the sql, did you rename the `$prefix to `nuke in the sql? The installer should have worked after you created the database. Did you try it?

Hangin' Around Joined: Sep 25, 2003 Posts: 30

Raven wrote:

Before manually loading the sql, did you rename the `$prefix to `nuke in the sql? The installer should have worked after you created the database. Did you try it?

Didnt work for me either. After starting the installer and filling in the correct
info (in my case, my database name was nelson_nuke), the installer said it
could not connect to the database "mysql".. Confused

I then changed the prefixed to nuke as you suggested. Here is the next error from phpmyadmin:

Quote:

Error

SQL-query :

INSERT INTO `nuke_blocks`
VALUES ( 19, '', 'RWH WaitingContent', '', '', 'l', 7, 1, 3600, '', '', 'block-RWH_WaitingContent.php', 2 )

MySQL said:

#1136 - Column count doesn't match value count at row 1

This is as far as I got, will look at it further in the morning.

--Nelson

Posted: Fri Jul 16, 2004 2:40 am

Raven why didnt you keep the old installer, it worked fine? Well at least I think.

Posted: Fri Jul 16, 2004 6:38 am

Stephen - There never was an 'old installer'. That was only a MySQL tester.

Nelson,

I said in another thread that I missed something with the waiting content. i will post as soon as I look into it. Thanks.

Posted: Fri Jul 16, 2004 7:00 am

Here's the Waiting Content fix http://www.ravenphpscripts.com/postp15806.html#15806

Posted: Fri Jul 16, 2004 7:40 am

I meant with your 7.0 distro, unless im crazy there was an sql installer. Rolling Eyes

Posted: Fri Jul 16, 2004 7:47 am

No installer there.

Posted: Fri Jul 16, 2004 8:27 am

I was having the same problem as Tao Man. I renamed $prefix to nuke using find/replace in my php editor. And now I have nuke_ tables.
But now I have "you can't access this file directly" when loading index.php.

ooops... maybe I had the wrong index.php file!
now to change the theme name in nuke_config ...

It worked! I've got a new nuke. Well, almost, some missing info in the blocks.

Posted: Fri Jul 16, 2004 8:46 am

I didn't have *all* the /image files and dirs in place. Rolling Eyes

Looks good now!
RavensScripts

Posted: Fri Jul 16, 2004 8:49 am

Posted: Fri Jul 16, 2004 9:06 am

Ok,

DB successfully (manual) installed, made the nessesary changes @ config.php and this is what shows up on my site,

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

SQL isn't my thing at this point so any idea's what causing this?

Thanks,

Fred Mr. Green

Posted: Fri Jul 16, 2004 9:24 am

What version of PHP and MySQL are you running?

In includes/RWH_wiw.inc.php try changing

Code:

   mysql_query('create table '.$prefix.'_wiw_m (who varchar(20), mn varchar(20)) type=memory') or die('MySQL said: '.

to

Code:

   mysql_query('create table '.$prefix.'_wiw_m (who varchar(20), mn varchar(20)) type=heap') or die('MySQL said: '.

BTW, were you this much trouble as a child Laughing

?

Posted: Fri Jul 16, 2004 9:35 am

I'am still a child Mr. Green

OK... a little late @ 38... Laughing

Fred

BTW I will check it with an info.php

Posted: Fri Jul 16, 2004 9:40 am

I just have seen that RWH_wiw.inc.php was not uploaded.. Sorry.. Embarassed

Fred

Posted: Fri Jul 16, 2004 9:42 am

Works!!

Fred

Posted: Fri Jul 16, 2004 9:54 am

YAY!!!!