Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the Forum Administrator.

Support Error Code:- err_SQLServer_getSessionData()_save_new_session_data
File Name:- functions_session_data.asp
Forum Version:- 11.01

Error details:-
Microsoft OLE DB Provider for SQL Server
Violation of PRIMARY KEY constraint 'PK__tblSession__30CE2BBB'. Cannot insert duplicate key in object 'dbo.tblSession'. The duplicate key value is (41091161aa4e1abz23a27891c4d957604282407).

Help us improve the site - If you have unwanted code/script in your post...
Print Page | Close Window

If you have unwanted code/script in your post...

Printed From: Progarchives.com
Category: Site News, Newbies, Help and Improvements
Forum Name: Help us improve the site
Forum Description: Help us improve the forums, and the site as a whole
URL: http://www.progarchives.com/forum/forum_posts.asp?TID=132330
Printed Date: April 23 2025 at 18:15
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com


Topic: If you have unwanted code/script in your post...
Posted By: Logan
Subject: If you have unwanted code/script in your post...
Date Posted: January 01 2024 at 12:19
Ever since we had some upgrades, many people have had issues with code injected in their posts. If this happens it depends on your browser, settings, add-ons, firewall and internet security. I have posted this before, but thought it might be helpful to make its own topic for it.

I had this injection of code into the text issue years ago, which in my case had to do with my security software. This is very common now here. One could try experimenting with clearing caches, different browsers, turning off and on add-ons.

What has worked for me is (when logged-in) to go to Member Control Panel (near top left of from screen), then click on Forum Preferences, then I clicked on the "No" option for Enable the WYSIWYG post editor before updating the profile.

EDIT: Additionally, as was mentioned in another topic (I had forgotten about it), if you have the post editor enabled, try unchecking Enable BBcodes in your post. This does need to be done each time you post so as not to get the unwanted script


That does mean that you have to manually tag urls to make them hyperlinks and manually tag videos to embed them (and manually tags colours), and you don't export rich text when pasting etc. but I have been fine with that.

If people have issues with adding vids, colours, urls, I can help. But if you find posts with those, it will show the code and technique anyway to tag it manually. I only enable the WYSIWYG post editor when I want to copy and paste to export the rich text/ format. I have long preferred to usually keep it disabled for my forum settings.

I've been tempted to disable the WYSIWYG post editor for the whole forum, but many like it and it can be used with no problem with the right browser, settings, add-ons disabled...

Manually using code is not hard to do, and I prepared this little guide before (you can try with more colours).

If it helps, here is some of the BB code. Remove spaces from tags to make it work, and by quoting this post you can see the code for where I used it:

[ b] Bolded sample text [ /b] to Bolded sample text
[ i] Italicised sample text [ /i] to Italicised sample text
[ u] Underlined text [ /u] to Underlined text

[color = red] Red text [ /color] to Red Text
[color = green] Green text [ /color] to Green text
[color= blue] Blue text [ /color] to Blue text
[color = orange] Orange text [/ color] to Orange Text

[size = 1] Small text [ /size] to Small text
[size = 3] Medium text [ /size] to Medium text

To combine various codes:

[ b] [ i] [ u] [color = red] [size = 1]This combines BB codes but is broken by spaces [ /b] [ /i] [ /u] [ / color] [ /size]
to
This combines BB codes and is unbroken

EDIT: and for images, youtube embeds, hyperlinks and hypertext links.

[ img]https://recordsale.de/570/570/spinal-tap-break-like-the-wind.jpg [/img]
to


And [url ]https://www.youtube.com/watch?v=RsOxgwF9LlM [/ url]
to
https://www.youtube.com/watch?v=RsOxgwF9LlM" rel="nofollow - https://www.youtube.com/watch?v=RsOxgwF9LlM

