Support is online

Problem when exporting from FastSeller #8037

Open alex_volhov opened this topic Monday, 15 February 2016 · 5 replies
Author

Very much I ask to help to understand.
There was a problem when exporting from FastSeller.
CSVI of version 6.5.2, the CSVI base are updated (Maintenance-Maintenance, Maintenance-Update available fields) too.
Two absolutely identical templates of export for different types of goods are made.
But in export attempt one type of goods (old) is exported, the second (is recently added) - No.

Besides, I adjusted downloading of the file of export, it doesn't happen, it turns out to send to e-mail only.

The screenshot of a mistake is applied, a log file too. Text of a mistake:

Error
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 ' kma33_fastseller_product_type_2.interior_watches_alarm AS interior_watches' at line 1 SQL=(SELECT , kma33_fastseller_product_type_2.interior_watches_alarmASinterior_watches_alarm, kma33_fastseller_product_type_2.interior_watches_calendarASinterior_watches_calendar, kma33_fastseller_product_type_2.interior_watches_functionASinterior_watches_function, kma33_fastseller_product_type_2.interior_watches_istochnik_energiiASinterior_watches_istochnik_energii, kma33_fastseller_product_type_2.interior_watches_korpus_materialASinterior_watches_korpus_material, kma33_fastseller_product_type_2.interior_watches_mayatnikASinterior_watches_mayatnik, kma33_fastseller_product_type_2.interior_watches_mechanizmASinterior_watches_mechanizm, kma33_fastseller_product_type_2.interior_watches_pogodaASinterior_watches_pogoda, kma33_fastseller_product_type_2.interior_watches_sposob_pokazaASinterior_watches_sposob_pokaza, kma33_fastseller_product_type_2.interior_watches_stranaASinterior_watches_strana, kma33_fastseller_product_type_2.interior_watches_styleASinterior_watches_style, kma33_fastseller_product_type_2.interior_watches_tsiferblat_tsvetASinterior_watches_tsiferblat_tsvet, kma33_fastseller_product_type_2.interior_watches_tsifriASinterior_watches_tsifri, kma33_fastseller_product_type_2.interior_watches_typeASinterior_watches_type, kma33_fastseller_product_type_2.interior_watches_woodASinterior_watches_wood` FROM kma33_fastseller_product_type LEFT JOIN kma33_fastseller_product_product_type_xref ON kma33_fastseller_product_product_type_xref.product_type_id = kma33_fastseller_product_type.product_type_id LEFT JOIN kma33_virtuemart_products ON kma33_fastseller_product_product_type_xref.product_id = kma33_virtuemart_products.virtuemart_product_id LEFT JOIN kma33_fastseller_product_type_2 ON kma33_fastseller_product_type_2.product_id = kma33_virtuemart_products.virtuemart_product_id WHERE kma33_fastseller_product_type.product_type_id IN (2) )

Support

Hello,

Besides, I adjusted downloading of the file of export, it doesn't happen, it turns out to send to e-mail only.

The debug log says the file source is still in Send to email, Please try to change it to Download and try export, don't forget to save the template.

As of the error, Please try loading the attached patch file and run the export again.

patch_fastseller_2016-02-16.zip

Kind regards,

Tharuna

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

Author

It's cool! Export happens without mistakes.
As for loading of the file of export on the computer, last time I adjusted at the same time and sending for e-mail, and loading of the file (as loading didn't happen).
For an example now I adjusted only loading of the file and I send you the log:

Support

Hello Alex,

Glad to hear the export runs good now.

I am unclear as to what the other issue is you have with the export. Do you mean the export file is not send to you via email? If so, have you filled in all the fields on the Email tab? On the File tab did you set the export to Email?

Kind regards,

RolandD

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

Author

On the contrary.
If I choose Source-Destination-Email file, the file comes to mail. Everything is great.
But if I choose Source-Destination-Download, there is no loading of the file via the browser. It is a problem.

Support

Ah, that is clear. Some people need to run the export twice for some reason to get the file and after that it exports always. If that is not the case for you, can you check if you get any JavaScript errors?

The article Using Firebug to analyze problems will explain how to check this.

Kind regards,

RolandD

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

Log in to reply to this topic.