Whenever i try to reindex a table in magento it tries to create a foreign key. That's not the problem. The error i'm getting however, is. Looking into Mysql it gives the following error: Error in foreign key constraint creation…
I am trying to create user profiles based on url. I know how to get paramaters from url like www.domain.com/profile?id=username But I would like to keep it SEO friendly and instead get value from url format: www.domain.com/profile/username I am using…
This is probably super simple - but i am tearing my hair out. database is using cPanel (MariaDB 10.1.28) Heres the scenario 1 Table Called "WARNINGS" 1 column called "WARNING_REASON" (VARCHAR) warning_reason contains various "reasons" 1 column called "WARNING_LEVEL" (VARCHAR)…
I'm currently working on a Laravel project. I did the deploy on a shared server, but I get the error message "SQLSTATE [HY000] [1045] Access denied for user 'root' @ 'localhost' (using password: NO)" The project in Local works me…
I am getting this error when I'm trying to connect using PDO. General error: 1651 Query cache is disabled; restart the server with query_cache_type=1 to enable it I do not have access to MySQL terminal. I only have access to…
I am moving a Magento 1.8 web to a lower cost hosting and exhausted by phpmyadmin installation. Magento 1.8 was suggested to run with PHP 5.4 and Mysql 5.5, therefore, I chose a Centos6.9 image and thought could be easier...The…
I haven't been able to deactivate any plugin for 3 days. When trying to deactivate a plugin, Wordpress shows me the classic success message, but the plugin stays activated. I also have troubles when trying to update widget areas. The…
I'm using centos7 as my server, when running a php page with mysql query i find that mysql is running about 4 processes using htop,knowing my thread concurrency is 1, and only one group should run according to my.conf too,…
I want to retrieve all details related to an order such as order_id, products related to that order and product attributes such as size, price and color in magento database. This is the query I have currently used to retrieve…
I want to create a dev environment of my website on the same server. But I have a 7Gb of database which contains 479 tables and I want to make a copy of that database to the new DB. I…