Support is online

Error 1064 on template exporting (SOLVED) #7119

Open levelcom opened this topic Wednesday, 04 February 2015 · 2 replies
Author

Hi my installation is:
Joomla 3.3.6
VirtueMart 3.0.4
PHP 5.6.3
MySQL 5.6.21
Magic Quotes Off.

1st: report a bug: if I try to: Maintenance > CSVI > Backup Template and leave option "Choose backup folder" to default (C:\xampp\htdocs\shop/tmp/com_csvi) I get error:

Could not open file C:/xampp/htdocs/shopC:/xampp/htdocs/shop/tmp/com_csvi/csvi_templates_20150204.csv

2nd: If I change option "Choose backup folder" to "/tmp/com_csvi" I get the following error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY x.id' at line 5 SQL=SELECT x.field_id,r.name FROM lvshop_csvi_template_fields_replacement AS x LEFT JOIN lvshop_csvi_template_fields AS t ON x.field_id = t.id LEFT JOIN lvshop_csvi_replacements AS r ON x.replace_id = r.id WHERE x.field_id IN () ORDER BY x.id

I have the same error if I go higher in the folder depth eg:"/tmp".

Any idea how to fix this?

I'm running this on my Dev. local server to upload templates to my Prod.

Thank you, Dennis

Support

Hello Dennis,

Do you happen to have any templates without any fields?

As for your first point, the bug is rather in how the user input is requested. The second point is definitely an issue of course, for that I have attached a patch file. You can load the patch file and after that you should be able to export the templates.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hi RonaldD

Yes I had fied-less templates, more convenient to me to take configuration from CSV file.

Working like a charm after the patch

Thank you, Dennis

Log in to reply to this topic.