Jump to content
Sign in to follow this  
asiandivergal

Excel Import 1.51 Error (SQL)

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×