The Energon Pub

News Credits: 3597 · by **Seibertron** » Sat Oct 24, 2015 2:11 pm

switched 5 primary forum tables back to ENGINE=MyISAM after switching to InnoDB last night. Not sure what went wrong with those 5 tables over night.

News Credits: 456 · by **Sabrblade** » Sat Oct 24, 2015 2:40 pm

Seems like the boards (but not the rest of the site) were down all day until now.

News Credits: 1642 · by **D-Maximal_Primal** » Sat Oct 24, 2015 2:53 pm

Sabrblade wrote:Seems like the boards (but not the rest of the site) were down all day until now.

They have been down for me for the past 14 hours. the main site page was accessible, but for some reason it included the 3 new articles for today at one point then it went back in time and only showed the news up to last night, so i am just now getting to the new stories.

News Credits: 3597 · by **Seibertron** » Sat Oct 24, 2015 3:21 pm

Making progress with things on the server. It should be stable for the next 12 to 14 hours after the latest round of changes. There's an automated script that runs around 4am that might cause a problem. If it doesn, I'll know what the last major culprit is. If it's all good at 4am, then I'll know the changes I've made during the past 48 hours to various scripts and server settings resolved one of the problems.

by **wilcosu35** » Sun Oct 25, 2015 6:44 am

I hate to be the bringer of bad news, but the problem i mentioned persists.
Accessing the TF-toys discussion forum (from outside or inside seibertron.com) will log me out automatically.

News Credits: 226 · by **Burn** » Sun Oct 25, 2015 6:47 am

wilcosu35 wrote:I hate to be the bringer of bad news, but the problem i mentioned persists.
Accessing the TF-toys discussion forum (from outside or inside seibertron.com) will log me out automatically.

Try doing a force refresh (Ctrl+F5). That cleared a few cookie problems up for me.

by **wilcosu35** » Sun Oct 25, 2015 6:52 am

Burn wrote:
wilcosu35 wrote:I hate to be the bringer of bad news, but the problem i mentioned persists.
Accessing the TF-toys discussion forum (from outside or inside seibertron.com) will log me out automatically.

Try doing a force refresh (Ctrl+F5). That cleared a few cookie problems up for me.

Whaddaya know, it worked. Thanks Burn!

News Credits: 3597 · by **Seibertron** » Sun Oct 25, 2015 1:32 pm

test to verify forums working after multiple mysqld restarts to pickup new global server variables.

News Credits: 3597 · by **Seibertron** » Sun Oct 25, 2015 3:27 pm

How's the site working for all of you currently? It looks good on my end for the first time in 6 weeks since they moved the server. Fingers crossed!

News Credits: 3597 · by **Seibertron** » Sun Oct 25, 2015 3:31 pm

rebooted server again after updating my.cnf to low_priority_updates=0

News Credits: 3597 · by **Seibertron** » Sun Oct 25, 2015 6:54 pm

test after running phpbb mysql_upgrade.php script

News Credits: 41 · by **Cobotron** » Sun Oct 25, 2015 7:06 pm

Everything is working well and looking good from my control console. ;)^

News Credits: 226 · by **Burn** » Sun Oct 25, 2015 8:25 pm

Cobotron wrote:Everything is working well and looking good from my control console.

Oh dear lord what have you done...
*goes and has a look*
NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO

News Credits: 3597 · by **Seibertron** » Sun Oct 25, 2015 8:46 pm

Installed phpbb support toolkit so that the username_clean field could be rebuilt to resolve a problem with users who couldn't login that had usernames which contained an apostrophe. Also did a variety of things to upgrade/fix the structures of the phpbb database tables. Also added new FULLTEXT indexes to the phpbb posts database table.

News Credits: 456 · by **Sabrblade** » Mon Oct 26, 2015 10:11 am

On this page of the "NYCC 2015 Titans Return product reveals at annual Hasbro Press Event Photogallery", the fifth image in the top row on the far right, the one labeled "DSC07918.psd" is severely broken, being a ginormously-tall image that stretches the page downward far longer than it's supposed to be.

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 10:27 am

