Resolved Error 1064

Hello Christophe,

Either remove (if you use column headers as configuration) or skip (if you use the template fields) the empty custom_title, custom_value and custom_param fields. You should be OK to go.

Hi Roland,

Did both but it did not work ;
Still have this error herehunder ;

Thanks for your support,

Chris

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=DELETE FROM e4h67_virtuemart_product_customfields WHERE virtuemart_product_id = 91 AND virtuemart_custom_id =

Hello Chris,

Can you post the new CSV file you have used? In addition I would like to see the debug log, if you don't see it in the Log details of your import, you can find it in the folder tmp/com_csvi/debug/ and then the latest file.

It should show use where it goes wrong.

Here you go ;

There is no debug found neither on the csvi admin ; no debug file ;
enclosed the modified doc;

C

Hello Chris,

Another idea, you don't happen to have any custom fields with the same name as the fields in your file?

It is a very peculiar error because the query is used only in a few places and they all have to do with custom fields.

No this a blank import from scratch which means no customs fields are defined.
Is it the reason ?

I manage to get the debug here enclosed.
C

The file is not enclosed, make sure it is zipped

here

yep

No this a blank import from scratch which means no customs fields are defined.
Is it the reason ?

That is not completely correct as I see in the debug log that CSVI is indeed processing the custom fields you have in your site.

2015-02-26 15:54:33 1 [DEBUG] Processing custom available field: Storage
2015-02-26 15:54:33 1 [DEBUG] Processing custom available field: Color

So you have at least these 2 custom fields, do you have any other? If so, which ones?

Your right these are the customs fields from the template. No others are listed.
Should I delete them ?

These custom fields come from VirtueMart, they are not in the template. CSVI reads them directly from the database upon import. There shouldn't be a need to delete them since they don't match the fields in your CSV file. At least these two. There is at least 1 custom field that matches a name used by the import routine, this does not have to be a name in the CSV file. That is why I wonder which custom fields you have.

ok I cleared all the products/custom fields through the database.
But still get this answer.

What can I do next?

Chris

Hello Chris,

You still get the error mentioned in your opening post? The debug log is clean, it ends nicely saying it is done and cleans up the old logs.

Hi Roland,

This is still not working for me.
Please help, as it is getting urgent now.
I send you via PM your ID & PM to check.

Thanks
C

Hello Chris,

I can't check because I don't have access to VM. Can you check that please?

Hello Chris,

I have managed to get access by removing myself from some usergroups and just leave the Super Admin. This has also given me a chance to look into the issue. I don't believe this is a CSVI issue because you are missing some basic data from VirtueMart. The Related Products and Related Categories custom fields are gone. This is causing the problems that you see.

It would be best to get the basics of VirtueMart back and then try again. You probably need to do the "Reset all tables and do a fresh install" from the Tools & Migration menu of VirtueMart.

Hi Roland,

I did what you said try even to uninstal and reinstall, updated the tables ...
I have withdrawn the manufacturer name and category path thinking it could cause a problem as they were not identified.

I still get an error now with a 500 server error

Thanks for your support

C

Oops something went wrong.

Let me try to show the warning below here. If nothing shows up then I didn't get any data, sometimes this is caused by faulty plugins.

Cancel the import and check if all settings are correct and try the import again. Status error: 500 Status message: Internal Server Error
System
Users
Menus
Content
Components
Extensions
Help
VirtueMart

Gent-Club

Error
An error has occurred.
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=DELETE FROM e4h67_virtuemart_product_customfields WHERE virtuemart_product_id = 1 AND virtuemart_custom_id =

Chris,

First, I can't open the Product page in VirtueMart, it gives me an error.

I found out what the issue is with the custom fields, your installation has vendor ID set to 0 for the custom fields while in a regular installation this is set to 1 by default. I modified the code so it uses 0 as vendor for the related products/categories fields.

Now on import I still get an Internal Server Error but this is something you need to check with your host, as to why the server stops processing. The real error will be in the server log, so we know where to look. I know it happens somewhere processing the category but that is all. With the exact error we know where to look.

Hi,

I can't open the Product page in VirtueMart, it gives me an error.

I could not either after having reinstalled virtuemart.
I turned the language of the site to FR and it went ok
Could it it has something to do with multilingual site: I chose this option in the beginning ?

Here enclosed the log of the server;

Thanks,

C