Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - save_new_session_data
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

save_new_session_data

 Post Reply Post Reply Page  123 4>
Author
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 254
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Topic: save_new_session_data
    Posted: 10 December 2023 at 9:50am
I have entered my forum logs and I have seen that there are many errors in "save_new_session_data" giving the problem "Cannot insert duplicate key in object...". I think the problem is because the forum is accessed from the same computer from several browsers at the same time, but I'm not sure. Is there any way to fix this problem? If when recording a session it is found that it already exists, instead of generating an error, can it be made to generate another session id?

e.g.

If strSessionData = rs(Session_data) Then strSessionData = LCase(hexValue(12))

Thank you,

I am Spanish and I translate with Google translator.
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9780
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 10 December 2023 at 12:21pm
As far as I am aware this bugs was fixed a number of years ago. 

Please try updating to the latest version and see if that resolves the issue for you.
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 254
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 10 December 2023 at 1:31pm
OK thanks. I will update the forum to the latest version.

Is the update only for the pages? Do we need to modify any tables in the database?
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9780
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 10 December 2023 at 3:46pm
It would depend on what version you are upgrading from. You can see the release notes at the version below that details many of the changes.


It is highly recommended that you replace all the files.
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 254
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 11 December 2023 at 5:43pm
I have it updated.

I have been investigating the IPs that generate the error and I have verified that they are robots. For now I have identified the following robots and expanded the function of "Search Robot" in functions_common.asp:

OR inStr(1, strUserAgent, "Twitter", 1) OR inStr(1, strUserAgent, "Semrush", 1) OR inStr(1, strUserAgent, "Petal", 1) OR inStr(1, strUserAgent, "GrapeshotCrawler", 1) OR inStr(1, strUserAgent, "omgili", 1) OR inStr(1, strUserAgent, "MuckRackFeedParser", 1) OR inStr(1, strUserAgent, "semantic-visions", 1) OR inStr(1, strUserAgent, "Buck", 1) OR inStr(1, strUserAgent, "proximic", 1) OR inStr(1, strUserAgent, "GoogleProducer", 1) OR inStr(1, strUserAgent, "CensysInspect", 1) OR inStr(1, strUserAgent, "Criteo", 1)

If you want, when I have more robots identified I can include them in this post.

I have had the forum purchased and running for many years, so I have many robots crawling my website every day. I have had the forum purchased and running for many years, so I have many robots crawling my website every day.
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9780
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2023 at 9:00am
Its an interesting idea, we have a list of over 100 different bots and that's just a small number of what's out there.

Before adding more to the list I think the way it is handled would need to be changed to prevent it impacting on performance.
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 254
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2023 at 1:25pm
So, are they going to make this change for a new version?
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9780
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 12 December 2023 at 2:57pm
Its on the 'to do' list, and will depend if there is any free time to work on it.
Back to Top
 Post Reply Post Reply Page  123 4>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.