14.06.2020, 19:35
Ich kenne das Plugin zwar nicht, aber lt. Github sollte das Problem schon im Sept. 2018 behoben worden sein (siehe hier). Verwendest Du die aktuellste Version?
function myalerts_alert_quoted()
{
global $mybb, $pid, $post, $db;
if (!isset($mybb->user['uid']) || $mybb->user['uid'] < 1 || $post['savedraft']) {
return;
}
$plugins->add_hook('datahandler_post_insert_post', 'myalertsrow_subscribed');
function myalertsrow_subscribed(&$dataHandler)
{
global $mybb, $db, $post;
if (!isset($mybb->user['uid']) || $mybb->user['uid'] < 1) {
return;
}
$plugins->add_hook('datahandler_post_insert_post', 'myalertsrow_subscribed');
function myalertsrow_subscribed(&$dataHandler)
{
global $mybb, $db, $post;
if (!isset($mybb->user['uid']) || $mybb->user['uid'] < 1 || $post['savedraft']) {
return;
}
SQL Error: 1054 - Unknown column 'myalerts_disabled_alert_types' in 'field list' Query: INSERT INTO nzug1_users (`username`,`password`,`salt`,`loginkey`,`email`,`postnum`,`threadnum`,`avatar`,`avatartype`,`usergroup`,`additionalgroups`,`displaygroup`,`usertitle`,`regdate`,`lastactive`,`lastvisit`,`website`,`icq`,`skype`,`google`,`birthday`,`signature`,`allownotices`,`hideemail`,`subscriptionmethod`,`receivepms`,`receivefrombuddy`,`pmnotice`,`pmnotify`,`showimages`,`showvideos`,`showsigs`,`showavatars`,`showquickreply`,`showredirect`,`tpp`,`ppp`,`invisible`,`style`,`timezone`,`dstcorrection`,`threadmode`,`daysprune`,`dateformat`,`timeformat`,`regip`,`language`,`showcodebuttons`,`sourceeditor`,`buddyrequestspm`,`buddyrequestsauto`,`away`,`awaydate`,`returndate`,`awayreason`,`notepad`,`referrer`,`referrals`,`buddylist`,`ignorelist`,`pmfolders`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`coppauser`,`classicpostbit`,`usernotes`,`dst`,`new_terms`,`new_terms_date`,`myalerts_disabled_alert_types`) VALUES ('USERNAME','c0897899cb1b39f89f976cce389396cc','UgFDRwHg','iIqnQCZ1zDFQzldcUElieIKwwNeLLcsKFSpLb7EuXdpBtGbqvO','EMAILADRESSE',0,0,'','',4,'',0,'',1613512346,0,0,'',0,'','','','',1,0,0,1,0,1,1,1,1,1,1,1,1,0,0,0,0,'+1',0,'',0,'','',X'','',1,0,1,0,0,0,0,'','',0,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**',0,0,0,0,0,0,1,'',0,1,1613512346,'[]')
ALTER TABLE nzug1_users ADD `myalerts_disabled_alert_types` TEXT NOT NULL DEFAULT '[]';
#1101 - BLOB/TEXT-Feld 'myalerts_disabled_alert_types' darf keinen Vorgabewert (DEFAULT) haben
#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei ''[]'' in Zeile 1
ALTER TABLE nzug1_users ADD `myalerts_disabled_alert_types` varchar(255) NOT NULL default '[]';
ALTER TABLE nzug1_users ADD `myalerts_disabled_alert_types` text NOT NULL;