Trade refs generating sql error

Information for new users, random messages, and stuff that doesn't go anywhere else. NO TRADE ADS!!! This forum is for Bartertown related information/messages ONLY.

Moderator: Moderators

Post Reply
pixelgeek ( 204 )
Resident Trader
Posts: 423
Joined: Wed Dec 03, 2003 4:22 pm
Location: Calgary, Alberta Canada

Trade refs generating sql error

Post by pixelgeek »

The page to add trade refs is currently spitting out SQL errors.

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

Post by MagickalMemories »

This is a known issue.

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.
pixelgeek ( 204 )
Resident Trader
Posts: 423
Joined: Wed Dec 03, 2003 4:22 pm
Location: Calgary, Alberta Canada

Re: cvb

Post 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.
MagickalMemories ( 832 )
Lord Logorrheic!
Posts: 16741
Joined: Thu Sep 04, 2003 11:38 pm
Location: St. Louis, MO - USA

sew

Post 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
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.
pixelgeek ( 204 )
Resident Trader
Posts: 423
Joined: Wed Dec 03, 2003 4:22 pm
Location: Calgary, Alberta Canada

Re: sew

Post 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?
MagickalMemories ( 832 )
Lord Logorrheic!
Posts: 16741
Joined: Thu Sep 04, 2003 11:38 pm
Location: St. Louis, MO - USA

xcvv

Post 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
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.
pixelgeek ( 204 )
Resident Trader
Posts: 423
Joined: Wed Dec 03, 2003 4:22 pm
Location: Calgary, Alberta Canada

Re: xcvv

Post 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.
orcdom ( 202 )
Millenium Trader
Posts: 1173
Joined: Sun Sep 28, 2003 4:28 am
Location: West Virginia

Post 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
Copy the trade, E-mail and put "Bartertown" in subject header.
i make custom terrain, my photobucket: http://photobucket.com/albums/b152/orcdom/
User avatar
TrademasterAdam ( 99 )
Site Admin
Posts: 709
Joined: Fri Jul 04, 2003 2:05 pm

Post by TrademasterAdam »

Pixelgeek, can you post the rest of that error message here?


Thanks,

TrademasterAdam
pixelgeek ( 204 )
Resident Trader
Posts: 423
Joined: Wed Dec 03, 2003 4:22 pm
Location: Calgary, Alberta Canada

Post 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.
Post Reply

Return to “Bartertown Information and Misc Messages”