Home  >   Forum Home  >  Technical Support Forums  >  Bug Forum  >  Thread
 

This Question is Resolved.

If you have a similiar issue that this thread does not address, click the button below to open a new related support topic.

 
 
{location} field from comments will not display
 
Scheffey
Posted: 13 August 2008 11:27 AM   [ Ignore ]  
Grad Student
Avatar
Rank
Total Posts:  67
Joined  10-03-2005

I am trying to display a users location by way of comment entries in my template. However, when the page displays I get no results showing. I checked the entries and the location is there.


TEMPLATE CODE:

{exp:comment:entries limit="20" entry_id="15" orderby="most_recent_comment"}
On {comment_date format="%F %d, %Y"}, {name} from {location}, wrote:{comment}
{/exp:comment:entries}


TEMPLATE DISPLAY:
On August 12, 2008, Lorraine from , wrote:
We had a wonderful time at the…

NOTICE no information is displaying after “Lorraine from”

ExpressionEngine v 1.6.3

Any suggestions?
Profile
 
 
Ingmar Greil
Posted: 13 August 2008 02:18 PM   [ Ignore ]   [ # 1 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  15380
Joined  05-15-2004

I can reproduce in the latest build. Might be a bug, I’ll check with the dev team.

 Signature 

Everything will be good in the end. If it’s not good, it’s not the end.
Profile
MSG
 
 
Ingmar Greil
Posted: 13 August 2008 02:47 PM   [ Ignore ]   [ # 2 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  15380
Joined  05-15-2004

Scheffey, I have reason to believe that this is indeed a bug, so thanks a lot for bringing this to our attention. I have made the appropriate bug report, and am moving this thread to the bug forum, too.

As a workaround, try adding this to your template:

{exp:query sql='SELECT location FROM `exp_comments`
WHERE comment_id="{comment_id}"'}{location}{/exp:query}

It worked for me, pulling {location} directly out of the database, as it were.

 Signature 

Everything will be good in the end. If it’s not good, it’s not the end.
Profile
MSG
 
 
Scheffey
Posted: 13 August 2008 02:58 PM   [ Ignore ]   [ # 3 ]  
Grad Student
Avatar
Rank
Total Posts:  67
Joined  10-03-2005

Ingmar,

Thank you for looking into this. Unfortunately, I am getting the same results with your workaround:


{exp:comment:entries limit="20" entry_id="15" orderby="most_recent_comment"}
On {comment_date format="%F %d, %Y"}, {name} from
{exp:query sql='SELECT location FROM `exp_comments` WHERE comment_id="{comment_id}"'}{location}{/exp:query}
wrote:{comment}
{/exp:comment:entries}

Profile
 
 
Ingmar Greil
Posted: 13 August 2008 03:04 PM   [ Ignore ]   [ # 4 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  15380
Joined  05-15-2004

Hm, it did work for me, and I really don’t see why it should not. You do have the query module installed, of course? If you just put {comment_id} in there, does that work? Also, can you try hardcoding the comment_id?

 Signature 

Everything will be good in the end. If it’s not good, it’s not the end.
Profile
MSG
 
 
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
Derek Jones
Posted: 14 August 2008 09:08 AM   [ Ignore ]   [ # 6 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15831
Joined  06-03-2002

Are you guys nesting your comment entries tag or anything?  The code looks fine and I can’t reproduce.

 Signature 
Profile
MSG
 
 
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
View / Hide • A moderator has determined that this reply may not contribute* to resolving this support issue.
Derek Jones
Posted: 15 August 2008 01:04 PM   [ Ignore ]   [ # 14 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15831
Joined  06-03-2002

Looks like Ingmar’s test was indeed nested.  Scheffey how about you?

 Signature 
Profile
MSG
 
 
Derek Jones
Posted: 19 August 2008 11:35 AM   [ Ignore ]   [ # 15 ]  
Administrator
Avatar
RankRankRankRankRankRankRank
Total Posts:  15831
Joined  06-03-2002

As I cannot reproduce and further details will be necessary in order to confirm the bug I’m suspending this report for the time being.  If you are able to reproduce this issue or have further relevant details, please use the button at the top or bottom of this thread to create a new related topic and we’ll take it from there.

 Signature 
Profile
MSG
 
 
 

This Question is Resolved.

If you have a similiar issue that this thread does not address, click the button below to open a new related support topic.

 
 
 
‹‹ Script injected by advanced search form tag and "id" parameter of this tag      20080808 - template debugging and sql query debugging not working ››
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 64937 Total Logged-in Users: 69
Total Topics: 81907 Total Anonymous Users: 44
Total Replies: 440302 Total Guests: 301
Total Posts: 522209    
Members ( View Memberlist )
Newest Members:  x_dde_x,  ElectricStudio.co.uk,  rduncan,  cleco-electric,  Kathryn Davies,  Petrovich,  usharu,  rblaisdell,  Lev,  agstudio
Active Members:    aircrash,  Alejandro Mut,  Arun S.,  atlkaren,  Ŧom,  Bas1c,  benjyrose,  berkeley,  Boyink!,  Brian M.,  Bud P,  Burly Chassis,  Carlo,  Christian Schulte,  Cog Design,  Crucial,  curtschultz,  Dan Lovejoy,  DennisNorris,  digitald3,  dossie,  dvancouver,  evasion,  Forrest Anderson,  GDmac,  grantmx,  Greg Griffith,  harsing,  hearsay,  hotknife,  Huan,  Ingmar Greil,  ITWY,  jeremydouglas,  John Ryan,  JohnD,  justsayingsomething,  knewell,  lincolnpixel,  Mark Bowen,  markgledhill,  michelG,  Milaan,  ovation,  P.J.,  padstow,  pcmeissner,  rccjax,  Robin Sowell,  russlipton,  sakana,  Saratoga UK,  Sentinel Mike,  silenz,  spacewalk,  springworks,  Stephany,  stephenslater,  Steve Abraham,  Tammo,  techjob,  tim bertens,  Victor Gutierrez,  webscribe2,  wuwongy
Powered By ExpressionEngine
ExpressionEngine Discussion Forum - Version 2.1.1 (20081028)
Script Executed in 0.3758 seconds
Atom Feed   RSS 2.0