Need Help on SQL Error

Lakshan · Jan 24, 2015

Hi, I'm getting this error when I try to add wallpapers to my website.

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

I tried to fix it my self, But I don't have much knowledge on it.

Who can fix this for me?

egres · Jan 24, 2015

Could you please show us the query that's returning the error?

Tia Wood · Jan 25, 2015

Are you naming the wallpaper as you add them? It almost sounds like a title may have a character the mysql interrupts as something else, such as a ' or " sign. Maybe if you are naming it something like: Tony's Favorite Wallpaper.

If not, will need to know what values you are submitting.

Lakshan · Jan 25, 2015

egres said:
Could you please show us the query that's returning the error?

tiawood said:
Are you naming the wallpaper as you add them? It almost sounds like a title may have a character the mysql interrupts as something else, such as a ' or " sign. Maybe if you are naming it something like: Tony's Favorite Wallpaper.

If not, will need to know what values you are submitting.

I checked the image names on server and they did not contain any characters which interrupt mysql. However I noticed all those wallpapers I tried to upload had 0 bytes as size. I re-uploaded the wallpapers and everything working fine. Thank you very much

Need Help on SQL Error

Top Member

Established Member

Dev for high-value domains. Email MeTop Member

Top Member

Online.Shopping

ZUZI.com

Stride.co

Unbound.co

Digi.co

ntminer.com

Health.Center

Codical.com

GovST.com

Cortico.com

Similar threads

We're social

Online.Shopping

ZUZI.com

Stride.co

Unbound.co

Digi.co

ntminer.com

Health.Center

Codical.com

GovST.com

Cortico.com

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy