blog documentation FAQ followers forum marketplace services youtube

solved Group Error - Firefox and IE Only

The Jamroom Network » Forum » Using Jamroom » Page » Group Error - Firefox and IE Only
Dazed
Dazed
@dazed
9 years ago
1,022 posts
I wanted to add a menu link to all groups and when I used the default page, it is fine in chrome but throws an error in IE and Firefox.

I ran an integrity check and repaired the DB but no go. I thought this had to do with groups that were deleted so I re-added them from the recycle bin but still no go.

Error:
CRI: Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

https://www.mixposure.com/group/

Thanks for the help!
updated by @dazed: 11/22/16 10:17:45PM
michael
@michael
9 years ago
7,768 posts
could you outline the steps you're taking to do what you're describing so I can replicate it and see if I get the same thing? That would make it easier for me to provide a solution.

My guess is you have a search="something = (nothing)" or the like. That error is saying, "You told me to fetch something from the database, but I couldn't understand what you wanted me to get."
Dazed
Dazed
@dazed
9 years ago
1,022 posts
Hey Michael - I was just using the modul url from the info page ie. site/group Then I added the code into my menu. Nothing major yet. I was looking for a quick link to all groups.

<a href="{$jamroom_url}/group/">Groups</a>
michael
@michael
9 years ago
7,768 posts
That shouldn't have caused any errors.

Whats the code after:
        <h1>Groups</h1>
    </div>

    <div class="block_content">
?????????
Dazed
Dazed
@dazed
9 years ago
1,022 posts
That is why I found it odd that it worked in chrome only.

I will take a look in the am. I have made no changes so this is all default templates. So if you are seeing something different on your site, I am not sure what would be wrong. The error is calling the sql statement so something is off and it should not be from a url.

Appreciate the help!
updated by @dazed: 08/22/16 08:22:27PM
Dazed
Dazed
@dazed
9 years ago
1,022 posts
Here is the template from the index.tpl file in the groups module.

{jrCore_include template="header.tpl"}

<div class="block">

    <div class="title">
        {jrSearch_module_form fields="group_title,group_description"}
        <h1>{jrCore_lang module="jrGroup" id=1 default="Groups"}</h1>
    </div>

    <div class="block_content">
        {jrCore_list module="jrGroup" order_by="_item_id numerical_desc" pagebreak=10 page=$_post.p pager=true}
    </div>

</div>

{jrCore_include template="footer.tpl"}
michael
@michael
9 years ago
7,768 posts
mmmm, just tried your code here and its working fine.

Made any adjustments to jrGroup/templates/item_list.tpl ? skin over-ride perhaps?
Dazed
Dazed
@dazed
9 years ago
1,022 posts
Hey Michael - This is all default Jamroom templates. No changes have been made.
michael
@michael
9 years ago
7,768 posts
Makes no sense, there is an SQL error getting in there from somewhere.

Could you send support at jamroom dot net your login details and I'll investigate.
Dazed
Dazed
@dazed
9 years ago
1,022 posts
Brian fixed this in the new version.