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

Corporal Joined: Feb 03, 2004 Posts: 62

Everything was goin good, no it was great. Everything was working according to plan, but then i had to install an SQL file for the ApproveMembership hack. i did, and it worked, but then i was looking through the SQL page in my cPanel, and because the page was so big, so much stuff, i clicked on my mouse wheel, making those two little arrows that allow you to scroll up and down, just by moving your mouse up or down. Anyway, when i go to turn it off, i used my left mouse button and accidently clicked on one of the users in my database !! what are the odds ??

look at the picture,

the USERS, on the lower left is what it usually looks like, with the DELETE link not really visible(but very much active!), on the right is the same USERS group but after you refresh that page a couple times, the delete shows up and is gone again. anyway, the top pic is the database.

Now i dont know what to do, when i clicked on the USERS tab, i accidentaly deleted kgbinc_nuke5 . And when i try to create a new user, it tells me that it has been created, but no user shows up. I think that is what the problem is, that there is a kgbinc_nuke5 database, but no user on there, so nuke cant access it without a user. But hey what do I know ?

I have nuke 6.8 and here are the server info, General server information:
Operating system Linux
Service Status Click to View
Kernel version 2.4.25
Apache version 1.3.29 (Unix)
PERL version 5.8.1
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.3.3
MySQL version 4.0.18-standard
cPanel Build 9.1.0-CURRENT 199
Theme cPanel X v2.3.0
Documentation Click to View

ANY help would be appreciated !

@linuxkid76, I have the SAME EXACT problem as you, that error on liine 88 and then i applied vjg's little fix, it have me the same error you had,

Could not connect to the database 1045: Access denied for user: 'kgbinc_nuke5@localhost' (Using password: YES)

and you seem to have getten it fixed, waht do you do to fix it?

@ LostCause, where is this php.ini file where i can edit the register_globals = On .

[/img]

Corporal Joined: Feb 03, 2004 Posts: 62

I JUST noticed that the privileges for all the other nuke SQL things, are all on ALL PRIVILEGES

kgbinc_nuke4 (Privileges: ALL PRIVILEGES)

nuke5 isnt : kgbinc_nuke5 (Privileges: )

maybe thats why its not working ?!

hwo would i give it privileges ?

Captain Joined: Oct 26, 2003 Posts: 553

You will probably have to have your host fix your user in the database. Contact the support desk/team.

- Virgil

Corporal Joined: Feb 03, 2004 Posts: 62

hhmm, is there anyway i could do it myself ?

give kgbinc_nuke5 all teh privileges ?

my "hostign company" is friend of mine in canada, taht barely goes online, lol. There shoudl be a way to fix it myself, shouldnt there, after alll its my DB and my SQL. Again, im just using basic reasoning, because i dont know much about sql.

Corporal Joined: Feb 03, 2004 Posts: 62

well i have no idea why it works now, but it does !!

This is what i did, i went to my "Scripts Library" in the cPanel, and installed a BRAND NEW installation of phpnuke on a WHOLE DIFFERENT FOLDER. instead of /russiainus like the last one, this one was /russiainus2 . so then i go to open it at the /russiainus2 URL, and it gives me an error, telling me that there are errors in the file theme.php under fiapple, the theme i used for my first original installation, which was weird, because i didnt change any settings any yet on the new installation, i didnt change the theme or anything.

And also an error under the footer.php file in the t directory of nuke in russiainus2.

i quickly realized that these two files are the two that i edited on my original site. so i figured, id try to reupload the edited files from /russiainus to the new installion, and IT WORKED ! the second installation worked, with all the same exact settings that i had in the first installtion, the color code, survey, and such, except for the logo.gif file, it was the original, php-nuke one.

so then i figured if this works, ill just try to copy the config.php file from the second installtion to the first one, and that did it ! the site works !

i still dont understand though, why did the second installtion have all the same settings as the first, it was in a whole different folder and a whole new installation ?!?!

Nuke Cadet Joined: Apr 16, 2004 Posts: 5

i have tryed always i have even tried a older version of php nuke still nothing i still get the same old error and wht do you mean the root directory

evry time i go to view it i just get message_die in db.php on line 88

Corporal Joined: Feb 03, 2004 Posts: 62

root directory meaning logging into the website through an FTP client, and going into the ROOT directory, the equivilence of C:\ of your hard drive. Where you see just the very basics of the site(C: drive).

Nuke Cadet Joined: May 21, 2004 Posts: 2

Hi guys..I'm hoping someone can help me out with this. The site worked fine yesterday....today i tried to check everything out and i get the Fatal error: Call to undefined function: message_die() in /var/www/html/phpnuke/db/db.php on line 88

I went through this forum but haven't found the answer yet.

i checked to see that the config file was correct and it seems to be.

i also changed line 88 in the db.php so that it would give me a better error message...well, it did but i have no clue how to fix this. here is the new message.

Could not connect to the database 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

I get the same thing when i run analyze.php.

If anyone can help with this it would be greatly appreciated.

Thanks

Captain Joined: Oct 26, 2003 Posts: 553

Sounds like mySQL server isn't running.

Do you have shell access? What does "mysqladmin version" command return?

- Virgil

Nuke Cadet Joined: May 21, 2004 Posts: 2

Thanks for replying Virgil...well...I'm not really sure how to answer that..this mysql is all new to me..i've been trying to learn what i can about this problem but i haven't been very succesful so far.

I'll tell you what i do have and maybe you can help me from there.

My host has a MySQL 3.23.58 Administration tool...which i don't have a problem getting into...i just don't know what to do when i get there. Very Happy

How do i get to the "mysqladmin version" command?

yes...yes...i'm definetly a newbie....i don't know if this is something you can help me get through or not but i'm hoping you have the time to help.

Eric

Captain Joined: Oct 26, 2003 Posts: 553

sounds like you probably don't have shell (command line) access. As your host if mySQL is up. They should be able to help you resolve the error you're getting. Pass that message on to them.

- Virgil

Nuke Soldier Joined: Feb 17, 2004 Posts: 23

I woke up this morning to find the fatal error message. The site has been running fine for a few months now so I have no reason to believe that any information in the config file will be wrong.

I tried changing the error meesage to that as suggested in the earlier posts and now get this error:

Could not connect to the database 2002: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)

It therefore seems to be a connection problem, but now I know this what do I do?

Thanks

Nuke Soldier Joined: Feb 17, 2004 Posts: 23

As soon as I started to write a message to my domain host, everything started working again. I therefore figure that mysql must have been down on their side and they sorted it out for me, just hope it doesn't happen too often!

Nuke Cadet Joined: Jan 10, 2004 Posts: 4

When my site gets heavy traffic i get the following error:

Fatal error: Call to undefined function: message_die() in /home/virtual/site2/fst/var/www/html/db/db.php on line 88

Now this means that for some reason the site can't communicate with the database.

I've tried increasing the man_connections setting on the server from 100 to 150. Initially it helps but after a few days i get the same problem again.

Does anyone have any ideas on this?

My guess is that somehow the connections are staying and not closing correctly, i have no idea what settings might fix this.

Anyone help?

Captain Joined: Oct 26, 2003 Posts: 553

Are you using persistent connections? If so, don't. There really isn't a need.

- Virgil