phpBB.de

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

Duplicate entry 'user_reminder_enable' for key 1 [1062]

SQL

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('user_reminder_enable', 0, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 156
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_user_reminder.php
LINE: 130
CALL: set_config()

FILE: includes/acp/acp_user_reminder.php
LINE: 92
CALL: acp_user_reminder->configuration()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_user_reminder->main()

FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Unknown column 'user_reminder_zero_poster' in 'where clause' [1054]

SQL

SELECT * FROM phpbb_users WHERE user_id <> '' AND user_type NOT IN (2, 1) AND ((user_reminder_zero_poster < 1230840408 AND user_reminder_zero_poster > 0) OR (user_reminder_inactive > 0 AND user_reminder_inactive < 1230840408) OR (user_reminder_not_logged_in > 0 AND user_reminder_not_logged_in < 1230840408)) AND user_allow_massemail = 1 AND user_reminder_inactive_still = 0

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_user_reminder.php
LINE: 77
CALL: dbal_mysqli->sql_query()

FILE: index.php
LINE: 151
CALL: send_user_reminders()

Code: Alles auswählen

Fehler
SQL-Befehl: 

INSERT INTO phpbb_config( config_name, config_value ) 
VALUES (

'user_reminder_last_auto_run', '0'
);



MySQL meldet:  

#1062 - Duplicate entry 'user_reminder_last_auto_run' for key 1

Code: Alles auswählen

Fehler
SQL-Befehl:  

SELECT * 
FROM Array
WHERE CONCAT_WS( "-", config_name, config_value ) = "user_reminder_last_auto_run"
ORDER BY config_name, config_value
LIMIT 0 , 30 

MySQL meldet:  

#1146 - Table 'fish.Array' doesn't exist 

Code: Alles auswählen

Unknown column 'user_reminder_zero_poster' in 'where clause' [1054]

Code: Alles auswählen

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_last_auto_run', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_ignore_no_email', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_delete_choice', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_zero_poster_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_zero_poster_days', '15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_days', '60');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_days', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_not_logged_in_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_not_logged_in_days', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_protected_users', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_zero', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_inactive', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_not_logged_in', '1');

ALTER TABLE phpbb_users ADD user_reminder_inactive INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_zero_poster INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_inactive_still INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_not_logged_in INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';

Code: Alles auswählen

#1062 - Duplicate entry 'user_reminder_last_auto_run' for key 1