Mx Autumn :blobcatpumpkin: on Nostr: I have a very weird problem with #SQLite. My Laravel migration is adding a new ...
I have a very weird problem with #SQLite. My Laravel migration is adding a new varchar(255) column thats not nullable. MySQL and SQLite on my local will run the migration no problem.
However, when ran in our test suite, SQLite returns "General error: 1 Cannot add a NOT NULL column with default value NULL"
Why is SQLite on my computer running it and not the one in our test infra?
#PHP #WebDev
Published at
2025-01-16 11:30:31Event JSON
{
"id": "ca01ed79fb5d1ad38d1b40c7bbad7f3e8b88aa512d1094ef9df2711c37f8815d",
"pubkey": "3631bd2fecc3cc8c0c8582027159251e0da96512c8fde867459de1de5ef4c94c",
"created_at": 1737027031,
"kind": 1,
"tags": [
[
"t",
"sqlite"
],
[
"t",
"php"
],
[
"t",
"webdev"
],
[
"proxy",
"https://notacult.social/users/carbontwelve/statuses/113837803535558394",
"activitypub"
]
],
"content": "I have a very weird problem with #SQLite. My Laravel migration is adding a new varchar(255) column thats not nullable. MySQL and SQLite on my local will run the migration no problem.\n\nHowever, when ran in our test suite, SQLite returns \"General error: 1 Cannot add a NOT NULL column with default value NULL\"\n\nWhy is SQLite on my computer running it and not the one in our test infra?\n\n#PHP #WebDev",
"sig": "8bc3714aba084db482a71444377b4acd38a7a4c0d003534a3c6189522443f4272f31e0345f48edb41fc3ca2d58c3dc3aa1d74d21a5f71fb75782b2e3245632a3"
}
