hendy777
|
| posted on 31/3/17 at 09:53 AM |
|
|
Cant upload images
Hi,
Iv done some searching on here and found a few solutions but still having trouble uploading to the photo archive. I keep getting this message:
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
The image has been resized to 800 x 600 pixels and iv made sure it was only letters and not symbols or dots in the filename.
What am i doing wrong?
Thanks
|
|
|
|
|
nick205
|
| posted on 31/3/17 at 10:28 AM |
|
|
Don't know what the solution is, but I'm getting the same issue trying to upload images. Tried deleting browser history, restarting the
laptop etc., but no change.
Good to hear it's not just me!
[Edited on 31/3/17 by nick205]
|
|
|
r1_pete
|
| posted on 31/3/17 at 10:49 AM |
|
|
I just uploaded a couple of pictures from the mac no problems.....
|
|
|
loggyboy
|
| posted on 31/3/17 at 11:40 AM |
|
|
Are they are large files? (as in MB not resolution?)
Large ones get rejected but it isnt always clear thats the reason.
[Edited on 31-3-17 by loggyboy]
Mistral Motorsport
|
|
|
nick205
|
| posted on 31/3/17 at 11:47 AM |
|
|
quote:
Originally posted by loggyboy
Are they are large files? (as in MB not resolution?)
Large ones get rejected but it isnt always clear thats the reason.
[Edited on 31-3-17 by loggyboy]
Resized mine to 800x600 pixels and sub 1mb file size - still doesn't work.
|
|
|
hendy777
|
| posted on 31/3/17 at 11:49 AM |
|
|
Sussed it!!
Opened it in Photoshop and reduced the quality right down to low and it worked. It was at 90KB but now down to 65KB.
Thanks
|
|
|
Ugg10
|
| posted on 31/3/17 at 12:11 PM |
|
|
Host on Flickr and then just copy bbcode into message.
---------------------------------------------------------------
1968 Ford Anglia 105e, 1.7 Zetec SE, Mk2 Escort Workd Cup front end, 5 link rear
Build Blog - http://Anglia1968.weebly.com
|
|
|
ChrisW
|
| posted on 31/3/17 at 12:12 PM |
|
|
There was a problem last night which I have now resolved. Ran out of disk space on the server! Would you believe it: LB has 102,000 images
uploaded!
Chris
My gaff my rules
|
|
|
nick205
|
| posted on 1/4/17 at 06:30 PM |
|
|
Good work Chris!
Thank you
|
|
|
russbost
|
| posted on 6/4/17 at 07:39 AM |
|
|
I'm getting the same problem
"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"
& it won't let me upload any images - I've tried deleting some older images that I no longer need to try to free up space, but
hasn't made any difference - any ideas?
I can't add to my build diary at the moment! 
Edited to say, would it help if everyone went thro' their images & deleted old stuff they no longer need? I would have thought that should
free up a ton of space?
[Edited on 6/4/17 by russbost]
I no longer run Furore Products or Furore Cars Ltd, but would still highly recommend them for Acewell dashes, projector headlights, dominator
headlights, indicators, mirrors etc, best prices in the UK! Take a look at http://www.furoreproducts.co.uk/ or find more parts on Ebay, user names
furoreltd & furoreproducts, discounts available for LCB users.
Don't forget Stainless Steel Braided brake hoses, made to your exact requirements in any of around 16 colours.
http://shop.ebay.co.uk/furoreproducts/m.html?_dmd=1&_ipg=50&_sop=12&_rdc=1
|
NOTE:This user is registered as a LocostBuilders trader and may offer commercial services to other users
|
40inches
|
| posted on 6/4/17 at 07:51 AM |
|
|
quote:
Originally posted by Ugg10
Host on Flickr and then just copy bbcode into message.
I find it frustrating when an interesting, pic heavy, thread is ruined because the photos are no longer hosted
|
|
|
z2000
|
| posted on 6/4/17 at 08:21 AM |
|
|
Same issue for me trying to upload a 12kb JPG file.
I have about 5 photos in my archive too.
Agree that perhaps there are a lot of old photos that people could delete to free up space? maybe a new thread is needed?
If it isn't broken; take it apart and fix it! Build PhotoBlog:
http://z2000.co.uk
|
|
|
Ugg10
|
| posted on 6/4/17 at 08:43 AM |
|
|
quote:
Originally posted by 40inches
quote:
Originally posted by Ugg10
Host on Flickr and then just copy bbcode into message.
I find it frustrating when an interesting, pic heavy, thread is ruined because the photos are no longer hosted
That is one of the beauties for me - if you want to remove a picture from the web, just delete/rename one file and all of the links disappear, but I
am a bit of a control freak.
---------------------------------------------------------------
1968 Ford Anglia 105e, 1.7 Zetec SE, Mk2 Escort Workd Cup front end, 5 link rear
Build Blog - http://Anglia1968.weebly.com
|
|
|
nick-york
|
 posted on 5/9/17 at 10:57 PM |
