參考連結：(Flash Paint)
使用版本：(phpBB 2.0.4)
網站位置：
狀況描述：
我正想安裝 Flash Paint .. 已把 dat upload 上指定位置\r
跟 readme 先行 Mod Db，好可惜出現 err ...
已了解過是可能 Password 權限問題，WebHost 都幫不上忙
不如何才可以 update 有關之 db
一行 db 時出現 err ... 用 phpMyAdmin-2.5.6 手動一句句加都不可以 ..
Could not update db.
DEBUG MODE
SQL Error : 1044 Access denied for user: 'hkwei@localhost' to database 'hkwei_phpbb'
ALTER TABLE phpbb_posts_text ADD `post_fpdata` LONGTEXT NOT NULL
Line : 20
File : /home/hkwei/public_html/phpBB2/fp_db_install.php
用手動加一樣 err
資料庫 hkwei_phpbb 在 localhost 執行
錯誤
SQL 語法 :
"INSERT INTO ".CONFIG_TABLE. " (`config_name`, `config_value`) VALUES ('flash_paint', '0|0|640|480|340|280')", "ALTER TABLE ".POSTS_TEXT_TABLE. " ADD `post_fpdata` LONGTEXT NOT NULL", "ALTER TABLE ".TOPICS_TABLE. " ADD `topic_flashpaint` TINYINT(1) NOT NULL", "ALTER TABLE ".POSTS_TABLE. " ADD `post_flashpaint` TINYINT(1) NOT NULL", "ALTER TABLE ".FORUMS_TABLE. " ADD `auth_flashpaint_post` TINYINT(2) NOT NULL", "ALTER TABLE ".FORUMS_TABLE. " ADD `auth_flashpaint_view` TINYINT(2) NOT NULL", "ALTER TABLE ".AUTH_ACCESS_TABLE. " ADD `auth_flashpaint_post` TINYINT(1) NOT NULL", "ALTER TABLE ".AUTH_ACCESS_TABLE. " ADD `auth_flashpaint_view` TINYINT(1) NOT NULL"
)
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 '"INSERT INTO ".CONFIG_TABLE. " (`config_name`, `config_value`)
原 file 係
代碼: 選擇全部
<?php
define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<style>
<!--
body { font-family: arial; font-size: 9pt; line-height: 1.5em; }
pre { color:#000000; background:#FFF9D8; }
pre.fnd { color:#000000; background:#E6E6E6; }
b { font-size: 9pt; font-weight: bold; color:#008800; }
.title { font-size: 12pt; font-weight: bold; }
.cmd { color:#0000FF; }
.g { color:#00FF00; }
.r { color:#FF0000; }
//-->
</style>
</head>
<body bgcolor="#FEFEFE">
<span class="title">Flash Paint Mod DB Installation</span><p>
<?php
$sql = array(
"INSERT INTO " . CONFIG_TABLE . " (`config_name`, `config_value`) VALUES ('flash_paint', '0|0|640|480|340|280')",
"ALTER TABLE " . POSTS_TEXT_TABLE . " ADD `post_fpdata` LONGTEXT NOT NULL",
"ALTER TABLE " . TOPICS_TABLE . " ADD `topic_flashpaint` TINYINT(1) NOT NULL",
"ALTER TABLE " . POSTS_TABLE . " ADD `post_flashpaint` TINYINT(1) NOT NULL",
"ALTER TABLE " . FORUMS_TABLE . " ADD `auth_flashpaint_post` TINYINT(2) NOT NULL",
"ALTER TABLE " . FORUMS_TABLE . " ADD `auth_flashpaint_view` TINYINT(2) NOT NULL",
"ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD `auth_flashpaint_post` TINYINT(1) NOT NULL",
"ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD `auth_flashpaint_view` TINYINT(1) NOT NULL"
);
for ($i=0; $i<count($sql); $i++)
{
if ( !($db->sql_query($sql[$i])) )
{
message_die(GENERAL_ERROR, 'Could not update db.', '', __LINE__, __FILE__, $sql[$i]);
}
else
{
echo "<b>DB SCRIPT($i).......DONE</b><BR>";
}
}
?>
<p>
<span class="title">You may now remove this file.</span>
</body>
</html>
