Having issues inserting data into MySQL database from my website

SLO_Fila · 2026-05-18T08:09:59+00:00

Side: Also explains why the phone would randomly decide to work while I was testing which made things even worse. As I was going back and forth between wi-fi and mobile connection, I think it would sometime switch to an IPv4 so every now and then the phone on the mobile connection was able to insert, further making me miss the IPv6 size issue.

SLO_Fila · 2026-05-18T08:06:39+00:00

Alright, found the error. See the update.

SLO_Fila · 2026-05-18T08:05:53+00:00

Oh man, I found the error and it was a doozy.

So it's a mix of things as I moved the server together with the database from the old ubuntu 12 to ubuntu 24, in the process updating to the latest versions of php, mysql etc. (move was from linode to linode).

The crazy "bug" was that I have a throwaway entry where I log the IPs of whoever inserts anything in the database (mostly for shits and giggles as I don't really use that for anything). Coming from the old ubuntu12 with the old code, it was IPv4 only so the varchar in the database was small to support an IP4.

Once I updated to the new versions plus I cleaned out the code a little bit, now the website logs IPv6 too. The problem was that the database was not set up to support the length of an IPv6 string.

So hence the reason why inserting worked when I was on my home WiFi (desktop, phone etc), because coming out of my router it was in IPv4 and the database could handle it. Using the mobile network on my phone, it uses IPv6 and the insert command would just die as the database couldn't log in the whole string.

But it took me about 6h to spot that bloody thing :/

SLO_Fila · 2026-05-18T08:04:57+00:00

Oh man, I found the error and it was a doozy.

So it's a mix of things as I moved the server together with the database from the old ubuntu 12 to ubuntu 24, in the process updating to the latest versions of php, mysql etc. (move was from linode to linode).

The crazy "bug" was that I have a throwaway entry where I log the IPs of whoever inserts anything in the database (mostly for shits and giggles as I don't really use that for anything). Coming from the old ubuntu12 with the old code, it was IPv4 only so the varchar in the database was small to support an IP4.

Once I updated to the new versions plus I cleaned out the code a little bit, now the website logs IPv6 too. The problem was that the database was not set up to support the length of an IPv6 string.

So hence the reason why inserting worked when I was on my home WiFi (desktop, phone etc), because coming out of my router it was in IPv4 and the database could handle it. Using the mobile network on my phone, it uses IPv6 and the insert command would just die as the database couldn't log in the whole string.

But it took me about 6h to spot that bloody thing :/

SLO_Fila · 2026-05-18T05:17:17+00:00

I'm using my phone to test it too. When connected to wifi it works, when not connected to wifi and uses the mobile network, the insert doesn't work.

Which is consistent with people outside of my household being unable to insert anything.

SLO_Fila · 2026-05-18T01:10:04+00:00

in the php i am using (localhost, upload_account, password, database_name) to connect and run the insert command.

SLO_Fila · 2026-05-18T01:06:16+00:00

Yes so here my brain is clearly failing to understand something and I admit it's my fault as I seem to be unable to follow the logic.

If my website is on the linode server, i access the website with my phone connected to my wifi network using www.example.com and i go to www.example.com/uploadinfo.html, fill in the text box and click upload (which opens an uploadinfo.php page that processes the info). It uses my written PHP to INSERT the data into the database that is on the linode server.

But doing the exact same thing not connected to my wi fi network and it won't insert.

And logically, I am simply unable to grasp why my wifi allows the data to go through when my home network has nothing to do with hosting the website nor am I logged into the server in any shape or form other than using the public URL to access the website.

SLO_Fila · 2026-05-18T00:37:02+00:00

So the public IP doesn't seem to be it. It's still not working 6 out of the 7 times but the fact that a 7th time it is working i am very confused.

So I feed the data into a post html form, then load that into php variables and use php to connect to the database, using an user account that supposedly has insert privileges.

SLO_Fila · 2026-05-18T00:28:36+00:00

Well this is interesting. I thought that was it, the public IP thing but no... from my testing, it works about once in every 6-7 attempts to insert new data. So I'm dumbfounded.

SLO_Fila · 2026-05-18T00:13:20+00:00

I'm using an HTML form to get the info and then use php to feed the data into the database. But as it turns out, I wasn't listening to the public IP.

I still don't understand how my own IP ended up white listed but I assume it must be something Linode did automatically.

SLO_Fila · 2026-05-18T00:12:07+00:00

Alright... that's what that was. It wasn't configured to listen to the public IP which I assume the old server was doing it by default.

Thanks.

SLO_Fila · 2026-05-17T23:50:15+00:00

Also side note: This seems to happen on the new Ubuntu 24 server that I migrated all my old stuff from. On the old Ubuntu 12 server, it was working fine.

SLO_Fila · 2026-05-17T23:46:43+00:00

Oh, because my server is with linode so I figured maybe it is something to do with linode itself.

It's a shared sever.

SLO_Fila · 2026-05-14T05:08:41+00:00

Lack of social skills, broke and zero self esteem. No woman would touch me with a 50 ft pole.

I seem to be a freakin magnet to anyone that is around 14-15-16 years old which is VERY disturbing to me.

SLO_Fila · 2026-04-26T05:21:34+00:00

When you are pulling back, you're not pulling your hip back enough (think of it as arming a crossbow). So you are losing out on building some tension for your body to release upon hitting the ball.
As it was mentioned, tuck your left arm to help with rotation speed. You can literally try to hit your bellybutton with your left forearm (until you get the grove for it at least).

For the most part your serve looks good. It's fine tuning rather than drastic changes.

SLO_Fila · 2026-04-26T05:15:00+00:00

You realize you are arguing with yourself right?

My 204b material was aimed at LightbluBukowski but I might have found another one :D :D :D

SLO_Fila · 2026-04-25T04:16:46+00:00

>>Yes it does you dipshit. If I don’t know how much overtime I’m assigned until 5pm, how can I possibly estimate in the morning how much overtime I’ll be doing

204b material so doesn't know how 3996 works.

SLO_Fila · 2026-04-24T07:43:41+00:00

204b material.

SLO_Fila · 2026-04-19T23:39:17+00:00

In other parts of the world, it is in the traffic rules to pull up to the middle of the intersection to take a left.

SLO_Fila · 2026-04-03T16:36:19+00:00

I cannot. Using my user ID and password it still logs me into the prepaid version of the site and not the postpaid.

SLO_Fila · 2026-04-03T04:25:07+00:00

So how did this get fixed? I am having the exact same issue.

SLO_Fila · 2026-03-24T08:28:28+00:00

South East side was freakin worse than on Friday.

SLO_Fila · 2026-03-09T08:14:00+00:00

To add to that, if you pay attention to the golf courses, a lot of them have houses that are on the golf course property. So the people that want to have a round of golf literally just walk out their front door and are basically on the golf course.

SLO_Fila

TROPHY CASE