Hi to all,
Have an issue trying to backup a specific template (it's Google Merchant Export type),
i get the attached error.
Would appreciate your feedback.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello,
Try to use developer tools to analyze problems document and see if you get the full information on the error. Can you post a screenshot of it?
Try to use developer tools to analyze problems document and see if you get the full information on the error. Can you post a screenshot of it?
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,
Do you see the same error when you backup other templates too? Can you check with other templates?
Do you see the same error when you backup other templates too? Can you check with other templates?
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
Hi Tharuna,
Some templates works, some do not.
See attached screenshot from Google Dev Tools
When i click on the link i see on a new page:
{"success":true,"message":null,"messages":{"message":["vmdebug PHP 5.4<\/span>","vmdebug Show All Errors<\/span>","vmdebug my lfbs <\/span>","vmdebug LangCount: 23 $siteLang: en-EU self::$vmlangSef: en self::$_jpConfig->lang en_eu DefLang en_eu<\/span>","vmdebug vmTime: time to load config: 0.00335288047790527<\/span>"],"error":["No templates have been selected to backup. At least one template must be selected to be able to run the backup."]},"data":{"process":false,"url":"https:\/\/http://www.quality-tuning.eu\/administrator\/index.php?option=com_csvi&view=maintenance","run_id":0}}
Rgrds,
Chris
Some templates works, some do not.
See attached screenshot from Google Dev Tools
When i click on the link i see on a new page:
{"success":true,"message":null,"messages":{"message":["vmdebug PHP 5.4<\/span>","vmdebug Show All Errors<\/span>","vmdebug my lfbs <\/span>","vmdebug LangCount: 23 $siteLang: en-EU self::$vmlangSef: en self::$_jpConfig->lang en_eu DefLang en_eu<\/span>","vmdebug vmTime: time to load config: 0.00335288047790527<\/span>"],"error":["No templates have been selected to backup. At least one template must be selected to be able to run the backup."]},"data":{"process":false,"url":"https:\/\/http://www.quality-tuning.eu\/administrator\/index.php?option=com_csvi&view=maintenance","run_id":0}}
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello,
You seem to have VirtueMart debug enabled and so you are seeing logs messages from Virtuemart, you can disable it on VirtueMart Configuration page -> Shop, at the bottom you can set it to no debug.
The error in the message you posted shows "No templates have been selected to backup. At least one template must be selected to be able to run the backup." . It looks like you haven't selected any template for backup. Please check the template name and try taking the backup.
You seem to have VirtueMart debug enabled and so you are seeing logs messages from Virtuemart, you can disable it on VirtueMart Configuration page -> Shop, at the bottom you can set it to no debug.
The error in the message you posted shows "No templates have been selected to backup. At least one template must be selected to be able to run the backup." . It looks like you haven't selected any template for backup. Please check the template name and try taking the backup.
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,
Noted for the VM Debug, disabled.
For the error, i'm indeed selecting a template (if you don't select one you get a notice from CSVI), but the issue is there.
Rgrds,
Chris
Noted for the VM Debug, disabled.
For the error, i'm indeed selecting a template (if you don't select one you get a notice from CSVI), but the issue is there.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
In that case the error shown is not giving us the full information on where the execution is breaking. It also shows 500 error in your screenshot. Please have a look at 500 error document and see if you can get any information on the error from your server error logs.
In that case the error shown is not giving us the full information on where the execution is breaking. It also shows 500 error in your screenshot. Please have a look at 500 error document and see if you can get any information on the error from your server error logs.
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 Chris,
With the VM debug disabled, what happens if you select a template and click on Backup?
With the VM debug disabled, what happens if you select a template and click on Backup?
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,
It's the same, but also checked some other templates and i get this error:
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::save(/home/xxx/public_html/tmp/com_csvi/csvi_templates_20170109.xml): failed to open stream: No such file or directory in /home/xxx/public_html/administrator/components/com_csvi/addon/com_csvi/model/maintenance.php on line 1247
{"success":true,"message":null,"messages":null,"data":{"run_id":1555,"info":"","continue":false,"cancel":false,"key":0,"downloadfile":"https:\/\/http://www.quality-tuning.eu\/administrator\/index.php?option=com_csvi&task=exports.downloadfile&tmpl=component&file=L2hvbWUvcXR0ZXN0L3B1YmxpY19odG1sL3RtcC9jb21fY3N2aS9jc3ZpX3RlbXBsYXRlc18yMDE3MDEwOS54bWw=","process":false,"url":"https:\/\/www.quality-tuning.eu\/administrator\/index.php?option=com_csvi&view=logdetails&run_id=1555&return=aHR0cHM6Ly93d3cucXVhbGl0eS10dW5pbmcuZXUvYWRtaW5pc3RyYXRvci9pbmRleC5waHA\/b3B0aW9uPWNvbV9jc3ZpJnZpZXc9bWFpbnRlbmFuY2U="}}
I will also check my server logs later today and advise.
Rgrds,
Chris
It's the same, but also checked some other templates and i get this error:
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::save(/home/xxx/public_html/tmp/com_csvi/csvi_templates_20170109.xml): failed to open stream: No such file or directory in /home/xxx/public_html/administrator/components/com_csvi/addon/com_csvi/model/maintenance.php on line 1247
{"success":true,"message":null,"messages":null,"data":{"run_id":1555,"info":"","continue":false,"cancel":false,"key":0,"downloadfile":"https:\/\/http://www.quality-tuning.eu\/administrator\/index.php?option=com_csvi&task=exports.downloadfile&tmpl=component&file=L2hvbWUvcXR0ZXN0L3B1YmxpY19odG1sL3RtcC9jb21fY3N2aS9jc3ZpX3RlbXBsYXRlc18yMDE3MDEwOS54bWw=","process":false,"url":"https:\/\/www.quality-tuning.eu\/administrator\/index.php?option=com_csvi&view=logdetails&run_id=1555&return=aHR0cHM6Ly93d3cucXVhbGl0eS10dW5pbmcuZXUvYWRtaW5pc3RyYXRvci9pbmRleC5waHA\/b3B0aW9uPWNvbV9jc3ZpJnZpZXc9bWFpbnRlbmFuY2U="}}
I will also check my server logs later today and advise.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
Can you check the permissions of your tmp folder? The error message says it cannot find the file so i guess it was not able save the file.
Can you check the permissions of your tmp folder? The error message says it cannot find the file so i guess it was not able save the file.
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
Hi Tharuna,
Checked the permission is 755. Btw, the folder is empty.
Rgrds,
Chris
Checked the permission is 755. Btw, the folder is empty.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello:
This is the error seen in server log:
mod_fcgid: stderr: PHP Warning: DOMDocument::createCDATASection() expects parameter 1 to be string, object given in /home/xxx/public_html/administrator/components/com_csvi/addon/com_csvi/model/maintenance.php on line 1207, referer: https://www.quality-tuning.eu/administrator/index.php?option=com_csvi&view=maintenance
Rgrds,
Chris
This is the error seen in server log:
mod_fcgid: stderr: PHP Warning: DOMDocument::createCDATASection() expects parameter 1 to be string, object given in /home/xxx/public_html/administrator/components/com_csvi/addon/com_csvi/model/maintenance.php on line 1207, referer: https://www.quality-tuning.eu/administrator/index.php?option=com_csvi&view=maintenance
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
Can you send me your site Joomla administrator login details, ftp and database access details to check this issue?
Can you send me your site Joomla administrator login details, ftp and database access details to check this issue?
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
Hi Tharuna,
Sure, will PM you. I will just need your current working IP address.
Rgrds,
Chris
Sure, will PM you. I will just need your current working IP address.
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
My current ip is 103.196.221.121.
My current ip is 103.196.221.121.
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 Chris,
Thank you so much for sending the details. Your both issues of backup templates and SQL error on export are solved on your site. Can you check and confirm if they are working?
Thank you so much for sending the details. Your both issues of backup templates and SQL error on export are solved on your site. Can you check and confirm if they are working?
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
Hi Tharuna,
Thanks for the help, confirm that the backup works ok
For the export i still get the error when trying to export 'Merchant Test' template:
Error
Unknown column '#__virtuemart_categories.published' in 'where clause' SQL=SELECT `#__virtuemart_products`.`virtuemart_product_id`, `#__virtuemart_products`.`product_parent_id`, `product_sku` FROM `#__virtuemart_products` LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency` LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id` WHERE `#__virtuemart_products`.`product_parent_id` = 0 AND `#__virtuemart_categories`.`published` = 1 AND #__virtuemart_products.published = 1 AND `#__virtuemart_product_prices`.`virtuemart_shoppergroup_id` = '4' GROUP BY #__virtuemart_products.virtuemart_product_id
Rgrds,
Chris
Thanks for the help, confirm that the backup works ok
For the export i still get the error when trying to export 'Merchant Test' template:
Error
Unknown column '#__virtuemart_categories.published' in 'where clause' SQL=SELECT `#__virtuemart_products`.`virtuemart_product_id`, `#__virtuemart_products`.`product_parent_id`, `product_sku` FROM `#__virtuemart_products` LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency` LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id` WHERE `#__virtuemart_products`.`product_parent_id` = 0 AND `#__virtuemart_categories`.`published` = 1 AND #__virtuemart_products.published = 1 AND `#__virtuemart_product_prices`.`virtuemart_shoppergroup_id` = '4' GROUP BY #__virtuemart_products.virtuemart_product_id
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
Please check your export template now and let me know. I have fixed the SQL error.
Please check your export template now and let me know. I have fixed the SQL error.
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
- 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 »