I posted a reply to a thread in the Poser Forum; just a paragraph of text, and what happened was all replies to the OP (including mine) disappeared, and the following message appeared above the thread:

mysql error: 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 '== 'active' ORDER BY post_date LIMIT 0,29' at line 4, occured in query: "SELECT t.*, m.username, m.date_first_logon AS joined, m.location AS user_location, m.avatar_url AS avatar, u.posts AS user_posts, u.last_post AS user_last_post, u.signature AS user_signature FROM forumpro_message t LEFT OUTER JOIN member m ON t.user_id=m.userid LEFT OUTER JOIN forumpro_user u ON t.user_id=u.user_id WHERE t.thread_id='2642018' AND t.status == 'active' ORDER BY post_date LIMIT 0,29;".

Uh-oh

Looks like all replies have been hosed.

I doubt it was anything you did Phantast

Tom

WTF  :scared:

Sorry guys. Things got caught in the middle of an upgrade to fix some fixes and add some features. It's workin. now.

Hmm..it's back now.

Kooky Ma-jooky

Hey, did you fix the cache problem with the star graphics?

Len.

(PLEASE say yes)

C'mon..level with us.

We know it's because Stacy was adding her new avatar.

The system simply had to stop and drool.

8 )

Tom

Quote - "  

Hey, did you fix the cache problem with the star graphics?

Len.

(PLEASE say yes)

"

Yes I did. AND search by username is back. We're bit by bit getting rid of the quirks.

:b_grin:

Wohooooooooooo!

I'd offer you all a free beer but I'm skint - so there  :tt2:

Len.

E-bot takes me directly to post now also.

Nice

Tom

Testing format options

BTW, you have a NEW problem.

Spacing between message lines is too big!

Go for it Nicholas, while you're on a roll  :biggrin:

Len.

Testing carraige return Testing carraige return Testing carraige return Testing carraige return

Testing carraige return

Testing carraige return

Testing carraige return

X-posted with you pumeco

LOL

It's seems to be significantly faster for me as well.

Tom

How's this?

Does this work?

Test

Test

Test

...nope!

williamsn
That be fine by me. a little space wont kill anyone. great job hope you solve the other minor problems.

Like turning the heating up, its so cold here.

BTW - please feel free to visit the free eye test incorporating the latest R'osity technology  :biggrin:

http://market.renderosity.com/mod/forumpro/showthread.php?thread_id=2642722

PLEASE LEAVE YOUR TEXT COLOUR AT THE DEFAULT!

By changing it to black....

well you're becoming invisible to all of us who finally got rid of the white background.....

Confusion sets in... Is there text formatting somewhere around here (other than simply using html tags)? I don't see it near this reply box...

Quote - Confusion sets in... Is there text formatting somewhere around here (other than simply using html tags)? I don't see it near this reply box...

No, the forums now have an HTML editor. You do not need to know or use HTML. Just type in the text and format it as you wish with the buttons at the top of the reply box and you're on your way.

Perhaps your toolbar is collapsed.

When you reply, click the little down-pointing arrow to reveal the text formatting options.(Directly under the word "Body")

I hope this is what you meant.

Tom

Nicholas - just thought I'd point-out itallics is not working.

TESTING LEFT JUSTIFY

TESTING CENTER JUSTIFY

TESTING RIGHT JUSTIFY

TESTING BOLD

TESTING ITALLICS

TESTING UNDERLINE

TESTING BOLD ITALLICS UNDERLINE

TESTING COLOUR TEXT

TESTING COLOUR TEXT BOLD ITALLICS UNDERLINE BACKGROUND

Len.

TESTING ITALLICS

lower case italics

Edit:: Not working here either.

IE latest version

Hawk, how did you get rid of the line-gap on your previous post ?

Testing italics.

EDIT: That's odd. worked fine for me.

Hey, that's not fair :huh:

I usually type my posts in Outlook for spell checking reasons,then copy and paste them into the forum reply field.

