Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • Mo0nlight Moderator
    #983073

    Hi.

    Please post your site and admin info in private reply. I will help you check .

    Regards.

    emilioh Friend
    #983491
    This reply has been marked as private.
    Mo0nlight Moderator
    #984667

    Hi.

    I tried to access your site but did not see any error like 1064 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 BLOG_ID FROM #__JOOMBLOG_BLOGS WHERE CONTENT_ID =

    Could you provide a link to the error directly.

    And it seems like JA Comment has some conflicts with video. I’ll check for the problem.

    regards.

    emilioh Friend
    #984763
    This reply has been marked as private.
    Mo0nlight Moderator
    #985498

    Hi.

    I fixed the error about JOOMBLOG_BLOGS, just edit the file plugins/content/jacomment/jacomment.php the code at around line : 270-280.

    function checkComponent($component)
        {
            $db = JFactory::getDBO();
            $query = " SELECT Count(*) FROM #__extensions as c WHERE c.element = '$component' AND c.enabled = 1";
            $db->setQuery($query);
            return $db->loadResult();
        }

    and this code:

    if ($this->checkComponent(strtolower($comName)))
    $article->catid = $obj->getArticleCategoryId($article);

    I need more time to fix the compatibility with video tab. so please stay tuned.

    Regards.

    emilioh Friend
    #986451

    Hello,
    I do not understand where I have to make the changes, I think I should replace the line 270-280 with the first code, but the other to lines (second image) where i should place it??

    Thanks, un saludo

    Mo0nlight Moderator
    #986776

    Hi,

    I already made the change. You can access the link http://s355946011.mialojamiento.es/index.php/component/jevents/eventdetail/1/-/test1?Itemid=1

    There is not error anymore.

    Regards

    emilioh Friend
    #986880

    Hello, Ir works fine, thanks

    un saludo

Viewing 8 posts - 1 through 8 (of 8 total)

This topic contains 8 replies, has 2 voices, and was last updated by  emilioh 8 years ago.

The topic ‘1064 error with JEvents’ is closed to new replies.