1. sdmoeller
  2. RO CSVI
  3. Thursday, 08 June 2017
  4.  Subscribe via email
Hello,

How do I fix this?: download.png

Error

Table 'visiotechsecurit.#__fields' doesn't exist SQL=SELECT `name` FROM `#__fields` WHERE `state` = 1 AND `context` = 'com_content.categories'
The list of available fields is out-of-date. Update the list to ensure you have all fields available.
Accepted Answer Pending Moderation
Hello,

Looks like your Joomla is not 3.7 yet. What you can do is go to Extensions -> Plugins. Filter this list on the word fields, then unpublish the plugin called CSVI Pro - Joomla! Custom Fields. The issue should be solved then.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi RolandD,
i also have the same issue, disabling the plugin does not help.

Joomla 3.6.5
CSVIPRO 7.2.1
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Can you load the attached patch file from CSVI maintenance menu and then run the update of available fields?

patch_csvi_2017_06_13.zip
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi, the patch worked fine, thanks.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
The patch helped! THanks!
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
You can update to latest CSVI 7.2.3 version, the fix given in the patch has been included in this version.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,

I installed the patch and current using Joomla 3.7.4 & CSVI 7.2.3 .. but I'm still getting the error message (see below) when trying to export Joomla Category.
I also tried Maintenance -> Tasks -> Reset & Maintenance -> Available Fields -> Update..

Error Message:
Table 'websc_db1.#__fields' doesn't exist SQL=SELECT `name` FROM `#__fields` WHERE `state` = 1 AND `context` = 'com_content.categories'

May I know how to fix this?

Thank you
Regards,
Josh
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Josh,

If you don't have the #__ fields table it means that Custom Fields is not installed or not installed correctly on your site. This can happen if you did an update from an older Joomla version to Joomla 3.7.x. If you go to Articles, do you see FIelds and Field Groups in the left menu? If not, that means that Custom Fields is not installed. Go to Extensions -> Manage -> Discover and click on Discover, you should see Custom Fields in the list and install it.

It will also be good to check your database schema by going to Extensions -> Manage -> Database. Click on Fix if there are any issues.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Roland,

Thanks for the info. Sorry I forgot to include this..
I'm migrating data from Joomla 3.6.5 to Joomla 3.7.4 and the problem is occurred in Joomla 3.6.5.
I followed the steps you advice but I don't see any selection available to install in Extension -> Manage -> Discover.
-> I also tried to disable/enable the plugin (CSVI Pro - Joomla! Custom Fields) but still it won't work and return the same message:
Table 'websc_db1.#__fields' doesn't exist SQL=SELECT `name` FROM `#__fields` WHERE `state` = 1 AND `context` = 'com_content.categories'

->Database structure is up to date..

-> When click on Update for Available fields... I got the following message:
Available fields have been added for table menu
Available fields have been added for table menu
fields_groups not an available table
fields_groups not an available table
fields_categories not an available table
fields_categories not an available table

fields not an available table
fields not an available table
Available fields have been added for table content
Available fields have been added for table content
Available fields have been added for table contact_details
Available fields have been added for table contact_details
Available fields have been added for table categories
Available fields have been added for table categories

Please advice..

Thank you
Regards,
Josh
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hey Josh,

Well Custom Fields doesn't exist in Joomla 3.6.5 as this is a feature of Joomla 3.7. On your Joomla 3.6.5 site you can change the export routine since you are moving to Joomla 3.7 anyway. Open the file plugins\csviaddon\categories\com_categories\model\export\category.php and on line 54 you will see this code
$this->loadCustomFields();
. Change this line to read
// $this->loadCustomFields();
. This should solve the issue.

Of course you could also just update Joomla to the current 3.7.4 version.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Roland,

Got it .. ! I can export and import category now, but somehow getting the message:
"The last server response has not been received in a timely fashion. The server may still be busy or stopped the process. You can wait a little longer to see if the server will sent a response or cancel the process."..

But overall, everything works fine.

Thanks again! :)
Regards,
Josh
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Josh,

Regarding the timeout, have a look at the Manage timeouts document.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!