吉川拓也 寫:你沒執行內附的 sql 執行檔案 ..
所以顯示欄位不存在程式無法運作所致 ..
吉川拓也大大,內附的 sql 執行檔案不知在哪裡?如何執行?感謝您!!!
以下是 C:\AppServ\www\phpBB2\install\schemas\attach_mysql_schema.sql (這些應是來自mod的錯誤?煩請幫我debug!謝謝啦!)
資料庫 mysql 在 localhost 執行
錯誤
SQL 語法 :
/* phpBB2 - attach_mod schema - mssql $Id: attach_mssql_schema.sql,v 1.3 2003/01/29 11:43:58 acydburn Exp $ */ BEGIN TRANSACTIONGO CREATE TABLE [phpbb_attachments_config](
[config_name][varchar]( 100 ) NOT NULL ,
[config_value][varchar]( 100 ) NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_forbidden_extensions](
[ext_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[extension][char]( 100 ) NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_extension_groups](
[group_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[group_name][char]( 20 ) NOT NULL ,
[cat_id][tinyint] NOT NULL ,
[allow_group][tinyint] NOT NULL ,
[download_mode][tinyint] NOT NULL ,
[upload_icon][varchar]( 100 ) NOT NULL ,
[max_filesize][int] NOT NULL ,
[forum_permissions][varchar]( 255 ) NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_extensions](
[ext_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[group_id][int] NOT NULL ,
[extension][varchar]( 100 ) NOT NULL ,
[ COMMENT ][varchar]( 100 ) NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_attachments_desc](
[attach_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[physical_filename][varchar]( 100 ) NOT NULL ,
[real_filename][varchar]( 100 ) NOT NULL ,
[download_count][int] NOT NULL ,
[ COMMENT ][varchar]( 100 ) NULL ,
[extension][varchar]( 100 ) NULL ,
[mimetype][varchar]( 50 ) NULL ,
[filesize][int] NOT NULL ,
[filetime][int] NOT NULL ,
[thumbnail][tinyint] NOT NULL
) ON [ PRIMARY ]GO CREATE TABLE [phpbb_attachments](
[attach_id][int] NOT NULL ,
[post_id][int] NOT NULL ,
[privmsgs_id][int] NOT NULL ,
[user_id_1][int] NOT NULL ,
[user_id_2][int] NOT NULL
)GO CREATE TABLE [phpbb_quota_limits](
[quota_limit_id][int]IDENTITY( 1, 1 ) NOT NULL ,
[quota_desc][varchar]( 20 ) NOT NULL ,
[quota_limit][bigint] NOT NULL
) ON [ PRIMARY ]
MySQL 傳回：
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRANSACTION
GO
CREATE TABLE [phpbb_attachments_config] (
[說明文件] · [回上一頁]
修改如下:
#
http://localhost/phpmyAdmin/ to create phpbb database and it's following tables
#select phpbb database and sql tag , put all the text to create the following tables
#
# phpBB2 - attach_mod schema
#
# $Id: attach_mysql_schema.sql,v 1.2 2003/01/29 11:43:58 acydburn Exp $
#
#
# Table structure for table 'phpbb_attachments_config'
#
CREATE TABLE phpbb_attachments_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name)
);
#
# Table structure for table 'phpbb_forbidden_extensions'
#
CREATE TABLE phpbb_forbidden_extensions (
ext_id mediumint(8) UNSIGNED NOT NULL auto_increment,
extension varchar(100) NOT NULL,
PRIMARY KEY (ext_id)
);
#
# Table structure for table 'phpbb_extension_groups'
#
CREATE TABLE phpbb_extension_groups (
group_id mediumint(8) NOT NULL auto_increment,
group_name char(20) NOT NULL,
cat_id tinyint(2) DEFAULT '0' NOT NULL,
allow_group tinyint(1) DEFAULT '0' NOT NULL,
download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
upload_icon varchar(100) DEFAULT '',
max_filesize int(20) DEFAULT '0' NOT NULL,
forum_permissions varchar(255) default '' NOT NULL,
PRIMARY KEY group_id (group_id)
);
#
# Table structure for table 'phpbb_extensions'
#
CREATE TABLE phpbb_extensions (
ext_id mediumint(8) UNSIGNED NOT NULL auto_increment,
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
extension varchar(100) NOT NULL,
comment varchar(100),
PRIMARY KEY ext_id (ext_id)
);
#
# Table structure for table 'phpbb_attachments_desc'
#
CREATE TABLE phpbb_attachments_desc (
attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
physical_filename varchar(255) NOT NULL,
real_filename varchar(255) NOT NULL,
download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
comment varchar(255),
extension varchar(100),
mimetype varchar(100),
filesize int(20) NOT NULL,
filetime int(11) DEFAULT '0' NOT NULL,
thumbnail tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (attach_id),
KEY filetime (filetime),
KEY physical_filename (physical_filename(10)),
KEY filesize (filesize)
);
#
# Table structure for table 'phpbb_attachments'
#
CREATE TABLE phpbb_attachments (
attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_id_1 mediumint(8) NOT NULL,
user_id_2 mediumint(8) NOT NULL,
KEY attach_id_post_id (attach_id, post_id),
KEY attach_id_privmsgs_id (attach_id, privmsgs_id)
);
#
# Table structure for table 'phpbb_quota_limits'
#
CREATE TABLE phpbb_quota_limits (
quota_limit_id mediumint(8) unsigned NOT NULL auto_increment,
quota_desc varchar(20) NOT NULL default '',
quota_limit bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (quota_limit_id)
);
#
# Table structure for table 'phpbb_attach_quota'
#
CREATE TABLE phpbb_attach_quota (
user_id mediumint(8) unsigned NOT NULL default '0',
group_id mediumint(8) unsigned NOT NULL default '0',
quota_type smallint(2) NOT NULL default '0',
quota_limit_id mediumint(8) unsigned NOT NULL default '0',
KEY quota_type (quota_type)
);
ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL;
論壇無法 附加檔案 ?
換了另一個mod卻是附加了但無法下載!
ps.訊息如下:
一般錯誤
選擇的附加檔案再也不存在了。
404 File Not Found: The File no2.zip does not exist.
Fatal error: Call to undefined function: is_imagick() in c:\appserv\www\phpbb2\admin\admin_attachments.php on line 874
Fatal error: Call to undefined function: get_var() in c:\appserv\www\phpbb2\admin\admin_extensions.php on line 539
如有發錯區,煩請版大處理.
)