![]() | ||
Views: 9,373,065 |
Home
| Forums
| Uploader
| Wiki
| Object databases
| IRC
Rules/FAQ | Memberlist | Calendar | Stats | Online users | Last posts | Search |
02-22-19 09:46 PM |
Guest: |
0 users reading Big server update | 1 bot |
Main - Announcements - Big server update | New reply |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6766/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
After ages of being lazy, StapleButter has finally updated the server. So, what do we get?
* the latest shiny distro, Ubuntu 16.04 * PHP7 * a new (and more picky) MySQL version * security updates Let me know if anything shits itself. There were a number of issues caused by the new system being more picky, like logins not working, but this is fixed now. You will need to login again. KNOWN ISSUES * * ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
NintendoFan |
| ||
Normal user Level: 37 ![]() Posts: 314/403 EXP: 331930 Next: 6323 Since: 07-15-14 Last post: 417 days ago Last view: 411 days ago |
Oh, is this why the RPG stat thing on your profile doesn't work anymore? Or is that an entirely separate issue?
... Regardless, good to hear that things are improving. ____________________ A nobody. |
NightYoshi370 |
| ||
Member Normal user Level: 30 Posts: 187/248 EXP: 158546 Next: 7323 Since: 08-19-14 Last post: 163 days ago Last view: 145 days ago |
What were we using before? |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6767/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
Posted by NintendoFan Oh, good sight. Another thing to fix. fdbdfgf Posted by maor322 Older shit. Also, PHP5. But for whatever reason, it didn't feel like working again after the update. And PHP7 is said to be faster. ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
NightYoshi370 |
| ||
Member Normal user Level: 30 Posts: 188/248 EXP: 158546 Next: 7323 Since: 08-19-14 Last post: 163 days ago Last view: 145 days ago |
I tried blocking a post layout and this appeared:
|
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6768/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
post edited, you had given away your token. anyway, yeah, same issue with long URLs.
the new MySQL version is picky. old MySQL would simply truncate strings that were too long, but this new version throws errors instead. we'll need to update the board to sanitize things properly. ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
shibboleet |
| ||
![]() Fire Mario DROP TABLE users; Level: 113 Posts: 4227/4653 EXP: 15618722 Next: 199839 Since: 07-07-12 Last post: 56 days ago Last view: 6 days ago |
... php ____________________ a |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6769/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
no idea what's breaking status.php, but for the rest, MySQL is the one to blame.
anyway, two solutions. 1. set MySQL to run in 'old' mode, where it truncates shit like before + it would work. it has always worked so far. - 'bad'. shouldn't be relied upon. 2. fix the board + 'good'. we would be following the right practices. - effort. the URL one should be an easy fix, users.url can only hold 100 characters. except when I tried to change it to varchar(1024), it complained that a record was too long. wtf?? shit like editprofile would need fixing -- it will throw an error if you make shit too long by altering the fields' maxlength value, or even if you put characters in fields like 'posts per day'. another good thing to do would be transactions for shit like posting. so we don't end up in a half fucked up state if a query fails during the process. oh by the way, status.php is back. we were just missing the GD library for PHP7. and the issue with long URLs is 'fixed'... it will still blow up if your URL is longer than 65535 characters, but that should be enough for everyone. I still have a lot of code to fix. blarg. ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
Yoshimaster96 |
| ||
Member Normal user Level: 35 ![]() Posts: 313/345 EXP: 254095 Next: 25841 Since: 11-03-14 Last post: 58 days ago Last view: 2 days ago |
The board uses Linux? Huh. |
shibboleet |
| ||
![]() Fire Mario DROP TABLE users; Level: 113 Posts: 4230/4653 EXP: 15618722 Next: 199839 Since: 07-07-12 Last post: 56 days ago Last view: 6 days ago |
the server does ____________________ a |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6781/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
more fun facts: PHP7 removed support for evaling preg_replace. it had been deprecated for security reasons, and now it's gone.
anyway, I had found that the old K64 archive showed blank posts. that is now fixed. the current board won't be exploding if you feed it oversized strings or bad integers. I used the 'bad', easy fix, but I guess that doesn't surprise you. ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
TheKoopaKingdom |
| ||
![]() Lakitu Aka Koopa. Still looking for new username ideas~ Level: 42 ![]() Posts: 477/552 EXP: 517652 Next: 3710 Since: 10-13-14 From: Castle Grounds Last post: 183 days ago Last view: 55 days ago |
I get a MySQL error whenever I try to view this thread:
![]() All of the other threads appear to be working fine. ____________________ Website | Twitter ![]() |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6783/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
oh my god. more SQL mode shenanigans. will fix it after my dinner. edit- fixed the ugly way. also seems PHP7 isn't a big fan of divisions by zero. ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
MC708 |
| ||
![]() Cheep-cheep Odyssey is the best game ever Level: 25 ![]() Posts: 5/188 EXP: 84919 Next: 4701 Since: 03-04-16 From: Ireland Last post: 427 days ago Last view: 72 days ago |
Wow, that sounds rather complicated. What was the cause? ____________________ Sorry for the maintenance -- we'll be back soon! |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6785/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
<insert nerd speak here>
anyway, we had a weird query for counting poll votes. I made it less weird and now it works in strict mode, no more need to tweak the MySQL modes. oh and while I was at it messing with the poll code, I made it possible to retract a vote from a non-multivote poll. ____________________ NSMBHD - Kafuka - Jul melonDS the most fruity DS emulator there is tonks |
MC708 |
| ||
![]() Cheep-cheep Odyssey is the best game ever Level: 25 ![]() Posts: 7/188 EXP: 84919 Next: 4701 Since: 03-04-16 From: Ireland Last post: 427 days ago Last view: 72 days ago |
Makes sense. I heard that MySQL is kinda finicky. ____________________ Sorry for the maintenance -- we'll be back soon! |
Yoshimaster96 |
| ||
Member Normal user Level: 35 ![]() Posts: 314/345 EXP: 254095 Next: 25841 Since: 11-03-14 Last post: 58 days ago Last view: 2 days ago |
Well, I guess I'm glad the server isn't on Windows Vista x3 |
shibboleet |
| ||
![]() Fire Mario DROP TABLE users; Level: 113 Posts: 4241/4653 EXP: 15618722 Next: 199839 Since: 07-07-12 Last post: 56 days ago Last view: 6 days ago |
...what? ____________________ a |
Arisotura |
| ||
![]() Star Mario macron démission Level: 146 ![]() Posts: 6811/8418 EXP: 38042491 Next: 470803 Since: 07-02-12 From: in a box ![]() Last post: 2 days ago Last view: 1 day ago |
C-lector |
| ||
Normal user Level: 14 ![]() Posts: 45/52 EXP: 11210 Next: 1861 Since: 09-12-16 From: Somewhere Last post: 669 days ago Last view: 667 days ago |
Is normal that the Mario Rankset icon isn"t animated in Chrome?
They work normally in an animated form in Firefox. |
Main - Announcements - Big server update | New reply |
Page rendered in 0.031 seconds. (2048KB of memory used) MySQL - queries: 30, rows: 235/235, time: 0.018 seconds. ![]() © 2005-2008 Acmlm, Xkeeper, blackhole89 et al. |