Object reference not set to object instance error when configuring MySQL Server 8.0

I'm installing MySQLServer8.0.29 from the MySQL installer and while applying the configuration I get the error...

From [MySQLdiscussion group] 2024-03-26 00:24:43 0  1  670

Cannot drop index '*': required -> in foreign key constraint but which one?

Context I have a problem deleting a row from a table. I use these queries to first delete its foreign key and ...

From [MySQLdiscussion group] 2024-03-25 23:27:49 0  2  425

Scan error on column index 0, name 'ID': Scan not supported, storing driver.Value of type int64 to type *authService.Permission"

I receive the following error when I try to call err=row.Scan(&resourceList,resourceTypeId) Scan error on ...

From [MySQLdiscussion group] 2024-03-25 21:26:54 0  1  402

Workaround: How to resolve Unable to delete or update parent row: Foreign key constraint violated?

I want to delete users based on phone number. So I made a custom query to delete that specific user. But an er...

From [MySQLdiscussion group] 2024-03-25 18:47:47 0  1  634

PHP implements file upload function

I want to upload a file to a given folder. <?php$folder="upload/";if(is_uploaded_file($HTTP_POST_...

From [MySQLdiscussion group] 2024-03-25 18:04:14 0  2  581

Multiple updates in MySQL

I know you can insert multiple rows at once, is there a way to update multiple rows at once (like in one query...

From [MySQLdiscussion group] 2024-03-25 16:21:20 0  2  548

ValueError: Invalid literal for base 10 int(): ''

I'm getting this error in my code: ValueError: invalidliteralforint()withbase10:''. What does this mean? Why d...

From [MySQLdiscussion group] 2024-03-25 15:34:49 0  1  612

Efficiently find the last timestamp within a given time range

The problem is with a hypothetical online store; I'll simplify the data for my specific problem. Suppose there...

From [MySQLdiscussion group] 2024-03-22 13:22:08 0  1  660

Unable to insert values ​​into mysql database using spring boo

Hibernate: Inserting employee (age, name) values ​​(?,?) I don't know how to fix it, I tried everything but un...

From [MySQLdiscussion group] 2024-03-22 13:11:21 0  1  577

How to solve the problem of running bash commands that require password in Python

I'm writing a Python function that needs to export a MySQL database to a .sql file using bash. I am using the ...

From [MySQLdiscussion group] 2024-03-22 13:20:24 0  1  634

Using variables within strings for SQL queries using python

I want to see all the data of a specific table of sql database world entered by the user, the code below will ...

From [MySQLdiscussion group] 2024-03-22 12:35:15 0  1  657

Enhance date calculations using the AND operator

I'm sure this is a simple fix, but I can't find it anywhere. I'm trying to use AND to affect the results of a ...

From [MySQLdiscussion group] 2024-03-22 12:11:14 0  1  352

Retrieve next/previous record from MySQL query sorted by multiple columns

I'm running a query through my MySQL database (MariaDB10.3) like this: SELECT*FROMmy_tableORDERBYpriorityDESC,...

From [MySQLdiscussion group] 2024-03-22 11:08:54 0  1  329

A connection interruption was encountered while executing a specific query

I'm getting a 2013LostConnectiontoMySQLserver message during a query to MySQL hosted on an AWS instance. The q...

From [MySQLdiscussion group] 2024-03-22 10:12:35 0  1  444

MySQL datediff returns wrong date

I want to calculate the difference in days between two dates: selectdatediff('2024-03-31','2019-04-01'); retur...

From [MySQLdiscussion group] 2024-03-22 09:51:22 0  1  387