Trade refs generating sql error
Moderator: Moderators
-
pixelgeek ( 204 )
- Resident Trader
- Posts: 423
- Joined: Wed Dec 03, 2003 4:22 pm
- Location: Calgary, Alberta Canada
Trade refs generating sql error
The page to add trade refs is currently spitting out SQL errors.
Error, insert query failed, give this to username:bartertown
Error, insert query failed, give this to username:bartertown
-
MagickalMemories ( 832 )
- Lord Logorrheic!
- Posts: 16741
- Joined: Thu Sep 04, 2003 11:38 pm
- Location: St. Louis, MO - USA
cvb
This is a known issue.
Leave your reference again. This time, omit any apostrophe's.
Eric
Leave your reference again. This time, omit any apostrophe's.
Eric
Lower rating? You ship first.
Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.
I think what this situation needs is some imagination.
"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell
Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.
I think what this situation needs is some imagination.
"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell
Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
-
pixelgeek ( 204 )
- Resident Trader
- Posts: 423
- Joined: Wed Dec 03, 2003 4:22 pm
- Location: Calgary, Alberta Canada
Re: cvb
There aren't any.MagickalMemories wrote:Leave your reference again. This time, omit any apostrophe's.
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.
-
MagickalMemories ( 832 )
- Lord Logorrheic!
- Posts: 16741
- Joined: Thu Sep 04, 2003 11:38 pm
- Location: St. Louis, MO - USA
sew
Probably the dollar sign. IIRC, that is already in place there, and the box is for numbers and, of course, a decimal.
Eric
Eric
Lower rating? You ship first.
Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.
I think what this situation needs is some imagination.
"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell
Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.
I think what this situation needs is some imagination.
"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell
Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
-
pixelgeek ( 204 )
- Resident Trader
- Posts: 423
- Joined: Wed Dec 03, 2003 4:22 pm
- Location: Calgary, Alberta Canada
Re: sew
If its a known issue why hasn't it just been patched?MagickalMemories wrote:Probably the dollar sign. IIRC, that is already in place there, and the box is for numbers and, of course, a decimal.
-
MagickalMemories ( 832 )
- Lord Logorrheic!
- Posts: 16741
- Joined: Thu Sep 04, 2003 11:38 pm
- Location: St. Louis, MO - USA
xcvv
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
I'm just a member, like you.
Keep in mind, though, that the guys "in charge" do it for free.
Eric
Lower rating? You ship first.
Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.
I think what this situation needs is some imagination.
"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell
Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
Give me a sense of humor Lord. Give me the grace to see a joke.
To get some humor out of life and pass it on to other folk.
I think what this situation needs is some imagination.
"...I'm a nerd, and I'm here tonight to stand up for the rights of other nerds.” – Gilbert Lowell
Want my help with a BTR or backout? All messages sent/posted should be in CHRONOLOGICAL order. Otherwise, I just won't read it.
-
pixelgeek ( 204 )
- Resident Trader
- Posts: 423
- Joined: Wed Dec 03, 2003 4:22 pm
- Location: Calgary, Alberta Canada
Re: xcvv
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.MagickalMemories wrote:Keep in mind, though, that the guys "in charge" do it for free.
-
orcdom ( 202 )
- Millenium Trader
- Posts: 1173
- Joined: Sun Sep 28, 2003 4:28 am
- Location: West Virginia
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
and no since of griping about it because now you know and there is another thread telling the next person.
Steve
Copy the trade, E-mail and put "Bartertown" in subject header.
i make custom terrain, my photobucket: http://photobucket.com/albums/b152/orcdom/
i make custom terrain, my photobucket: http://photobucket.com/albums/b152/orcdom/
- TrademasterAdam ( 99 )
- Site Admin
- Posts: 709
- Joined: Fri Jul 04, 2003 2:05 pm
-
pixelgeek ( 204 )
- Resident Trader
- Posts: 423
- Joined: Wed Dec 03, 2003 4:22 pm
- Location: Calgary, Alberta Canada
I can try to duplicate it...TrademasterAdam wrote:Pixelgeek, can you post the rest of that error message here?
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.