[問題]安裝Questionary/問卷調查又失敗

[jeffyuan]

問題外掛：Questionary/問卷調查\r
參考連結：http://phpbb-tw.net/phpbb/viewtopic.php?t=40771
使用版本：phpBB 2.0.17
網站位置：http://www.j-kst.com
狀況描述：
控制台出現以下畫面~sql選項
Critical Error!
message_die() was called multiple times.
Error #1
Could not query data

Line : 163
File : c:\appserv\www\phpbb2\admin\admin_questionary.php
SQL : CREATE TABLE questionary ( questionary_id int(11) NOT NULL auto_increment, questionary_active tinyint(1) NOT NULL default '0', questionary_time int(11) NOT NULL default '0', questionary_user_id mediumint(8) NOT NULL default '0', questionary_level tinyint(1) NOT NULL default '0', questionary_type tinyint(1) NOT NULL default '0', questionary_value int(11) NOT NULL default '0', questionary_record int(11) NOT NULL default '0', questionary_begin_time int(11) NOT NULL default '0', questionary_end_time int(11) NOT NULL default '0', questionary_announce_time int(11) NOT NULL default '0', questionary_title varchar(255) NOT NULL default '', questionary_desc text, PRIMARY KEY (questionary_id) ) TYPE=MyISAM;
Please, contact the webmaster. Thank you.

且按問卷調查進行後進論壇時會出現:
ritical Error!
message_die() was called multiple times.
Error #1
我願意參與問卷活動！
不了，我不想填寫。
等下次再填吧！

Please, contact the webmaster. Thank you.
請問是那有錯呢?

[shihchieh]

唔，先別激動......

控制台出現以下畫面~sql選項

你先試試把admin_questionary.php

中sql的部份 在create table的語法中把 TYPE=MyISAM;的TYPE=MyISAM;去掉看看，等會我會在測試一次\r

ps:
為便於問題集中處理，請在原發表的文章內給予支持，謝謝
另外，ｓｑｌ的問題我已初步解決，請再試試

[lama1]

按著說明小心地安裝了questionary,

在acp怎樣也跑不來, 當加入新的問卷調查, [送出]時出error "could not query data46"....

我調查過admin_questionary當中的code, 發生在 行821中...求教各位大大

代碼: 選擇全部

			case 'questionary':	
			default:
				$template->assign_block_vars('questionary',array(
					"TITLE" => $lang['Questionary_Mana_Questionary'],
					"EXPLAIN" => $lang['Questionary_Mana_Questionary_Explain'],
					
					'L_QUESTIONARYS' => $lang['Questionarys'],
					'L_QUESTIONARY_MESSAGE' => $lang['Message']
				));

				$sql = "SELECT q.*, u.username, COUNT(i.item_id) AS questionary_items, COUNT(s.sub_id) AS questionary_subs, COUNT(r.record_id) AS questionary_records 
					FROM ((( questionary q, phpbb2plus_users u 
						LEFT JOIN questionary_item i ON i.item_questionary_id = q.questionary_id ) 
						LEFT JOIN questionary_item_sub s ON s.sub_questionary_id = q.questionary_id ) 
						LEFT JOIN questionary_record r ON r.record_questionary_id = q.questionary_id ) 
					WHERE q.questionary_user_id = u.user_id 
					GROUP BY q.questionary_id 
					ORDER BY q.questionary_id";
				if( !($result = $db->sql_query($sql)) )
					message_die(GENERAL_ERROR, 'Could not query data46', '', __LINE__, __FILE__, $sql);
				while( $row = $db->sql_fetchrow($result) )
				{

節錄如上, 我特意將所有"Could not query data46"個別加上數字, 方便debug....資料庫的prefix是phpbb2plus, 所以我也把所有phpbb_users 改成phpbb2plus_users....

本人來自香港, 若表達有點不通, 見諒!!

[shihchieh]

你可能....資料表還沒建立...

(1)將docs/questionary/*.sql 匯入資料庫
(2)後台的questionary/sql mana 建立資料表