[url= https://www.youtube.com/watch?v=RsOxgwF9LlM]the darning of the sock[ /url]
to
https://www.youtube.com/watch?v=RsOxgwF9LlM" rel="nofollow - the darning of the sock

[ tube]RsOxgwF9LlM [ /tube]
to


Note: as some have issues with embedding youtube videos, you just use the unique ID identifier (letters/numbers combination) after v=

-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).



Replies:
Posted By: Atavachron
Date Posted: January 01 2024 at 14:49
"The more it stays the same, the less it changes"


Brilliant-- man they just don't write lyrics like they used to.



-------------
"Too often we enjoy the comfort of opinion without the discomfort of thought."   -- John F. Kennedy


Posted By: Floydoid
Date Posted: January 01 2024 at 15:31
Originally posted by Logan Logan wrote:



What has worked for me is (when logged-in) to go to Member Control Panel (near top left of from screen), then click on Forum Preferences, then I clicked on the "No" option for Enable the WYSIWYG post editor before updating the profile.


I briefly had the problem and got rid of it by disabling the WYSYWYG option.

-------------
"Christ, where would rock & roll be without feedback?" - D. Gimour


Posted By: Logan
Date Posted: January 02 2024 at 10:37
^ Yeah, it works universally. One issue that has been raised about not using it is that you lose out on various options (like colour coding) , but I find manually using the BB codes very easy (though I have to remember to spell it color, not colour). I almost exclusively have kept that editor turned off for many years. I only use it when I want to import (paste) thinks from elsewhere and keep the format/ rich text... Like having a snapshot.


Posted By: Floydoid
Date Posted: January 02 2024 at 10:52
I'm guessing that the database is creaking at the seams, and the whole board could do with a bit of a makeover.

-------------
"Christ, where would rock & roll be without feedback?" - D. Gimour


Posted By: Logan
Date Posted: January 02 2024 at 12:06
Yeah, the real problem is what is off the board with this site. The forum software is by Web Wiz, and they provide updates now and then. This is not the best version, but it has been improved. Could do some things with revising the scope and heading of the actual forums in the board, I think, to make it better. And maybe adjusting some forum settings. Often there's some give and take and one adapts the best one can.

The rest of the site is more of an issue, as the architecture would benefit from a major overhaul, in fact a rebuild (kind of like the great pyramid of Giza, which could use a lot of reconstruction to turn it into a really useful and productive space, like, say the world's largest Pizza Hut (the Great Pyramid of Giza Hut), McDonald's, or a sporting goods store).

I have found it mostly running pretty smoothly recently. Various changes were made my the webmaster that have helped.


Posted By: Floydoid
Date Posted: January 02 2024 at 12:16
Well us long term forum users are quite familiar with BB codes... time for others to learn the more manual way of doing things maybe.

-------------
"Christ, where would rock & roll be without feedback?" - D. Gimour


Posted By: FlashBack2210
Date Posted: April 10 2024 at 10:47
The image code only works if the image link ends in .jpg. However, today most image links have a completely different look, and they do not work with this code. Question: how to place links to pictures of a different type? Or how to turn another link into a link so it ends with .jpg?



Posted By: Logan
Date Posted: April 10 2024 at 11:43
^ There are many programs out there to covert .jpgs to other formats. Then you could, upload to your FIle Manger under Control Panel then link it using the img BB code. That said, it can work for .gif and .png and I don't know how many image extensions.

This:
[ img]https://media.senscritique.com/media/000017108581/300/Koehnzert_Zund_Live.png[/ img]

to



Otherwise you can just link to them using url code if they have been uploaded to a site.

When you look up, say google images, a lot are with code to make it hotlinkable (or very hard to), but, while minding intellectual property rights/ copyrights, amny times things can be saved to your computer and then uploaded. Lots of photo/image editing software to help.






-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: Floydoid
Date Posted: January 01 2025 at 16:08
Originally posted by Logan Logan wrote:

Yeah, the real problem is what is off the board with this site. The forum software is by Web Wiz, and they provide updates now and then. This is not the best version, but it has been improved. Could do some things with revising the scope and heading of the actual forums in the board, I think, to make it better. And maybe adjusting some forum settings. Often there's some give and take and one adapts the best one can.

