Citroen XM Forum

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.

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.

Thanks Matthew.

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

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

Erm.... I'm not too sure on the size, just iPhone pics? And I think they're JPEG?

Hi Ciaran

Now getting the same error as raynoon.

John

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

Many thanks for your continued efforts to fix Ciaran and I am really missing the facility!! Regards, Matthew T.

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.