I`m trying to use CSVI 8.60 on VM 4.20 an J4.4.2 for an Multivariant import but i always got the following error:
Unknown column "created_at" in 'field list'....but there isn't such an column anywhere.....
Can you point me to the right direction?
Hello,
Support is given for user issues with active subscription.
As you said there is no created_at field in core VirtueMart tables. Check if the field is from any VirtueMart 3rd party extension table.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna,
many thanks for your answer even if i'm not an subscriber anymore (but have been 2-3 times before) at this time.I'm currently out of buisness and working on my comeback....
In the meantime the errror is changed to "Unknown column 'created_on' in 'field list'"
Can you answer me one last thing?
->Is this Error caused by CSVI, Virtuemart or my Exel CSV?
Even the logfile shows me absolutly nothing why it stops.
The last row is: SELECT virtuemart_customfield_id FROM g710n_virtuemart_product_customfields WHERE virtuemart_product_id = 1 AND virtuemart_custom_id = 3
I have one old Testversion of my Page where it runs absolutly fine and now tried 3 absolut clean installs (joomla, virtuemart,csvi only) and it doesn't work.
All have the same Versions of the components, i also tried php from 7.8 to 8.2
Hello,
The PHP version is irrelevant here. It will be good to know that version 8.6.0 does not have any fixes for the newer PHP version. So you may run into issues due to a too new PHP version. PHP 8.0 should be OK though. The import is apparently trying to update the created_xxx fields but they do not exist in the table it is trying to update. There are other fields like that too like modified_xxx.
Primarily the issue is coming from RO CSVI because it tries to do an insert but without knowing which table it is trying to update it is a guess as to where things stall.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you Roland for your answer...
it is an Product-Multivariant import with the fields:
product_sku;product_parent_sku;product_name;Länge;Farbe;multi_variant_title;multi_variant_fields;file_url_thumb;category_path;product_gtin;product_in_stock;product_price;published;product_s_desc
I just did further Test on my old testpage where i mentioned that it works, but thats wrong.....it only inserts products if you setup up an Multivariant field in the parent product itself....and you need only 1 variant, the others will be created automaticly till the next parent product....
Ok Roland, i think your hint pointed me in the right direction for now...looks good at the moment...many thanks !!!
I created the fields "created_on" and then after the next error the field "created_by" in the table "virtuemart_product_customfields" and it looks lik the import works.
After that i got the following error:
0 Attempt to assign property "resultstats" on null
But i think that should only be the statistics and dont matter?
Hello,
But i think that should only be the statistics and dont matter?
Yes looks like the error is coming from Joomla. You see the error with import? It does not stop the import and products are updated?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Tharuna,
yes this error is thrown after the import but i seems like every product is processed and updated.
Looks like its only statistics and caused by some changes to Joomla 4.
This must be the part of the code in administrator/components/com_csvi/models/logdetails.php line 208:
// Get the status area results
$query->clear()
->select('COUNT(' . $this->db->quoteName('status') . ') AS ' . $this->db->quoteName('total'))
->select($this->db->quoteName('status'))
->select($this->db->quoteName('area'))
->from($this->db->quoteName('#__csvi_logdetails'))
->where($this->db->quoteName('csvi_log_id') . ' = ' . (int) $runId)
->group($this->db->quoteName(array('status', 'area')))
->order($this->db->quoteName('area'));
$this->db->setQuery($query);
$details->resultstats = $this->db->loadObjectList();
But this doesn' matter csvi works now for my needs.Many many thanks
Log in to reply to this topic.