We have a magento + marketplace website and a good web server by 128G RAM and other hardwares in this level and about 15000 products + not many visitors (about 5000 per days). BUT we have a trouble on performance.…
I'm moving a website to cPanel hosting and from php 5.1 to 5.4. The only thing that is not working with the move is the return to the index.php page after the MySql data insertion. The data is inserted OK,…
I created a PHP script that imports posts from a CSV file into a WordPress website. To do this, I first bulk import the posts into a table of the WP website database and then the PHP script creates the…
I am using Laravel 5.5 i added this dependency for making simple search engine https://github.com/nicolaslopezj/searchable but getting problem when i try to search anything SQLSTATE[42000]: Syntax error or access violation: 1055 'myreview.movies.name' isn't in GROUP BY (SQL: select count() as…
I have 2 tables. USER table with all personal details and TWEETTABLE with all tweets from user's timeline retrieved through twitter api User table id|twitter_user_name|firstname|lastname|email ----------------------------------------------- 1 | @johnsmith |john |smith |[email protected] tweettable name|scr_name|tweets |created_at_ |followers_count ---------------------------------------------------------- CNN |CNN |*tweet…
I went to Cpanel, and from there created a user and a database with the option MySQL Databases in Cpanel. I inserted and created tables without any problem. Now when I want to connect to it, with these parameters: $servername…
I am having an issue with ONLY_FULL_GROUP_BY on MySQL 5.7.14 where I can't seem to disable it even though I've set the SQL mode. I have set both @@sql_mode to remove ONLY_FULL_GROUP_BY by running this command: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));…
I've created a custom Magento plugin, and everything is working fine, except the database creation. Here is my SQL code. <?php $installer = $this; $installer->startSetup(); $installer->run(" -- DROP TABLE IF EXISTS {$this->getTable('store_city')}; CREATE TABLE '{$installer->getTable('store_city')}'( `city_id` int(11) unsigned NOT NULL…
This is my very first time uploading a website. now I'm having a problem with my hosting which is CPANEL. I'm using the code <?php date_default_timezone_set("Asia/Manila"); $servername = "localhost"; $username = "root"; $password = ""; $db = "exampledb"; // Create…
The following occurs when I try to add a REST role to a user under Permission > Users. Tried this with all users created and also disabled caching but still same problem occurs. Any solution will be helpful. SQLSTATE[23000]: Integrity…