1064 Error Showing Up. Can't Find The Right Solution.

[dayreach]

HELP! I've been driving myself crazy trying to identify what it means when you get error 1064. I have tried a number of solutions but they have not worked. The difference between what I'm reading here and my actual problem is that mine reads:

 

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 ("products_image_med", "products_image_lrg")

 

INSERT INTO products ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'image.jpg',big_imagemed.jpg", "raw_imagelrg.jpg", "", "", "", "", "", "", "", "", "", "", "", "", " 'model', '0', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '1', '', '1', '218')

 

[TEP STOP]

 

Please can anyone help! I'm really going crazy and I've tried everything posted here on how to fix it and it hasn't worked. Any tips will be appreciated!

[Jan Zonjee]

HELP! I've been driving myself crazy trying to identify what it means when you get error 1064. I have tried a number of solutions but they have not worked. The difference between what I'm reading here and my actual problem is that mine reads:

 

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 ("products_image_med", "products_image_lrg")

 

INSERT INTO products ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'image.jpg',big_imagemed.jpg", "raw_imagelrg.jpg", "", "", "", "", "", "", "", "", "", "", "", "", " 'model', '0', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '1', '', '1', '218')

 

[TEP STOP]

 

Please can anyone help! I'm really going crazy and I've tried everything posted here on how to fix it and it hasn't worked. Any tips will be appreciated!

Actually, I hesitate to answer because you (and regrettably many other people) apparently can't be bothered to read what is displayed in the top of this page: For support, please post in another related channel in this forum.. This part of the forum is for posting tips, not to receive them.

 

Take a good look at the code you added in admin/categories.php because I think the error is in the second part with the values:

VALUES ( 'image.jpg',big_imagemed.jpg", "raw_imagelrg.jpg", "", "", "", "", "", "", "", "", "", "", "", "", " 'model',

There is no quote in front of big_imagemed.jpg and in the field for model there is one to many in front of 'model'.

 

Another thing: give relevant information about the page that produces the error and the contribution that you added that caused this error when you ask for help. People here have no crystal balls. Actually, there might even be a support thread for the particular contribution in the General Contribution Support forum.