竹貓星球

phpBB : Critical Error
Error updating sessions table
DEBUG MODE
SQL Error : 1054 Unknown column 'PAGE_LINKS' in 'field list'
UPDATE phpbb_sessions SET session_time = 1066664659, session_page = PAGE_LINKS WHERE session_id = '222ff182923052dfc3ff08f6aade061d'
Line : 267
File : /home/forum/public_html/includes/sessions.php

Could not query link categories list

DEBUG MODE

SQL Error : 1146 Table 'forumsql.LINK_CATEGORIES_TABLE' doesn't exist

SELECT cat_id, cat_title FROM LINK_CATEGORIES_TABLE ORDER BY cat_order

Line : 106
File : /home/forum/public_html/links.php

#
# Table structure for table `phpbb_link_categories`
#
CREATE TABLE phpbb_link_categories (
cat_id mediumint(8) unsigned NOT NULL auto_increment,
cat_title varchar(100) NOT NULL default '',
cat_order mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
) TYPE=MyISAM;
#
# Dumping data for table `phpbb_link_categories`
#
INSERT INTO phpbb_link_categories VALUES (1, '藝術文化', 1);
INSERT INTO phpbb_link_categories VALUES (2, '商業金融', 2);
INSERT INTO phpbb_link_categories VALUES (3, '生活資訊', 3);
INSERT INTO phpbb_link_categories VALUES (4, '電腦通訊', 4);
INSERT INTO phpbb_link_categories VALUES (5, '視聽休閒', 5);
INSERT INTO phpbb_link_categories VALUES (6, '醫療保健', 6);
INSERT INTO phpbb_link_categories VALUES (7, '運動體育', 7);
INSERT INTO phpbb_link_categories VALUES (8, '教育學習', 8);
INSERT INTO phpbb_link_categories VALUES (9, '其他類型', 9);
#(Note. The back-end of category manage wasn't done yet, so you have to manually insert or edit the category)
#
# Table structure for table `phpbb_links`
#
CREATE TABLE phpbb_links (
link_id mediumint(8) unsigned NOT NULL auto_increment,
link_title varchar(100) NOT NULL default '',
link_desc varchar(255) default NULL,
link_category mediumint(8) unsigned NOT NULL default '0',
link_url varchar(100) NOT NULL default '',
link_logo_src varchar(120) default NULL,
link_joined int(11) NOT NULL default '0',
link_active tinyint(1) NOT NULL default '0',
link_hits int(10) unsigned NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
user_ip varchar(8) NOT NULL default '',
last_user_ip varchar(8) NOT NULL default '',
PRIMARY KEY (link_id)
) TYPE=MyISAM;
#
# Dumping data for table `phpbb_links`
#
INSERT INTO phpbb_links VALUES (1, 'phpBB Official Website', 'Official phpBB Website', 4, 'http://www.phpbb.com/', 'images/links/phpBB_88a.gif', 1019910254, 1, 0, 2, '', '');
INSERT INTO phpbb_links VALUES (2, 'phpbb-tw.net', 'Unofficial phpBB Chinese Support Centre', 4, 'http://phpbb-tw.net', 'images/links/phpbb-tw_logo88a.gif', 1019910254, 1, 0, 2, '', '');

//
// Only update session DB a minute or so after last update
//
if ( $current_time - $userdata['session_time'] > 60 )
{
$sql = "UPDATE " . SESSIONS_TABLE . "
SET session_time = $current_time, session_page = $thispage_id
WHERE session_id = '" . $userdata['session_id'] . "'";
if ( !$db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, 'Error updating sessions table', '', __LINE__, __FILE__, $sql); 第267行
}

if ( $userdata['user_id'] != ANONYMOUS )
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_session_time = $current_time, user_session_page = $thispage_id
WHERE user_id = " . $userdata['user_id'];
if ( !$db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, 'Error updating sessions table', '', __LINE__, __FILE__, $sql);
}
}

#
#-----[ ACTION: OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ ACTION: FIND ]------------------------------------------
#
define('PAGE_TOPIC_OFFSET', 5000);
#
#-----[ ACTION: before ADD ]------------------------------------------
#
#
define('PAGE_LINKS', -14);// Links_MOD
#
#-----[ ACTION: FIND ]------------------------------------------
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
#
#-----[ ACTION: after ADD ]------------------------------------------
#
define('LINKS_TABLE', $table_prefix.'links'); //Links_MOD
define('LINK_CATEGORIES_TABLE', $table_prefix.'link_categories');//Links_MOD
#
#-----[ ACTION: OPEN ]------------------------------------------
#
viewonline.php
#
#-----[ ACTION: FIND ]------------------------------------------
#
case PAGE_FAQ:
$location = $lang['Viewing_FAQ'];
$location_url = "faq.$phpEx";
break;
#
#-----[ ACTION: after ADD ]------------------------------------------
#
case PAGE_LINKS: // Links_MOD
$location = $lang['Site_links'];
$location_url = "links.$phpEx";
break;
#
#-----[ ACTION: OPEN ]------------------------------------------
#
admin/index.php
#
#-----[ ACTION: FIND ]------------------------------------------
#
case PAGE_FAQ:
$location = $lang['Viewing_FAQ'];
$location_url = "index.$phpEx?pane=right";
break;
#
#-----[ ACTION: after ADD ]------------------------------------------
#
case PAGE_LINKS: // Links_MOD
$location = $lang['Site_links'];
$location_url = "index.$phpEx?pane=right";
break;