Recently I have have received under my responsibility the company's wordpress site, suffers from extreme performance issues... I have started investigating, installed Query Monitor and discovered several problemas: Get_terms(). The site's theme use heavily this method in many shortcodes. All…
I'm developing an API with Flask and I cannot retrieve queries from a MySQL database I've connected with flask-sqlalchemy (not sqlalchemy alone). This is a pre-existing database downloaded from my client's PHPMyAdmin, so I haven't ran db.create_all(): I simply created…
I cannot connect to my database which is hosted on OVH remotely from Flutter's package mysql1 and get the following error: flutter: SocketException: Failed host lookup: 'saintlouqpweb.mysql.db' (OS Error: nodename nor servname provided, or not known, errno = 8) I…
Hello I have a telegram bot connected to a MySQL db. I'm using a free account of PythonAnywhere which allows me to have max 3 connections to db per user. But I've been getting a max_user_connections error, so I've configured…
my website recently crashed and is no longer available. I browsed through my Cpanel dashboard and I found error logs file in which I noticed my website is crashing due to call to undefined function mysqli_connect. Website is using PHP…
I am trying to make a CRUD in PHP. Apache and MySQL is still running. class DB { static private $connection; const DB_TYPE = "mysql"; const DB_HOST = "localhost"; const DB_NAME = "crud"; const USER_NAME = "root"; const USER_PASSWORD =…
I'm trying to create mysql db table as below, but it got a syntax error at line 4. CREATE TABLE findable_drivers ( id BIGINT NOT NULL AUTO_INCREMENT, driver_id BIGINT NOT NULL, current_role VARCHAR(100) NOT NULL, #here lat DOUBLE NOT NULL,…
I want to select values 'b' and 'c' by meta key and user id = 197 Select cc.meta_value, fname,cc.meta_value lname FROM usermeta cc where user_id = 197 and (cc.meta_key = 'last_name' or cc.meta_key = 'first_name')
I'm trying to return those posts with post_type = "attachment" , where their meta_value (url) doesn't appear in any post_content . For now I'm trying to give the meta_value manually, which in this case is a image name speed1 I've…
My current site is outdated (not updated for a long time), so created WordPress with all updated plugins, etc. I am using Polylang on my website for the language switching (English = Arabic), and I need to export all my…