On that particular post,I went back and edited the".(Directly under the word "Body") part of the text.

BUT..I notice Bobs warpped correctly also.

I think that if your text exceeds the reply body,it wraps correctly,but if you hit "Enter" it spaces twice.

I did not copy/paste this reply for test perposes so ignore any mispellings.

Tom

BTW, I'm on IE6

E-bot recognizing my preferences.

I was taken to post on second page.

Great work.

Tom

Cheers Hawk - that's gotta be a pain.

Hope Nick's onto it :biggrin:

Len.

testin italics..ok looks the same to me, then again it is 3am in the morning.

On about e-bots, why is it now when i get them there is a large cap inbetween each line of text..never use to be like this.

Just so you know what i mean here is a copy of one i just received

 Someone has replied to "I killed a thread ..." on Renderosity MarketPlace!
 
 
 
 
 This is a notification that hawkfyr has replied to the thread "I killed a thread ..." in the Community Center forum. Click <a href="

removed the links

Okay..do you see my last post? (about prefences?)

That was typed in Outlook first,then paseted here.

I got single spacing even with hitting enter(In Outlook)

But the post before that I didn't (I just used the text reply editor here) notice how my long,first sentence dropped properly?(The words "reply field.").It's my guess that hitting "Enter" is what is double spacing.

Tom

I suppose the long title is truncated.

My e-bot looks like this

"This is a notification that CrazyDawg has replied to the thread "I killed a thread ..." in the Community Center forum. Click here to view this message or here to visit the forum.

You can edit your options here.

I'm using Outloot Express, latest verson.

It's probably a mail setting on our end.

Tom

Edited to remove links

I hear ya hawk - it's still bloody annoying though :cursing:

TESTING ITALLICS USING THE STYLE DROPDOWN OPTION

"Cheers Hawk - that's gotta be a pain."

What's gotta be a pain?

 Do you mean typing everything in Outlook first?

If so...no,it's not really a pain. I have dual monitors and Outlook open in one and my browser in the other.

It's great for spell checking first and also gives me a copy of my posts in case the server times out while I'm typing.

Usually,when I'm ready,I re-fresh my browser and paste it.

I got into the habit when I was Admin over at 3DCommune.

It didn't look good for the staff to be making tons of spelling errors...lol

Tom

LOL -Lucky you.

I'm on a single 4:3 17"

I like that the ebot gives the thread subject in it's subject line. I can go through my downloaded email and quickly kill off the notifications of repeated posts in a single thread and only click on the latest one. With the old system I would have had to open each email before deleting it. I'm saving time now.

That is strange Bob.

BTW Nick..the e-bots are not taking me to the post any longer.

Just to the first post in the thread.

Tom

FUNNY

Quote - I don't have an arrow. FWIW I'm on a Mac using Safari 2.0.3.

The HTML Editor does not work on Safari. I, too, use Safari and am disappointed by that fact. However, we officially only support the following browsers: Firefox, IE, Netscape, Mozzila. Many in the browser community have complained to Apple that it needs to take Safari back into Beta mode. It simply needs to be re-written because it doesn't support anything compared to mainstream browsers.

Most Javascript-based inbrowser HTML / WSYWIG editors don't support Safari. In fact, as far as I know, none of them do. If you want to use the HTML editor, you will have to use Firefox or Netscape on your Mac.

Sorry for the bad news.

Nicholas

:sad:

Wow. I just checked it out in Firefox. There's definately a difference....

I'm sometime not seeing anything but blank space underneath

Reply
Body: [smilies]

If I refresh evertything shows up, but sometimes there's nothing there, no formatting section, no text box, nothing selectable.

And this is with Firefox, I don't feel like trying it with IE6.

What version of Firefox are you using? 1.5, right?

I used 1.5. It's not my regular browser though.

Quote - What version of Firefox are you using? 1.5, right?

I wasn't, but I am now and it's still happening.