[問題] 彩色群組的問題(以解決)

[jerry6983]

安裝完出現下列錯誤:

代碼: 選擇全部

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

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

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

[tseesther]

有mysql那邊的語法未執行？

可以的話請附上安裝檔

[jerry6983]

有mysql那邊的語法未執行？

可以的話請附上安裝檔

我確定有執行"nivisec_install.php"這個檔案
但是到後台要執行彩色群組時卻出現下列問題:
從會員資料中發生資料查詢錯誤

代碼: 選擇全部

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

我附上原來安裝的檔案請大大幫我看看! 謝謝!!
http://jerry6983.myweb.hinet.net/color_groups.zip

[Man520]

安裝完出現下列錯誤:

代碼: 選擇全部

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

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]

mysql那邊應該是裝好的

請檢查 jerry691017這個group是否存在或有問題？

[tseesther]

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才出現？

[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才出現？

第一次裝就有了,我想自己手動安裝sql也沒無法成功

[tseesther]

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

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

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

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

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

[jerry6983]

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

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

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

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

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

自行解決了!!謝謝大大的回覆!