I have to run migrations on my online project but it doesn't work for a foreign key. I have two tables : media and video_categorie (existing) Here is my migration file to create the video_categorie file: <?php use IlluminateDatabaseMigrationsMigration; use…
I'm trying to migrate a Laravel 5 API with MySQL 5.7 to a Laravel 9 API with MySQL 8. Almost everything is working well, except on a few queries that tries to load data with their parent, recursively. On Laravel…
When trying to start XAMPP I get the following: [mysql] Error: MySQL shutdown unexpectedly. 11:02:20 [mysql] This may be due to a blocked port, missing dependencies, 11:02:20 [mysql] improper privileges, a crash, or a shutdown by another method. 11:02:20 [mysql]…
Trying to fetch products ID and the products variable ID in Mysql. My category is 7006. This query gives me only the general product, and not the product variables values. SELECT post.ID, post.post_title, metavalue1.meta_value AS MetaValue1, metavalue2.meta_value AS MetaValue2 FROM…
firstly I'd like to say that this topic might be related to others, but I can't find a solution for this specific error. Remembering that this error happens ONLY when I execute my ./mvnw test within the Dockerfile stage and…
I am trying to run an SQL query provided to me in a .sql file. The query is as below: SELECT CONCAT('[', GROUP_CONCAT(json_column SEPARATOR ','),']') AS jsonout FROM (SELECT JSON_OBJECT( 'courseid', (CAST(c.id AS JSON)), 'title.en',CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(c.fullname, '{mlang en}', -1), '{mlang}', 1)…
I have a docker compose which contains the following instructions : version: '3.8' services: mysql-standalone: container_name: marqueblanchebd image: marqueblanchebd:latest ports: - "3307:3306" volumes: - data:/var/lib/mysql spring-boot: image: testmb container_name: mbwebservice ports: - "8091:8080" build: context: . dockerfile: Dockerfile depends_on: -…
I am trying to containerize my company's app. When I deploy that app in VM, I have to install MySQL in the same VM because the application has a hardcoding 127.0.0.1:3306 in the source code. Now I am trying to…
I'm trying to achieve a simple custom AJAX request from my Wordpress Page. I don't want to use form data but custom data from input fields. When I try to use the data, that is send by the AJAX Call…
I am new to Laravel and I built a Linktree clone following a Youtube video. I had many problems since I was coding in Laravel 8 and his project was in an older version of Laravel. Now, I don't have…