Page 1 of 1
Trade refs generating sql error
Posted: Tue Feb 14, 2006 1:51 am
by pixelgeek
The page to add trade refs is currently spitting out SQL errors.
Error, insert query failed, give this to username:bartertown
cvb
Posted: Tue Feb 14, 2006 3:07 am
by MagickalMemories
This is a known issue.
Leave your reference again. This time, omit any apostrophe's.
Eric
Re: cvb
Posted: Tue Feb 14, 2006 4:18 am
by pixelgeek
MagickalMemories wrote:Leave your reference again. This time, omit any apostrophe's.
There aren't any.
Update: It appears that the problem is either a) too much text in the ref and/or using a dollar sign in the trade amount field.
sew
Posted: Wed Feb 15, 2006 3:04 am
by MagickalMemories
Probably the dollar sign. IIRC, that is already in place there, and the box is for numbers and, of course, a decimal.
Eric
Re: sew
Posted: Wed Feb 15, 2006 4:14 am
by pixelgeek
MagickalMemories wrote:Probably the dollar sign. IIRC, that is already in place there, and the box is for numbers and, of course, a decimal.
If its a known issue why hasn't it just been patched?
xcvv
Posted: Wed Feb 15, 2006 5:25 am
by MagickalMemories
Dude. I don't know.
I'm just a member, like you.
Keep in mind, though, that the guys "in charge" do it for free.
Eric
Re: xcvv
Posted: Wed Feb 15, 2006 5:28 am
by pixelgeek
MagickalMemories wrote:Keep in mind, though, that the guys "in charge" do it for free.
True but that still doesn't mean that you can't do something like post a list of "dos adn don'ts" on the trade ref page.
Posted: Fri Feb 17, 2006 4:23 am
by orcdom
thats what the discussion area is for, if you have ever read any of the other posts of roughly the same thing you will "usually" find this as well in other threads.
and no since of griping about it because now you know and there is another thread telling the next person.
Steve
Posted: Fri Feb 17, 2006 4:41 am
by TrademasterAdam
Pixelgeek, can you post the rest of that error message here?
Thanks,
TrademasterAdam
Posted: Fri Feb 17, 2006 6:56 am
by pixelgeek
TrademasterAdam wrote:Pixelgeek, can you post the rest of that error message here?
I can try to duplicate it...
And it didn't work. So can someone delete the obvious test ref I just posted for Nightlord?
All the rest of the error was a SQL dump and I didn't post it originally for security reasons as I didn't want to post table names etc in public.