Hi Sean,

I've tried this on a couple of sites and I can't replicate the error so I think the error relates only to your site
I have asked the team to look at your thread

Cheers
Paul

Thank you very much. I appreciate their being willing to take a look. If they could find a conflict that is creating this, I would be most grateful to know.
Sean

It is an sql error so I need the developers to look at it as I understand sql but I don't use it much

7 days later

I keep coming back each day to see if this has been looked at yet. Maybe my being the last to reply will bump it up in the queue a little bit?

Hi Sean,

I've been away for a couple of days - sorry again for the delay

I've sent a message to the lady who co-ordinates bug reports / tasking

Unfortunately as far as I can tell this is specific to your site and isn't a bug as such

Cheers
Paul

Hi.

to fixed the bug.
edit the file:
modules/mod_zentools2/includes/easyblog_posts.php

Look for line 177

							if(!empty($catids)) {
								$query->where('id in (' . $get_items.')');
							}

Change to

							if(!empty($get_items)) {
								$query->where('id in (' . $get_items.')');
							}

And for latest version compatible
Look for

							$query->order($ordering);
							$query->setLimit($limit, $offset);
							$db->setQuery($query, 0);

Add this above.

							if(!empty($catids) && preg_match('/catid/', $ordering))
								$ordering = str_replace('catid', 'category_id', $ordering);

This worked. Thank you for fixing that. I have changed it on the test site and on the real site.

I do hope next time we can get this fixed in less than 22 days but I am grateful to have it fixed for sure!

Sean

PS. I do also realize that I was partially to blame for the delay.

Thanks Sean

Have a great weekend

Cheers
Paul

It ends up this did not work. Unfortunately I do have it on my live site now. the problem is that the Zentools2 modules are now pulling data from EasyBlog categories that they should not be pulling from. I have opened a new ticket with the url from my live site. But, I am thinking we may need to fix it here first and I may have to back off the changes on the live site until it is working properly.

Sean

    scarney I tried to change my live site back to what it was before but it did not work. So, right now both the test site at dev1.carneycorner.com and the real site at www.drcarney.com are BROKEN.
    So, I will be really grateful for a solution. Mostly it is the new ticket that we have to pay attention to I believe.

      Hi Sean,

      I've just replied to the other thread

      Cheers
      Paul

        paulus1031 Thanks Paul, I did not realize there were ticket numbers (as you asked me in the other thread. But, when I replied to this I do see
        paulus1031
        So, I am supposing that 33473 might be the ticket number for this ticket?
        Thanks, Sean

            Hi Sean,

            I will alert the developer but it will probably be Monday I'm afraid

            Cheers
            Paul

            4 days later

            Paul, My apologies. I was just able to submit a ticket just now. Not sure why it was not doing anything before when I hit the submit button but it appears to be working now.

            Ticket has been submited
            Reference number is: #WXK-259208

            Here is the reply to the ticket I opened in which they told me to get my support here in the forum:

            Hi

            I see your two forum threads are still open. Please help to follow up in those two threads instead of opening a new ticket, it causes confusion to have multiple threads on same topic open at the same time.

            Also the Ticket System is meant to be used by Developer members only. As you are Pro member, you should always use the forum at https://www.joomlart.com/forums/ for support.

            Hope this clears things up. I'll close this ticket now.

            Sorry Sean this was my fault - I was thinking you were still on the Joomlabamboo lifetime which does provide ticket access

            Thanks Paul,
            I guess I did not pay enough attention to the choice I made. Maybe I was able to purchase a lower cost membership in exchange for giving up my lifetime membership? I see now that was probably a BIG mistake in that I may have received the help I needed already had I not done that.
            Sean

            I'll talk to support leader in regard to your threads

            Looks like JoomlArt has no intention of helping me. 😞 I thought I was purchasing the option to best support the JoomlaBamboo to JoomlArt effort and did not realize I was picking the option that would create second class support because I did not maintain the lifetime membership. Very troubling.

              You need to Login to view replies.