Previous Thread
Next Thread
Print Thread
Hop To
#245923 09/24/2011 10:40 PM
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Trying to upload a 76k jpg, get the following:
Quote
We encountered a problem. The reason reported was
Script: C:\Inetpub\ca.dsm.org\forums\scripts\filemanager.inc.php
Line#: 292
SQL Error: Incorrect integer value: '' for column 'FILE_SIZE' at row 1
SQL Error #: 1366
Query: UPDATE ubbt_FILES SET FILE_NAME = '4.jpg', FILE_ORIGINAL_NAME = 'talon launch.jpg' , FILE_WIDTH = 750 , FILE_HEIGHT = 500 , FILE_SIZE = '' WHERE FILE_ID = 4

Please click back to return to the previous page.


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
No ideas?


...usin' da classic UBB, since the beginning of time.
wink
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
It appears that you need to finish setting up your gallery settings.
I just took a peek at your site but am waiting on verification to complete my registration.

In the meantime try:
http://www.ubbwiki.com/wiki/view/81/gallery.html
For some pointers


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Odd, I didn't get an email to approve you.. but have just done that. smile


...usin' da classic UBB, since the beginning of time.
wink
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
I can't get past the upload. for your site.
So first thing I would do is goto Control Panel » Permission Checks
And see if anything has a fail flag.
Targeting gallery/???
Then goto:
Control Panel » Gallery Settings
Look at what Graphics Library is selected.
By default most people have gd2 selected.
I see the setting is for a file size of 900kb? or so.

Also I would re-save any settings in the control panel regardless if you change something or not.

Finally since you are using the currently released security patch I would open a support ticket in case there is a bug in the patch.

BTW,As of now there is a patch 2

Last edited by Ruben; 09/26/2011 3:25 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
permission checks: all gree OK's
gallery settings: use ImageMagick (had that installed for an unrelated gallery program already)
file size: yeah, with no docs, I guessed that 1000 (or was it 1000000) would be 1 meg

patch 2?
ok... will go get that.


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
No improvement... seems the code isn't sending the file size.

Quote
We encountered a problem. The reason reported was
Script: C:\Inetpub\ca.dsm.org\forums\scripts\filemanager.inc.php
Line#: 292
SQL Error: Incorrect integer value: '' for column 'FILE_SIZE' at row 1
SQL Error #: 1366
Query: UPDATE ubbt_FILES SET FILE_NAME = '15.jpg', FILE_ORIGINAL_NAME = 'P002027.JPG' , FILE_WIDTH = 640 , FILE_HEIGHT = 480 , FILE_SIZE = '' WHERE FILE_ID = 15

Please click back to return to the previous page.


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
ticket submitted


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
but not getting very far... frown


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
use GD -- which will always work, barring other problems.

then, if it DOES work...

you know that it is Imagemagick -- and it is probably incorrect paths like:

/usr/bin/local/convert should be /usr/bin/convert or vice versa

or something simple like that smile


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)