I have a MySQL server on my host machine and I want my docker containers connect to it, instead of create a MySQL container. In my application configuration file I'm using localhost, as I used to do before using Docker,…
In my prestashop database I tried to update the default product attribute when there is 0 quantity for that one. I check if quantity is 0 and then set default_on to null. Then I try to set another attribute default_on…
I have a Nginx, PHP-FPM and MySQL running inside a docker containers. I want install Opencart 3 in subfolder "public" for future developement. But when I try to install OC3, I get a 404 error from nginx. At the same…
i am fetching a product collection and i want to use like condition on custom attribute but the problem is that while using like condition i want to remove all white space contain in my custom attribute value. i have…
i have 3 tables like this questions_table question_id | content | user | 1 | my first question | [email protected] | 2 | my second question | [email protected]| replies_table reply_id | question_id|user |content |voteCount| 1 | 1 |[email protected] |first reply…
Thank to your help I made a view in my database called 'people' that retrieve data using three functions called 'isUserVerified', 'hasUserPicture' and 'userHobbies' from two tables called 'users' and 'user_hobbies': SELECT `u`.`id` AS `id`, `isUserVerified`(`u`.`id`) AS `verification`, `hasUserPicture`(`u`.id) AS…
Database connection working fine with localhost but not working with remote host.I got the ip from my cpanel that is shared ip. is there anything i am missing? const db = mysql.createConnection({ host: '195.201.179.80', user: '****', password: '****', database: 'enamme_m-tube'…
In Woocommerce I'm trying to modify the Customer Order note to say "Ship with this provider" when a customer billing/shipping address is a specific city. WordPress 5.2.2 WooCommerce 3.6.5 I'm using the woocommerce_thankyou hook, getting the order data via order…
I have a simple sessions table which looks like this: sid watchtime 1 01:07:00 2 01:07:00 3 01:34:00 4 01:36:00 5 01:36:00 6 01:59:00 7 01:59:00 8 00:00:00 9 00:00:00 10 03:42:00 11 00:16:00 12 00:49:00 13 00:55:00 14 00:00:00…
I have an issue where I filter a collection by date and the item I expect to get is not being returned in the collection, however if I print out the SQL that the collection uses and run that against…