Joomla Templates Club 406,261 posts

[adrienne pitman Friend adrienne pitmanJoin date: September 2007Posts: 53Downloads:28Uploads:7 Thanks: 2]

#894266

All of a sudden and out if the blue I started getting an SQL error when accessing the settings interface of JA News Pro.

Table 'rtvn:televisionhispana_live.q9lxy_k2_categories' doesn't exist SQL=SELECT m.* FROM q9lxy_k2_categories m WHERE trash = 0 AND m.published = '1' ORDER BY parent, ordering

K2 has never been installed on this site, therefore the error is all the more mysterious.
Moreover, this site was NOT built from the quickstart package.

Screenshot:
https://www.dropbox.com/s/0mfkrcydsegce60/Screenshot%202016-03-03%2013.30.41.png?dl=0

I must reiterate that this error appeared out of nowhere.

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#894549

Hi,

With this kind of issue with database, the common solution is going to Backend > Extensions > Manage > Database (you can see in the left panel) > Click Fix button.

I did it on your site and you can see the backend of your site is working as well now

Let know me if it helps

Regards

[adrienne pitman Friend adrienne pitmanJoin date: September 2007Posts: 53Downloads:28Uploads:7 Thanks: 2]

#894766

Correct and thank you very much.
But now I have another problem.
It is not possible to save settings in JA News Pro. Clicking Save or Save & Close does nothing.

The JS error console throws the following error:

[Error] Failed to load resource: the server responded with a status of 403 (Forbidden) (helper.php, line 0)
[Error] TypeError: undefined is not an object (evaluating 'result.profile')
    (anonymous function)
    (anonymous function)
    (anonymous function)
    forEach
    (anonymous function)
    each
    fireEvent
    (anonymous function)
    onFailure
    (anonymous function)
    failure
    (anonymous function)
    onStateChange
    (anonymous function)
    (anonymous function)

However, helper.php has the right permissions for this server environment (with suPHP enabled).
All files are set to 644 and belong to user cbrigade.

ls -l modules/mod_janewspro/admin/japrofile/helper.php
-rw-r--r-- 1 cbrigade cbrigade 2090 Mar  3 13:30 modules/mod_janewspro/admin/japrofile/helper.php

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#895794

This reply has been marked as private.

[adrienne pitman Friend adrienne pitmanJoin date: September 2007Posts: 53Downloads:28Uploads:7 Thanks: 2]

#897511

As my earlier post made very clear, I am aware of the error.
However, the file in question has the right permissions.
I’ will check if he error is related to Akeeba Admin Tools.
Must add that only this particular module is throwing the error.

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#897661

JA Newspro module needs to change directly from file below.

modules/mod_janewspro/admin/japrofile/helper.php?jaction=save&profile=nex_sidebar

You can request to Admin Tools component and ask them to make the permission access it

[Author]

Posts