Resolved No fields available and cant update it

Hello,
Try to use developer tools to analyze problems document and see if you can find anything that is happening in the background which is causing the error. Can you post the information you find?

is it ok? do you see something?

Hello,

Yes, I can see the red line at the bottom stating you get an internal server error. Let's see if there is any more information. Can you do this again but then also click on the red line and then click on the Response tab. Let me know what it says there.

If it is indeed the internal server error, have a look at the 500 Internal Server Error document. This will give you more insight into this error. We would need the error from the server log in that case.

in the response tab I only have a failed to load response data.
my php version is: 5.5.28

folders are in 755 and file are 644.

Hello,

In that case please check with the hosting company which error that there is in server error log when you run the update. Once we have that error we know where to look to resolve the issue.

I have active the joomla debug system...

and I have this error when I run the update...I have 2 times r86iy_csvi_settings??

Duplicate queries: #8 #9
SELECT `params`

FROM `r86iy_csvi_settings`

WHERE `csvi_setting_id` = 1
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE r86iy_csvi_settings const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
Status Duration
starting 0.01 ms
Waiting for query cache lock 0.00 ms
init 0.00 ms
checking query cache for query 0.00 ms
checking privileges on cached 0.00 ms
checking permissions 0.01 ms
sending cached result to clien 0.01 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1731
16 JDatabaseDriver->loadResult() JROOT/administrator/components/com_csvi/helper/settings.php:45
15 CsviHelperSettings->__construct() JROOT/administrator/components/com_csvi/views/maintenance/view.html.php:62
14 CsviViewMaintenance->onDetail() JROOT/libraries/fof/view/raw.php:110
13 FOFViewRaw->display() JROOT/libraries/fof/controller/controller.php:1114
12 FOFController->display() JROOT/administrator/components/com_csvi/controllers/default.php:69
11 CsviControllerDefault->detail() JROOT/libraries/fof/controller/controller.php:960
10 FOFController->execute() JROOT/administrator/components/com_csvi/controllers/default.php:50
9 CsviControllerDefault->execute() JROOT/administrator/components/com_csvi/controllers/maintenance.php:48
8 CsviControllerMaintenance->execute() JROOT/libraries/fof/dispatcher/dispatcher.php:326
7 FOFDispatcher->dispatch() JROOT/administrator/components/com_csvi/csvi.php:91
6 require_once JROOT/administrator/components/com_csvi/csvi.php JROOT/libraries/cms/component/helper.php:405
5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380
4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/administrator.php:98
3 JApplicationAdministrator->dispatch() JROOT/libraries/cms/application/administrator.php:152
2 JApplicationAdministrator->doExecute() JROOT/libraries/cms/application/cms.php:257
1 JApplicationCms->execute() JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 0.32 ms Query memory: 0.024 MB Memory before query: 11.409 MB Rows returned: 6

Hello,
Joomla debug information is something which is used for identifying performance of a component and this wont help us in finding 500 internal error you are having. As Roland said your actual errors will be in your server log. We would need to check that to help you.

and before I ask this to my support (it seems to me so complicated)...
it not possible that it can be becose installation did not work...

Has I said in my first message : blank page when i install the VM plugin...

can I overwrite files via FTP? where?...in the component? just to try...

Hello,

and before I ask this to my support (it seems to me so complicated)...

Unfortunately that is the nature of the 500 error, where the server says something went wrong but I won't tell you what.

Has I said in my first message : blank page when i install the VM plugin...

Turn on the error reporting in System -> Global configuration -> Server -> Error reporting. Set the level to Development. After that install the VirtueMart plugin again. I think if there is an error it will be the maximum execution time has passed. This can happen as the installer tries to update the list of available fields and that is quite a long one with VirtueMart.

It is worth a try.

i have ask it...but not shure I will have support.

Can I copy paste fields in my mysql BD?

Hello,

Can I copy paste fields in my mysql BD?

Available field list is very big for Virtuemart to do copy paste of fields. How about the solution Roland posted, it didnt help?

ok

heres the log of my server

Hello,

