asiandivergal Posted February 28, 2007 Share Posted February 28, 2007 Hi everyone, I have tried bulk upload of my products using Excel Import 1.51, with a Microsoft Excel document saved in .csv format. However, it failed with the following message: File uploaded. Temporary filename: /tmp/phpPSRTSG User filename: Batch1upload.csv Size: 110971 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 1 insert into categories(date_added, parent_id) values ('2007-03-01',) [TEP STOP] Could someone kindly assist, how to solve the following error? (I'm a newbie in PHP programming and such, and will apreciate any explanation in simple terms. Thank you in advance! Cheers, Agnes Quote Link to comment Share on other sites More sharing options...
adyck Posted February 28, 2007 Share Posted February 28, 2007 Hi everyone, I have tried bulk upload of my products using Excel Import 1.51, with a Microsoft Excel document saved in .csv format. However, it failed with the following message: File uploaded. Temporary filename: /tmp/phpPSRTSG User filename: Batch1upload.csv Size: 110971 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 1 insert into categories(date_added, parent_id) values ('2007-03-01',) [TEP STOP] Could someone kindly assist, how to solve the following error? (I'm a newbie in PHP programming and such, and will apreciate any explanation in simple terms. Thank you in advance! Cheers, Agnes Quote Link to comment Share on other sites More sharing options...
adyck Posted February 28, 2007 Share Posted February 28, 2007 Hi everyone, I have tried bulk upload of my products using Excel Import 1.51, with a Microsoft Excel document saved in .csv format. However, it failed with the following message: File uploaded. Temporary filename: /tmp/phpPSRTSG User filename: Batch1upload.csv Size: 110971 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 1 insert into categories(date_added, parent_id) values ('2007-03-01',) [TEP STOP] Could someone kindly assist, how to solve the following error? (I'm a newbie in PHP programming and such, and will apreciate any explanation in simple terms. Thank you in advance! Cheers, Agnes Quote Link to comment Share on other sites More sharing options...
adyck Posted February 28, 2007 Share Posted February 28, 2007 My experience is that because apostrophes are used in PHP programming, apostrophes within the text you are uploading confuses PHP. I replace mine with underscores. I know it's not ideal but that's what works for me. Maybe others have a better solution Arthur Quote Link to comment Share on other sites More sharing options...
asiandivergal Posted March 2, 2007 Author Share Posted March 2, 2007 Hi Arthur, Thank you for your kind response. It seems that the error was due to an error to my csv file (according to the tech guys of my webhosting company). I created a new csv file using OpenOffice and uploaded it, but it fails to recognise all the data - firstly it lumps all the products into Misc category and all the product description, pricing, manufacturer into etc goes missing or haywire. I'm not sure why it does not recognise the info. I am going to remove this contribution (could be an error with the installation part), and try with EasyPopulate instead. Hopefully it will work out better. Cheers, Agnes My experience is that because apostrophes are used in PHP programming, apostrophes within the text you are uploading confuses PHP. I replace mine with underscores. I know it's not ideal but that's what works for me. Maybe others have a better solution Arthur Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.