Error 1054 using a menu item: Tagged Items

davbra
Offline

Active Subscriptions:

None

7 years 10 months ago #58706 by davbra

Error 1054 using a menu item: Tagged Items was created by davbra

I have a link called "Crowd Leaders" that shows all articles with the Joomla! 3 tag "Crowd Leaders"

When you click on it, this error page appears:

1054
Error: 1054

Unknown column 'Array' in 'where clause' SQL=SELECT act.* FROM #__jfbconnect_autopost_activity act WHERE `act`.`ext`='com_tags' AND `act`.`layout`='tag' AND `act`.`item_id`=Array AND `act`.`type`=1 AND `act`.`status`=2

You can see it yourself if you go to: dailycrowdsource.com & in the left menu hover over "Library", then click "Crowd Leaders" at the top. The menu uses "Menu Item Type:" "Tagged Items"

I'm on Joomla 3.5.1 & JFBConnect 7.0.2
To test it, I created a whole new menu item called "spammy" with Menu Type: Tagged Items & picked a different tag. It gives the same error: (just add /spammy after the domain name to test it)

I'm running AdminTools, but it doesn't seem like a restriction error.
Thanks!

The topic has been locked.

mel
Offline

Support Specialist

7 years 10 months ago #58723 by mel

Replied by mel on topic Error 1054 using a menu item: Tagged Items

Could you try the following temporary fix?

In plugins/system/jfbcsystem/jfbcsystem.php around line 274, can you add the following if statement that checks for the com_tags so that the code looks like the following?

$option = JRequest::getCmd('option');
if($option == 'com_tags')
   return;

I've added an issue to our tracker to properly address this, but I think this should help you get past the issue for now. Let me know if you still have the errors after adding the change.

-Melissa

The topic has been locked.

davbra
Offline

Active Subscriptions:

None

7 years 9 months ago #58793 by davbra

Replied by davbra on topic Error 1054 using a menu item: Tagged Items

I've added the line you indicated.

It seems to have worked. The link does NOT produce an error any more.

I'll check if it's pulling my tagged content correctly. But for now I think that did it.

Thank you,
-David

The topic has been locked.

mel
Offline

Support Specialist

7 years 9 months ago #58796 by mel

Replied by mel on topic Error 1054 using a menu item: Tagged Items

Thanks for letting me know. I've created an issue in our tracker to make sure this is addressed for the next release.

-Melissa

The topic has been locked.

Start
Prev
1
Next
End

SourceCoast Login

Error 1054 using a menu item: Tagged Items