PDA

View Full Version : RSS Feed - XML Error: Undeclared entity warning at line 53


Inked_Mono
05-12-2016, 10:33 AM
I've been trying to figure this RSS feed out for quite awhile now, and I seem to be getting absolutely nowhere. I've tried everything and I can think of, and I've made absolutely no progress. Here's hoping someone can help.

When using an RSS feed URL (http://vb-dev.os-scape.com/external.php?type=RSS2&forumids=5), which by the way, for whatever reason seems to show absolutely nothing in both Firefox and Chrome [outside of the occasional database error]), I get this error on the feeder:

http://i.imgur.com/sJ8qHia.png

These are my current RSS settings:

http://i.imgur.com/HSd3IGm.png


What am I doing wrong here?

Inked_Mono
05-13-2016, 01:55 PM
Bump. I've had absolutely no luck with this.

Dave
05-13-2016, 02:54 PM
The undeclared entity warning is caused by bad syntax in the XML file.
Database error shouldn't happen in the first place, can you paste the database error here?

Paul M
05-13-2016, 10:28 PM
I get a database error on that link (every time).

Inked_Mono
05-14-2016, 02:11 AM
The undeclared entity warning is caused by bad syntax in the XML file.
Database error shouldn't happen in the first place, can you paste the database error here?

Do you know where I would go about finding the database error? I'd be happy to post it.

The pictures shown are all of the information I have at the moment.

I get a database error on that link (every time).

Which is odd, because the other RSS feed links just come up blank.

Dave
05-14-2016, 12:48 PM
Database errors should be sent to the email defined in your /includes/config.php file.

Inked_Mono
05-15-2016, 01:34 AM
The undeclared entity warning is caused by bad syntax in the XML file.
Database error shouldn't happen in the first place, can you paste the database error here?

Database errors should be sent to the email defined in your /includes/config.php file.

Thank you! The error reads as the following:

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT COUNT(*) AS thread_count
FROM thread AS thread
where postuserid =;

MySQL 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 '' at line 3
Error Number : 1064
Request Date : Saturday, May 14th 2016 @ 08:33:38 PM
Error Date : Saturday, May 14th 2016 @ 08:33:38 PM
Script : http://vb-dev.os-scape.com/external.php?type=RSS2&forumids=5
Referrer :
IP Address : 24.64.44.202
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Inked_Mono
05-17-2016, 11:42 AM
Bump.

squidsk
05-17-2016, 02:32 PM
I took a look at the code in external.php and that query is not in stock vbulletin. Check your plugins for any that are on hooks in external.php:

external_start
external_type
external_query
external_complete


If there are none on those hook locations, start looking through plugins on global locations to see if there are plugins that should not be running on rss feeds.

Inked_Mono
05-20-2016, 03:16 AM
I took a look at the code in external.php and that query is not in stock vbulletin. Check your plugins for any that are on hooks in external.php:

external_start
external_type
external_query
external_complete


If there are none on those hook locations, start looking through plugins on global locations to see if there are plugins that should not be running on rss feeds.

Would a quick way to circumvent the necessary checks be to disable all current plugins and see if it makes a difference?

squidsk
05-20-2016, 01:01 PM
Yes, totally disabling the plugin system via config.php would do the trick.

Inked_Mono
05-20-2016, 02:07 PM
Yes, totally disabling the plugin system via config.php would do the trick.

Sorry, I'm a bit naive when it comes to a lot of the significant back end work. What would be the most efficient way of disabling the plugin system through the config.php?

MarkFL
05-20-2016, 03:14 PM
Sorry, I'm a bit naive when it comes to a lot of the significant back end work. What would be the most efficient way of disabling the plugin system through the config.php?

To disable the plugin system via config.php, at the top of that file add the line:

define('DISABLE_HOOKS', true);

You can also disable plugins via the AdminCP. Follow:

AdminCP -> Settings -> Options ->Plugin/Hook System

And set "Enable Plugin/Hook System" to "No".

Inked_Mono
05-20-2016, 05:15 PM
To disable the plugin system via config.php, at the top of that file add the line:

define('DISABLE_HOOKS', true);

You can also disable plugins via the AdminCP. Follow:

AdminCP -> Settings -> Options ->Plugin/Hook System

And set "Enable Plugin/Hook System" to "No".

That worked perfectly! The RSS feed works without a problem, so now I guess it's just to find the plugin responsible for the problem. Thanks!