Site Upgrade 2/4/2014

[meissen]

Good morning everyone,

We upgraded our vBulletin software to the "latest and greatest" version this morning due to some security concerns with the version we were running. If you notice anything that isn't working quite right, please be sure to let us know in this thread.

[popo8]

Thanku u B!!!

LTXtech.com is my drug.

[shownomercy]

Whats up with bold red LIVE in front of every thread?

[meissen]

Upgrading outdated add-ons, just one of the qwerks. Thanks for the tip, I'll fix it.

[meissen]

Viewing user profiles causes a database crash. Working to resolve.

[popo8]

<tbody>
http://ltxtech.com/forums/image.php?type=dberror
Database error


The LTXTECH Forums database has encountered a problem.





Please try the following:

Load the page again by clicking the Refresh (http://ltxtech.com/forums/member.php?1330-popo8&tab=mentions#) button in your web browser.
Open the ltxtech.com (http://ltxtech.com/) home page, then try to open another page.
Click the Back button to try another link.




The ltxtech.com forum technical staff have been notified of the error, though you may contact them (meissen@mifbody.com) if the problem persists.



We apologise for any inconvenience.

</tbody>
<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 4.2.2: Invalid SQL: ( SELECT post.pagetext AS message, post.title AS posttitle, post.visible AS postvisible, thread.title AS threadtitle, thread.visible, thread.forumid, mention.dateline, mention.postid, mention.type, user.userid, user.username, user.usergroupid, user.infractiongroupid, user.displaygroupid, mentioned.userid AS mentioneduserid, mentioned.username AS mentionedusername, mentioned.usergroupid AS mentionedusergroupid, mentioned.infractiongroupid AS mentionedinfractiongroupid, mentioned.displaygroupid AS mentioneddisplaygroupid FROM dbtech_usertag_mention AS mention LEFT JOIN post AS post ON (post.postid = mention.postid) LEFT JOIN thread AS thread ON (thread.threadid = post.threadid) LEFT JOIN user AS user ON (user.userid = mention.userid) LEFT JOIN user AS mentioned ON (mentioned.userid = mention.mentionedid) WHERE (mention.mentionedid = 1330 OR mention.userid = 1330) AND mention.type = 'post' ORDER BY dateline DESC LIMIT 0, 20 ) UNION ALL ( SELECT blog_text.pagetext AS message, blog_text.title AS posttitle, IF(blog_text.state = 'visible', 1, 0) AS postvisible, blog.title AS threadtitle, IF(blog.state = 'visible', 1, 0) AS visible, 0 AS forumid, mention.dateline, mention.postid, mention.type, user.userid, user.username, user.usergroupid, user.infractiongroupid, user.displaygroupid, mentioned.userid AS mentioneduserid, mentioned.username AS mentionedusername, mentioned.usergroupid AS mentionedusergroupid, mentioned.infractiongroupid AS mentionedinfractiongroupid, mentioned.displaygroupid AS mentioneddisplaygroupid FROM dbtech_usertag_mention AS mention LEFT JOIN blog_text AS blog_text ON (blog_text.blogtextid = mention.postid) LEFT JOIN blog AS blog ON (blog.blogid = blog_text.blogid) LEFT JOIN user AS user ON (user.userid = mention.userid) LEFT JOIN user AS mentioned ON (mentioned.userid = mention.mentionedid) WHERE (mention.mentionedid = 1330 OR mention.userid = 1330) AND mention.type = 'blog' ORDER BY dateline DESC LIMIT 0, 20 ) ORDER BY dateline DESC; MySQL Error : Illegal mix of collations for operation 'UNION' Error Number : 1271 Request Date : Tuesday, February 4th 2014 @ 10:44:15 AM Error Date : Tuesday, February 4th 2014 @ 10:44:16 AM Script : http://ltxtech.com/forums/member.php?1330-popo8&tab=mentions Referrer : http://ltxtech.com/forums/ IP Address : 216.162.91.10 Username : popo8 Classname : vB_Database MySQL Version : 5.6.12On o





</textarea>
</form>

[popo8]

On occasion, I am getting that ^^^ when trying to get on the site thru this

http://ltxtech.com/forums/member.php?1330-popo8&tab=mentions

[meissen]

popo8 - let me know if it's fixed now.

[popo8]

@popo8 (http://ltxtech.com/forums/member.php?u=1330) - let me know if it's fixed now.

so far so good.

[meissen]

26956

26957

[Blackbird96WS6]

Testing: 26960

[Tyler Wheat]

Thanks Brian!

Just wanted to chime in and let you know it is appreciated!

[meissen]

:thumbsup: I'm happy to report that prior to the upgrade, our server was having backdoors uploaded to the server multiple times a day. Thankfully our server's antivirus was catching it as soon as it was uploaded. Since the upgrade, I haven't had any malware e-mails. :thumbsup:

[popo8]

Awesome work B!!! Thanku for keepin us up to date and running smooth.

LTXtech.com is my drug.

[nateleduc]

:thumbsup: I'm happy to report that prior to the upgrade, our server was having backdoors uploaded to the server multiple times a day. Thankfully our server's antivirus was catching it as soon as it was uploaded. Since the upgrade, I haven't had any malware e-mails. :thumbsup:

Pointless...... Why try and screw with a site like this..... Its not like we're 4chan

[meissen]

Pointless...... Why try and screw with a site like this..... Its not like we're 4chan

Agreed, but sadly there's hacking rings out there that get off with how many sites they've defaced.

Surprisingly/thankfully -- said sites also include ways to make it harder for people to deface your site.

[popo8]

Agreed, but sadly there's hacking rings out there that get off with how many sites they've defaced.

Surprisingly/thankfully -- said sites also include ways to make it harder for people to deface your site.

Remember that other one that hacked us, then wanted me to HIRE him as an admin to keep things like that from happening again?

[meissen]

Remember that other one that hacked us, then wanted me to HIRE him as an admin to keep things like that from happening again?

Haha yeah, that's the group specifically I'm referring to. :lol:

[popo8]

I figured... man that was a dik move.

LTXtech.com is my drug.