A fatal, non-recoverable error has occurred
Error Message: An error occurred while retrieving the feed. Affected Elements: Feed.GetData();
The error occurred on or near: You have an error in your SQL syntax near 'on d.FirstCommentID = fc.CommentID left join LUM_User u on d.AuthUserID = u.User' at line 1
Comments
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •did now
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •A fatal, non-recoverable error has occurred
Technical information (for support personel):
Error Message: An error occurred while retrieving the feed.
Affected Elements: Feed.GetData();
The error occurred on or near:
You have an error in your SQL syntax near 'on d.FirstCommentID = fc.CommentID left join LUM_User u on d.AuthUserID = u.User' at line 1
For additional support documentation, visit the Lussumo Documentation website at: lussumo.com/support
The user will likely follow the path given. So, the link provided was to the forum, and in my morning zombie state just followed the link and created a post. If possible, it may be worth making such error messages display a link to the bug report page.
But, of course, I'm sure Mark doesn't want bug reports for every user error found, as help could be on the forums.
Hopefully Mark can finish the docs soon so some of us that have been around for a while can fix our own bugs or help others. This has got to be tons of unpaid work that's continually snowballing on him.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •not sure if the data it is giving me is correct or not, but it works.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •$s->AddLimit(0, agDISCUSSIONS_PER_FEED);to this:
$s->AddLimit(0, agDISCUSSIONS_PER_FEED);
echo($s->GetSelect());
die();
Then referesh the page and copy out the entire sql statement and paste it here so we can see what happened.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •from LUM_Discussion d join LUM_Comment fcbe
from LUM_Discussion <b>as</b> d <b>left</b> join LUM_Comment <b>as</b> fc- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •link rel="alternate" type="application/atom+xml"
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •so my user goofed. he was using feed demon which doesn't support atom 1.0 yet, so it was throwing a different error.
it's working for everyone else in the forum. must be a mysql 3 vs. 4 thing.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •You're good - that worked in my phpmyadmin. Now, I guess the question is where can I can change that in the code on my site?
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •thx Mark!
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •