So i am trying to login to my site via steam api and this error pops up SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ip' cannot be null. SQL: insert into `users` (`name`, `steamid`, `avatar`, `token`, `ip`) i use laravel php7.0…
I need to take value ecotax from table ps_product for id_product and update value ecotax on same id_product in table ps_product_shop. Make this command: UPDATE `ps_product_shop` SET `ecotax` = (SELECT `ecotax` FROM `ps_product` WHERE ps_product.`id_product` = ps_product_shop.`id_product`); but get: #1048…
I have Laravel running in Docker with 3 containers - Nginx, MySQL 8 And PHP 8. I have the following docker-compose.yaml version: '3.8' services: server: build: context: . dockerfile: dockerfiles/nginx.dockerfile ports: - '8000:80' volumes: - ./src:/var/www/html - ./nginx/nginx.conf:/etc/nginx/conf.d/default.conf:ro container_name: server…
i have many to many relationship like this : Server version: 10.4.17-MariaDB table colors(id,name). table items(id,title....). table item_color(id,items_id,color_id). my query is like this : SELECT items.*,colors.name FROM items,item_color,colors where items.id = item_color.item_id and colors.id = item_color.color_id i use php function…
Version: OS lsb_release -a : Ubuntu 18.04.5 LTS PHP php -v : 8.0.1 Apache apache2 -v : 2.4.29 (Ubuntu) MySQL mysql --version : mysql Ver 14.14 Distrib 5.7.32 Problem: I'm trying to install LAMP Stack using following article. However, I…
I'm working with a containerized Laravel app that is supposed to be connecting to a remote rds database, here is a sample .env DB_HOST=xxxxxx.rds.amazonaws.com DB_DATABASE=sample DB_USERNAME=sample DB_PASSWORD=sample DB_PORT=3306 DATABASE_DRIVER=mysql The container works as it should but the problem is, it…
I am making my first app with Symfony and when i setup my database (doesn't matter if it's postgresql or mysql). I have an error "could not find driver" three time. One in PDOConnection.php line 38. Other in Exception.php line…
Found Problem: I was able to significantly reduce the response time to less than 0.01 seconds from 1.1 seconds simply by removing the ORDER BY clause. I was doing a USORT in PHP on dates anyway since the post-processing would…
I have two tables users and radacct, both table has same column username . table radacct also has a column acctstoptime which is important here. table acctstoptime is actually a datetime column with allow null. table users has more than…
I have 2 tables in my product database: product_list(id, Product_ID, Product_Name, Supplier), product_option (id, Product_ID, Color, Size). both 'id's are primary keys with auto_increment. I want to print all Color and Size values under each Product_Name (without repetition) that is…