Kuribo64
Views: 19,852,820 Home | Forums | Uploader | Wiki | Object databases | IRC
Rules/FAQ | Memberlist | Calendar | Stats | Online users | Last posts | Search
03-28-24 11:10 PM
Guest:

0 users reading Big server update | 1 bot

Main - Announcements - Big server update Hide post layouts | New reply

Pages: 1 2
Arisotura
Posted on 10-11-16 05:14 PM (rev. 5 of 10-11-16 08:17 PM) Link | #78537
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

* board chokes if the URL is too long (buying/selling items, deleting posts...) THERE IS STILL A LOT OF CODE TO FIX
* gfx/status.php is broken

____________________
NSMBHD - Kafuka - Jul
melonDS the most fruity DS emulator there is

zafkflzdasd

NintendoFan
Posted on 10-11-16 05:16 PM Link | #78538
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
Posted on 10-11-16 05:20 PM Link | #78540
What were we using before?

Arisotura
Posted on 10-11-16 05:21 PM Link | #78541
Posted by NintendoFan
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.

Oh, good sight. Another thing to fix. fdbdfgf


Posted by maor322
What were we using before?

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

zafkflzdasd

NightYoshi370
Posted on 10-11-16 05:41 PM (rev. 2 of 10-11-16 05:43 PM by Arisotura) Link | #78543
I tried blocking a post layout and this appeared:

MySQL error: Data too long for column 'url' at row 1
Query: UPDATE users SET lastview=1476207646,ip='76.90.217.242',ipfwd='',url='/board/profile.php?id=757&blocklayout=1&token=*snip*',useragent='Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.124 Safari/537.36',ipbanned=0 WHERE id=651MySQL error

Arisotura
Posted on 10-11-16 05:45 PM Link | #78544
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

zafkflzdasd

shibboleet
Posted on 10-11-16 07:42 PM Link | #78547
* board chokes if the URL is too long (buying/selling items, deleting posts...)
* gfx/status.php is broken

...

php

____________________
a

Arisotura
Posted on 10-11-16 08:00 PM (rev. 3 of 10-11-16 08:18 PM) Link | #78549
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

zafkflzdasd

Yoshimaster96
Posted on 10-11-16 11:25 PM Link | #78572
The board uses Linux? Huh.

My Youtube Channel:
Yoshimaster96smwc
Some layout tips/code!

-Yoshimaster96

shibboleet
Posted on 10-11-16 11:27 PM Link | #78573
the server does

____________________
a

Arisotura
Posted on 10-11-16 11:47 PM Link | #78574
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

zafkflzdasd

CodingKoopa
Posted on 10-12-16 05:37 PM Link | #78615
I get a MySQL error whenever I try to view this thread:
[image]
All of the other threads appear to be working fine.

____________________
Website | Twitter


Arisotura
Posted on 10-12-16 05:39 PM (rev. 2 of 10-12-16 05:46 PM) Link | #78616
MySQL error: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'kuribo64.v.user' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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

zafkflzdasd

MC708
Posted on 10-12-16 05:55 PM Link | #78620
Wow, that sounds rather complicated. What was the cause?

____________________

Sorry for the maintenance -- we'll be back soon!

Arisotura
Posted on 10-12-16 06:16 PM Link | #78622
<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

zafkflzdasd

MC708
Posted on 10-12-16 06:29 PM (rev. 2 of 10-12-16 06:31 PM) Link | #78624
Makes sense. I heard that MySQL is kinda finicky.

____________________

Sorry for the maintenance -- we'll be back soon!

Yoshimaster96
Posted on 10-14-16 10:26 PM Link | #78737
Well, I guess I'm glad the server isn't on Windows Vista x3

My Youtube Channel:
Yoshimaster96smwc
Some layout tips/code!

-Yoshimaster96

shibboleet
Posted on 10-15-16 01:52 PM Link | #78766
...what?

____________________
a

Arisotura
Posted on 10-16-16 10:54 PM Link | #78830
I don't think running a server on Windows Vista would be a very good idea anyway :P

However, the server versions of Windows are said to be pretty good at it, but Microsoft yadda yadda capitalism yadda.

____________________
NSMBHD - Kafuka - Jul
melonDS the most fruity DS emulator there is

zafkflzdasd

C-lector
Posted on 10-18-16 05:10 PM (rev. 2 of 10-18-16 05:13 PM) Link | #78909
Is normal that the Mario Rankset icon isn"t animated in Chrome?
They work normally in an animated form in Firefox.
Pages: 1 2

Main - Announcements - Big server update Hide post layouts | New reply

Page rendered in 0.065 seconds. (2048KB of memory used)
MySQL - queries: 30, rows: 240/240, time: 0.011 seconds.
[powered by Acmlm] Acmlmboard 2.064 (2018-07-20)
© 2005-2008 Acmlm, Xkeeper, blackhole89 et al.