Hello,
How do I fix this?:
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.
- sdmoeller
- RO CSVI
- Thursday, 08 June 2017
- Subscribe via email
0
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
i also have the same issue, disabling the plugin does not help.
Joomla 3.6.5
CSVIPRO 7.2.1
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
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
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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
Of course you could also just update Joomla to the current 3.7.4 version.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
Accepted Answer
Pending Moderation
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »