Posts

PHPMYAdmin Error: mysqli::query(): (HY000/1034): Index for table 'global_priv' is corrupt; try to repair it

Image
 If you facing the error in opening any MySQL database.  here are the steps to fix it. In localhost/phpmyadmin in Left Side you will see mysql   then click on global_priv  Finally, go to the Operations tab along the top and use the Repair link  4. Finally all error has been fixed successfully. You can check

Error in starting MYSQL in XAMPP

If you getting error in starting in mysql in xampp something like this error. Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method. Press the Logs button to view error logs and check the Windows Event Viewer for more clues If you need more help, copy and post this entire log window on the forums Answer:    Then Follow the step Rename folder mysql/data to mysql/data_old Make a copy of mysql/backup folder and name it as mysql/data Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema , and phpmyadmin folders) Copy mysql/data_old/ibdata1 file into mysql/data folder Start MySQL from XAMPP control pane Enjoy Now 😜😋

Bitbucket repositories | Adding , updating files to git and bitbucket respository

 Here is the inital command for adding files git status = to check list of files need to be update ( it will show i red) FOR ALL NEW FILE git add  <filename> = it will file add to queue to add FOR SINGLE FILE git add <filename> = it will file add to queue to add git commit -m "add some message" = it will add file to git repository git push = this command add files bitbucket repository NOTE: sometime above first code doesn't work. so for that. first run this command " git init " then close the bash window and try again by opening git bash window again and type " git status " it should work

Simple Read XLSX and CSV file in PHP

 here is the code and the library file is attached below. Library File is here:- Download from here https://drive.google.com/file/d/1fNXtQQbmnII5P7_CZ4EUulaazoPfuz-b/view To Read CSV:  $FileURL = ' testfile.xlsx '; require_once "lib/parsecsv.lib.php"; $csv = new parseCSV($FileURL); echo "test<pre>"; print_r($csv->data); To Read XLSX:  $FileURL = ' testfile.xlsx '; require_once "lib/SimpleXLSX.php" $xlsx = SimpleXLSX::parse($FileURL); echo "test<pre>"; print_r($xlsx->rows());

Openart 3.0.3.3 Error " Notice: Trying to access array offset on value of type null in vendor\scss.inc.php on line 1753"

Image
 Hi, I was getting a lots of errors while doing disable the cache from opencart admin by clicking on this button. like this "Notice: Trying to access array offset on value of type null in vendor\scss.inc.php on line 1753" to fix this error. I did change this code in the following files storage->vendor->scss.inc.php $key = $key[1]; to $key = isset($key[1]) ? $key[1] : null; Now everything is fine and working great 😅

Openart 3.0.3.6 twig error Fatal error: Uncaught Twig\Error\LoaderError: Template "extension/import/productimport.twig" is not defined

 Hi, I was getting an error while including twig file into twig file by this code {% include 'extension/import/productimport.twig' %} since this code is working in my Opencart version 3.0.3.3 but not in Opencart version 3.0.3.6 so I fixed it by following way. Solution:   I defined a variable in the controller like this.  $data['productimport'] = $this->load->view('extension/import/productimport', $data); Then I call this variable in twig file. {{ productimport }}   It is working fine. perfectaly Enjoy 😊 this and save your time.