1. belto
  2. RO CSVI
  3. Sunday, 21 August 2022
  4.  Subscribe via email
Fatal error: require_once(): Failed opening required '/home/customer/www/website.com/public_html/plugins/system/customfieldsforallbase/Block/Admin/ProductRow.php' (include_path='.:/usr/local/php74/pear') in /home/customer/www/website.com/public_html/plugins/csviext/customfieldsforall/customfieldsforall.php on line 20

I get this error when running the import product template with XML external link, I analized the file and URL seems to be working file
Accepted Answer
Accepted Answer Pending Moderation
Hello,
I was able to reproduce this error when Basecustomfieldsforall plugin is not installed in the site. This plugin is needed to import Dependent custom fields for all data but not for basic product import. Please load the attached patch file and run the import. The error should be gone with the patch file.
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. # Permalink
Accepted Answer Pending Moderation
hello Tharuna, thank you for the support. as you said now I dont see that error with this patch: but I do see this error

Error
COM_CSVI_ERROR_XML_READING_FILE
Cannot process file /home/customer/www/ofixcomp.com/public_html/tmp/com_csvi/3503165460/lista_precios.xml_cliente_18434&marca_HP&grupo_%25impresora%25&clave_%25&codigo_%25

and I have debugger mentioning this; PHP Warning: XMLReader::open(): Unable to open source data in .../administrator/components/com_csvi/helper/file/import/xml.php:915

Category Message
csvidebug Retrieving file https://www.grupocva.com/catalogo_clientes_xml/lista_precios.xml?cliente=18434&marca=HP&grupo=%25impresora%25&clave=%25&codigo=%25
csvidebug Check if remote file exists
csvidebug URL:https://www.grupocva.com/catalogo_clientes_xml/lista_precios.xml?cliente=18434&marca=HP&grupo=%25impresora%25&clave=%25&codigo=%25
csvidebug Opening socket to ssl://http://www.grupocva.com at port 443
csvidebug HTTP response:HTTP/1.1 200 OK
csvidebug Create temporary filelista_precios.xml_cliente_18434&marca_HP&grupo_%25impresora%25&clave_%25&codigo_%25
csvidebug Retrieve file from remote location
csvidebug HTTP Response: 200
csvidebug Retrieved from URL: https://www.grupocva.com/catalogo_clientes_xml/lista_precios.xml?cliente=18434&marca=HP&grupo=%25impresora%25&clave=%25&codigo=%25


Category Message
databasequery SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM u0wk5_menu AS m LEFT JOIN u0wk5_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
databasequery SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `u0wk5_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
databasequery SELECT template, s.params FROM u0wk5_template_styles as s LEFT JOIN u0wk5_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id WHERE s.client_id = 1 AND home = '1' ORDER BY home
databasequery SELECT `params` FROM `u0wk5_extensions` WHERE `element` = 'com_csvi' AND `type` = 'component'
databasequery SELECT `params` FROM `u0wk5_extensions` WHERE `element` = 'com_csvi' AND `type` = 'component'
databasequery SELECT `csvi_template_id`,`csvi_log_id`,`processfile`,`processfolder`,`position` FROM `u0wk5_csvi_processes` WHERE `csvi_process_id` = 190
databasequery TRUNCATE TABLE `u0wk5_csvi_processed`
databasequery SELECT `csvi_template_id`,`template_name`,`settings`,`action`,`frontend`,`secret`,`log`,`lastrun`,`enabled` FROM `u0wk5_csvi_templates` WHERE `csvi_template_id` = 3
databasequery SELECT `params` FROM `u0wk5_extensions` WHERE `element` = 'com_csvi' AND `type` = 'component'
databasequery SELECT `records` FROM `u0wk5_csvi_logs` WHERE `csvi_log_id` = 236
databasequery UPDATE `u0wk5_csvi_processes` SET `processfolder` = '[ROOT][TMP]/com_csvi/3503165460' WHERE `csvi_process_id` = 190
databasequery INSERT INTO `u0wk5_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (236,0,'COM_CSVI_ERROR_XML_READING_FILE','Failure','Incorrect','COM_CSVI_AREA_CsviHelperFileImportXml')
databasequery SELECT * FROM `u0wk5_users` WHERE `id` = 641
databasequery SELECT `g`.`id`,`g`.`title` FROM `u0wk5_usergroups` AS g INNER JOIN `u0wk5_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 641
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
thank you for the support. as you said now I dont see that error with this patch:

Glad to know that one issue is solved with the patch file.

Error
COM_CSVI_ERROR_XML_READING_FILE
Cannot process file /home/customer/www/ofixcomp.com/public_html/tmp/com_csvi/3503165460/lista_precios.xml_cliente_18434&marca_HP&grupo_%25impresora%25&clave_%25&codigo_%25

and I have debugger mentioning this; PHP Warning: XMLReader::open(): Unable to open source data in .../administrator/components/com_csvi/helper/file/import/xml.php:915

Error says that RO CSVI is not able to read the XML file. In your import template on File tab set Use file extension to XML, save the template and run the import. Check if that solves the import error.
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. # 2
Accepted Answer Pending Moderation
thank you Haruna, I moved to Joomla 4 since I had too many issues not only with your component. It was not solved with this since I already had XML selected in file tab. Maybe the file is not well formatted
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
does the patch work with joomla 4 as well?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
i patched it manually and now it works, curious thing is I did install all the available products in the download section of ROCSVI
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,
does the patch work with joomla 4 as well?

Yes the patch works in Joomla 4 as well.

curious thing is I did install all the available products in the download section of ROCSVI

You should install RO CSVI core package and the needed addons for your import and export :)
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
  • Page :
  • 1


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