Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Can you post your <code>{exp:channel:entries}</code> tag so that we can more effectively debug your issue? Just going off of what you've written, it seems like you may have used an incorrect 'date' parameter. The correct parameter to use is the <a href="http://expressionengine.com/user_guide/modules/channel/channel_entries.html#start-on" rel="nofollow"><code>start_on</code> parameter</a>. The documentation for that parameter shows example code for ignoring entries that were published in the past and should clear up any questions you have about how to implement it.</p> <p>Please elaborate on your question if you still need help!</p> <p><strong>Updated answer:</strong></p> <p>Hey Jamal, thanks for posting your code. I would definitely set your <code>start_on</code> parameter to <code>start_on="{current_time format='%Y-%m-%d %H:%i'}"</code> and then troubleshoot from there. If you're seeing an error or no generated code after making this change, it's most likely a sign of a problem somewhere else and should be fixed.</p> <p>You could try hard coding a date for the <code>start_on</code> parameter, like so:</p> <pre><code>start_on="2012-06-18 03:39" </code></pre> <p>You could also try adding <code>dynamic="no"</code> to the tag, but I can't recall if that 's supposed to change anything in this instance.</p> <p>If you're still having trouble with this parameter, please turn on template debugging and EE's output profiler (both found in <em>Admin > System Administration > Output and Debugging</em> ), refresh the page, and try to determine what the issue is based off of the debugging info that appears on the screen. </p>
    singulars
    1. This table or related slice is empty.
    1. POSkipping an ExpressionEngine Chanel Entry
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRay
    1. USRay
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSkipping an ExpressionEngine Chanel Entry
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHere it is, {exp:channel:entries channel="news_articles" limit="1" orderby="end_date" sort="asc" show_future_entries="yes" start_on="{current_time}"}. The start_on parameter was in place and it wasn't responding or when I called the format the space would just go blank
      singulars
      1. PO
      1. This table or related slice is empty.
    2. COThat's what I put for the current_time parameter at first, that's when it went blank in the area the entries are suppose to show. I figured out the blank area indicates that the older entries are still getting pulled, but since they aren't set up with any code to be displayed they just show a blank space. I started doing the debugging earlier, but got pulled into something else. Thanks for the help
      singulars
      1. PO
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload