Categories
View Replies (9)

Resolved Category Export Failing VM3 J3 Error: 1064[SOLVED]

  1. mmwol
    mmwol
  2. RO CSVI
  3. Wednesday, 14 January 2015
  4.  Subscribe via email
Hi

I cannot get the export of VM categories to work. The Outputted CSV file just contains html warning page rather than any data. In it there is an SQL error

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 '' at line 3 SQL=SELECT file_url

I've set up a custom export to export the following fields.

metadesc
file_url
virtuemart_category_id
slug
category_name
category_description

Find resulting CSV file attached

Cheers

I am using
CSVI Pro 5.20
VM3.0.2
Joomla 3.3.6
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

In your template on the File tab set the Record Grouping to No and you should be able to get all your categories.
Kind regards,

RolandD

=========================
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. # 1
kmeyer
kmeyer
Accepted Answer Pending Moderation
Sorry, I forgot the debug file, it's attached.
Attachments (1)
com_csvi.log.1423594456.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Please also post your debug log as requested under "Where to get the debug information?".
Kind regards,

RolandD

=========================
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. # 3
kmeyer
kmeyer
Accepted Answer Pending Moderation
I've applied the patch, and I get an export file but with only 2 categories, not the 30 or so categories I have set up. There's no error, just 2 records processed. Attached are the log and dumps of the VM category tables. Thanks for your help. I have a similar issue with VM Shipping export.

Joomla 3.3.6, VM 3.0.4. Site is live at test.kurtmeyer.com.
Attachments (4)
CSVI_VM_ExampleVirtueMartCategoryexport_10-02-2015_19.54.csv
w15_virtuemart_categories_en_gb.txt
w15_virtuemart_categories.txt
w15_virtuemart_category_categories.txt
  1. more than a month ago
  2. RO CSVI
  3. # 4
mmwol
mmwol
Accepted Answer Pending Moderation
Many thanks, that has fixed the issue, it was because I had categories without an image.

I'll also try and gets to grips with forum decorum better :unsure:

Cheers
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

There is an edit button available to add info to your original post ;)

The issue can occur when a category has no image linked to it. Attached is a patch file, you can load and the export should be good to go then.
Attachments (1)
patch_category_export_20150114.zip
Kind regards,

RolandD

=========================
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
mmwol
mmwol
Accepted Answer Pending Moderation
Removing the field file_url has fixed it but I really need an export of the field file_url
  1. more than a month ago
  2. RO CSVI
  3. # 7
mmwol
mmwol
Accepted Answer Pending Moderation
Tried updating available fields. No success
  1. more than a month ago
  2. RO CSVI
  3. # 8
mmwol
mmwol
Accepted Answer Pending Moderation
I've tried adjusting the export.php file as suggested below to

SET OPTION SQL_BIG_SELECTS=1

and

SET SQL_BIG_SELECTS=1

but neither work
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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