>> Site Map >> Forums >> PHP-Nuke Common Problems & Solutions
Forum module - topics in forum:
PHP-Nuke Common Problems & Solutions - <font color=red>Look Here First For Your Problems And Get Their Solutions.</font><br><br>See also <a href="http://phpnuke-uk.net/modules.php?name=PHP-Nuke_HOWTO&page=common-installation-problems.html"><b>this</b></a> section of the phpnuke howto.<br>
There seems to be a problem with the MySQL server.......
---- The Error
- You see the following message when trying to get into the site
Code: : There seems to be a problem with the MySQL server, sorry for the inconvenience.
- This error is is mostly caused by a miss configured config.php file.
---- The Solution
- Please Note these variables Are CaSe SeNsItIvE so take care when entering them!!
- You must edit the config.php file and fill in the following variables. This will allow nuke to conect to your database.
- $dbhost is generally "localhost" but if you are unsure contact your hosting company to find out
Code: : $dbhost = "localhost";
- $dbuname is the uname that will allow you access to the database, this can sometimes be the same as your FTP account but if you are unsure contact your hosting company to find out;
Code: : $dbuname = "UserName";
- $dbpass will be the corresponding password for whatever $dbuname you are using
Code: : $dbpass = "*******";
- $dbname is the name of the database your nuke tables are stored in this may simply be your site url, but most hosting companies will change it slightly to for example phpnuke-uk.net -> phpnuke-uk_net. If you log into PhpMyAdmin it should show you the name of your database in the left hand side panel, but if you are still unsure contact your hosting company to find out.
Code: : $dbname = "nuke-uk_net";
- $prefix is "nuke" by default. If you have changed the table names in the sql/nuke.sql file then you will have to change this to suit what ever prefix you have used on your tables
Code: : $prefix = "nuke";
- $user_prefix is as above but only applies to the users table
Code: : $user_prefix = "nuke";
- $dbtype is probably the where most people have problems. As stated earlier these settings are CaSe SeNsItIvE and it needs to be "MySQL", any other combination such as "mysql" or "MySql" will not work, so double check this one
Code: : $dbtype = "MySQL";
- $sitekey can be anything you want except for quotes ie: " or '
Code: : $sitekey = "1234qwerasdfzxcv";
- $gfx_chk is a variable that allows you to control the Security Code, below are a list of the options avaliable:
- 0: No check
- 1: Administrators login only
- 2: Users login only
- 3: New users registration only
- 4: Both, users login and new users registration only
- 5: Administrators and users login only
- 6: Administrators and new users registration only
- 7: Everywhere on all login options (Admins and Users)
The Security code option requires GD to be installed on your server, if it is not this option is overided automaticly to 0
| Code: : |
| $gfx_chk = 5; |
---- Still Not Working
If you have found out all these details and are sure they are correct and you are still having problems please post up your specific problem in the Installation Forum and we will try to help
In your post if you can put all of the above variables in the post (except your password) or if you wanted try the conntest.php - this script should tell you whats wrong, just upload it to the same place as your config.php and call it from your browser.
Added poll