The rest of the site is more of an issue, as the architecture would benefit from a major overhaul, in fact a rebuild (kind of like the great pyramid of Giza, which could use a lot of reconstruction to turn it into a really useful and productive space, like, say the world's largest Pizza Hut (the Great Pyramid of Giza Hut), McDonald's, or a sporting goods store).

I have found it mostly running pretty smoothly recently. Various changes were made my the webmaster that have helped.


But then again a major overhaul might just foul up chunks of the site, given its enormity.

-------------
"Christ, where would rock & roll be without feedback?" - D. Gimour


Posted By: Logan
Date Posted: April 14 2025 at 11:45
Note: There has been more script being added to posts to the point that it is often hard to read through posts and threads. While one could avoid that by disabling the WYSIWYG pots editor in your forum preferences, many have not been doing so. Upon a recommendation, I have globally turned off the post editor.

As I turned it off, it does not show up as an option any more. The initials stand for What You See Is What You Get. It's a rich text editor that shows you a preview of the finished post and you can paste in rich text, images, hyperlinks... It's most valuable for ease of pasting, and we still have a preview button.

I suggest using the full reply editor if that makes it easier to read your posting box (see the "male" arrow like symbol).

-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: Sean Trane
Date Posted: April 14 2025 at 12:35
OK, I think I can handle it (it's not different to other forums), but this is probably going to be a the cost of fewer posts from me, because it will take a lot longer to type them, if not automatic scripts.

-------------
let's just stay above the moral melee
prefer the sink to the gutter
keep our sand-castle virtues
content to be a doer
as well as a thinker,
prefer lifting our pen
rather than un-sheath our sword


Posted By: MikeEnRegalia
Date Posted: April 14 2025 at 13:15
This puts an end to pasting AP formatted lists into the forum ... well, it was nice while it lasted ;)

-------------
https://awesomeprog.com/release-polls/pa" rel="nofollow - Release Polls

Listened to:


Posted By: Logan
Date Posted: April 14 2025 at 13:20
^ I actually prefer the not so pretty lists (without the album covers). Anyway, I'm hoping that M@x will be able to address this and this will only be a temporary thing. NOTE: I am trying to contact M@x via PM, but hope others might try to contact him (like on FB or wherever).

I sent this message (doubling in case it gets missed):

Hello Max,

Due to long time issues with code/script being injected/shown in posts I have globally disabled the WYSIWYG post editor (Disabled for all users in admin settings). Is there some way you can fix it so that the script does not show up while people can still use the post editor?

See these topics for reference: https://www.progarchives.com/forum/forum_posts.asp?TID=132330" rel="nofollow - https://www.progarchives.com/forum/forum_posts.asp?TID=132330

https://www.progarchives.com/forum/forum_posts.asp?TID=134793" rel="nofollow - https://www.progarchives.com/forum/forum_posts.asp?TID=134793

https://www.progarchives.com/forum/forum_posts.asp?TID=134775" rel="nofollow - https://www.progarchives.com/forum/forum_posts.asp?TID=134775

https://www.progarchives.com/forum/forum_posts.asp?TID=134793" rel="nofollow - https://www.progarchives.com/forum/forum_posts.asp?TID=134793

Greg

-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: yam yam
Date Posted: April 14 2025 at 14:29
^ Julien from the E&O team is able to get in touch with M@X. He recently got him to fix the long-standing problem with the admin panel which caused it to replace letters which have diacritics above them with some unpronounceable garbage.


Posted By: MikeEnRegalia
Date Posted: April 14 2025 at 14:33
I've looked into this, and it seems like the script gets injected into every <body> element, including that of the post editor, where it then ends up as plain text when the forum software parses the content. Switching to the non-wysywig editor fixes this because it uses a <textarea> instead. Logan, maybe you can let M@x know that the proper fix would be to skip the WYSIWYG text editor body (which has a special class and thus should be easy to exclude) when injecting the scripts.

