Nuke Resources Forums » Post 11399 » Error with nukesql: Need help bad

Dark_Dragon · Resource Newbie

I am having some problems with the nukesql and its totally ticking me off. I am not the type to just give up but I am almost there. I am new to PHP but I have been reading everything about it.

I have php nuke 7.9, the newest version and I noticed the newest nukesql.php version is 7.7 so I am not sure if thats the problem or not, anyway here is my problem.

I have uploaded all PHP Nuke files to my server and then I uploaded all the nukesql files like it says to do, then I edit the config.php file using Crimson Editor. The reason I wont use notepad is because I heard notepad has hidden characters and isnt recommended.

This is what I have enterd.

$dbhost = "66.49.203.215";
$dbuname = "dragonsrea";
$dbpass = "********";
$dbname = "dragonsrealm_ca_-_MySQL";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SStgF54$3@+%288-982%/(-derThsR-23";
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";
$nuke_editor = 1;

The password and username I know for a fact is right. The dbhost I am not sure of. On my hosts server all it says is localhost so I just put the IP that the server is brodcasting on. I also tried localhost like it says and that didnt work either.

Once that was done I pointed my browser to the location of the nukesql.php file then clicked run the test and this comes up.

NukeSQL.php and the Connection Test Script were not able to connect to the MySQL server,
hence the database tables cannot be created!
config.php needs to be configured correctly before running nukesql.php,
one of the following values seems to be wrong in your config.php file:
dbhost, dbuname or dbpass,,
currently you entered 66.49.203.215 , dragonsrea and ******** as your values,
if you are not sure about what the correct ones should be contact your webhost and ask them.

I do not have a server on my PC and I do not have PHPnuke installed on it either I only have it installed on my hosts server which I am paying for and I am desperate.....I have tried every possible solution and still get the same error.

Any help will be appreciated.

ps. Like I said I have the newest version of PHPNuke. I am not sure but it may be possible that nukesql 7.7 wont work with php nuke 7.9.

darklord · Resourceful

first thing is 7.7 sql is not the same as 7.9

But thats not ur problem...now heres the main thing about servers:

1. Make sure they are reputable and can give u support

2. Any server that uses phpmyadmin on a windows system has got to REALLY know what they are doing...linux systems are easier to update and dont use as many resources..i personally only use a linux server,
I have set up a server on windows and found it to contain more problems then its truly worth.

The server i run is liinux and the easiest way u can tell is that if u have cpanel installed on ur server u can tell its linux. I believe cpanel is goin to have a release so that it would be able to be put on windows soon but as far as i know its not been done yet.

Now if u have cpanel i can help u easier

So I'll post a kinda setting up a databse tutorial here,

First goto your sites cpanel...either by http://yoursite.com/cpanel or if ur server has it set up this way, http://yoursite.com:port

then go into ur mysql database,
Make a databse in the options
**For example lets say u make a databse called nuke and ur username to your cpanel is blah, It wont make nuke....itll make blah_nuke(dark_dragon i think this may be ur error)

Now u must go and make a username and a pass
Notice also if we make username user with pass 123456
It actually makes blah_user for the username and the pass remains.

Now after setting up a username and password
you MUST set that user to have access to your database be4 that username can access it Right below the place where we made the database ull see the option to add user to databse...select the user and the database then click the add user to DB button

Now at the bottom jut above phpmyadmin link...ull see access hosts...this is the dbhost...by default it should be set to localhost
leave this and now in ur config.php should look like this

$dbhost = "localhost";
$dbuname = "blah_user";
$dbpass = "123456";
$dbname = "blah_nuke";
$prefix = "nuke";
$user_prefix = "nuke";

now while in the config.php
Lets review one more thing...and by all means edit this or correct me if im wrong.

$gfx_chk = 0;
This is to turn the display of the code verification on or off, or at what setting ud like it. For the users when they log into ur site so they may have a check for bots or not.

One more thing and i only restate this because of the amount of looking ppl forget to do so here it is again so ull all know

$display_errors = false;

change this to

$display_errors = true;

so u can see the errors when some1 advises you to turn ur errors on...now i hope this is enough info so that u can fix ur problem

Dark_Dragon · Resource Newbie

I did what you suggested and OMG it worked I actually have a portal installed.

You have no idea how long I have been at this pulling my hair out by the roots and by following your advice I had it up and running in 10 minutes. Thank you thank you thank you.

You da man

I am far better at static HTML then I am with PHP. I always wanted to learn PHP but never got around to it. There is so much stuff you can do with php that you cant with static HTML.

Anyway enough of my blabbing. Thanks a lot I am gonna recommend this forum to anyone that wants to learn PHP.

Until next time I need help which will probably be tomorrow lol I will be seeing ya Smile

darklord · Resourceful

you could almost see the excitement behind what u wrote...glad i could help..made it all worth it...was it easy enough to understand?

Dark_Dragon · Resource Newbie

yes it was once you figure out what everything does and now that I am onto this I dont think I can go back to HTML lol thanks again darklord.
[/quote]