Can't post pictures 🤔

General information about upcoming maintenance, and other events which affect the forum.
User avatar
raynoon
Could do a 2.1 headgasket
Posts: 1128
Joined: Mon Aug 31, 2015 7:38 am
Orga / RP numbers: 6043
Location: Merseyside

Can't post pictures 🤔

Post by raynoon » Sun Feb 21, 2016 12:13 pm

Keep getting this error message when trying to post a pic:

General Error
SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int. [22003]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
1993 Citroen XM 2.1 turboSD auto
1995 Citroen XM 2.1TD Auto EXCLUSIVE

User avatar
MTXM
Citroen God!
Posts: 4895
Joined: Mon Apr 20, 2009 8:45 pm
Location: Aylsham Norfolk

Re: Can't post pictures 🤔

Post by MTXM » Sun Feb 21, 2016 3:45 pm

John M (XM Exclusive) and I have been experiencing the same problem Ray and apparently Ciaran is on the case! I understood there was a general problem with the site and memory storage, although some people are managing to post pictures! Hopefully all will be fixed soon. Regards, Matthew T.
1989 V6 Exclusive (Poland car) - Now living in a local Motor Museum!
1990 V6sei auto (grey auto)
1990 V6sei manual (gold car)
1990 V6.24 Pallas (Germany car)
1990 V6.24v (Scotland car)
Other previous XM sold and broken too many to mention!

User avatar
raynoon
Could do a 2.1 headgasket
Posts: 1128
Joined: Mon Aug 31, 2015 7:38 am
Orga / RP numbers: 6043
Location: Merseyside

Re: Can't post pictures 🤔

Post by raynoon » Sun Feb 21, 2016 7:05 pm

Thanks Matthew.
1993 Citroen XM 2.1 turboSD auto
1995 Citroen XM 2.1TD Auto EXCLUSIVE

User avatar
Dean
Global Moderator
Posts: 6116
Joined: Wed Apr 15, 2009 7:53 am
Location: Isle of wight

Re: Can't post pictures 🤔

Post by Dean » Sun Feb 21, 2016 7:31 pm

If you want to post pictures in the mean time link them from an external host site like flickr photobucket etc it is just uploading of pictures to the forum that isn't working at the moment.

D
92 Citroen XM Prestige 3.0i Auto R.P5678
14 Mitsubishi L200 Trojan
89 Talbot Express 2.0 coach built Auto-trail Chinook

Addicted to Crackanory

Ciaran
Site Admin
Posts: 1824
Joined: Tue Apr 14, 2009 9:59 pm
Orga / RP numbers: 1234
5678
91011
Location: Ireland

Re: Can't post pictures 🤔

Post by Ciaran » Mon Feb 22, 2016 4:17 pm

Hi guys,
Yes there was (well, still is evidentially), an issue with posting attachments, however this is a different error than that which Matthew and John experienced last week (which was due to lack of disk space on the server, now resolved, although Matthew tells me this morning there's a further issue).

Ray, what size approximately is the file you're trying to upload, and what type is it, i.e .jpg or similar?

Matthew, are you getting the same error as Ray or just that 'The attachment is invalid', same as last week?

As Dean says, in the meantime you can upload the images to an external source such as Dropbox, OneDrive, Photobucket etc and have them be displayed in-line on your forum post, more info on how to do that here.

Ciarán

User avatar
raynoon
Could do a 2.1 headgasket
Posts: 1128
Joined: Mon Aug 31, 2015 7:38 am
Orga / RP numbers: 6043
Location: Merseyside

Re: Can't post pictures 🤔

Post by raynoon » Mon Feb 22, 2016 7:17 pm

Erm.... I'm not too sure on the size, just iPhone pics? And I think they're JPEG?
1993 Citroen XM 2.1 turboSD auto
1995 Citroen XM 2.1TD Auto EXCLUSIVE

xmexclusive
Global Moderator
Posts: 5925
Joined: Wed Apr 15, 2009 8:11 am

Re: Can't post pictures 🤔

Post by xmexclusive » Mon Feb 22, 2016 7:21 pm

Hi Ciaran

Now getting the same error as raynoon.

John

Ciaran
Site Admin
Posts: 1824
Joined: Tue Apr 14, 2009 9:59 pm
Orga / RP numbers: 1234
5678
91011
Location: Ireland

Re: Can't post pictures 🤔

Post by Ciaran » Tue Feb 23, 2016 11:36 am

Thanks guys.

It would appear this issue is a little more complex, so it may take a few days to rectify.

I plan on doing a major overhaul of the forum over the weekend, its well overdue.
Will hopefully have attachments sorted before then, however.

Ciarán

User avatar
MTXM
Citroen God!
Posts: 4895
Joined: Mon Apr 20, 2009 8:45 pm
Location: Aylsham Norfolk

Re: Can't post pictures 🤔

Post by MTXM » Tue Feb 23, 2016 7:05 pm

Many thanks for your continued efforts to fix Ciaran and I am really missing the facility!! Regards, Matthew T.
1989 V6 Exclusive (Poland car) - Now living in a local Motor Museum!
1990 V6sei auto (grey auto)
1990 V6sei manual (gold car)
1990 V6.24 Pallas (Germany car)
1990 V6.24v (Scotland car)
Other previous XM sold and broken too many to mention!

Ciaran
Site Admin
Posts: 1824
Joined: Tue Apr 14, 2009 9:59 pm
Orga / RP numbers: 1234
5678
91011
Location: Ireland

Re: Can't post pictures 🤔

Post by Ciaran » Sat Feb 27, 2016 6:49 pm

Attachment problem is now fixed.

Well, not fixed, but worked around. The issue is actually a limitation in 32 bit operating systems which limits the max addressable size of a particular data type, to 2GB. Everytime a new attachment is uploaded, the forum takes the attachment's file size in bytes, and adds it to a database field which tallies up the overall size of all the attachments.
The attachment directory total size reached 2GB last week, so subsequent attempts to increment the overall attachment directory size field, as new attachments were being added, hit this 2GB limit and hence the SQL query failed with the 'Arithmetic overflow' error, because the 32 bit server OS couldn't address the field when it went beyond that 2GB value.

I've set the attachment directory size field to '0', then modified the attachment code so it manually adds 2GB (2,147,483,648 bytes to be exact), to the actual calculated value, meaning the display of the attachment directory size will remain accurate, and we avoid encountering the problem again - until the attachment directory grows by another 2GB that is!

The long term solution is to upgrade the server to 64bit hardware and OS, I'll be doing this over the next few months. :)

Post Reply