Whiners Corner
Forums > Whiners Corner (Archives) > Drippy-Search | New Thread
Thread Locked. You cannot edit or reply to any messages.
Drippy-
 
Page 1, 2 | Next Page
kyree
Super Regular
Killer Scout

P: 08/28/2021 01:38 EST
E: 08/28/2021 01:39 EST
    your forums *been acting kinda weird  
drippy-
Unreasonable Dictator
Hot Roasted
Sniper Delivery

P: 08/28/2021 09:31 EST
    its all full up of three word thread titles  
Ignorant_Florist
Daycare Manager
Pipebomb Monkey

P: 08/28/2021 11:02 EST
    Well, that kinda explains why it always jumps to 3 pages prior to the New posts when you click "New"....

  
Prelude to Agony
Super Regular
Sniper Harassment
Duty

P: 08/28/2021 11:13 EST
    I said that weeks ago....  
kyree
Super Regular
Killer Scout

P: 08/28/2021 12:38 EST
    I remember..I believe I also replied LOL  
Prelude to Agony
Super Regular
Sniper Harassment
Duty

P: 08/28/2021 12:44 EST
    I believe you're right on that. But, then there's Iggy....  
kyree
Super Regular
Killer Scout

P: 08/28/2021 12:48 EST
    https://www.youtube.com/watch?v=g9NY8R-LmIw
which reminded me of Adrienne Barbeau
  
Spoofer
Super Regular
WMD Creator

P: 08/28/2021 12:53 EST
   
kyree wrote:
which reminded me of Adrienne Barbeau
https://youtu.be/NKVkMEhtkI8
  
sp0t
Super Regular
Assault Cannon
Lover

P: 08/28/2021 13:19 EST
   
kyree wrote:
which reminded me of Adrienne Barbeau
https://www.youtube.com/watch?v=_-9Pewr-JgY
  
Ignorant_Florist
Daycare Manager
Pipebomb Monkey

P: 08/28/2021 13:27 EST
   
Prelude to Agony wrote:
I believe you're right on that. But, then there's Iggy....
Yeah, but now that THREE of us have replied, it should reset itself and work again.

3x3x3...........
  
drippy-
Unreasonable Dictator
Hot Roasted
Sniper Delivery

P: 08/28/2021 18:47 EST
E: 08/28/2021 19:01 EST
    I think I fixed it

If you want the technical details, ts due to newer mysql versions deciding '0000-00-00 00:00:00' is not a valid timestamp. I actually upgraded mysql some time ago, but it wasn't until i wanted to modify the table structure that it became a 'problem', otherwise it worked exactly as it did before.

So I changed the timestamp to NULL instead since that better describes 'not edited' for a message.

That broke some logic in jumping to unread messages since null is special in mysql, and not considered less than a given timestamp like all zeroes is.

If you want random details, I fixed it while using an iPad and a raspberry pi (and I broke it while using a PC)
  
kyree
Super Regular
Killer Scout

P: 08/28/2021 19:09 EST
    drippy- is an apple guy...who knew?  
drippy-
Unreasonable Dictator
Hot Roasted
Sniper Delivery

P: 08/28/2021 19:27 EST
    I'm not really, but my iPhone and iPad I got for free from work. But I also can't deny the quality and usefulness of them -- The iPad lasts forever with just bluetooth enabled (which I use to connect to the pi for a desktop and to a keyboard), so it makes a great mobile workstation for me.

One of these days I'll buy an android phone for myself, because I'm a fan of actually being able to control my own devices and installing whatever I want.
  
kyree
Super Regular
Killer Scout

P: 08/28/2021 19:35 EST
    * drippy- is a smart feller who finds the path of least resistance... Who didn't know this :)  
level1nobody
Super Regular
Cold Giver

P: 08/28/2021 22:09 EST
   
drippy- wrote:
I think I fixed it

If you want the technical details, [...]
https://youtu.be/W9b_63G3iZU
  
Page 1, 2 | Next Page
Forums > Whiners Corner (Archives) > Drippy-