-------------
https://awesomeprog.com/release-polls/pa" rel="nofollow - Release Polls

Listened to:


Posted By: Logan
Date Posted: April 14 2025 at 14:35
^^ thanks David, I have managed to contact Max by PM before, but will PM Julien to ask him to use however he has managed to contact Max before in order to address these concerns as that might at the least expedite matters. Easy Money has also spoken to Max about site issues.

^ Thanks, Mike. I will try to let M@X know, and pass that on to Julien.

EDIT: New message sent to M@x and one to Julien. :)

-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: Easy Money
Date Posted: April 14 2025 at 19:14
I can get a hold of Max, I will send a link to this thread to him.


Posted By: Logan
Date Posted: April 14 2025 at 20:19
^ Thank you, John. And Julien was going to send him an email.

-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: projeKct
Date Posted: April 14 2025 at 21:12
^ He replied to me one hour ago. He will try to fix this issue.


Posted By: Logan
Date Posted: April 15 2025 at 17:36
I saw that M@x had checked in yesterday, thanks for notifying him, but not sure if he was able to do anything yet (such issues often are not easy to fix without turning off features which one wants for the site/ forum).  I have just turned the WYSISWYG post editor back on, and testing.< defer="" ="https://static.cloudflareinsights.com/beacon.min.js/vcd15cbe7772f49c399c6a5babf22c1241717689176015" integrity="sha512-ZpsOmlRQV6y907TI0dKBHq9Md29nnaEIPlkf84rnaERnq6zvWvPUqr2ft8M1aS28on72PdrCzSjY4U6VaAw1EQ==" -cf-beacon=""rayId":"930f4024ed3a0d87","Timing":"name":"cfExtPri":true,"cfL4":true,"cfSpeedBrain":true,"cfCacheStatus":true,"version":"2025.3.0","token":"717409392a644498b4dbcbfbeafd4181"" crossorigin="anonymous">

EDIT: Turned it off again for all users.  Sorry for the inconvenience. Hopefully this is a temporary thing.


-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: David_D
Date Posted: April 16 2025 at 14:43

It's impossible for me now to edit my posts, as that means very much code/script text.

-------------
                      quality over quantity, and all kind of PopcoRn almost beyond


Posted By: Logan
Date Posted: April 17 2025 at 10:09

^ Even now since I disabled the WYSIWYG post editor for all the other day? Could you please test it. That should have taken care of the code.

While I have not heard back from M@X, guess he is very busy or preoccupied with other things, I would quite like to enable that again (maybe by tomorrow) if I/we don't hear back from him. If Ian wants to disable it again under Admin Setup/Config User Settings (I went solo on doing this after a recommendation) then that seems good. I do feel more comfortable with such things being decided on and taken care of by Max. Then I would ask people to keep it disabled from their own accounts except for if they "need" it for something. Paul was mentioning it being super hard without it, there is a learning curve to many things. Not sure why that would be other than importing stars and ease of active hyperlinks, but I would think the usual kinds of discussion posts would still be easy. If others are not having problems, then having it enabled likely would do more harm than good. I know it's work aroundable even if one choose to do things a bit differently.

One can use the full replay editor, there still are multiple ways to add hyperlinks if one feels they are needed. And one can still paste in copied plain text from elsewhere if writing here is hard -- including your own word processor program or Notepad. I prefer to write things in the post boxes we have, but that means lots of typos. The WYSIWYG editor makes pasting rich text/info easier.


-------------
"Questions are a burden to others; answers a prison for oneself" (The Prisoner, 1967).


Posted By: projeKct
Date Posted: April 19 2025 at 10:53
I followed up with M@X a few times; he showed some signs of life, but unfortunately the issue still isn't resolved. Maybe this weekend?



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.01 - http://www.webwizforums.com
Copyright ©2001-2014 Web Wiz Ltd. - http://www.webwiz.co.uk