This is the access log, not the error log. You can send the message to your hosting provider asking for the error log. The message could be something like:
-----
When I run a script I get an Internal Server Error. Please provide me with either the error log that contains the error or the actual error message so this issue can be resolved. In the access log I see the error as well. 74.56.53.197 - - [19/May/2016:13:40:09 -0400] "GET /administrator/index.php?option=com_csvi&view=maintenance&task=runoperation&operation=updateavailablefields&component=com_csvi&format=json&run_id=&key=0&0b5f5b67f624a199f4628d0d56fe35af=1&_=1463679605751 HTTP/1.1" 500
-----
Only with that real error do we know what is going on and will we know what to fix.

so they will need a admin access to see it?

my host :
I don't see any messages in error log related to this issue. The internal server error message may occur because of script timeout. I've increased max_execution_time to 180 seconds in php.ini. Please check
whether it made any difference.

and no, it'S not making difference.

one week now that i try to import product update and i cant becose Erreur
No available fields found for import template for com_virtuemart and action product. To update the list of available fields go to Available Fields and click on Update.

and in update I have a An error occured processing the records. The error occured is shown below if available. Additionally check your server log for any errors or warnings.

so, i repeat my question, can I copy/paste via Mysql...juste to update my website faster....

Hello Rosalie,

my host :
I don't see any messages in error log related to this issue. The internal server error message may occur because of script timeout. I've increased max_execution_time to 180 seconds in php.ini. Please check
whether it made any difference.
and no, it'S not making difference.

This cannot be possible, there should be some error in error log which would say why the 500 error occurred. can we get the error log file so we check it?

one week now that i try to import product update and i cant becose Erreur
No available fields found for import template for com_virtuemart and action product. To update the list of available fields go to Available Fields and click on Update.

We need to know why the 500 error is happening so we can help you here. That is only possible with server error logs as 500 error will not give us any information on what went wrong.

so, i repeat my question, can I copy/paste via Mysql...juste to update my website faster....

Instead of trying to copy/paste fields in mysql, Since you said installation didnt go well, can you try to do clean CSVI installation? Uninstall CSVI, CSVI Virtuemart add on plugin from extension manager >> Manage, Remove all CSVI tables from phpmyadmin and then do a fresh installation. If you have any CSVI templates, make sure you take a backup before cleaning. You can backup templates from CSVI maintainence menu, select CSVI Pro in first option and Backup templates from the second option. Let me know if that helps.

Hello Rosalie,

Since your hosting provider doesn't know how their own system works, it is going to be nearly impossible to find out why the 500 error occurs. The maximum execution time isn't usually the problem with a 500 error, more common is the PHP version or file permissions.

If the suggestion of Tharuna doesn't work and you still get the 500 error, I have included an SQL file with my VirtueMart fields. Do know that since the update did not run on your system, the fields may or may not work and you won't have the option of using the custom fields. Depending on what you want to import you could have enough with this.

I do think your hosting company should learn how to check the error logs.

hi

I repeat : Thanks for your great support...

I try to uninstall CSVI clean...with tabs in phpmyadmin and all...

First step, I try in maintenance to export my template:
An error occured processing the records. The error occured is shown below if available. Additionally check your server log for any errors or warnings.
Warning: DOMDocument::createCDATASection() expects parameter 1 to be string, object given in /home/nameofmywebsite/public_html/administrator/components/com_csvi/addon/com_csvi/model/maintenance.php on line 1206

Catchable fatal error: Argument 1 passed to DOMNode::appendChild() must be an instance of DOMNode, null given, called in /home/nameofmywebsite/public_html/administrator/components/com_csvi/models/maintenances.php on line 96 and defined in /home/nameofmywebsite/public_html/administrator/components/com_csvi/addon/com_csvi/model/maintenance.php on line 1206

i forget my template and uninstall, or It tell you something?

nothing works

I deleted everything and re-installation gave the same problem.
I have my fields imported via BD. I created a template, basic ones are gone.
I import my file he said he found no fields.

I miss probably not much to update my shop, someone just help me. I would send an access.

Hello Rosalie,
Please send a private message of your Joomla administrator site, Database and FTP access details. I will have a look at your site.