Sabrblade wrote:On this page of the "NYCC 2015 Titans Return product reveals at annual Hasbro Press Event Photogallery", the fifth image in the top row on the far right, the one labeled "DSC07918.psd" is severely broken, being a ginormously-tall image that stretches the page downward far longer than it's supposed to be.

The Photoshop PSD file has been removed. It was the same image as this: http://www.seibertron.com/events/fullsi ... 1&image=53

http://www.seibertron.com/events/galler ... 0&start=50

Thanks for pointing it out!

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 10:29 am

Almost 48 hours and no crisis with the server or database. A ton of things have changed behind the scenes with the server, the database, and the site's codebase so hopefully the problems have been resolved for the time being.

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 10:48 am

After some additional reading, I found out about some additional regarding the InnoDB engine variables in my.cnf. InnoDB is not the preferred MySQL database engine on Seibertron.com, we usually use MyISAM engine for the database tables. However, it is used on a few of our database tables for the Seibertron.com primary database as well as some of the core databases used in Plesk that manage the server, so I updated the variables. The server seems to be running good at the moment. Will keep an eye on it after this changes to see how it does.

http://dba.stackexchange.com/questions/ ... o-much-cpu
http://www.bigdbahead.com/?p=115

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 11:21 am

Sorry about that delay ... made some additional changes to the mysql configuration file which accidentally prevented the database from restarting properly. Figured out what this page left out that was wrong http://www.bigdbahead.com/?p=115 and it's working now.

News Credits: 18 · by **leokearon** » Mon Oct 26, 2015 12:14 pm

I'm not sure if this can be fixed, but Norton keeps trying to prevent me going on this site, apparently it's a security risk

http://safeweb.norton.com/report/show?u ... ce=toolbar

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 12:32 pm

leokearon wrote:I'm not sure if this can be fixed, but Norton keeps trying to prevent me going on this site, apparently it's a security risk

http://safeweb.norton.com/report/show?u ... ce=toolbar

Thank you for bringing this to our attention, leokearon. A different user brought this up this past weekend. I thought it was resolved but apparently not. According to Norton (https://safeweb.norton.com/report/show_mobile?url=seibertron.com), the following single page on Seibertron.com was reported as having a phishing attack on it but doesn't provide any additional information to help me resolve the problem.

http://seibertron.com/transformers/news ... line/29522

After registering myself and Seibertron.com with Norton, I have disputed the report and requested that they re-evaluate it. Please let me know if it is still flagged as having a problem in a few days.

News Credits: 331 · by **chuckdawg1999** » Mon Oct 26, 2015 1:05 pm

Everything is fine on my end, I did have a few links from notifications send me to the wrong forum, but everything seems fine now.

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 1:11 pm

chuckdawg1999 wrote:Everything is fine on my end, I did have a few links from notifications send me to the wrong forum, but everything seems fine now.

That's odd. Keep me posted if it happens again. There could be a bigger issue at hand that might need to be resolved of which I'm not aware yet.

News Credits: 10 · by **Agamemnon** » Mon Oct 26, 2015 4:03 pm

Some subscribed threads have not sent notifications in the last 24 hours. Not sure if this is relevant for ya, but thought I would mention it. I'll let you know if this thread notifies me after a reply.

Thanks for your work, Seibs!

News Credits: 3597 · by **Seibertron** » Mon Oct 26, 2015 4:25 pm

Agamemnon wrote:Some subscribed threads have not sent notifications in the last 24 hours. Not sure if this is relevant for ya, but thought I would mention it. I'll let you know if this thread notifies me after a reply.

Thanks for your work, Seibs!

The notifications are kind of odd on phpbb. If you haven't visited the topics after X amount of time, it quits sending notifications until X amount of time has passed. This is to help prevent users perceiving email notifications from phpbb as spam.

In other words, you might need to revisit those topics again so that it starts sending you notifications again.

Hopefully all of the changes I've made have made over the past month or so have made Seibertron.com a better working online home for all of you. Having all of you participating in our community is what brings a smile to my face!