Can't post pictures 🤔
- 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 🤔
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.
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
1995 Citroen XM 2.1TD Auto EXCLUSIVE
- MTXM
- Citroen God!
- Posts: 4895
- Joined: Mon Apr 20, 2009 8:45 pm
- Location: Aylsham Norfolk
Re: Can't post pictures 🤔
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!
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!
- 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 🤔
Thanks Matthew.
1993 Citroen XM 2.1 turboSD auto
1995 Citroen XM 2.1TD Auto EXCLUSIVE
1995 Citroen XM 2.1TD Auto EXCLUSIVE
- Dean
- Global Moderator
- Posts: 6116
- Joined: Wed Apr 15, 2009 7:53 am
- Location: Isle of wight
Re: Can't post pictures 🤔
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
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
14 Mitsubishi L200 Trojan
89 Talbot Express 2.0 coach built Auto-trail Chinook
Addicted to Crackanory
-
- Site Admin
- Posts: 1826
- Joined: Tue Apr 14, 2009 9:59 pm
- Orga / RP numbers: 1234
5678
91011 - Location: Ireland
Re: Can't post pictures 🤔
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
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
- 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 🤔
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
1995 Citroen XM 2.1TD Auto EXCLUSIVE
-
- Global Moderator
- Posts: 5925
- Joined: Wed Apr 15, 2009 8:11 am
Re: Can't post pictures 🤔
Hi Ciaran
Now getting the same error as raynoon.
John
Now getting the same error as raynoon.
John
-
- Site Admin
- Posts: 1826
- Joined: Tue Apr 14, 2009 9:59 pm
- Orga / RP numbers: 1234
5678
91011 - Location: Ireland
Re: Can't post pictures 🤔
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
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
- MTXM
- Citroen God!
- Posts: 4895
- Joined: Mon Apr 20, 2009 8:45 pm
- Location: Aylsham Norfolk
Re: Can't post pictures 🤔
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!
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!
-
- Site Admin
- Posts: 1826
- Joined: Tue Apr 14, 2009 9:59 pm
- Orga / RP numbers: 1234
5678
91011 - Location: Ireland
Re: Can't post pictures 🤔
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.
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.