+- MyBBHacks.com Plugins for MyBB (https://www.mybbhacks.com)
+-- Forum: Free Mods (https://www.mybbhacks.com/forumdisplay.php?fid=5)
+--- Forum: MyBB 1.8 Plugins and Mods (https://www.mybbhacks.com/forumdisplay.php?fid=14)
+--- Thread: RSS Feed Poster (/showthread.php?tid=3124)
RE: RSS Feed Poster - Sumato - 03-25-2022
Just installed it and when I went to Add a Feed,
I am getting this message.
Code:
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
If you're a visitor of this website, please wait a few minutes and try again. If this problem persists, please contact the site owner.
If you are the site owner, please check the MyBB Documentation for help resolving common issues, or get technical help on the MyBB Community Forums.I couldn't find anything on either my cPanel or Mybb,
is there someplace special I should check?
RE: RSS Feed Poster - MyBBHacks - 03-25-2022
Would be in the mybb error log I would think.
What mysql or mariadb version are you using.
RE: RSS Feed Poster - Sumato - 03-25-2022
I did enable Error reporting and this is what it said..
Code:
Your copy of MyBB running on The Flightdeck (http://sumato.org/flightdeck) has experienced an error. Details of the error include:
---
Type: 20
File: (Line no. 0)
Message
SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
' at line 6
Query: INSERT IGNORE INTO mybb_feedbot
(fid, feedurl, title, enabled, html, postername, uid, locked,
articlelink, topicprefix, numbertoimport, importevery, updatetime,markasread,usefeeddate,
threadprefix,threadicon)
VALUES
(132,'https://www.heyitsfree.net/feed/','Hey, It's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
'0','-1')
Back Trace: #0 errorHandler->email_error(20, SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
' at line 6
Query: INSERT IGNORE INTO mybb_feedbot
(fid, feedurl, title, enabled, html, postername, uid, locked,
articlelink, topicprefix, numbertoimport, importevery, updatetime,markasread,usefeeddate,
threadprefix,threadicon)
VALUES
(132,'https://www.heyitsfree.net/feed/','Hey, It's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
'0','-1'), , 0) called at [/home2/sumato/public_html/flightdeck/inc/class_error.php:229]
#1 errorHandler->error(20, Array ([error_no] => 1064,[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
' at line 6,[query] => INSERT IGNORE INTO mybb_feedbot
(fid, feedurl, title, enabled, html, postername, uid, locked,
articlelink, topicprefix, numbertoimport, importevery, updatetime,markasread,usefeeddate,
threadprefix,threadicon)
VALUES
(132,'https://www.heyitsfree.net/feed/','Hey, It's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
'0','-1'))) called at [/home2/sumato/public_html/flightdeck/inc/db_mysqli.php:601]
#2 DB_MySQLi->error(INSERT IGNORE INTO mybb_feedbot
(fid, feedurl, title, enabled, html, postername, uid, locked,
articlelink, topicprefix, numbertoimport, importevery, updatetime,markasread,usefeeddate,
threadprefix,threadicon)
VALUES
(132,'https://www.heyitsfree.net/feed/','Hey, It's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
'0','-1')) called at [/home2/sumato/public_html/flightdeck/inc/db_mysqli.php:337]
#3 DB_MySQLi->query(INSERT IGNORE INTO mybb_feedbot
(fid, feedurl, title, enabled, html, postername, uid, locked,
articlelink, topicprefix, numbertoimport, importevery, updatetime,markasread,usefeeddate,
threadprefix,threadicon)
VALUES
(132,'https://www.heyitsfree.net/feed/','Hey, It's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
'0','-1'), 0, 1) called at [/home2/sumato/public_html/flightdeck/inc/db_mysqli.php:370]
#4 DB_MySQLi->write_query(INSERT IGNORE INTO mybb_feedbot
(fid, feedurl, title, enabled, html, postername, uid, locked,
articlelink, topicprefix, numbertoimport, importevery, updatetime,markasread,usefeeddate,
threadprefix,threadicon)
VALUES
(132,'https://www.heyitsfree.net/feed/','Hey, It's Free!',1,
1, 'Sumato', 1, 0,1,
'Free Stuff',1,360,1648181546,0,0,
'0','-1')) called at [/home2/sumato/public_html/flightdeck/inc/plugins/rssfeedposter.php:475]
#5 rssfeedposter_admin() called at [/home2/sumato/public_html/flightdeck/inc/class_plugins.php:142]
#6 pluginSystem->run_hooks(Array ([function] => rssfeedposter_admin,[file] => )) called at [/home2/sumato/public_html/flightdeck/admin/index.php:823]RE: RSS Feed Poster - MyBBHacks - 03-26-2022
Posted an update to fix that issue.
RE: RSS Feed Poster - Sumato - 03-26-2022
(03-26-2022, 02:01 AM)MyBBHacks Wrote: Posted an update to fix that issue.
Thank You, will give it a go tomorrow when I get off shift.
EDIT: It works great, Thank You once again for the fix!
RE: RSS Feed Poster - 370 - 06-30-2022
Trying out this plugin but I noticed that when using SQLite as a back-end this plug-in doesn't work? Running on the latest version of mybb and plugin 7.1.
For example, auto_increment does not exist on SQLite, a primary key can't be a mediumint,...
Are there any plans for SQLite support?
RE: RSS Feed Poster - MyBBHacks - 06-30-2022
No plans for SQL Lite support. The plugins I make are for MySQL only no plans to expand due to low userbase.
RE: RSS Feed Poster - MyBBHacks - 08-17-2022
Update
Version 7.2
!Fix bug with posting topic on php 8.0+
RE: RSS Feed Poster - Captain - 11-10-2022
Rss Feed Plugin showing this in task log
Post Errors:Array ( [0] => The subject is too long. Please enter a subject shorter than 85 characters (currently 98). )
How am i fix it
RE: RSS Feed Poster - MyBBHacks - 11-10-2022
What version of the plugin are you running?