Any time, a logged-in user navigates to the main page of our site, where the JaNewsFeatured module is active, we get an 1064 database error page (screenshoot attached)

If the JA News Featured module is disabled, than there is no bug and everything works fine.

A similar error was reported in the K2 forum here: https://www.joomlaworks.net/forum/k2-en/46431-error-1064-database-error-in-k2-table
The bug in the mod_janews_featured/helpers/adapter/k2.php file was already fixed by Joomlart.
In the K2.php file there are the row that are being referred to, but we can not fix the error:

93 $query = "SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.name as cattitle, c.params AS categoryparams";
94 $query .= "\n FROM #k2_items as i LEFT JOIN #k2_categories c ON c.id = i.catid";
95 $query .= "\n WHERE i.published = 1 AND i.featured=1 AND i.access <= {$aid} AND i.trash = 0 AND c.published = 1 AND c.access <= {$aid} AND c.trash = 0";

Since we has not modified any files except css, it seems to be a bug. Please, have a look at it.
Thank you!

    raffaizoltan Pls update the ftp account as I asked in another topic, I will check this also.

      Hi, actually all FTP data were given correctly. I've just checked them in 2 separate FTP clients.

      Hi, I just checked the log, the service provider limits the countries by IP that can have FTP access, and I can not change that.
      Would you please try the built in file manager component named 'ProFiles' ? It has all features and almost the same comfort level. Thank you!

      If Profiles does not work, please send us your country code and we do make it set at the service provider

        Hi raffaizoltan

        I updated this file: mod_janews_featured/helpers/adapter/k2.php

        Line 438:

        // $aid = $user->get('aid');
            $aid = $user->get(‘aid’) ? $user->get(‘aid’) : 1;

        It's working fine now, kindly check.

          Write a Reply...
          You need to Login to view replies.