FIX: undefined function: message_die in db.php on line 88

Posted: Thu Jan 22, 2004 7:39 pm

line 88 errors are ALWAYS problems connecting to the database

the troubleshooting process is as follows:
1. is mysql running?
2. is the user/password in config.php correct?
3. is the database name in config.php correct?
4. does the user in config.php have access to the database name in config.php?
5. is dbhost set to "localhost" or a valid mysql server with unrestricted access to port 3306?
6. are the $prefix and $user_prefix variables in config.php set to "nuke"?
7. is the $dbtype variable set to "MySQL"? -not mySQL, mysql, MYsql, MYSQL, my sql, or MySQL3.
8. if youve gotten this far and haven't fixed it repeat the whole process starting at step 1 again until it is fixed

and here are some fun words thrown in for the benefit of the 3 people on the planet that use the search function:

line 88
on line 88
db.php
db.php on line 88
db/db.php on line 88
message_die
message_die()
Fatal error
Fatal error:
Call to undefined function
Fatal error: Call to undefined function: message_die() in /home/what ever/public_html/html/db/db.php on line 88

Private Joined: Oct 26, 2003 Posts: 38 Location: USA

Hi,

And thank you. I thought it may have something to do with the database and username. I've never seen it set up where it asks for the username and also a prefix. So ... am I supposed to use JUST the user name in that field ... and then the prefix in the prefix field rather than as dbuser_dbname?

Thanks again!

Posted: Wed Jan 28, 2004 3:19 am

prefix and user_prefix almost always should always be nuke

its used for running multiple php nuke sites within the same db

so unless you need to run multiple site in the same db, its useless

Nuke Cadet Joined: Feb 01, 2004 Posts: 3

how do you find out the username/password to put in config.php? im runing windows xp with foxserv =\

Nuke Cadet Joined: May 12, 2003 Posts: 1

For me the fix was different.

My config.php was spot on. Had all the right values without a doubt. But I was still getting that blasted undefined function message.

I fixed it by putting the config.php file back in the phpnuke root directory.

Remember back to the install docs (you all read them, right?) where, in Install.txt, it suggests that you ...

Quote:

SECURITY TIP: It's a good choice to put your config.php file outside the
Web Server path, then you can create a new config.php with the line:<?php include("../config.php"); ?>

Well, being a good soldier, I did exactly this. This might be the right thing to do from a security point of view, but it does also seem to be responsible for that 'undefined function' error. Additionally, it causes an error when, as Admin, you try to go to Forums Admin section.

Kosuke

Nuke Soldier Joined: Nov 13, 2003 Posts: 15

Having just had to change my password to get into the server cPanel to my site, I then got this error. Thanks to your help I was able to solve the problem, and ended up changing the password for the SQL database in config.php so it matched that of the cPanel.
I take it that everytime I change the cPanel PW I need to change the SQL PW?
Once again, thanks for your help. Your forum is invaluble!

Nuke Cadet Joined: Feb 08, 2004 Posts: 3

i fixed this error then got:

Warning: open_basedir restriction in effect. File is in wrong directory in /home/luckypicom/public_html/mainfile.php on line 189

Warning: Failed opening 'language/lang-.php' for inclusion (include_path='.:/usr/share/php') in /home/luckypicom/public_html/mainfile.php on line 189

Warning: open_basedir restriction in effect. File is in wrong directory in /home/luckypicom/public_html/header.php on line 31

Warning: Failed opening 'themes//theme.php' for inclusion (include_path='.:/usr/share/php') in /home/luckypicom/public_html/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /home/luckypicom/public_html/header.php on line 47

Sad

Posted: Sun Feb 08, 2004 3:01 pm

I have the same problem as luckypill dan:

Warning: main(language/lang-.php): failed to open stream: No such file or directory in /home/virtual/site32/fst/var/www/html/mainfile.php on line 189

Warning: main(): Failed opening 'language/lang-.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site32/fst/var/www/html/mainfile.php on line 189

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /home/virtual/site32/fst/var/www/html/header.php on line 31

Warning: head(): Failed opening 'themes//theme.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site32/fst/var/www/html/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /home/virtual/site32/fst/var/www/html/header.php on line 47

HELP!

Nuke Cadet Joined: Feb 10, 2004 Posts: 1

Quote:

and here are some fun words thrown in for the benefit of the 3 people on the planet that use the search function:

line 88
on line 88
...

Thanks a million. I looked thru various posts for an hour to no avail... then the Search feature turned me to this topic. (Make that 4 people that use the Search function)
Razz

Nuke Cadet Joined: Feb 17, 2004 Posts: 2

I am attempting to install and am getting this same error. Here are the details:

OS: Fedora Core 1
Apache 2.0.47
PHP 4.3.3
MySQL 3.23.58
(the stuff that came with Fedora)

Here is the pertinent part of the config.php file:

Code:

