Real time stats - mysql error

New Member Joined: Jun 19, 2003 Posts: 5

Have installed and activated but within the block I get this error

Quote:

MySQL said Table 'nuke.nuke_session' doesn't exist

Any Ideas

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

If you look at your MySQL databse, using phpMyAdmin, do you have a nuke.nuke_session table?

Posted: Sun Jun 22, 2003 6:14 am

Sorry Raven, I should have mentioned in the original post, yes the nuke_session table does exist. But the Database is not titled "Nuke" it is titled "phpnuke" hence I would assume the script is looking for nuke.nuke_session and it needs to look for php.nuke_session, correct?? If so how do I fix this?? Thanks for advice in advance.

Posted: Sun Jun 22, 2003 9:55 am

The script uses what is in the $prefix variable in the config.php file, or at least that's what I recall. What is the $prefix value set to?

Posted: Mon Jun 23, 2003 3:45 pm

mmm, from .root/config.php file -

Quote:

$dbhost = "localhost";
$dbuname = "root";
$dbpass = "xxxxxx";
$dbname = "phpnuke";
$prefix = "nuke";
$user_prefix = "nuke";

Does this make things clearer Question

Posted: Mon Jun 23, 2003 4:04 pm

What version of nuke are you running?

Posted: Mon Jun 23, 2003 5:05 pm

PHPnuke 6.5
PHP 4.3.1.1
Mysql 4.0.12

Posted: Mon Jun 23, 2003 6:10 pm

One more time Embarassed

Change all instances of

$prefix.nuke

to

".$dbname.".".$prefix."

Include the quote marks.

Posted: Tue Jun 24, 2003 2:12 am

Thanks Raven, thats got it. Very Happy

Thats kind of where I was going in my second post but couldn't get it to find the database.

Thanks for your time and better still the solution.