Thread

I’ve got a full version of EE 1.6.8 (build 20090723) installed, the Query module activated, yet the basic functionality is not working for me.  My template is simply:

{exp:query sql="SELECT cat_id FROM exp_categories"}
{cat_id}

{if no_results}no results!{/if}
{exp:query}

Yet the page outputs:

{cat_id}

rather than the actual cat_id’s from the database.

I know that the Query module is at least somewhat working because I edited mod.query.php (for testing) after line 182 and added:

print_r($query);

And on the outputted template I do indeed get the full result set.

DB_Cache Object
(
    [result] => Array
        (
            [0] => Array
                (
                    [cat_id] => 4
                )

            [1] => Array
                (
                    [cat_id] => 5
                )

            [2] => Array
                (
                    [cat_id] => 6
                )

            [3] => Array
                (
                    [cat_id] => 7
                )

            [4] => Array
                (
                    [cat_id] => 8
                )

            [5] => Array
                (
                    [cat_id] => 9
                )

            [6] => Array
                (
                    [cat_id] => 10
                )

        )

    [row] => Array
        (
            [cat_id] => 4
        )

    [num_rows] => 7
    [q_count] => 18
    [fields] => Array
        (
        )

)

What could be stopping the template tags from being parsed correctly?  I’ve got no other problems with tags on the rest of my site.

First things first. How about upgrading your version of EE? You’re quite a few builds behind.

First things first. How about upgrading your version of EE? You’re quite a few builds behind.

That was a typo.  I’m running the latest build of 1.6.8.

You’re missing the forward slash from your closing tag:

{exp:query sql="SELECT cat_id FROM exp_categories"}
{cat_id}

{if no_results}no results!{/if}
{exp:query}

Should be (notice the last line):

{exp:query sql="SELECT cat_id FROM exp_categories"}
{cat_id}

{if no_results}no results!{/if}
{/exp:query}

You’re missing the forward slash from your closing tag:

{exp:query sql="SELECT cat_id FROM exp_categories"}
{cat_id}

{if no_results}no results!{/if}
{exp:query}

Should be (notice the last line):

{exp:query sql="SELECT cat_id FROM exp_categories"}
{cat_id}

{if no_results}no results!{/if}
{/exp:query}

Wow, duh!  This was driving me crazy.  I knew it had to be something stupid but sometimes it takes a second pair of eyes.  Thanks!

It would be nice for EE to output some error message if basic parsing fails.

If you turn on the Template Debugging (Output and Debugging Preferences) you would indeed get such a message, e.g.:

(0.013598) Tag: {exp:query sql="SELECT cat_id FROM exp_categories"}
(0.013719) No Closing Tag
(0.013776) Tag: {exp:query}
(0.013816) No Closing Tag

If you turn on the Template Debugging (Output and Debugging Preferences) you would indeed get such a message, e.g.:

(0.013598) Tag: {exp:query sql="SELECT cat_id FROM exp_categories"}
(0.013719) No Closing Tag
(0.013776) Tag: {exp:query}
(0.013816) No Closing Tag

Excellent, thanks.

Glad to help, Phil!