Page 2 of 2

Re: Can't Access Thread

Posted: 30 Jun 2017, 21:27
by jeeswg
OK, I found my backup copy of the page. TLM's intro post and Excel constants posts are the same. The Word constants post has been replaced with an asterisk.

I plan to repost my content, but in two smaller posts in a new thread, instead of one big post.

We could create a test thread, where we post the 2 combined posts, or other large posts, to see if it causes a similar error. The things I thought it might be, with no specialist knowledge on the subject: too much text, too many urls, closed the tab before the 'busy' icon on the Internet Explorer tab had finished.

Re: Can't Access Thread

Posted: 01 Jul 2017, 10:32
by tank
send me the post in IM i can edit it

Re: Can't Access Thread

Posted: 01 Jul 2017, 10:44
by jeeswg
IM, do you mean direct message on the forum, IRC, Discord? I haven't used IRC or Discord before.

I'm on IRC as 'kiwibis...' (the website is called 'Kiwi IRC').

Autohotkey Livechat / Autohotkey IRC / Discord - AutoHotkey Community
https://autohotkey.com/boards/viewtopic.php?f=5&t=59

[EDIT:] OK I'm on both IRC and Discord as jeeswg.

[EDIT:] I've uploaded the constants lists here:
jeeswg/AutoHotkey-scripts: AutoHotkey scripts
https://github.com/jeeswg/AutoHotkey-scripts

Re: Can't Access Thread

Posted: 01 Jul 2017, 21:35
by User
Nice to see you've created your github account!

It will be extremely easier for you now to organize your things! Keep the good work!

Re: Can't Access Thread

Posted: 02 Jul 2017, 00:29
by tank
use the forum IM

Re: Can't Access Thread

Posted: 02 Jul 2017, 07:16
by jeeswg
I was going to post both of these ahk files, as posts, but they were causing the problem:
https://github.com/jeeswg/AutoHotkey-sc ... excel).ahk
https://github.com/jeeswg/AutoHotkey-sc ... (word).ahk

I didn't want to try posting them via private message, because I was concerned that that might also get things messed up, and cause the same error, and I wouldn't necessarily have a way to fix it. I have potentially irreconcilable problems with messaging.

The contents of both files caused the error message, but for both of them when I removed some of the content, they worked, so perhaps a specific string is causing the problem, or perhaps something about the way the post looks, some pattern in the text, when there is a certain number of such lines, is causing the problem. Perhaps some sort of cross-site scripting error?

@User: Cheers.

Re: Can't Access Thread

Posted: 02 Jul 2017, 13:00
by tank
i thoought the word one was a backup of TLM's post
you mentioned having such a back up if thats not it can i have it?
I did find the problem the DB cant handle a post the size limited to 65535 bytes I may consider changing that feild to long blob

Re: Can't Access Thread

Posted: 04 Jul 2017, 10:52
by jeeswg
A saved htm copy of the original thread.

MS Office COM Interface Constants - AutoHotkey Community
https://autohotkey.com/boards/viewtopic.php?f=22&t=1672

Re: Can't Access Thread

Posted: 05 Jul 2017, 17:45
by jeeswg
Is there not a backup of all posts? Or perhaps there is but only for recent months?

I backed up my posts as txt files (i.e. what you see in the Edit box) and it came to just under 3MB. Since my posts are 1,324 (0.96%) of 138,109 posts, then on that basis you could back up the forum's posts taking only around 300MB.

Re: Can't Access Thread

Posted: 06 Jul 2017, 09:30
by tank
there is but its painful to dig out one specific post. one of those rare situations where a complete restore would do more harm than good
I re did the post from your backup