[SOLVED]Header and footer random error messages after 2.0.20

[jrubio]

I have no idea wether these errors are related to the update, but they did start right after we updated from 2.0.19 to 2.0.20 we used changed files only. I use subsilver template . If I refresh these messages disappear. Someone , please point me in the right direction.

Error messages in the header section:

Code: Select all

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SESSIONS_KEYS_TABLE'., SQL state S0002 in SQLExecDirect in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\sessions.php on line 366

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\sessions.php on line 367

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 475

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 477

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 478


Error messages in the footer:

Code: Select all

PHP Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SESSIONS_KEYS_TABLE'., SQL state S0002 in SQLExecDirect in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php on line 171 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\sessions.php on line 366 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\sessions.php on line 367 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 475 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 477 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 478 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in Unknown on line 0 PHP Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in Unknown on line 0

[argus]

I'm not a mssql user, so I'm not familiar with their errors, but it looks like SESSIONS_KEYS_TABLE hasn't been defined.

Have you had a look at this: http://www.phpbb.com/phpBB/viewtopic.php?t=381261

[jrubio]

I will try this , and post with the results, Thank You.

[PizzaMan79]

I luv open source. Thanx a lot.

Couldn't they change this in the update files? I'm sure that would save a lot of admins a little annoyance

[jrubio]

open /includes/constants.php and find

Code: Select all

define('SESSIONS_TABLE', $table_prefix.'sessions');

AFTER ADD,

Code: Select all

define('SESSIONS_KEYS_TABLE', $table_prefix.'sessions_keys');

save and upload

this definitely solved the problem, Thank You.

[argus]

Glad it worked!