$dbhost = "localhost";
$dbuname = "todd";
$dbpass = "**********";
$dbname = "nuke";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "*********************";
$gfx_chk = 0;

(Real passwords obscured)

mysql is running
user/password is set to my user/password with which I use to log into Linux. I assume(?) that this is correct. I have given myself access to the database by including my user in the mysql group. Ownership of everything in the mysql library appears to be set to mysql:mysql
variables appear to be set correctly.

I am still getting the error. Perhaps a silly questions.

Does it matter where the database is stored? When I did the installation per the instructions I simply created the nuke database. MySQL stored it in /var/lib/mysql/. Is the program finding it or does it have to be created and stored in the public html folder somewhere or is there someplace to tell the program where to look.

Any thoughts would certainly be appreciated. Thanks.

Almost forgot to add: using PHPNuke 7.0

Captain Joined: Oct 26, 2003 Posts: 553

Did you grant Todd authority *in* the database? When you say you added yourself to the mysql group, do you mean a linux group, or a mysql group? (I don't think mysql has groups)

- Virgil

Nuke Cadet Joined: Feb 17, 2004 Posts: 2

Ah, gotta love it when the light goes on! That's what I get for being new to MySQL at the same time. Thanks.

Nuke Soldier Joined: Oct 19, 2003 Posts: 22

My site has been up and running just fine for the past 8 months and now all of a sudden some (not ALL) users are getting this error...

I know you said that line 88 errors are ALWAYS problems connecting to the database - but why would some users be able to connect and others can't?

the troubleshooting process is as follows:
1. is mysql running?

- YES (I can connect to the website just fine)

2. is the user/password in config.php correct?

- YES (I can connect to the website just fine)

3. is the database name in config.php correct?

- YES (I can connect to the website just fine)

4. does the user in config.php have access to the database name in config.php?

- YES (I can connect to the website just fine)

5. is dbhost set to "localhost" or a valid mysql server with unrestricted access to port 3306?

- YES (I can connect to the website just fine)

6. are the $prefix and $user_prefix variables in config.php set to "nuke"?

- YES (I can connect to the website just fine)

7. is the $dbtype variable set to "MySQL"? -not mySQL, mysql, MYsql, MYSQL, my sql, or MySQL3.

- YES (I can connect to the website just fine)

8. if youve gotten this far and haven't fixed it repeat the whole process starting at step 1 again until it is fixed

- REPEATED 3 TIMES - And like I said the site works fine for some -- for others they get this line 88 in db.php error.

I've seen it myself and maybe this is a clue:

On my Windows box I connect fine when connected normally. Once I use my CiscoVPN client to connect to work from that point forward I get the line 88 error. As soon as I disconnect from VPN I get back into the website just fine.

Any help would be appreciated.

Posted: Wed Feb 18, 2004 8:44 am

kaltizer wrote:

I have the same problem as luckypill dan:

Warning: main(language/lang-.php): failed to open stream: No such file or directory in /home/virtual/site32/fst/var/www/html/mainfile.php on line 189

Warning: main(): Failed opening 'language/lang-.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site32/fst/var/www/html/mainfile.php on line 189

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /home/virtual/site32/fst/var/www/html/header.php on line 31

Warning: head(): Failed opening 'themes//theme.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site32/fst/var/www/html/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /home/virtual/site32/fst/var/www/html/header.php on line 47

HELP!

Check your permissions on those files. 9 times out of 10 when you see No such file or directory of Failed opening for inclusion it is a file permission problem. I usually use at least rw permissions for user/group and rx for world. This will clean up a majority of those problems. It is especially note worthy when you install new themes or some modules. Most of the time module designers are good about shipping their files with proper permission settings and you don't need to worry about it. However I see themes all the time that just don't have the permissions set properly.

Posted: Wed Feb 18, 2004 9:05 am

simrin wrote:

kaltizer wrote:

I have the same problem as luckypill dan:

Warning: main(language/lang-.php): failed to open stream: No such file or directory in /home/virtual/site32/fst/var/www/html/mainfile.php on line 189

Warning: main(): Failed opening 'language/lang-.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site32/fst/var/www/html/mainfile.php on line 189

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /home/virtual/site32/fst/var/www/html/header.php on line 31

Warning: head(): Failed opening 'themes//theme.php' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site32/fst/var/www/html/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /home/virtual/site32/fst/var/www/html/header.php on line 47

HELP!

Check your permissions on those files. 9 times out of 10 when you see No such file or directory of Failed opening for inclusion it is a file permission problem. I usually use at least rw permissions for user/group and rx for world. This will clean up a majority of those problems. It is especially note worthy when you install new themes or some modules. Most of the time module designers are good about shipping their files with proper permission settings and you don't need to worry about it. However I see themes all the time that just don't have the permissions set properly.

its not a permissions thing - those files dont exist - that error is cause nuke cant slect the language from nuke_config