Is there anyway to see the old forum posts? The imported code examples now are all but unusable in this forum. For example, check out this SQL mod from EOHSupport (https://forum.osticket.com/d/85900-auto-close-resolved-tickets-after-3-days/4):
I think this SQL is better:*** change ost_DB to the ost database name.use ost_DB;update ost_DB.ost_ticket inner join ost_ticket_status on ost_ticket.status_id = ost_ticket_status.id set ost_ticket.status_id = (select ost_ticket_status.id from ost_ticket_status where ost_ticket_status.name like 'closed')where ost_ticket_status.name like 'resolved' and DATEDIFF(now(), ost_ticket.updated ) > 3; I am going to schedule this with windows task scheduler. the command to schedule is:mysql -hlocalhost -uthe_userid -pthe_password < The_sql_File.SQL > the_output_File.txtI am thinking it would be good to have a feature in OST that allows you run SQL command on a schedule.If anyone else uses this I'd appreciate feed back.

I'm not aware of a way to see the old forums anymore.

I imagine that read something close to:
--- Start old post ---

I think this SQL is better:

change ost_DB to the ost database name.use ost_DB;
update ost_DB.ost_ticket inner join ost_ticket_status on ost_ticket.status_id = ost_ticket_status.id set ost_ticket.status_id = (select ost_ticket_status.id from ost_ticket_status where ost_ticket_status.name like 'closed')where ost_ticket_status.name like 'resolved' and DATEDIFF(now(), ost_ticket.updated ) > 3;

I am going to schedule this with windows task scheduler. the command to schedule is:
mysql -hlocalhost -uthe_userid -pthe_password < The_sql_File.SQL > the_output_File.txt

I am thinking it would be good to have a feature in OST that allows you run SQL command on a schedule.If anyone else uses this I'd appreciate feed back.

--- end old post ---

As a side note there is a 3rd party plugin for automatically closing posts.
https://github.com/clonemeagain/plugin-autocloser

    ntozier Thanks for doing this. However, I was just posting it as an example of what happened to all the code posts. The idea of having to manually re-create all the posts that include code seems not only daunting but a big waste of time seeing as the old forum has it intact. Seems to me that the powers at be could simply revive the old Vanilla forum and put it in a different directory (for example, archive) and link to it. Thanks again!

      @NaturalNine

      Sorry but this is the best we could do as the format for Vanilla posts is WAYYY different than Flarum posts...this isn’t Pokémon, we can’t catch ‘em all lol

      Cheers.

        KevinTheJedi Thanks for the reply. I'm not sure understand, sorry. Isn't there a backup of the old Vanilla forum somewhere and if so, why couldn't there be a new read-only installation of it strictly for archival purposes? For example, phplist has both their old forum and their new forum available. Something like that.

          @NaturalNine

          ...two installations of the same forum with the same data?? that would make no sense at all...I mean, I get your point but that wouldn't make any sense...at all...

          Just be glad we actually have older posts and all their content as we were (originally) only going to keep the ones from 1.10.x+. ?

          It's not just a matter of re-importing posts....
          The FORMAT of the Vanilla posts are DIFFERENT than the FORMAT of the Flarum posts. Vanilla used a combination of HTML/CSS and other formats where Flarum only uses Markdown format. There is no migration script to migrate from Vanilla to Flarum currently, so we had to write our own. This means we had to write our own conversion functions as well (HTML/CSS/etc -> to -> Markdown). Obviously you can't convert everything from HTML/CSS/etc to Markdown (as there are many ways to do just one thing in HTML and you can't guess every single way to do that one thing in HTML and find ways to convert them all to the Markdown equivalent unless you have all the time in the world) so yea...there will be some posts that just aren't converted correctly. We could go in and edit them manually and add the closest matches in Markdown but we would have to do this post-by-post which would obviously be wayy too time consuming and sooo not feasible as there are hundreds of thousands of posts.

          So, like I said, the best we could do in the time-frame we had was to convert the MAIN HTML/CSS/etc tags to Markdown and hope for the best (for the rest). ?

          Hopefully that clears things up a bit for you.

          Cheers.

            @NaturalNine

            Ohhh I get you. We cannot do that as A.) we retired the old server and B.) we are not willing to run the old forum software on our new servers as we moved away from it specifically because it has many security vulnerabilities. Not going to run that on our equipment anymore due to the potential security risks.

            P.S.
            Gotta fix that in my free time.

            Cheers.

              KevinTheJedi Thanks again for the replies. Vanilla Forums is mature software with large communities, some numbering in the millions of posts, so I'm wondering what security issues you're referring to. I just find it unfortunate that this new software mangled all the paragraphs and code of the old forum and the search doesn't work. You can't even use cached versions of the old one via site:forum.osticket.com searches on Google because this new forum is in the same directory... :-|

                @NaturalNine

                The search issue is just a bug I need to find and fix.

                I feel you on the format issue. I so wish we could’ve converted it all, but it is what it is. ? ?

                Cheers.

                  KevinTheJedi Hope the bug is easy to find and fix - a forum without search is a drag (especially when @ntozier asks, did you search the forum first? :-)

                  As for the Vanilla Forums security issues, I see that they had a critical update in August (is that what you're referring to?) https://open.vanillaforums.com/discussion/36559/critical-security-update-vanilla-2-6-1-is-here

                  With WordPress at least, it’s possible to generate a static site using the SimplyStatic plugin https://www.simplystatic.co (I’ve used SimplyStatic on several domains and it replaces the WordPress site perfectly with html pages so there are no database calls or php pages anymore). So maybe something like that exists for Vanilla? Found this on the Vanilla Forums regarding their export tool:

                  Linc Director of Development Detroit Vanilla Staff
                  November 2014
                  Also, note that our export tool also exports Vanilla itself and turns it into a nicely formatted text file you can use elsewhere.
                  https://open.vanillaforums.com/profile/Linc

                  ==
                  Anyhow, not trying to “beat a dead horse” with this or expecting you to revive the old forum, just trying to understand what happened and if there might have been another way. Thanks!

                    2 months later

                    @NaturalNine

                    Not until I can get some time to look through their code to see if there is a fix and if not I'll have to make my own. This will take some time as I'm working on many other projects at this time (including v1.11 stable).

                    But please keep bugging me until I do, it keeps it fresh on my mind ?

                    Cheers.

                    v1.11 stable is definitly more important...
                    looking forward to it ?

                    Write a Reply...