Topic-icon conflict between k2 opengraph plugin and k2 frontend item submission

K2 feature "submit item" (through frontend) does not work if K2 opengraph plugin is activated.

Error message in K2: "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 1 SQL=SELECT parent FROM *****_k2_categories WHERE id ="

Joomla error report:

Notice: Undefined index: id in /usr/www/users/discuo/plugins/opengraph/k2/k2.php on line 47

Notice: Trying to get property of non-object in /usr/www/users/discuo/plugins/opengraph/k2/k2.php on line 51
1064

Can you help?

Joomla 3.41
K2 latest version 2.6.9
JFBConnect 6.3.0
The topic has been locked.
Support Specialist
9 years 1 day ago - 9 years 1 day ago #53090 by mel
Do you have an Open Graph object set up for a K2 item or category? If not, please try adding one? If so, do you have a category set in the object?

[Edited to add] Looking at the code, this code should not be executing if you're in the front-end editor for the item. I think we may need FTP credentials so we can add some debugging statements to see how it got in the code block. If you're comfortable with this, please click on the envelope icon under my avatar to send me a PM with the credentials.
Last edit: 9 years 1 day ago by mel.
The topic has been locked.
Support Specialist
Thanks for the FTP credentials. We were able to verify that you're using the latest version of the Open Graph - K2 plugin and it correctly has a check to determine if the current view is the "edit" view. If so, the Open Graph plugin shouldn't be executing line 46-52 in that file, which are the ones that are throwing the error on your site.

Can you let us know specifically what you're doing? Are you simply clicking the "Submit new item" link and it's showing those errors? Is it when you save the page that the error occurs? Also, please provide an exact relative URL (domain not required) of the page with the problem, like /index.php?option=com_k2&view=item&task=edit

In general, we do a lot of testing with K2 under different circumstances. We also have many, many users who use JFBConnect and K2 together. In no cases have we had this issue reported, so we're a bit dumbfounded.

Some other quick things to test:
* Disable all caching on your site
* Disable SEF URLs either in Joomla or a 3rd party extension
** this should be done to provide the relative path above as well
** If you are using 3rd party SEF extensions, let us know what they are

Once we get all the details above, we'll gladly investigate further.

Finally, right now we just have FTP access. If you can provide a super admin account as well, that would help us get some of the details requested above.

Thanks,
Melissa
The topic has been locked.