Not signed in (Sign In)
Categories
Vanilla 1.1.5 is a product of Lussumo. More Information: Documentation, Community Support.
Help keep Vanilla free:Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.
-
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 -
yes yes there is a thread about this already.
are you guys submitting these bugs using the bug report form?
http://lussumo.com/community/bugreport.php -
did now
-
excellent... it makes it alot easier for mark to track and address the bugs that way :D
-
Just a note on that, here's the error message that was displayed:
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. -
For the record - does the atom feed work for ANYONE?
I'm dumbfounded by this error. I uploaded and tested the atom feed manually to two different servers, and it works just fine. -
the feed works for me in safari 2.0 using the browsers internal reader.
not sure if the data it is giving me is correct or not, but it works. -
ahh, yeah, it looks like it's giving me all the threads
-
does it have anything to do with login credentials?
-
Okay, I need for someone who is getting the error to go to line 186 of feeds/index.php and change it from this:
$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. -
and ithcy, no - it shouldn't have anything to do with your credentials. It's choking on a different sql statement - but we'll see, I guess.
-
select d.DiscussionID, d.CategoryID, d.AuthUserID, d.Name, d.DateCreated, d.DateLastActive, d.CountComments, fc.Body, u.Name as AuthUsername, c.Name as Category from LUM_Discussion d join LUM_Comment fc on d.FirstCommentID = fc.CommentID left join LUM_User u on d.AuthUserID = u.UserID left join LUM_Category c on d.CategoryID = c.CategoryID left join LUM_CategoryRoleBlock crb on d.CategoryID = crb.CategoryID and crb.RoleID = 6 left join LUM_CategoryBlock cb on d.CategoryID = cb.CategoryID and cb.UserID = 1 where coalesce(crb.Blocked, 0) = 0 and d.Active = '1' and coalesce(cb.Blocked,0) <> '1' and (d.AuthUserID = 1 or d.WhisperUserID = 1 or d.WhisperUserID = '0' ) group by d.DiscussionID order by d.DateLastActive desc limit 0, 20
-
can you omit AS?
-
i mean shouldn't
from LUM_Discussion d join LUM_Comment fc
befrom LUM_Discussion <b>as</b> d <b>left</b> join LUM_Comment <b>as</b> fc -
Mine looks the same as ithcy's:
select d.DiscussionID, d.CategoryID, d.AuthUserID, d.Name, d.DateCreated, d.DateLastActive, d.CountComments, fc.Body, u.Name as AuthUsername, c.Name as Category from LUM_Discussion d join LUM_Comment fc on d.FirstCommentID = fc.CommentID left join LUM_User u on d.AuthUserID = u.UserID left join LUM_Category c on d.CategoryID = c.CategoryID left join LUM_CategoryRoleBlock crb on d.CategoryID = crb.CategoryID and crb.RoleID = 6 left join LUM_CategoryBlock cb on d.CategoryID = cb.CategoryID and cb.UserID = 2 where coalesce(crb.Blocked, 0) = 0 and d.Active = '1' and coalesce(cb.Blocked,0) <> '1' and (d.AuthUserID = 2 or d.WhisperUserID = 2 or d.WhisperUserID = '0' ) group by d.DiscussionID order by d.DateLastActive desc limit 0, 20 -
Okay, what version of mysql are you guys running?
Can you try running that query directly on your database and see what happens? -
MySQL 4.0.24-standard
-
the query returns results when run directly.
also the feed works in sage. let me see what reader my users were using when they got the error.
one thing: the feeds appear to hardlink to "/vanilla" ? -
MySQL 3.23.58 (Yeesh)
Error:
SELECT d.DiscussionID, d.CategoryID, d.AuthUserID, d.Name, d.DateCreated, d.DateLastActive, d.CountComments, fc.Body, u.Name AS AuthUsername, c.Name AS Category
FROM LUM_Discussion d
JOIN LUM_Comment fc ON d.FirstCommentID = fc.CommentID
LEFT JOIN LUM_User u ON d.AuthUserID = u.UserID
LEFT JOIN LUM_Category c ON d.CategoryID = c.CategoryID
LEFT JOIN LUM_CategoryRoleBlock crb ON d.CategoryID = crb.CategoryID AND crb.RoleID =6
LEFT JOIN LUM_CategoryBlock cb ON d.CategoryID = cb.CategoryID AND cb.UserID =2
WHERE coalesce( crb.Blocked, 0 ) =0 AND d.Active = '1' AND coalesce( cb.Blocked, 0 ) <> '1' AND (
d.AuthUserID =2 OR d.WhisperUserID =2 OR d.WhisperUserID = '0'
)
GROUP BY d.DiscussionID
ORDER BY d.DateLastActive DESC
LIMIT 0 , 20
MySQL said:
#1064 - You have an error in your SQL syntax near 'ON d.FirstCommentID = fc.CommentID
LEFT JOIN LUM_User u ON d.AuthUserID = u.Use' at line 3 -
works fine for me as a Firefox live bookmark.. and it would be great if could show up as a live bookmark link with a:
link rel="alternate" type="application/atom+xml"
-
ithcy - the feeds shouldn't hard-link to anything. I always use the values defined in your settings.php file. Check out Settings > application settings to see what you have defined as your "Web-path to Vanilla".
brady - try changing that "JOIN LUM_Comment" to an "INNER JOIN LUM_Comment" and see if that helps. -
yeah, that was my bad, nav, i missed it on the upgrade.
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. -
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?
-
//
-
I'll make a fix and upload a minor version upgrade... give me a few minutes...
-
thx Mark!
-
one other thing - it appears to pull all latest threads, whether or not the user has read them - is that right?
-
Okay, go ahead and re-download the app from getvanilla.com. the fix should be in there. Please let me know that it worked :)
ithcy - Yeah, it just pulls all of the latest threads (ie. ordered by most recently active).
there has been talk of altering the feed so you can filter to specific categories. Neat idea, methinks. -
how many files were changed on this? can we just edit 1 file?
-
Yeah - just change the feeds/index.php file and you should be good.
-
I changed the feeds/index.php and it worked like a charm!
I'm using mysql 3.23.... time to upgrade, I guess.
Thanks very much!! -
i agree, neat idea
thanks for the fix... still works on mysql 4.0.24 -
Cheers :)
-
sorry, which line and what am I changing in feeds/index.php?
-
Just re-download the entire application from getvanilla.com. Then take the new feeds/index.php file and replace your existing one.
-
sorry to keep bumping.. but wouldn't it make sense to feed the last comments from the latest threads rather than the first comments from those threads?
-
I don't know. I'm open to suggestions. Majority rules.
-
success!
-
or just making "recent activity" and "recent threads" feeds?
-
Personally, I like the feed the way it is... I want readers subscribed to the feed to see the latest discussion topic and an excerpt giving them an idea of what it's about.
-
"Personally, I like the feed the way it is... I want readers subscribed to the feed to see the latest discussion topic and an excerpt giving them an idea of what it's about."
i'm thinking extension? -
but if it's a long discussion that keeps getting bumped and you've participated in it, wouldn't you rather see what's new right away, since you've already read the first part?
maybe the first comment could go in <summary> and the latest in <content>? -
Has this one been nailed down for what's doing what or what to change, yet?
I'm still getting the same error (mysql 4.1.11, php 4.3.10, vanilla 0.9.2) -
did you get the new zip and replace feeds/index.php?
(and appg/init_internal.php) -
yes
(and yes) -
Open up the appg/settings.php file that came with your zip file and make sure that it says 0.9.2.1 (or greater) next to the agVANILLA_VERSION definition. If it does, and you've replaced your feeds/index.php file, let me know and I can take a look. Thanks!
-
okay, appg/settings.php was the only file i hadn't overwritten (was trying to keep my db settings and all). with the new copy of that in there, it works fine.
* beats himself in the head with the RTFM stick* -
no no no
You don't have to overwrite your settings file. I just wanted to make sure you had the correct version, and the version is written in the settings.php file. -
well, i didn't have the right version.
or rather: i hadn't completed all the instructions from the upgrade instructions (i only added the <?php to the first line).
beautiful work, btw. looking forward to some extension documentation, the ideas are going crazy. ;)
1 to 50 of 50