Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Replace strings after upgrade to 3.4.04
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

suona
Junior Member

Taiwan
121 Posts

Posted - 22 February 2004 :  10:43:20  Show Profile  Visit suona's Homepage
I've upgraded my snitz forum from 3.1SR4 to 3.4.04.

I found that all replise with quotes , their code has been changed after upgrade. like this:


<BLOCKQUOTE id=quote><font size=1 face="Arial" id=quote>quote:<hr height=1 noshade id=quote>
Here is the quoted text.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Arial" size=2 id=quote>


How can I replace all thousands of posts , to normal, simple quote codes ?

I'm a amateur WWW site builder.

And Sorry for my poor english .....


ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 22 February 2004 :  23:36:58  Show Profile  Send ruirib a Yahoo! Message
Sorry, what do you mean? AFAIK, that's the way quoted posts are stored in a message, there is nothing to change. Aren't the posts correctly displayed?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 26 February 2004 :  08:01:41  Show Profile  Visit suona's Homepage
No. The display was abnormal. That's why I found the content was changed.

Normally, the quoted words ars smaller, but in this case, all words (both reply & quoted words) are small size.

If I manually edit the content and replace with normal "quote" pairs, the display will become normal (reply words larger, quoted words smaller).

And I edit them after the replacement, the content is normal.

I'm a amateur WWW site builder.

And Sorry for my poor english .....


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 26 February 2004 :  12:13:13  Show Profile  Send ruirib a Yahoo! Message
As I wrote, I had a look at my messages and they are stored like that. I saw no difference between my messages and the one you posted.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 27 February 2004 :  11:07:00  Show Profile  Visit suona's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Arial" id=quote>quote:<hr height=1 noshade id=quote>
Here is the quoted text.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Arial" size=2 id=quote>

Just make a test !
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 27 February 2004 :  11:08:43  Show Profile  Visit suona's Homepage
quote:

Here is the quoted text.



Second test, with normal quote codes.

I'm a amateur WWW site builder.

And Sorry for my poor english .....


Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 27 February 2004 :  11:15:22  Show Profile  Visit suona's Homepage
I have made two testing posts above.

I have many old posts in my forum with normal quote codes like test no.2 .

But all old contents were changed to abnormal codes like test no.1

Their contents ( stored ) were obviously different , I mean the "quote code" part.

And in my forum, the test no.1 shows different than here. I see all codes here, but in my forum, the abnormal codes shows like test no.2, just the string "Just make a test !" will be small size.


I'm a amateur WWW site builder.

And Sorry for my poor english .....


Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 February 2004 :  16:45:27  Show Profile  Send ruirib a Yahoo! Message
If you see the source generated for this topic, you will see that blockquote is generated as well for the message being shown correctly.

When you post a message, that message goes through the chkString function, that changes [quote] into <blockquote> tags. When you display a message, blockquote tags are shown without change. The blockquotes are changed back into [quote] when you edit the message. So I do not understand why that is happening in your forum.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 27 February 2004 :  22:10:16  Show Profile  Visit suona's Homepage
when I use edit with old posts, I see a lot of <blockquote> tags in message body. rather than normal [quote] tags.

This happens only in old posts. New posts works correctly.

That's why I guess some transformation was made to my old database during the upgrade process.

I want to find a way to replace all wrong <blockquote> tags in my database(SQL7.0), but can not find any easy way to replace them. That's main problem for me now.

I'm a amateur WWW site builder.

And Sorry for my poor english .....



Edited by - suona on 27 February 2004 22:13:06
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 28 February 2004 :  02:39:48  Show Profile  Visit suona's Homepage
I look into my dataabse & inc_func_posting.asp, seems some of my old posts contains blockquote tags not listed in the section:
'## left for compatibility with older versions of the forum

of inc_func_posting.asp


So, the display was abnormal, using edit will see blockquote tags without transform.

But My forum start with snitz3.1sr4, then upgrade to 3.4.04 directly, why there's abnormal tags stored ?


I'm a amateur WWW site builder.

And Sorry for my poor english .....



Edited by - suona on 28 February 2004 02:41:07
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 February 2004 :  22:17:26  Show Profile  Send ruirib a Yahoo! Message
My whole point is that the tags are not abnormal. I have them in my own DB. That's the way quotes are stored. I just don't know why your code does not display them. And my forum was initially 3.1 SR4, then upgraded it to 3.3. an now to 3.4.

I don't know what else to say without looking at your DB. If you want me to do that, let me know.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

suona
Junior Member

Taiwan
121 Posts

Posted - 29 February 2004 :  12:27:38  Show Profile  Visit suona's Homepage
Thanks for your help.

At first I don't know the actual content stored in my db, after looking into my db, I know the stored content are blockquote...... tags.

and I look into snitz 3.4.04's "inc_func_posting.asp" , I found that there's some program lines to deal with several kinds of old versions' blockquote.... tags .

but i compare them, there are a little difference with my db's, so the change process in "inc_func_posting.asp" was failed to work. And I got abnormal display in posts.

Now I added my old db's blockquote tags string into snitz's chage process condition, solved my problem now.

Thanks again for your patience for my ignorant and poor english....

I'm a amateur WWW site builder.

And Sorry for my poor english .....



Edited by - suona on 29 February 2004 12:31:12
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 February 2004 :  13:47:49  Show Profile  Send ruirib a Yahoo! Message
No need to thank me, cause all I did was telling you that the problem you had wasn't really a problem (which made me feel a bit weird about it anyway ). I do not understand why the tags weren't properly processed by the Snitz code, but I'm glad you managed to change the code to make everything ok properly again .


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07