1. eva2000

    MySQL FYI, MySQL 8.0 doesn't support minor version downgrades anymore

    This is a public notice to let folks know that if you're using Oracle MySQL 8.0 or Percona MySQL 8.0 versions, that even minor version downgrades are not supported anymore unlike on MySQL 5.7 and below and MariaDB 10.4 and below. So you can't rollback/downgrade from MySQL 8.0.18 to 8.0.17 easily...
  2. Sal Collaziano

    Anybody running vB 3.8.11 on MySQL 5.7?

    Anybody running vB 3.8.11 on MySQL 5.7?
  3. Pandemixx

    Rekindling an old passion

    It's funny to say that programming has been my life's work since I started at a young age (I suspect that's the case for many here as well), all of which got started by building forums. I learned the basics of PHP, HTML, CSS, JS, and MYSQL from building many forums on vB, IPB, and even...
  4. eva2000

    Nginx Configuration tips to improve Centmin Mod LEMP stack performance

    Seeing as there are some folks here using my Centmin Mod LEMP stack, I thought I'd share a quick guide I wrote for configuration tips to improve performance beyond the out of box automatic optimisations already done. In theory these configuration tips can provide an additional 5-40% improvement...
  5. Karll

    Query to find the xth post

    My board recently reached the 300,000 post milestone (yippee!) and I'm trying to find which post was the 300,000th, and who posted it, and where. I've come up with the below query, which should give the 300,000th post in the first row in the result set, but it's not quite right, as the board...
  6. LT Mote

    MySQL WorkBench; Pulling data from Multiple tables; Read Only?

    I am trying to pull data from multiple MYSQL tables using MySQL WorkBench v6.3.6. I can get the data to pull and associate correctly with the other table; however I can't seem to EDIT the data... It's like it's in Read Only mode. If I change my select statement to only pull from one table; I...