Resolved Errors during install and during updating available fields.

Hello,

But we had updated CSV to 8.5.0, after that we had issues and needed to downgrade to 7.14.0.

I understand your issues but with RO CSVI 8.6.0 version we have fixed the issue with update of custom fields. You can now update to latest RO CSVI 8.6.0 version and check.

An error occured running the query ALTER TABLE `xxxxx_csvi_logs` MODIFY `records` INT(11) DEFAULT '' ;. This generates the error Invalid default value for 'records'
The list of available fields is out-of-date for extension com_customfilters. Update the list to ensure you have all fields available.

Default value for records field in csvi_logs table should be 0 since it is set to empty you are seeing this error. This is fixed with RO CSVI 8.0.0 version.

We would recommend to update to latest RO CSVI 8.6.0 version and check import of custom fields as well as update of available fields.

Is there a way to change this without upgrading to 8.6.0, because we have issues with 8.5.0 and VM version, with overwriting existing data, and I do not want to face them again.

If I delete this particular table xxxxx_csvi_logs - will the installation of 7.14 version would be successful and would everything works fine?

Hello,
Do not delete the table. This table is needed for log details references. You can change the default value for records field in xxxxx_csvi_logs table from PHPMyAdmin and check. See attached screenshot.

Now I have this error:
An error occured running the query ALTER TABLE `s5qyo_csvi_processes` MODIFY `position` INT(11) UNSIGNED DEFAULT '' ;. This generates the error Invalid default value for 'position'
The list of available fields is out-of-date for extension com_customfilters. Update the list to ensure you have all fields available.

Hello,
Like records field set default value of position field to 0 in s5qyo_csvi_processes table and check.

The value was 0 when I have opened the table.
I have changed the default value for records field in xxxx_csvi_processes table from PHPMyAdmin from 0 to None and It managed to update the available fields.

But now I have this error when I try to make and EXPORT
Error
Column 'category_parent_id' in field list is ambiguous

Hello Hrissy,
You did not mention the export you are using. Check if your changes from this forum post are still in place.

The export is for products with column product_sku, category_path and many more. I am attaching the log from the export.

I have this ot that row:
$this->db->quoteName('category_parent_id', 'pid')

have change it to
$this->db->quoteName('x.category_parent_id', 'pid')

and to

$this->db->quoteName('c.category_parent_id', 'pid')

it both cases it did not work
If I want to make an export without field category_path the export works well.

Thank you very very much Tharuna!

I have loaded the patch (I am attaching it here to be easier, if someone has the same problem) and in file plugins/csviaddon/virtuemart/com_virtuemart/model/export/category.php on line 52 I have changed

$this->db->quoteName('category_parent_id', 'pid')

to

$this->db->quoteName('c.category_parent_id', 'pid')

I am not sure that it is necessary, but I do not want to try changing it with $this->db->quoteName('x.category_parent_id', 'pid') or to leave it as it was before, $this->db->quoteName('category_parent_id', 'pid') because the EXPORT of products including category_path is working like a charm now.

Thank you again for your help, I am sorry for all the questions and my stubbornness not to use version 8.6.0, but I know that with 7.14.0 everything works ok (I have problems with this particular site, because we had updated version here to 8.5.0 before and since then there are some bugs). When we have more time, we will try 8.6.0 and how it works with VM.

Have a great day!!! You are a life savior
P.S. Happy Valentine's day! Celebrate love every day

Hello Hrissy,

I am sorry for all the questions and my stubbornness not to use version 8.6.0, but I know that with 7.14.0 everything works ok (I have problems with this particular site, because we had updated version here to 8.5.0 before and since then there are some bugs).

No problem at all. We totally understand your situation. We recommend latest version because it is tricky to fix issues with older version of files.

When we have more time, we will try 8.6.0 and how it works with VM.

Sure, let us know.

Have a great day!!! You are a life savior
P.S. Happy Valentine's day! Celebrate love every day

Thank you and Happy Valentine's day to you too