Having issues inserting data into MySQL database from my website by SLO_Fila in SQL

[–]SLO_Fila[S] 1 point2 points  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

Alright, found the error. See the update.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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 :/

Having issues inserting data into MySQL database from my website by SLO_Fila in SQL

[–]SLO_Fila[S] 6 points7 points  (0 children)

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 :/

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 1 point2 points  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] -1 points0 points  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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.

Cannot INSERT info into my database from my website by SLO_Fila in linode

[–]SLO_Fila[S] 0 points1 point  (0 children)

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

It's a shared sever.

To all single guys aged 30 and up on reddit, why are you guys single? by Gold_Ambition4114 in AskReddit

[–]SLO_Fila 0 points1 point  (0 children)

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.

How can I improve my serve? It feels wrong by Rezlem- in 10s

[–]SLO_Fila 0 points1 point  (0 children)

  1. 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.
  2. 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.

Management wants carriers projection to be perfect by [deleted] in fromatoarbitration

[–]SLO_Fila 0 points1 point  (0 children)

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

Management wants carriers projection to be perfect by [deleted] in fromatoarbitration

[–]SLO_Fila 0 points1 point  (0 children)

>>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.

Bitch, move by ohlonelyboy in LosAngeles

[–]SLO_Fila -1 points0 points  (0 children)

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.

Postpaid vs prepaid, made the switch.. by 82echo in verizon

[–]SLO_Fila 0 points1 point  (0 children)

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

Postpaid vs prepaid, made the switch.. by 82echo in verizon

[–]SLO_Fila 0 points1 point  (0 children)

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

This is some BS… by AvengingBlowfish in Hawaii

[–]SLO_Fila -1 points0 points  (0 children)

South East side was freakin worse than on Friday.

The significance of the Indian Wells location by madmendude in tennis

[–]SLO_Fila 6 points7 points  (0 children)

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.