Author |
Share Topic Topic Search Topic Options
|
Constantine XI
Suspended
Suspended
Joined: 01-May-2005
Online Status: Offline
Posts: 5711
|
Quote Reply
Topic: Avatar upload issue Posted: 25-May-2007 at 22:54 |
Whenever I upload my avatar, I always get this error message:
Any ideas?
All Empires History Forum is temporarily unavailable
An error has occured while writing to the database.
Please try again later.
Error Details:
Support Error Code:- err_mySQL_update_USR
File Name:- register.asp
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC
3.51 Driver][mysqld-4.1.21-community-nt]You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 's not the challenges a people face
which define who they are, but rather the way' at line 1
|
|
azimuth
Caliph
SlaYer'S SlaYer
Joined: 12-Dec-2004
Location: Neutral Zone
Online Status: Offline
Posts: 2979
|
Quote Reply
Posted: 26-May-2007 at 02:17 |
yea happened to me alot before i changed my avatar
if you want i will try to upload it for you, whats the avatar?
|
|
|
Constantine XI
Suspended
Suspended
Joined: 01-May-2005
Online Status: Offline
Posts: 5711
|
Quote Reply
Posted: 26-May-2007 at 03:03 |
Thankyou azimuth, that is very much appreciated. Here is the picture I want to put up, before I get a nicer one:
Edited by Constantine XI - 26-May-2007 at 03:06
|
|
azimuth
Caliph
SlaYer'S SlaYer
Joined: 12-Dec-2004
Location: Neutral Zone
Online Status: Offline
Posts: 2979
|
Quote Reply
Posted: 27-May-2007 at 05:04 |
i tried and got the same error message!
i tried to change mine again and it worked but didnt work with yours, dont know why!
|
|
|
Constantine XI
Suspended
Suspended
Joined: 01-May-2005
Online Status: Offline
Posts: 5711
|
Quote Reply
Posted: 27-May-2007 at 05:16 |
thanks for trying, azimuth. I will take up the issue with the admin staff.
|
|
Dawn
Suspended
Suspended
Joined: 02-Aug-2004
Online Status: Offline
Posts: 3148
|
Quote Reply
Posted: 27-May-2007 at 10:06 |
Northman is the one to ask. I tried and could not get it to go up on your account but it worked fine on mine. I could find no reason why.
|
|
Suren
Arch Duke
Chieftain
Joined: 10-Feb-2006
Location: United States
Online Status: Offline
Posts: 1673
|
Quote Reply
Posted: 27-May-2007 at 15:04 |
It works for me but why max size is 15k ?
|
Anfører
|
|
Constantine XI
Suspended
Suspended
Joined: 01-May-2005
Online Status: Offline
Posts: 5711
|
Quote Reply
Posted: 27-May-2007 at 19:17 |
This file is about 4 kb so it should have no troubles uploading. I have
pm'd Northman and hopefully he can be of assistance soon, this is quite
bizarre though.
|
|
Northman
Tsar
Suspended
Joined: 30-Aug-2004
Online Status: Offline
Posts: 4262
|
Quote Reply
Posted: 28-May-2007 at 02:29 |
Here is what I found out.
Reading the error in the first post carefully, its evident that the problem is not related to the avatar, but to the signature - or more correctly, the two in combination.
A part of the signature appears as a part of the code which generates the error - but only in combination with an avatar.
I removed the signature, uploaded the avatar without troubles... but when I replaced the signature the error was there again. The signature was simply interpreted by the forumsoftware as code, more specifically the very first word "It's".
Changing "It's" to "It is" solved the problem.
Just typing this explanation for possible future reference.
~ Northman
|
|
Constantine XI
Suspended
Suspended
Joined: 01-May-2005
Online Status: Offline
Posts: 5711
|
Quote Reply
Posted: 28-May-2007 at 02:52 |
Thankyou very much Northman, for the life of me I couldn't work out
what the problem could be. Who ever thought computers could be so evil!
|
|
Leonidas
Tsar
Joined: 01-Oct-2005
Location: Australia
Online Status: Offline
Posts: 4613
|
Quote Reply
Posted: 28-May-2007 at 05:08 |
it wasn't the same with the ? mystery man
|
|
The Charioteer
Colonel
Joined: 16-Feb-2006
Online Status: Offline
Posts: 735
|
Quote Reply
Posted: 20-Jul-2007 at 14:13 |
Originally posted by Northman
Here is what I found out.
Reading the error in the first post carefully, its evident that the problem is not related to the avatar, but to the signature - or more correctly, the two in combination.
A part of the signature appears as a part of the code which generates the error - but only in combination with an avatar.
I removed the signature, uploaded the avatar without troubles... but when I replaced the signature the error was there again. The signature was simply interpreted by the forumsoftware as code, more specifically the very first word "It's".
Changing "It's" to "It is" solved the problem.
Just typing this explanation for possible future reference.
~ Northman
|
Thanks for the analysis.
I wonder what if the signature is in Chinese characters, how would it be interpreted by the forumsoftware?
|
|