|
|
Well I've just wasted another hour of my time trying to upload some pictures into my archive !! I've downloaded the photobucket app to see
if that helped .Just made the situation more confusing .every time I've tried doing this over a few years now I've had problems .so now I
just give up ! Any posts I put on here just won't have any pictures with them unfortunately. And it's not just me that has problems with
this .It is so frustrating and drives me completely mad ! I can fully understand why a lot of people are using the kit car groups on Facebook for
their info .It is so easy and straightforward and takes seconds ! Anybody else as peeved as me about uploading pictures ? Cheers - nick
|
|
|
McLannahan
|
| posted on 6/9/17 at 08:08 AM |
|
|
Hi Nick - This issue does raise its head every few months and with the very odd exception when it's Chris's site at fault - it does
work.
Common issues that cause failure are....
1 - Pictures too large. Keep them below 100kb if you can. I know that seems small but it'll help the server and people viewing on bad/mobile
connections.
I use Pixresizer for this as it'll do bulk and takes a few seconds but there's loads of good free tools
2 - Picture name not unique - This is an annoying one as it's not an obvious "this picture is called the same as one that already
exists" type error!. If you prefix all your images with your own username that should always get success?
I've just uploaded this with no issues and I was confident no similar file names would exist on a forum about cars!
 
A pretty butterfly of course
All the best
[Edited on 6/9/17 by McLannahan]
|
|
|
nick-york
|
| posted on 6/9/17 at 08:35 PM |
|
|
Well I've managed to reduce one of the pictures and tried to upload it but no luck .but it gives different reason for not doing it .tried to
rename the picture without any luck .Thanks for the help .I just don't know why it can't be easy .Cheers.
|
|
|
snippy
|
| posted on 24/1/19 at 08:50 PM |
|
|
Is this problem back? I`ve been trying to upload some pics for the last few days but keep getting the same error message -
"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
The pics I was going to upload are only 65kb, I`ve also tried changing the file name to something not likely to have been used before but still no
joy. I`ve also deleted a few pics from my archive. Any one else having the same issue?
|
|
|
gremlin1234
|
| posted on 24/1/19 at 09:00 PM |
|
|
quote:
Originally posted by snippy
Is this problem back? I`ve been trying to upload some pics for the last few days but keep getting the same error message -
"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
The pics I was going to upload are only 65kb, I`ve also tried changing the file name to something not likely to have been used before but still no
joy. I`ve also deleted a few pics from my archive. Any one else having the same issue?
yes its currently broken,
estimated time to fix : N/A
|
|
|
loggyboy
|
| posted on 25/4/19 at 11:55 AM |
|
|
Still no fix to this... bummer
|
|
|
CosKev3
|
| posted on 25/4/19 at 04:08 PM |
|
|
Someone chuck some coal on the fire please get this prehistoric forum going
|
|
|
Mr Whippy
|
| posted on 26/4/19 at 05:54 AM |
|
|
given the activity on the site these days I doubt there is any justification in investing in better hardware. Might be an idea to do a purge though
and delete a few years worth of images, maybe on old accounts not accessed in the last 2 years
Really we're probably not helping either, when was the last time people went through their images and deleted the redundant ones? (although it
is a spectacularly slow process to do so...a folder delete button would be helpful here Chris )
No idea how much money Chris actually pulls in from donations but I bet it's not much an isn't enough and he runs this as a side hobby too
so really can't complain.
[Edited on 26/4/19 by Mr Whippy]
|
|
|
kingster996
|
| posted on 26/4/19 at 06:37 AM |
|
|
The site needs a complete update - look at the member list from March onwards, thousands of “bots” registered.
Sadly it must cost more to maintain than its worth in fees.
I know exactly what it’s like to do this as I’m a full time web developer and happen to maintain the WSCC site. Although I personally take no money
for this, the WSCC forum is paid for by member subscriptions and without that it would slowly die like this one is.
When I get a reminder on here to “contribute” again I choose not to because I do not see a penny of investment. If Chris decided to put something in
other than the basic server hosting fees, then I’d give money again, but otherwise it’s just not a good investment.
Sadly the likes of Facebook are taking us all away from places like this that are full of amazing people with a mass of knowledge.
I used to be indecisive, but now I'm not so sure
|
|
|
