Login

u/shez19833

▲ 2 r/mysql

incorrect datetime error: 2026-03-29 01:17:06

EDITED: thankfully only happens on local (mac ) and not on server.
thanks to everyone

Mysql 8.4.8

so i have a column which is a timestamp, i was using b/e language to seed test random data and i got an error

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2026-03-29 01:17:06' for column 'created_at' at row 1 (Connection: mysql, Host: xx, Port: xxx, Database: xx SQL: insert into `messages` (`inbox_id`, `user_id`, `text`, `is_image`, `seen_at`, `created_at`, `updated_at`) values (33, 22, some text., 0, NULL, 2026-03-29 01:17:06, 2026-05-11 13:10:45))

if i change that datetime to 2026-04-29 01:17:06 OR. 2026-03-29 02:17:06 it works.. as its RANDOM data i havent seen the error before, but just want a solution as it could happen in production

(PS> dont worry about unquoted text/time etc) i have manually adding them and tested in MYSQL and i get same errror)

EDITED to add from some research it seems to be timezone issue. but that to me doesnt make sense because if i enter a datetime of '2026-03-29 02:18:06' it works and in DB i still see 2026-03-29 02:18:06 and not 2026-03-29 01:18:06 if there was a timezone issue?

reddit.com
u/shez19833 — 11 days ago
▲ 1 r/vuejs

Edit: solved it . using a store.. so on app.vue increment a variable held in store,
watched for it in the component and fetched Fresh data from API.

I am using composition (script setup) vue 3.
i have found this method:

router.go()

which does work, but it triggers a full page refresh..

In my App.Vue I have a header section. Here i display a link called remove.

In my actual component where i have a list.. Users are able to batch select them, once they do, remove button in App vue becomes visible.. when they click it i send that to api..

when i now do a page refresh, i can see items being removed. but of course this is undesirable. so what are my options?

from searching i have tried adding a key to the user list div, and increasing it everytime remove button is clicked to force component refresh but that doesnt work

i guess when users click on remove, i can trigger an event and the component can filter out the items..

is there a better way?

  1. the list is coming from api and i store that in a const.
  2. when i click the remove button, component doesnt know anything thats happened, and i thought instead of sending an event etc i can do a component refresh
reddit.com
u/shez19833 — 17 days ago
▲ 3 r/vuejs

from this website" https://vueuse.org/core/onLongPress/#component-usage

and its working but i have a link which when clicked takes you to another page.. i want to be able to longpress and when let go, and cancel the link action.

i have tried adding e,.prevenTDefault to the handler..
and added following as given in example but dont seem to stop link from working

<script setup>
import { reactive, ref, onBeforeMount, useTemplateRef } from 'vue'
import { onLongPress } from '@vueuse/core'

onLongPress(
  htmlRefHook,
  onLongPressCallbackHook,
  {
    modifiers: {
      prevent: true,
      stop: true
    }
  }
)

const htmlRefHook = useTemplateRef('htmlRefHook')
function onLongPressCallbackHook(e) {
  e.preventDefault()
  e.stopPropagation()
  console.log("Long Press Triggered")
}
</script>
<template>
<div class="users-grid">
    <div
      class="user-card"
      v-for="user in users"
      :key="user.id"
    >
   <router-link ref="htmlRefHook" :to="{ name: 'users.show', params: { ulid: user.ulid } }">  ....</router-link>
u/shez19833 — 21 days ago
▲ 2 r/SQL

so creating something where you show list of users sorted (think dating app). and when you click on a user you see their profile, but then you can also move to the next/prev user in the same order as the list.

so currently what i am doing is:

  1. when user clicks on a user (selected)
  2. run a query to only get IDs of all users (in an array)
  3. find the INDEX of selected user in this array
  4. create a pagination consisting of 3 records (using backend language)
  5. send that to frontend.
  6. when user scrolls through to the 3rd, call the endpoint again

no 2 query runs initially) but on subsquent we send pack the 'current row' so it all works out perfectly.

THE ISSUE is:

  1. ideally i need to return the rows so if user id = 6, i return couple of users either side
  2. no 2 query above will return large no of ids, so memory and speed issues

tried searching but not even sure what to search for..

(using MySQL but i feel like this is a general discussion)

reddit.com
u/shez19833 — 24 days ago
▲ 30 r/BritishTV

the competitioons are advertised few times in each show.. and i dont like jhow they say you will win.. when its probably just the money belonging to people who enter and dont win.

Also gutted the win to spin is now not free to enter

reddit.com
u/shez19833 — 24 days ago
▲ 35 r/eastenders

i know the younger one was recasted and grown up - but sincet hen they have recatsed him twice.. for no apparent reason

i wonder if they wll bring a new one back.. and when

reddit.com
u/shez19833 — 24 days ago