phpBB Smith: I'm back.

Author	Message
nza Member
Sun Aug 06, 2006 2:19 am Post subject: I'm back.
Its been awhile and I should thank you for the help with the template mod. Unfortunately some other things happened and I got rid of that board. That is irrelevant, however. I finally got around to re-installing Prillian and the install went just fine. Everything looked good but I did the install on a test forum and I let the session expire before I got the chance to setup a second account to test it. Anyways the session expired and now I get this; "phpBB : Critical Error Error doing DB query userdata row fetch DEBUG MODE SQL Error : 1146 Table 'pldhtest.SESSIONS_KEYS_TABLE' doesn't exist SELECT u.* FROM phpbb_users u, SESSIONS_KEYS_TABLE k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = 'af79e81abc59d037b54eaf77f41db5bc' Line : 89 File : /home/content/b/z/r/bzrjbod/html/pldhtest/pldhtestforums/includes/sessions.php" I'm completely un-familiar with MySQL and my guess is this problem involves making a new table? That message is displayed on the test forum's home page, I can't access ACP either. Many thanks and Cheers.

Thoul Administrator
Mon Aug 07, 2006 12:44 am Post subject: re: I'm back.
In this case, the problem indicates that there is a missing or disabled table name definition in includes/constants.php. Look in that file for a line that begins with define('SESSIONS_KEYS_TABLE', $table_prefix. I don't have the code handy at the moment so I can't give you the full line, but that should let you find it if the line is present. If you find that line and there is anything before "define", move "define" and everything after it to a new line just below. If the line isn't present, then you'll need to add it. Get a fresh, unedited copy of includes/constants.php from the latest version of phpBB and grab the full line from that.

nza Member
Tue Aug 08, 2006 12:18 am Post subject:
Well I added that line under the Sessions table line because it was missing from the code entirely. Now I'm getting this; Fatal error: Call to undefined function: dss_rand() in /home/content/b/z/r/bzrjbod/html/pldhtest/pldhtestforums/includes/sessions.php on line 180

Thoul Administrator
Tue Aug 08, 2006 10:41 am Post subject: re: I'm back.
Ok, that means that you're missing some code in includes/functions.php. In that file, find: Code: // // Get Userdata, $user can be username or user_id. If force_str is true, the username will be forced. // Before it, add: Code: /** * Our own generator of random values * This uses a constantly changing value as the base for generating the values * The board wide setting is updated once per page if this code is called * With thanks to Anthrax101 for the inspiration on this one * Added in phpBB 2.0.20 */ function dss_rand() { global $db, $board_config, $dss_seeded; $val = $board_config['rand_seed'] . microtime(); $val = md5($val); $board_config['rand_seed'] = md5($board_config['rand_seed'] . $val . 'a'); if($dss_seeded !== true) { $sql = "UPDATE " . CONFIG_TABLE . " SET config_value = '" . $board_config['rand_seed'] . "' WHERE config_name = 'rand_seed'"; if( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, "Unable to reseed PRNG", "", __LINE__, __FILE__, $sql); } $dss_seeded = true; } return substr($val, 4, 16); }

nza Member
Thu Aug 10, 2006 2:21 am Post subject:
Thanks that worked. Ok well that fixed all the kinks so I moved everything over to main board and that went well, as for as board function is concerned. However when clicking "Launch Prillian" I get this in the pop-up, "Template->make_filename(): Error - file prillian/frameset.tpl does not exist" Now that file does exist in phpbb root/templates/subSilver/Prillian so I'm not sure what is wrong.

Thoul Administrator
Thu Aug 10, 2006 5:25 am Post subject: re: I'm back.
Make sure it's templates/subSilver/prillian, with a lowercase p. This path is case sensitive, so if it's subSilver/Prillian, you would get that error.

nza Member
Thu Aug 10, 2006 7:45 am Post subject:
The path does have the directory in all lowercase. My mistake typing it capitalized. Any other ideas?

Thoul Administrator
Thu Aug 10, 2006 4:59 pm Post subject: re: I'm back.
Try reuploading the .tpl file; it could be corrupt. If subSilver isn't the only template installed, copy the subSilver/prillian directory to the other templates. Those are the typical causes of problems like this.

Sun Aug 06, 2006 2:19 am Post subject: I'm back.

Its been awhile and I should thank you for the help with the template mod.

Unfortunately some other things happened and I got rid of that board. That is irrelevant, however.

I finally got around to re-installing Prillian and the install went just fine. Everything looked good but I did the install on a test forum and I let the session expire before I got the chance to setup a second account to test it. Anyways the session expired and now I get this;

"phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1146 Table 'pldhtest.SESSIONS_KEYS_TABLE' doesn't exist

SELECT u.* FROM phpbb_users u, SESSIONS_KEYS_TABLE k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = 'af79e81abc59d037b54eaf77f41db5bc'

Line : 89
File : /home/content/b/z/r/bzrjbod/html/pldhtest/pldhtestforums/includes/sessions.php"

I'm completely un-familiar with MySQL and my guess is this problem involves making a new table? That message is displayed on the test forum's home page, I can't access ACP either.

Many thanks and Cheers.

Mon Aug 07, 2006 12:44 am Post subject: re: I'm back.

In this case, the problem indicates that there is a missing or disabled table name definition in includes/constants.php. Look in that file for a line that begins with define('SESSIONS_KEYS_TABLE', $table_prefix. I don't have the code handy at the moment so I can't give you the full line, but that should let you find it if the line is present.

If you find that line and there is anything before "define", move "define" and everything after it to a new line just below.

If the line isn't present, then you'll need to add it. Get a fresh, unedited copy of includes/constants.php from the latest version of phpBB and grab the full line from that.

Tue Aug 08, 2006 12:18 am Post subject:

Well I added that line under the Sessions table line because it was missing from the code entirely.

Now I'm getting this;

Fatal error: Call to undefined function: dss_rand() in /home/content/b/z/r/bzrjbod/html/pldhtest/pldhtestforums/includes/sessions.php on line 180

Tue Aug 08, 2006 10:41 am Post subject: re: I'm back.

Ok, that means that you're missing some code in includes/functions.php. In that file, find:

Code:

//
// Get Userdata, $user can be username or user_id. If force_str is true, the username will be forced.
//

Before it, add:

Code:

/**
* Our own generator of random values
* This uses a constantly changing value as the base for generating the values
* The board wide setting is updated once per page if this code is called
* With thanks to Anthrax101 for the inspiration on this one
* Added in phpBB 2.0.20
*/
function dss_rand()
{
global $db, $board_config, $dss_seeded;

$val = $board_config['rand_seed'] . microtime();
$val = md5($val);
$board_config['rand_seed'] = md5($board_config['rand_seed'] . $val . 'a');

if($dss_seeded !== true)
{
   $sql = "UPDATE " . CONFIG_TABLE . " SET
      config_value = '" . $board_config['rand_seed'] . "'
      WHERE config_name = 'rand_seed'";

   if( !$db->sql_query($sql) )
   {
      message_die(GENERAL_ERROR, "Unable to reseed PRNG", "", __LINE__, __FILE__, $sql);
   }

   $dss_seeded = true;
}

return substr($val, 4, 16);
}

Thu Aug 10, 2006 2:21 am Post subject:

Thanks that worked. Ok well that fixed all the kinks so I moved everything over to main board and that went well, as for as board function is concerned.

However when clicking "Launch Prillian" I get this in the pop-up,

"Template->make_filename(): Error - file prillian/frameset.tpl does not exist"

Now that file does exist in phpbb root/templates/subSilver/Prillian so I'm not sure what is wrong.

Thu Aug 10, 2006 5:25 am Post subject: re: I'm back.

Make sure it's templates/subSilver/prillian, with a lowercase p. This path is case sensitive, so if it's subSilver/Prillian, you would get that error.

Thu Aug 10, 2006 7:45 am Post subject:

The path does have the directory in all lowercase. My mistake typing it capitalized. Any other ideas?

Thu Aug 10, 2006 4:59 pm Post subject: re: I'm back.

Try reuploading the .tpl file; it could be corrupt. If subSilver isn't the only template installed, copy the subSilver/prillian directory to the other templates. Those are the typical causes of problems like this.