竹貓星球

tseesther 寫:有mysql那邊的語法未執行？

可以的話請附上安裝檔

DEBUG MODE 

SQL Error : 1146 Table 'jerry691017.color_groups_table' doesn't exist 

SELECT group_id, group_name FROM COLOR_GROUPS_TABLE 

Line : 145 
File : admin_color_groups.php

jerry6983 寫:安裝完出現下列錯誤:

代碼: 選擇全部

從會員資料中發生資料查詢錯誤

DEBUG MODE

SQL Error : 1146 Table 'jerry691017.color_groups_table' doesn't exist

SELECT group_id, group_name FROM[color=red], [/color]COLOR_GROUPS_TABLE

Line : 145
File : admin_color_groups.php

請問各位大大是那裡出錯??

jerry6983 寫:The working status of your phpBB version with this mod is unknown. It may or may not work correctly. If it is higher than 2.0.5 it will probably work, but no guarantees.


Found phpbb root path at ./.
Using sql queue list file nivisec_schema/install.sql.
Found php version 4.3.8.
Found phpbb version 2.0.14.


[FAILED] :: CREATE TABLE `phpbb_color_groups` ( `group_id` mediumint(8) unsigned NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_color` varchar(50) NOT NULL default '', PRIMARY KEY (`group_id`), UNIQUE KEY `group_name` (`group_name`) ) TYPE=MyISAM
Reason:Table 'phpbb_color_groups' already exists
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[FAILED] :: ALTER TABLE `phpbb_users` ADD `user_color_group` MEDIUMINT UNSIGNED NOT NULL
Reason:Duplicate column name 'user_color_group'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[OK] :: ALTER TABLE `phpbb_color_groups` ADD `hidden` TINYINT( 1 ) DEFAULT '0' NOT NULL

[OK] :: ALTER TABLE `phpbb_color_groups` ADD `order_num` MEDIUMINT NOT NULL

[FAILED] :: ALTER TABLE `phpbb_groups` ADD `group_color_group` MEDIUMINT UNSIGNED NOT NULL
Reason:Duplicate column name 'group_color_group'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.


Please delete this file (nivisec_install.php) and nivisec_schema/*.* for security reasons!

tseesther 寫:

jerry6983 寫:The working status of your phpBB version with this mod is unknown. It may or may not work correctly. If it is higher than 2.0.5 it will probably work, but no guarantees.


Found phpbb root path at ./.
Using sql queue list file nivisec_schema/install.sql.
Found php version 4.3.8.
Found phpbb version 2.0.14.


[FAILED] :: CREATE TABLE `phpbb_color_groups` ( `group_id` mediumint(8) unsigned NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_color` varchar(50) NOT NULL default '', PRIMARY KEY (`group_id`), UNIQUE KEY `group_name` (`group_name`) ) TYPE=MyISAM
Reason:Table 'phpbb_color_groups' already exists
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[FAILED] :: ALTER TABLE `phpbb_users` ADD `user_color_group` MEDIUMINT UNSIGNED NOT NULL
Reason:Duplicate column name 'user_color_group'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.

[OK] :: ALTER TABLE `phpbb_color_groups` ADD `hidden` TINYINT( 1 ) DEFAULT '0' NOT NULL

[OK] :: ALTER TABLE `phpbb_color_groups` ADD `order_num` MEDIUMINT NOT NULL

[FAILED] :: ALTER TABLE `phpbb_groups` ADD `group_color_group` MEDIUMINT UNSIGNED NOT NULL
Reason:Duplicate column name 'group_color_group'
Analysis:This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.


Please delete this file (nivisec_install.php) and nivisec_schema/*.* for security reasons!

忘了問.....
以上這段出現是你第一次裝已有？還是你重覆執行nivisec_install才出現？

tseesther 寫:如果第一次裝已有就奇怪了......

它說其中有幾項之前已有所以建立失敗.... 但你說這是第一次裝呢.....

或許你之前曾經裝過類似的外掛？？或嘗試裝過沒有成功但又沒有移除已修改的東西.........

sql那邊它說有幾項是失敗，你看看是否可以把它們移除(想想有沒有其他外掛是需要它們)然後再裝過:

- phpbb_color_groups
- phpbb_users 裡的 user_color_group
- phpbb_groups 裡的 group_color_group