Templot Club Archive 2007-2020                             

topic: 2439Upload problems
author remove search highlighting
 
posted: 7 Apr 2014 15:15

from:

PeterD
 
Waterlooville - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
I have tried 7 times to upload a .box file and a .png image and had returned SQL failure.

I have tried opening the .box file in Templot and there was no problem. I also tried to preview the image and again no problem. I have used Chrome and also Internet Explorer and also closed down my PC and re-started it. Still same problem.

Could anyone please advise what I am doing wrong?

Many thanks

Peter

posted: 7 Apr 2014 15:25

from:

Martin Wynne
 
West Of The Severn - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
testing
Attachment: attach_1813_2439_high_road_2014_04_07_1524_49.box     229

posted: 7 Apr 2014 15:28

from:

Martin Wynne
 
West Of The Severn - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
testing png attachment
Attachment: attach_1814_2439_bs95r_dims.png     151

posted: 7 Apr 2014 15:33

from:

Martin Wynne
 
West Of The Severn - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
testing image gallery

2_071030_570000000.gif2_071030_570000000.gif



2_071032_280000000.jpg2_071032_280000000.jpg



posted: 7 Apr 2014 15:40

from:

Martin Wynne
 
West Of The Severn - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
Hi Peter,

It seems ok now. The usual rule if there is a server problem is to wait half an hour and try again. :)

We are currently on a congested server -- Jim is planning to move us soon.

A few points to bear in mind:

1. when attaching files there must be at least one word of text. You can't attach files to an empty message (perhaps intending to edit it later).

2. when attaching files there is a size limit of 6 MB.

3. the image gallery can't resize images wider than about 4000 pixels. Re-size them first before uploading.

regards,

Martin.

posted: 7 Apr 2014 16:28

from:

PeterD
 
Waterlooville - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
Thanks Martin, I shall give it a try after we have eaten.
Best wishes

Peter

posted: 7 Apr 2014 20:49

from:

PeterD
 
Waterlooville - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
Hi Martin,
This is the report when uploading. I tried it again this evening.
------------
Invalid SQL query: INSERT INTO ultra_gallery (user_id, photo_name, comment) VALUES (2184, '2184_071404_530000000.png', 'Scissors for comments \; [Scissors in 6' way.png uploaded 7 Apr 2014]')-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 'way.png uploaded 7 Apr 2014]')' at line 1
------------

Best wishes

Peter

posted: 7 Apr 2014 22:33

from:

Alan Turner
 
Dudley - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides


PeterD wrote:
Hi Martin,
This is the report when uploading. I tried it again this evening.
------------
Invalid SQL query: INSERT INTO ultra_gallery (user_id, photo_name, comment) VALUES (2184, '2184_071404_530000000.png', 'Scissors for comments ; [Scissors in 6' way.png uploaded 7 Apr 2014]')-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 'way.png uploaded 7 Apr 2014]')' at line 1
------------

Best wishes

Peter

this  is my attempt. Seems to work for me.
42_071733_090000000.jpg42_071733_090000000.jpg
Alan

Last edited on 7 Apr 2014 22:35 by Alan Turner
posted: 8 Apr 2014 01:15

from:

Martin Wynne
 
West Of The Severn - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
PeterD wrote:
This is the report when uploading. I tried it again this evening.
------------
Invalid SQL query: INSERT INTO ultra_gallery (user_id, photo_name, comment) VALUES (2184, '2184_071404_530000000.png', 'Scissors for comments ; [Scissors in 6' way.png uploaded 7 Apr 2014]')-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 'way.png uploaded 7 Apr 2014]')' at line 1
Hi Peter,

Ah. :)

Your problem is that you used an invalid character in the file name:

 Scissors in 6' way.png

The single quote character ' is not valid in file names. It will usually work on your own computer but not on the web. When naming files for uploading to web sites, use only:

a..z
0..9
and underscores: _

Nothing else -- no spaces, and no punctuation marks apart from the dot marking the file type extension. And ideally all in lower case -- web files are case sensitive and it's easy to make mistakes if you mix the case and then forget. File names are symbols, they are not intended to be the title of the contents.

If you rename the file:

 scissors_in_6ft_way.png

I think you will find that it will upload ok. And the same with the .box file.

You could say that this is a bug and that I should make the forum software check file names, remove invalid characters and display a warning.

It has been on my list of things to do for years, but nowadays I can only do so much. Sorry. :(

regards,

Martin.

posted: 8 Apr 2014 07:32

from:

PeterD
 
Waterlooville - United Kingdom

click the date to link to this post
click member name to view archived images
view images in gallery view images as slides
Thanks Martin.

I knew it had to be a fault of mine that's why I posted the message. What a fool I have been and I am very sorry that I wasted your valuable time on something I knew about but had over looked.

Very best wishes

Peter



Templot Club > Forums > Baffled beginners > Upload problems
about Templot Club

Templot Companion - User Guide - A-Z Index Templot Explained for beginners Please click: important information for new members and first-time visitors.
indexing link for search engines

back to top of page


Please read this important note about copyright: Unless stated otherwise, all the files submitted to this web site are copyright and the property of the respective contributor. You are welcome to use them for your own personal non-commercial purposes, and in your messages on this web site. If you want to publish any of this material elsewhere or use it commercially, you must first obtain the owner's permission to do so.
The small print: All material submitted to this web site is the responsibility of the respective contributor. By submitting material to this web site you acknowledge that you accept full responsibility for the material submitted. The owner of this web site is not responsible for any content displayed here other than his own contributions. The owner of this web site may edit, modify or remove any content at any time without giving notice or reason. Problems with this web site? Contact webmaster@templot.com.   This web site uses cookies: click for information.  
© 2020  

Powered by UltraBB - © 2009 Data 1 Systems