I'm using MySQL 5.7 and PHP 7.4. The following select statement runs perfectly fine in phpMyAdmin and returns a row, as I would expect. select b.price,sum(ifnull(i.itemamount,0)) totalpaid,b.loyaltypoints from bookings b left join paymentitems i on i.bookingid = b.id where b.id…
I just upgraded my phpversion from php 7.1 to 7.3. Unfortunately I can't seem to get mysql working. I'm on a centos 7 box using yum package manager. These are my installed php packages. I've rebooted and tried uninstalling, reinstalling…
Trying to install mysql server on centos 8. and after using sudo systemctl status mysqld.service getting this picture, that is hanging for hours. I don't understand what it means and haven't found any information about this situation. If I'm trying…
Yesterday the mysql service stopped working from my dedicated server, taking down several webpages and other applications that run on it. Maybe a cpanel autoupdate didn't finished correctly but I've only recieved warnings emails with this error: (XID ######) The…
I am using Laravel 8.12 I am doing a DB::select() call with DB::raw() method filtering. But for convenience I will post full statement with values as well. Here is the PHP code for query $sql = "SELECT `medium_info`.* , `postings`.`posting_timestamp`…
I'm trying to create stored procedures for my teammates who are non-technical and can't write MySQL queries on their own. They are currently accessing the database through phpMyAdmin. However, when I create stored procedures, my teammates are unable to execute…
I am a Laravel and Eloquent noob. I'm trying to do a simple foreign key in a "checklist items" table that takes the primary ID from the "users" table as a foreign key. Here are my two database migrations: users:…
My problem is: I need to insert two values from two different tables and one given one by the exercise into a third table. First, I figured I need the data from the two separate tables, therefore: SELECT tablename1.id FROM…
I am pretty new to Laravel but have worked with several frameworks in the past. I am using a Linux development host and have created a docker container as per documentation using: curl -s https://laravel.build/example-app | bash After that I…
I am trying to connect docker nginx server to local MySQL database.But I am getting this error instead: SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations and table_type = 'BASE TABLE')…