Running SQL Manually

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

If you need to run the sql file manually, you will need to change all occurrences of

Code:

`$prefix_

to

Code:

`nuke_

or instead of `nuke_, use what ever prefix you would normally put in config.php.

Posted: Fri Jul 16, 2004 2:41 am

I think you might want to include a manual sql file in the pack.. It will help the confused ppl. Very Happy

Posted: Fri Jul 16, 2004 6:40 am

stephen2417 wrote:

I think you might want to include a manual sql file in the pack.. It will help the confused ppl. Very Happy

Stephen, the SQL IS included in the pack. What do you think this post is about Bang Head

Posted: Fri Jul 16, 2004 7:38 am

LOL noo, i meant one thats already changed for lazy ppl like me Laughing

Posted: Fri Jul 16, 2004 7:46 am

Won't happen unless I do away with the installer altogether which isn't likely. That's the problem with today's youth - no initiative Laughing

Posted: Fri Jul 16, 2004 8:21 am

Hi Raven,

I think the SQL connection problem has something todo with the DB name, It won't read the config.php correctly, it standard uses DB name mySQL even when u manually logged-in treu the install.php. The DB mySQL aint the DB you want to connect to, I gues that is is going wrong somewhere in that part.

But, I am a newbie so don't smack me if it is wrong.. Laughing

Posted: Fri Jul 16, 2004 8:26 am

I also have probs running the installer. I get the following:

localhost
database user name
my database password
===========

Connected successfully to your MySQL Server!

Unable to connect to MySQL database mysql with these credentials: Access denied for user: 'database user name@localhost' to database 'mysql

I didnt include my personal settings for security reasons.

I typed in all the correct database settings and received the error

When i try to go to the site, i get the following:

There seems to be a problem with the MySQL server, sorry for the inconvenience.

We should be back shortly.

Joe
Porcupine PC

Posted: Fri Jul 16, 2004 8:29 am

Well, if the tables aren't installed then you will receive that message. I'm not having any problems when I use the installer, so obviously we aren't going through the same steps. Joe, could you list a step by step of what you are doing so I can try to reproduce it here? Also list what permissions you have assigned your db user?

Posted: Fri Jul 16, 2004 8:31 am

I ftp'd all the files in the html directory into my /nuke directoey. Then i ran the install.

http://www.porcupinepc.com/nuke/install

I filled out the required info and received those errors that i reported in my previous message

Joe

Posted: Fri Jul 16, 2004 8:34 am

What are the permissions assigned to that db user?

Posted: Fri Jul 16, 2004 8:35 am

Did you use the installer to create the database or did you do it manually?

Posted: Fri Jul 16, 2004 8:36 am

how do i find the permissions for that?

Posted: Fri Jul 16, 2004 8:38 am

In your phpmyadmin.

Posted: Fri Jul 16, 2004 8:48 am

OK... My hosting provider blocks every other DB tool other then phpMyAdmin, so I don't have the correct permissions I gues.

I changed the file for manual use and changed the lines:

$prefix_

and

the line somewhere around line 990 (blocks)

I get this error,

SQL-query :

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

MySQL retourneerde:

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

Is there only one line or do I have to search for more of the same lines?

Thanks,

Fred Mr. Green

Posted: Fri Jul 16, 2004 8:51 am

Look at the Sticky fixes Bang Head

Posted: Fri Jul 16, 2004 8:51 am

Where do i find those permissions? My hosting company is runninf phpMyAdmin 2.5.1

Joe

Posted: Fri Jul 16, 2004 8:53 am

If you use cPanel, you should see them on the initial database screen/link BEFORE you go into phpmyadmin

Posted: Fri Jul 16, 2004 8:56 am

My hosting company uses Plesk

Joe

Posted: Fri Jul 16, 2004 8:57 am

Then I don't know - sorry. I need to know so i can set up my test here exactly like yours.

Posted: Fri Jul 16, 2004 8:58 am

ok. for now, ill just put my Nuke site on hold till i learn more on the new version

Joe

Posted: Fri Jul 16, 2004 9:00 am

Just load the sql through phpmyadmin, noting the Waiting Content table fix. It should work just fine like that.

New Member Joined: Dec 12, 2003 Posts: 1

i just installed the customized version and i dont know wot to do , i tried the installer and it give me error
how can i install it manually
i think i should be able to do that
thank
www.soduk.net/html

Posted: Mon Aug 23, 2004 3:23 pm

Hi,

I have visited your site @ soduk.net and soduk.net/html, on both adresses there is a different site running?? the customized version is running without any php errors as far I can see RavensScripts

The other one has errors... Rolling Eyes

not the Ravens Cusomized version.
What is it you want to do next...

greets,

Fred Mr. Green