[問題]安裝 custom_mass_pm_1.4.7em 的錯誤訊息求教[已解決]

[james0215]

問題外掛:custom_mass_pm_1.4.7em
參考連結:http://phpbb-tw.net/phpbb/viewtopic.php ... om+mass+PM

安裝完成後到了後台設定權限出現這樣的訊息,我有對照過367行附近的修改,跟修改說明上沒有發現差異,想請大家幫幫忙......

代碼: 選擇全部

一般錯誤
Could not update group

DEBUG MODE

SQL Error : 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 'WHERE group_id = 28' at line 3

UPDATE phpbb_groups SET group_type = 0, group_name = '版面管理員', group_description = '', group_moderator = 3, group_allow_pm = '5', WHERE group_id = 28

Line : 367
File : admin_groups.php 

我先將367行前後貼上來,如果不夠請告訴我再貼其他,以節省版面....

代碼: 選擇全部

if ( !($result = $db->sql_query($sql)) )
				{
					message_die(GENERAL_ERROR, 'Failed to obtain current group moderator info', '', __LINE__, __FILE__, $sql);
				}

				if ( !($row = $db->sql_fetchrow($result)) )
				{
					$sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)
						VALUES (" . $group_id . ", " . $group_moderator . ", 0)";
					if ( !$db->sql_query($sql) )
					{
						message_die(GENERAL_ERROR, 'Could not update group moderator', '', __LINE__, __FILE__, $sql);
					}
				}
			}

			$sql = "UPDATE " . GROUPS_TABLE . "
				SET group_type = $group_type, group_name = '" . str_replace("\'", "''", $group_name) . "', group_description = '" . str_replace("\'", "''", $group_description) . "', group_moderator = $group_moderator, group_allow_pm = '$group_allow_pm',
				WHERE group_id = $group_id";
			if ( !$db->sql_query($sql) )
			{
	第367行	message_die(GENERAL_ERROR, 'Could not update group', '', __LINE__, __FILE__, $sql);
			}
	
			$message = $lang['Updated_group'] . '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;

			message_die(GENERAL_MESSAGE, $message);
		}
		else if( $mode == 'newgroup' )
		{
			$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user) 
				VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm',	'0')";
			if ( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);\r
			}
			$new_group_id = $db->sql_nextid();

			$sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)
				VALUES ($new_group_id, $group_moderator, 0)";
			if ( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not insert new user-group info', '', __LINE__, __FILE__, $sql);
			}
			
			$message = $lang['Added_new_group'] . '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;

			message_die(GENERAL_MESSAGE, $message);

在此拜託了...........

謝謝

[心靈捕手]

To james0215:

應該是您在加入語法時, 在 WHERE 前面多了一個" ,"
以下的修改試試看:

#
#-----[ Find ]-----
#
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_type = $group_type, group_name = '" . str_replace("\'", "''", $group_name) . "', group_description = '" . str_replace("\'", "''", $group_description) . "', group_moderator = $group_moderator, group_allow_pm = '$group_allow_pm',
WHERE group_id = $group_id";

#
#-----[ Replace With ]-----
#
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_type = $group_type, group_name = '" . str_replace("\'", "''", $group_name) . "', group_description = '" . str_replace("\'", "''", $group_description) . "', group_moderator = $group_moderator, group_allow_pm = '$group_allow_pm'
WHERE group_id = $group_id";

[james0215]

謝謝心靈捕手再一次伸出援手...
我照您上述的位置改了,還是出現錯誤訊息,

代碼: 選擇全部

Could not update group

DEBUG MODE

SQL Error : 1054 Unknown column 'group_allow_pm' in 'field list'

UPDATE phpbb_groups SET group_type = 0, group_name = '版面管理員', group_description = '', group_moderator = 3, group_allow_pm = '2' WHERE group_id = 28

Line : 367
File : admin_groups.php

只是原本的這個

代碼: 選擇全部

SQL Error : 1064 Unknown

與後來的有點變化

代碼: 選擇全部

SQL Error : 1054 Unknown

我猜應改跟修改下列這部份有關吧\r

#
#-----[ FIND ]------------------------------------------------
#
$sql = "INSERT INTO " . GROUPS_TABLE
VALUES (

#
#-----[ IN-LINE FIND ]----------------------------------------
#
, group_moderator

#
#-----[ IN-LINE AFTER, ADD ]----------------------------------
#
, group_allow_pm

#
#-----[ IN-LINE FIND ]----------------------------------------
#
, $group_moderator

#
#-----[ IN-LINE AFTER, ADD ]----------------------------------
#
, '$group_allow_pm'

請您再幫我看一看好嗎....
謝謝

[~倉木麻衣~]

謝謝心靈捕手再一次伸出援手...
我照您上述的位置改了,還是出現錯誤訊息,

Could not update group

DEBUG MODE

SQL Error : 1054 Unknown column 'group_allow_pm' in 'field list'

UPDATE phpbb_groups SET group_type = 0, group_name = '版面管理員', group_description = '', group_moderator = 3, group_allow_pm = '2' WHERE group_id = 28

Line : 367
File : admin_groups.php

未知的欄位名稱 group_allow_pm
你沒執行必要的SQL變更檔吧

[james0215]

哎呀呀....改碼改到昏頭\r
竟然檔案copy了卻在最後遺忘了前頭看過這樣的內容

## 1.1 SQL commands are not performed
## -----------
## This MOD need a database update.
## Then, in any case if you install this MOD manually or using
## an alpha release of EM, please copying the *_db_update.php
## in your phpBB root directory, run it with your navigator,
## and then delete it from the phpBB root directory.

真是疏忽了...該罰
我先喝三杯致歉兩位......