MyBBHacks.com Plugins for  MyBB
0
Thread Rating:
  • 2 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
RSS Feed Poster
#71
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?
Reply
#72
Would be in the mybb error log I would think.
What mysql or mariadb version are you using.
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply
#73
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]
Reply
#74
Posted an update to fix that issue.
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply
#75
(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!
Reply
#76
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?
Reply
#77
No plans for SQL Lite support. The plugins I make are for MySQL only no plans to expand due to low userbase.
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)