After updating (through -apt update and apt upgrade) access to the installation of MantisBT has become useless. The databases and users are intact. Access to the server (VPS) through SSH is available and intact. The connection to the database has…
I have this input box on my form: <td contenteditable="true" class="date"></td> and I'm trying to add a date dropdown to it so what I did was: <td contenteditable="true" class="date"><input type="date"></td> And now when I hit send it won't save to…
I am trying to write a MySQL query that returns the most popular day of the week for bookings to take place. I am unsure of my issue here. MySQL returned an error saying there is a syntax error, but…
I have following query that works in phpMyAdmin SELECT CONCAT("'",GROUP_CONCAT( fence_id SEPARATOR "','" ),"'") AS fence_ids FROM asset_fence af INNER JOIN assets a ON a.vehicle_id = af.vehicle_id WHERE a.client_id=1 But the same query gives me error in stored procedure ERROR…
I am running MySQL Server version: 5.7.25-0ubuntu0.16.04.2 - (Ubuntu). When I run this php script below with the CORRECT MySQL root user password entered I get the error: Access denied for user 'root'@'localhost' (using password: NO) However if I change…
I had installed MAMP on my windows 10 machine. I had then configured the MySQL thru the phpMyAdmin and had installed the WordPress. Later due to certain issues, I had to un-install and re-install the MAMP again. This time Apache…
I have this website - www.spieltimes.com Now, I'm willing to restart the entire website from scratch, including databases and cPanel. So, I just want to back up my posts, pages, comments and images. Rest, I don't think are too relevant.…
I need to search and replace this html in a mysql database ( via phpMyAdmin ) : <tr> <td></td> <td></td> </tr> But I don't know how to find it, as it has line breaks. My current query is : UPDATE…
I tried to import a large sql file but its not getting imported. And it shows the following error. phpMyAdmin - Error Incorrect format parameter I have been using Xampp-php 5.6 in ubuntu16.04. I have tried these links given below…
I am using opencart for an online store and I have a SQL structure like this: (image from phpmyadmin) I am trying to cross match product ids with attribute ids. I need to find products that don't have a particular…