|
Donations |
|
 |
|
|
|
If you found this site helpful, please donate to help keep it online
Don't want to use PayPal? Try our physical address
|
|
|
Survey |
|
|
|
|
|
|
|
|
Translate |
|
|
|
|
|
|
|
|
|
|
| View previous topic :: View next topic |
| Author |
Message |
Paul
Admin
Joined: Feb 22, 2002
Posts: 5719
Location: USA
|
 Posted: Wed Jan 08, 2003 11:05 pm Post subject: PHPNuke Help |
|
|
Welcome - Introduction
The Installation Forum is a heavy traffic one, so the idea is to keep your related problems all in one thread without cross-posting anywhere else. Doing otherwise may have your thread drop off and unanswered. Please read this thread and search the forums for your problem/resolution prior to posting. Usually, a resolution has already been posted for the major/common issues.
Forum Etiquette
Before we begin in addressing common or major problems for your PHP-Nuke Installation, lets keep in mind that a well mannered, well bahaved forum acts like a magnet for experienced Nuke users who are happy to help folks new to Nuke. However a poorly behaved forum will not only drive them away, but also new members. Whether or not people keep coming back for quality posting is up to each of you. Basically, if you don't have something nice to say, then don't say anything.
Getting Help: What you need to know
To help us help you from the moment you post your new thread, its best to provide as much detail about the problems you are running into for your PHPNuke installation. To do that a minimum of what should be posted is:
- Title your thread appropriately, and not with "I need help!"
- PHPNuke Version Number
- Exact errors with Debug enabled
Mostly new threads here are seeking help anyway, so we know you need assistance. Instead of calling your thread "help", or "i need help", or "urgent help", title it accordingly to your problem like: "chat not loading", or "i can't download the tarball".
In addition, if you could it would be nice to see a link to the problem site (and/or page). Perhaps including a copy of the problem line from the code would be sweet too. There are sections below where you'll find simple instructions on how to enable debugging for PHPNuke and/or phpBB including resolutions to other common issues.
Connectivity Code for MySQL
Thanks go out to Humpa for this snip. Upload it to your base PHP-Nuke installation and run it from your browser.
| Code: |
<?php
require_once("config.php");
$dbcheck = mysql_connect("$dbhost", "$dbuname", "$dbpass");
if (!$dbcheck) {
die("<br><b>Connection Test Script was unable to connect to MySQL server!<br>");
}else{
echo "<b>Connection Test Script connected to your MySQL server successfully!<br>";
if (mysql_select_db($dbname)) {
echo "<br>Connection to your database \"$dbname\" was also successful.<br>";
$result = mysql_list_tables($dbname);
if (!$result) {
print "DB Error, could not list tables\n";
print 'MySQL Error: ' . mysql_error();
exit;
}
$i=0;
$stufftoprint = "";
while ($row = mysql_fetch_row($result)) {
$stufftoprint .= "Table: $row[0]\n<br>";
$i++;
}
echo "<br>There are $i tables in your $dbname database<br>";
echo "<br>Now check this list of tables with your nuke.sql file:<br><br>$stufftoprint</b>";
}else {
echo "<br><br>But, the connection to your database \"$dbname\" has FAILED!";
}
}
mysql_free_result($result);
?> |
Debug for PHPNuke
- Log into your server and cd to your sites root directory,
- cd to your includes subdirectory,
- Edit your sql_layer.php file found in your includes folder using vi, vim, nedit, or whatever editor you use,
- Search for "$sql_debug = 0;" and change it to "1" and save the file,
- Reload the webpage and see what the error is, then use it in making your "help wanted post".
Then of course to disable debugging, simply follow the above steps again and replace the "1" for $sql_debug to a "0".
Debug for phpBB Forums - Prior to Nuke 6.5 Releases
- Log into your server and cd to your sites root directory,
- cd to your modules/Forums/includes/ subdirectory,
- Edit your constants.php file found in your includes folder using vi, vim, nedit, or whatever editor you use,
- Search for the following block of text:
| Code: |
// Debug Level
//define('DEBUG', 1); // Debugging on
define('DEBUG', 1); // Debugging off |
- Uncomment the first define and comment out the second one. Now you have debugging enabled for the forums. Save the file,
- Reload the troubled web page and copy the exact problem and use it in your post.
Then to revert back follow the steps above and change the 1 to a 0.
Debug for phpBB Forums - 6.5 Release
- Same as above, except the directory is includes/ instead of modules/Forums/includes/.
sql_layer.php Debug
Open sql_layer.php go to line 300 and change:
| chatserv wrote: |
case "MySQL":
$row = mysql_fetch_row($res);
return $row;
break;; |
To the following:
| chatserv wrote: |
case "MySQL":
if ($row = mysql_fetch_row($res)) {
return $row;
} else {
print (mysql_error());
}
break;; |
Upload the changed file, go back to your site and in the error message you should now see a better error report.
Checking Basic Installation
| chatserv wrote: |
If config.php is correctly setup and you look closely on the web pages you'll notice instances like Version_Num from nuke_config which means it's grabbing the value for prefix which in this case is nuke, i'd check the following:
1)Make sure the database tables exist by using phpMyAdmin or similar tool.
2)If the database tables are there then see if they start with nuke, your config.php expects them to, so if they exist but the tables start with another name like hey_access instead of nuke_access, open config.php and change $prefix and $user_prefix to the word showing before each table name, no need to add the underscore (_)
3)If the first two items check ok then open config.php and make sure $dbtype is MySQL, it is case sensitive. |
Preferences Not Saving
| chatserv wrote: |
| The footer lines are not supposed to be deleted, instead fix them. |
Or...
| Mantrid wrote: |
Copy footer 1 and footer 3 to a text file for later use
Delete footer 1 and footer 3, then save
Replace all single quotes in footer 1 text with double quotes and put back in footer 1, then save
Replace all single quotes in footer 3 text with double quotes and put back in footer 3, then save |
Users not staying logged in - Offline
| Mage wrote: |
| tweak for Your_Account, found at Nukescripts.net. Now the logins work perfectly |
For those wanting the tweak for Your Account and phpBB forums port, go here.
Both tweaks will also enable your users to select their own passwords too among other features.
Cannot Add Header Information
Please read the thread here: http://phpnuke.org/modules.php?name=For...opic&t=162.
nuke.sql errors
The nuke.sql file contains dashes "--" instead of hashes "##". You need to fix them, learn how here: http://www.phpnuke.org/modules.php?name...light=#655.
Topic Icons
| chatserv wrote: |
| Topic icons must be uploaded to the images/topics folder, use lowercase for the names and avoid using underscores or symbols in the image names, mynew.gif will work but my_new.gif won't. |
MySQL Versus All Other Databases
| Zhen-Xjell wrote: |
| Compare various databases to MySQL and see why that should be used here: http://www.mysql.com/information/crash-me.php. |
Editing php.ini for MS Windows
| chatserv wrote: |
When installing on windows many people get issues with the undefined variables, failed logins and other problems, turning off error_reporting by placing a semi-colon in front of it (php.ini) will get rid of these "errors", these are not considered real errors and are mostly warnings, users with experience on windows installation of PHP-Nuke have recommended the following changes be made to the php.ini file:
- find register_globals and set to On
- find error_reporting and turn that off by putting a semicolon in front of it
- find include_path and add the path to your website root ex: ".;c:\inetpub\wwwroot"
- find display_errors and change it to Off
- find SMTP= and change it to the address of your mailserver ( localhost )
- find magic_quotes_gpc and set that to On
You should restart your server for the changes to take effect.
For more help on Windows installation visit warrenonline.
|
| dandumit wrote: |
- error_reporting = E_ALL & ~E_NOTICE
Don't comment it especially if you are using the web server for Intranet clients - if it is commented you'll never find out about errors which may be OS dependent.
|
Multiple Survey Votes
| chatserv wrote: |
By default the Survey comes set to 30 minutes between votes, to change this open modules/Surveys/index.php and search for:
$past = time()-1800; |
Warning: setlocale() [function.setlocale]: Passing locale category name as string is deprecated. Use the LC_* -constants instead.
| chatserv wrote: |
| Remove the quotes from around "LC_TIME" in those files/lines mentioned in your errors. This means "LC_TIME" should be changed to LC_TIME. |
Copy/Use
Feel free to copy any or all portions of this text for use on your PHP-Nuke site with the restriction that credits are given where credits are due.
Conclusion
That's it folks, and I hope this helps out everyone in the long run. This message shall most likely be updated from time to time to better prepare first timers. Thanks go to all the folks who help for free.
|
|
| Back to top |
|
 |
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
Powered by phpBB 2.0.8a © 2001 phpBB Group
Version 2.0.6 of PHP-Nuke Port by Tom Nitzschner © 2002 www.toms-home.com
Version 2.2 by Paul Laudanski © 2003-2004 Computer Cops
|
You can syndicate our news using the file RSS 0.91, ultramode.txt, or RSS 1.0.
Forum FAQ
Search
Usergroups
Profile
Login to check your private messages
Login
