https bei RSS News erzwingen?

HTMH

Hört sich gut an, wie bekomme ich das News System dazu die Feeds neu einzulesen,
habe das News System gelöscht, Cache geleert, Browser Cache geleert,
News System neu Installiert, aber es werden keine Feeds angezeigt

Cyperghost

Die Feed´s hast du erneut hinzugefügt?

Gibt es irgend welche Fehler im error log?

HTMH

jup, habe ich.

Jup, da gibt es eine Fehlermeldung.

Spoiler anzeigen

Tue, 30 May 2017 11:37:43 +0000
Message: Could not prepare statement 'INSERT INTO news1_news
(subject,time,userID,teaser,username,isDisabled,text,enableHtml,enableSmilies,enableBBCodes)
VALUES (?,?,?,?,?,?,?,?,?,?)'
PHP version: 7.0.14-nmm1
WoltLab Suite version: 3.0.5
Request URI: /acp/index.php?ajax-proxy/&
Referrer: http://test.htmh.de/acp/index.php?cronjob-list/&pageNo=2&sortField=cronjobID&sortOrder=ASC
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:53.0) Gecko/20100101 Firefox/53.0
Peak Memory Usage: 4407208/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'INSERT INTO news1_news
(subject,time,userID,teaser,username,isDisabled,text,enableHtml,enableSmilies,enableBBCodes)
VALUES (?,?,?,?,?,?,?,?,?,?)'
Error Code: 42
File: /www/htdocs/w00ccc8c/wls/lib/system/database/Database.class.php (240)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/DatabaseObjectEditor.class.php","line":35,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["INSERT INTO\tnews1_news\r\n\t\t\t\t\t(subject,time,userID,teaser,username,isDisabled,text,enableHtml,enableSmilies,enableBBCodes)\r\n\t\t\tVALUES\t\t(?,?,?,?,?,?,?,?,?,?)"]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"subject":"[redacted]","time":"[redacted]","userID":"[redacted]","teaser":"[redacted]","username":"[redacted]","isDisabled":"[redacted]","text":"[redacted]","enableHtml":"[redacted]","enableSmilies":"[redacted]","enableBBCodes":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"subject":"[redacted]","time":"[redacted]","userID":"[redacted]","teaser":"[redacted]","username":"[redacted]","isDisabled":"[redacted]","text":"[redacted]","enableHtml":"[redacted]","enableSmilies":"[redacted]","enableBBCodes":"[redacted]"}],"class":"","type":""},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/news\/lib\/data\/news\/NewsAction.class.php","line":244,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"function":"create","class":"news\\data\\news\\NewsAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/news\/lib\/system\/cronjob\/RSSFeedReaderCronjob.class.php","line":362,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/news\/lib\/system\/cronjob\/RSSFeedReaderCronjob.class.php","line":90,"function":"createNews","class":"news\\system\\cronjob\\RSSFeedReaderCronjob","type":"->","args":["news\\data\\rss\\feed\\RssFeed","wcf\\data\\user\\User",{"title":"[redacted]","link":"[redacted]","description":"[redacted]","time":"[redacted]","hash":"[redacted]","categories":"[redacted]"},[]]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/cronjob\/CronjobAction.class.php","line":141,"function":"execute","class":"news\\system\\cronjob\\RSSFeedReaderCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"function":"execute","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AJAXProxyAction.class.php","line":74,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'enableSmilies' in 'field list'
Error Code: 42
File: /www/htdocs/w00ccc8c/wls/lib/system/database/Database.class.php (235)
Extra Information: -
Stack Trace: [{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/system\/database\/Database.class.php","line":235,"function":"prepare","class":"PDO","type":"->","args":["INSERT INTO\tnews1_news\r\n\t\t\t\t\t(subject,time,userID,teaser,username,isDisabled,text,enableHtml,enableSmilies,enableBBCodes)\r\n\t\t\tVALUES\t\t(?,?,?,?,?,?,?,?,?,?)"]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/DatabaseObjectEditor.class.php","line":35,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["INSERT INTO\tnews1_news\r\n\t\t\t\t\t(subject,time,userID,teaser,username,isDisabled,text,enableHtml,enableSmilies,enableBBCodes)\r\n\t\t\tVALUES\t\t(?,?,?,?,?,?,?,?,?,?)"]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","args":[{"subject":"[redacted]","time":"[redacted]","userID":"[redacted]","teaser":"[redacted]","username":"[redacted]","isDisabled":"[redacted]","text":"[redacted]","enableHtml":"[redacted]","enableSmilies":"[redacted]","enableBBCodes":"[redacted]"}],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":336,"function":"call_user_func","args":[["[redacted]","[redacted]"],{"subject":"[redacted]","time":"[redacted]","userID":"[redacted]","teaser":"[redacted]","username":"[redacted]","isDisabled":"[redacted]","text":"[redacted]","enableHtml":"[redacted]","enableSmilies":"[redacted]","enableBBCodes":"[redacted]"}],"class":"","type":""},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/news\/lib\/data\/news\/NewsAction.class.php","line":244,"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"function":"create","class":"news\\data\\news\\NewsAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/news\/lib\/system\/cronjob\/RSSFeedReaderCronjob.class.php","line":362,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/news\/lib\/system\/cronjob\/RSSFeedReaderCronjob.class.php","line":90,"function":"createNews","class":"news\\system\\cronjob\\RSSFeedReaderCronjob","type":"->","args":["news\\data\\rss\\feed\\RssFeed","wcf\\data\\user\\User",{"title":"[redacted]","link":"[redacted]","description":"[redacted]","time":"[redacted]","hash":"[redacted]","categories":"[redacted]"},[]]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/cronjob\/CronjobAction.class.php","line":141,"function":"execute","class":"news\\system\\cronjob\\RSSFeedReaderCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"function":"execute","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":204,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AJAXProxyAction.class.php","line":74,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AJAXInvokeAction.class.php","line":104,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/action\/AJAXInvokeAction.class.php","line":63,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/lib\/system\/request\/RequestHandler.class.php","line":94,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/w00ccc8c\/wls\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

Cyperghost

Ach, du verwendest das WSC3.0
Dann kann dies auch nicht funktionieren.

Bitte den Inhalt wie folgt ersetzen.Und dann erneut versuchen.

PHP: RSSFeedReaderCronjob.class.php

private function createNews($feed, $user, $item, $tags) {
		$text = $item['description'];
		$text = preg_replace('(<img src="http://feeds.feedburner.com/~r/erecht24/~4/.*" height="1" width="1" alt=""/>)', "", $text);
		$htmlInputProcessor = new HtmlInputProcessor();
		$htmlInputProcessor->process($text, "de.wbb-elite.news.message");
		$action = new NewsAction([], 'create', [
			'data'        => [
				'subject'        => mb_substr(MessageUtil::stripCrap($item['title']), 0, 255),
				'time'           => $item['time'],
				'userID'         => $feed->userID,
				'teaser'         => '',
				'isMultilingual' => 0,
				'enableHtml'     => 1,
				'username'       => $user->username,
				'isDisabled'     => $feed->disableNews,
				'text'           => $htmlInputProcessor->getHtml()
			],
			'categoryIDs' => array_unique(ArrayUtil::trim(unserialize($feed->categoryIDs))),
			'tags'        => $tags,
			'sources'     => $this->getSource($feed, $item['link'])
		]);
		$resultValues = $action->executeAction();
		return $resultValues['returnValues']->newsID;
	}

Alles anzeigen

Ab der Zeile 342 bis 367 (Original Code) wenn du den geändert hast, dann bitte die alte Datei einfügen.
Oder die im Anhang nehmen

HTMH

~~Scheint zu Funktionieren~~, muss nur die Testseite auf SSL umstellen.

Perfekt, funktioniert, vielen Dank für die Hilfe.

https bei RSS News erzwingen?

Cyperghost 27. Mai 2018 um 12:40

Cyperghost 15. August 2019 um 22:08

Dragosius 31. Oktober 2022 um 00:34

Informationen

Über uns