Posts: 4
Threads: 0
Joined: Mar 2022
Reputation:
0
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?
Posts: 769
Threads: 38
Joined: Aug 2009
Reputation:
28
Would be in the mybb error log I would think.
What mysql or mariadb version are you using.
Posts: 4
Threads: 0
Joined: Mar 2022
Reputation:
0
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]
Posts: 769
Threads: 38
Joined: Aug 2009
Reputation:
28
Posted an update to fix that issue.
Posts: 4
Threads: 0
Joined: Mar 2022
Reputation:
0
03-26-2022, 04:35 AM
(This post was last modified: 03-27-2022, 02:25 AM by Sumato.)
(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!
Posts: 1
Threads: 0
Joined: Jun 2022
Reputation:
0
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?
Posts: 769
Threads: 38
Joined: Aug 2009
Reputation:
28
No plans for SQL Lite support. The plugins I make are for MySQL only no plans to expand due to low userbase.
Posts: 769
Threads: 38
Joined: Aug 2009
Reputation:
28
Update
Version 7.2
!Fix bug with posting topic on php 8.0+
Posts: 1
Threads: 0
Joined: Nov 2022
Reputation:
0
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
Posts: 769
Threads: 38
Joined: Aug 2009
Reputation:
28
What version of the plugin are you running?
|
