Bei der Installation des Mod shmk_user_feedback_1.0.6 tritt bei der Datenbankinstallation folgender Fehler auf.
Create Table Befehl:
Code: Alles auswählen
CREATE TABLE phpbb_shmk_feedback_tot (
fb_user smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
fb_pos smallint(4) DEFAULT '0' NOT NULL,
fb_neg smallint(4) DEFAULT '0' NOT NULL,
fb_neu smallint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (fb_user)
) COLLATE utf8_bin;
CREATE TABLE phpbb_shmk_feedback (
fb_id mediumint(8) UNSIGNED NOT NULL auto_increment,
fb_to mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
fb_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
fb_role tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
fb_vote tinyint(1) UNSIGNED DEFAULT '2' NOT NULL,
fb_link mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
fb_comment text NOT NULL,
fb_ip varchar(40) DEFAULT '' NOT NULL,
fb_date int(11) UNSIGNED DEFAULT '0' NOT NULL,
bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
bbcode_uid varchar(8) DEFAULT '' NOT NULL,
PRIMARY KEY (fb_id),
KEY fb_to (fb_to)
) COLLATE utf8_bin;
CREATE TABLE phpbb_shmk_feedback_config (
fb_config varchar(255) DEFAULT '' NOT NULL,
fb_config_val varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (fb_config)
) COLLATE utf8_bin;
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_minchars','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_maxchars','500');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_bbcode','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_smilies','1');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('comm_url','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_enable','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_force','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_force_in','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('link_forum','');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('m_haspower','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('role_enable','1');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('top_best','50');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('top_main','10');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('top_worst','50');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('u_canedit','1');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('u_morethenone','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('antiflood','0');
INSERT INTO phpbb_shmk_feedback_config(fb_config,fb_config_val) VALUES('antiflood_same','0');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score','0','1');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score_pos','1','1');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score_neu','0','1');
INSERT INTO phpbb_config(config_name,config_value,is_dynamic) VALUES('fb_score_neg','-1','1');
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_access',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_add',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_edit',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_delete',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_addmore',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_ignoreflood',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_bbcode',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('u_fb_smilies',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('m_fb_edit',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('m_fb_delete',1,0,0);
INSERT INTO phpbb_acl_options(auth_option,is_global,is_local,founder_only) VALUES('m_fb_viewip',1,0,0);
Code: Alles auswählen
SQL-Befehl:
INSERT INTO phpbb_config( config_name, config_value, is_dynamic )
VALUES (
'fb_score', '0', '1'
);
MySQL meldet: Dokumentation
#1146 - Table 'usr_web304_1.phpbb_config' doesn't exist SQL ERROR [ mysqli ]
Table 'usr_web304_1.SHMK_FEEDBACKCONFIG_TABLE' doesn't exist [1146] "Also ohne Underscore"
SQL
SELECT * FROM SHMK_FEEDBACKCONFIG_TABLE
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/acp/acp_feedback.php
LINE: 41
CALL: dbal_mysqli->sql_query()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_feedback->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
_______________________________________________________
Tables wurden aber angelegt!
) und mir aus der Klemme helfen, da ich diesen Mod dringend brauchen würde. Ich stelle alles zur Verfügung, was gebraucht wird.
