The server is working on CentOS 8, I'm trying to configure MariaDB by making alterations to /etc/my.cnf but then when I restart DB by doing sudo systemctl restart mariadb, the server does restart but no configuration changes get applied. mysql…
Let's say I have a login form, with 2 fields, email and password, first I want to check if the user email is actually registered or not, so I made a separate file named user_check.php with the PHP code to…
I'm using a PHP script to insert the unique value of an array into the database. Here's the script ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); if (isset($_POST['submit'])) { $df = $_POST['df']; $arr = array(); $file = fopen('files/'.$df.'.csv', 'r'); while (($line =…
I have a MYSQL Table called users. I also have a column called online_status. On my page I want a user to be able to toggle their status as 'Online' or 'Offline' and have this updated in the database when…
I have two sites with separate Wordpress instances. One is in the process of getting WooCommerce, the other has existing users with set groups to access courses. I the future access to the courses is supposed to be sold via…
I have an error when I create a Hikari connection, in a past have using mysql-connector but finally I decided use hikaricp. This is the error: [04:17:49] [Server thread/INFO]: HikariPool-1 - Starting... [04:17:49] [Server thread/INFO]: HikariPool-1 - Driver does not…
I have developed JSON API in the slim framework of PHP. Using this API I send contact numbers from my mobile device to the server. The server saves these contacts in the MySQL database. I hosted the API using digital…
I have a meta attribute on my products that can be accessed like this: get_post_meta( $product_id, '_disable_shipping', true ); I need to update _disable_shipping attribute of all products on MySQL or programmatically. Is there a simple way of doing it?…
I use Nextcloud (18 currently). Everything was working fine until this day when I got this message when accessing my cloud via the webbrowser. Internal Server Error The server encountered an internal error and was unable to complete your request.…
Using: MySQL 5.6 on Debian 9, total DB size is around 450Gb Updated to 5.7, ran mysql_upgrade, noticed that around 150 GB has been taken up. 2 tables are really large and they stayed in 'copying to tmp table' for…