error adding photo - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports » error adding photo

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	50
DennyP	24
Gizmo	23
Dunny	15
SteveS	13
AllenAyres	12
dbremer	10
SD	10
drkknght00	9
doug	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Topic Options

#245923 - 09/24/11 10:40 PM

error adding photo

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

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.

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#245980 - 09/26/11 12:33 PM

Re: error adding photo [Re: Andrew Bienhaus]

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

No ideas?

_________________________
...usin' da classic UBB, since the beginning of time.

Top

#245981 - 09/26/11 01:41 PM

Re: error adding photo [Re: Andrew Bienhaus]

Ruben

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL

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/index.php?title=Gallery
For some pointers

Edited by Ruben (09/26/11 01:46 PM)
Edit Reason: Added Comment

_________________________
Blue Man Group

Top

#245986 - 09/26/11 02:54 PM

Re: error adding photo [Re: Andrew Bienhaus]

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

Odd, I didn't get an email to approve you.. but have just done that.

_________________________
...usin' da classic UBB, since the beginning of time.

Top

#245987 - 09/26/11 03:14 PM

Re: error adding photo [Re: Andrew Bienhaus]

Ruben

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL

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

Edited by Ruben (09/26/11 03:25 PM)

_________________________
Blue Man Group

Top

#245991 - 09/26/11 04:18 PM

Re: error adding photo [Re: Andrew Bienhaus]

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

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.

Top

#245992 - 09/26/11 04:23 PM

Re: error adding photo [Re: Andrew Bienhaus]

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

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.

Top

#245993 - 09/26/11 04:28 PM

Re: error adding photo [Re: Andrew Bienhaus]

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

ticket submitted

_________________________
...usin' da classic UBB, since the beginning of time.

Top

#246202 - 10/04/11 12:49 PM

Re: error adding photo [Re: Andrew Bienhaus]

Andrew Bienhaus Offline

member

Registered: 04/10/07
Posts: 135
Loc: Binbrook, Ontario, Canada

but not getting very far...

_________________________
...usin' da classic UBB, since the beginning of time.

Top

#246207 - 10/04/11 03:46 PM

Re: error adding photo [Re: Andrew Bienhaus]

SD	Registered: 04/19/07 Posts: 4056 Loc: SoCal, USA

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

_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I

you, click this link as to why

Top

Previous Topic

Index

Next Topic

Hop to:

Moderator: AllenAyres, Harold, Ian, Ron M

Shout Box

May
Su	M	Tu	W	Th	F	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Today's Birthdays

No Birthdays