Search results for: 'how+to+update'

I tried to install an extension from the Magento market place but I got an incompatibility error...

Installing dependencies from lock file (including require-dev)

Verifying lock file contents can be installed on the current platform.

Your lock file does not contain a compatible set of packages. Please run composer update.

  Problem 1

    - laminas/laminas-dependency-plugin is locked to version 1.0.3 and an update of this package was not requested.

    - laminas/laminas-dependency-plugin 1.0.3 requires composer-plugin-api ^1.1 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

  Problem 2

    - magento/magento-composer-installer is locked to version 0.1.13 and an update of this package was not requested.

    - magento/magento-composer-installer 0.1.13 requires composer-plugin-api ^1.0 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

  Problem 3

    - dealerdirect/phpcodesniffer-composer-installer is locked to version v0.5.0 and an update of this package was not requested.

    - dealerdirect/phpcodesniffer-composer-installer v0.5.0 requires composer-plugin-api ^1.0 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

  Problem 4

    - magento/magento-composer-installer 0.1.13 requires composer-plugin-api ^1.0 -> found composer-plugin-api[2.0.0] but it does not match the constraint.

    - colinmollenhour/cache-backend-redis 1.10.6 requires magento-hackathon/magento-composer-installer * -> satisfiable by magento/magento-composer-installer[0.1.13].

    - colinmollenhour/cache-backend-redis is locked to version 1.10.6 and an update of this package was not requested.

You are using Composer 2, which some of your plugins seem to be incompatible with. Make sure you update your plugins or report a plugin-issue to ask them to support Composer 2.

Solution

Downgrade Composer to Version 1 

If for any reason you need to downgrade Composer to the latest version 1 release, you can do so by running the following command as root:

sudo composer self-update --1

Once the hold has been removed, then ServerPilot will eventually automatically update the composer package again. However, you can manually upgrade it to the latest version 2 release by running the following command as root:

sudo composer self-update --2

Introduction:
Few days ago I received a comment from one of the reader of my blog to show an example on CRUD (Create, Read, Update and Delete) with the database. So in this post we will explore the use of CRUD operation using SQLite database in PhoneGap application.

Description:
CRUD can be described as a process, which helps the user to add, view, search and modify the information inside the database.

Here are the basic steps which demonstrates CRUD operation.

• Create or add new entries
• Read, retrieve, search or view existing entries
• Update, modify or edit existing entries
• Delete, deactivate or destroy existing entries

Before doing any operation on database let’s initialize the database first, either using HTML5 local database concept or using SQLite plugin.

Let’s add the following javascript to initilze the database.

window.openDatabase helps to return the new database object. This method will create a the new SQLite database and also can be use for other data manipulation.

Above method will create the SQLite datebase with unlimited storage capacity. To integrate the SQLite plugin we can follow this post.

Now lets focus on the basic 4 steps of CRUD operation by using the database object already created by above step.

CREATE: Initializing or creating the table. We normally use two keywords CREATE and INSERT for this operation.

Example:

READ: Use to get, search or retrieve entries from a table inside the database.

Example:

UPDATE: This operation is used to update or modify the entries in the table.

Example:

DELETE: This is the last and final method of CRUD operation which is used to delete/drop the entries in table.

Example:

Summary:
I hope the above content will give some idea to start the basic CRUD operation with database and will make the life easy.

On your system, if you have installed multiple versions of PHP (eg PHP 7.1 and PHP 5.6 both). PHP 7.1 is running as default PHP for Apache and CLI. For any requirement, you need to use PHP 5.6. Then you don’t need to remove PHP 7.1. You can simply switch your PHP version to default used for Apache and command line.

For example, your server has PHP 7.1 and PHP 5.6 both version’s installed. Now following example will help you to switch between both versions.

From PHP 5.6 => PHP 7.1

Default PHP 5.6 is set on your system and you need to switch to PHP 7.1. Run the following commands to switch for Apache and command line.

Apache:-

$ sudo a2dismod php5.6
$ sudo a2enmod php7.1
$ sudo service apache2 restart

Command Line:-

$ sudo update-alternatives --set php /usr/bin/php7.1
$ sudo update-alternatives --set phar /usr/bin/phar7.1
$ sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.1

From PHP 7.1 => PHP 5.6

Default PHP 7.1 is set on your system and you need to switch to PHP 5.6. Now run the following commands to switch for Apache and command line.

Apache:-

$ sudo a2dismod php7.1
$ sudo a2enmod php5.6
$ sudo service apache2 restart

Command Line:-

$ sudo update-alternatives --set php /usr/bin/php5.6
$ sudo update-alternatives --set phar /usr/bin/phar5.6
$ sudo update-alternatives --set phar.phar /usr/bin/phar.phar5.6 

If you are modifyed some file automaticaly like log , cache in any application , web site on development or live . you does`t  want to update that particular file into your git repository .

You have a question about How to change Git updated index to previous index setting , just use this following comment in your comment line with current available git copy of your folder .

find {your folder} -type f -exec git update-index --assume-unchanged '{}' \;

for example from magento change the index of media folder

find media/catalog/product/v/ -type f -exec git update-index --assume-unchanged '{}' \;

When you are update ionic framework you got ECONNRESET proxey problem , here as your solution

Step 1:

Set up the npm config

npm config set registry http://registry.npmjs.org/

or 

npm config set registry -g http://registry.npmjs.org/

Step 2:

Update your npm if may have a problem of old version .

npm update -g

Updating/Upgrading to Magento 2.1.0 (via composer)

composer require magento/product-community-edition 2.1.0 --no-update

composer update

rm -rf var/di var/generation

sudo chmod -R 777 var/

php bin/magento cache:clean

php bin/magento cache:flush

php bin/magento setup:upgrade

php bin/magento setup:di:compile

php bin/magento indexer:reindex

After upgrade, check your Magento version with the following command:

php bin/magento --version

Magento CLI version 2.1.0

First let’s look at model and collection architecture in magento. If you look at a magento model class it extends Mage_Core_Model_Abstract which intern extends Varien_Object.The class Mage_Core_Model_Abstract has function like getId(), load(), save(), delete() etc .

Mysql4 resource files, as I mentioned earlier are used to perform database queries on tables. Below will list how we do sql operations inside resource files.

SELECT QUERY

Suppose we have the file Excellence_Test_Model_Mysql4_Test resource file.

<?php
class Excellence_Test_Model_Mysql4_Test extends Mage_Core_Model_Mysql4_Abstract
{
    public function _construct()
    {    
        $this->_init('test/test', 'test_id');
    }
    public function loadByField($field,$value){
    	$table = $this->getMainTable();
    	$where = $this->_getReadAdapter()->quoteInto("$field = ?", $value);
    	$select = $this->_getReadAdapter()->select()->from($table,array('test_id'))->where($where);
    	$id = $this->_getReadAdapter()->fetchOne($sql);
    	return $id;
    }
}

And here is the model file Excellence_Test_Model_Test

<?php
class Excellence_Test_Model_Test extends Mage_Core_Model_Abstract
{
	public function _construct()
	{
		parent::_construct();
		$this->_init('test/test');
	}
	public function loadByField($field,$value){
		$id = $this->getResource()->loadByField($field,$value);
		$this->load($id);
	}
}

In this file there are many new functions which have been used. Let’s take them one by one.

In our model file, we have used this function

$id = $this->getResource()->loadByField($field,$value);

$this->getResource() function returns the resource model’s object. So we are simply calling the loadyByField($field,$value) function in the resource model.

getTable() function

Now in our Mysql4 file, in the loadByField() function we have used $table = $this->getMainTable(); .This function returns the table name of the current model, i.e the one defined in the class’s constructor. If you want to get table name of another sql table in magento, we need to the getTable() call e.g

$table = $this->getTable(‘newsletter/subscribe’);

_getReadAdapter() function

Next we have: $where = $this->_getReadAdapter()->quoteInto(“$field = ?”, $value);

Here the first function too see is the $this->_getReadAdapter() function. This function return an object which has function to perform database query, like fetch(), fetchAll(), query(), etc.

Next, in read adapter, we can perform operations like:

1. fetchAll() : returns entire database table in multiple dimensional array as per the select query. e.g if we are executing an sql like “select * from table_name”, we would use the fetchAll() function to get all the values.
2. fetchRow(): returns a single row of the database table as per the select query. e.g if we are executing sql like “select * from table where id = ’1′” would use fetchRow() to get the single row.
3. fetchCol(): returns single column of a database table as per the select query. e.g if query is a select name from table” we would use fetchCol() function.
4. fetchOne(): return since value, i.e single row and single column. e.g if sql query “select count(*) from table” then we would use fetchOne()

The read adapter has many other functions as well, but above are the important functions used.

_quoteInfo() function

Another function we have used is quoteInto(): This function is used to create our where conditions. In this the actual value is substituted into the question mark we have written. For e.g $this->_getReadAdapter()->quoteInto(“user_id = ?”, 3); translates to

“user_id = 3″. Another frequently used variation of quoteInfo() is

$where = $this->_getReadAdapter()->quoteInto("$field IN(?)", array(1,2,3));

this translates to “field in (1,2,3)”

Getting deeper into the quoteInto() function: If we have multiple where conditions we can use

$where = $this->_getReadAdapter()->quoteInto("$field = ? AND ", $value).$this->_getReadAdapter()->quoteInto("$field1 = ? OR ", $value1).$this->_getReadAdapter()->quoteInto("$field2 = ?", $value2);

So this way, we can have multiple where conditions.

Continuing on the loadByField function in our resource model, next we have

$select = $this->_getReadAdapter()->select()->from($table,array(‘test_id’))->where($where);

Here we have created the select query using the select(), and on that called the from() function.

from() function

The from() function takes many different parameters, if you want to fire a simple select * query, you need to only pass the table name like from($table).

But right now, I wanted to select just a single column that is test_id, so I passed an array with column name to select. i.e array(‘test_id’). If we want to select multiple column, we need to array(‘test_id’,’col1’,’col2’). This will create a sql like

“select test_id,col1,col2 from $table”. But support we want a sql query like

“select test_id as id,col1 as column1 from $table” , i would call

from($table,array('id'=>'test_id','column1'=>'col1'));

Note:

If you want to see the exact sql that is generated by your function, you can any time do this

<?php echo $select; ?>

Again, back to the loadByField() function. The last line

<?php
	$id = $this->_getReadAdapter()->fetchOne($sql);
?>

This is already explained, above.

The select() function we used above return a select object which provides us with many more functions to perform all operations on a sql query. The class for the select object is Varien_Db_Select, where you can look into more details for all functions. Let look at a sample php code below.

public function getAll(){
		$table = $this->getMainTable();
		$where = $this->_getReadAdapter()->quoteInto("id = ?", 123);
$select = $this->_getReadAdapter()->select()->from($table)->columns(array('test_id'))->where($where)->limit(10,5)->order('created_time')->group('list_id')->having('list_id > ?',10);		
echo $select;
	}

As we can see all function in the select object, return the select object itself. Due to this we are able to chain the functions.

In this example, I have used almost all the sql select parameters you might require expect joins, which will be covered later.

Let’s take each function one at a time.

1. select() : used to initialize the sql query. This returns the Select object, which is the object on which we do all our operations.
2. from(): table name on which select operation is done. we have seen this in detail above.
3. columns() : here we can specify exactly which columns to select in the query
4. where() : used to give the where condition
5. limit(): takes to parameters. First are how many rows to return and second is offset from where to start. So in current case, it means return 10rows, leaving first 5rows.this uses the LIMIT 10 OFFSET 5 syntax in sql query, rather than LIMIT 10,5
6. order(): you can set how you want to order the result set. Default is ascending order. But if you want to mentioned descending order you do order(array(‘created_time Zend_Db_Select::SQL_DESC))
7. group(): put group by clause in your select query in the specified field.Having(): put having condition for group by clause.

JOINS

Let look at sample function.

public function joinUs()
{
		$table = $this->getMainTable();
		$table2 = $this->getTable('customer/entity');
		$cond = $this->_getReadAdapter()->quoteInto('t1.id = t2.customer_id','');
		$where = $this->_getReadAdapter()->quoteInto('t1.list_id = "?"',123);
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->join(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->joinLeft(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		$select = $this->_getReadAdapter()->select()->from(array('t1'=>$table))->joinRight(array('t2'=>$table2), $cond)->where($where);
		echo $select."<br/>";
		echo $select."<br/>";
}

This is the output I got in the my pc

SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` INNER JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")
SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` LEFT JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")
SELECT `t1`.*, `t2`.* FROM `aws` AS `t1` RIGHT JOIN `customer_entity` AS `t2` ON t1.id = t2.customer_id WHERE (t1.list_id = "123")

So, here you can see clearly how to use joins. I don’t think much explanation is required, the function call are self-explanatory. We can also use joinCross, joinFull, joinNatural as well, if you require it in any query. Please look at Varien_Db_Select class for details.

COUNT,MAX

Again, lets take another sample code

public function countUs(){
		$table = $this->getMainTable();
		$where = $this->_getReadAdapter()->quoteInto("id = ?", 123);
		$select = $this->_getReadAdapter()->select()->from($table)->reset('columns')->columns(new Zend_Db_Expr('count(*)'));
		echo $select.'<br>';
		$select = $this->_getReadAdapter()->select()->from($table)->reset('columns')->columns(new Zend_Db_Expr('max(list_id)'));
		echo $select.'<br>';
	}

This is the output.

SELECT count(*) FROM `aws`
SELECT max("list_id") FROM `aws`

As you can see here, using Expr classes, we do mysql averaging functions.

query() function

In the end, if you have a very complex sql query, you want to execute you can simple use the query function.

$sql = ‘…complex sql…’;

$this->_getReadAdapter()->query($sql);

public function updateUs(){
		$table = $this->getMainTable();
		$where = $this->_getWriteAdapter()->quoteInto('id = ?', 1);
$query = $this->_getWriteAdapter()->update($table, array('product_id'=>2,'file_id'=>3),$where);	
}

Here you can see how to execute the update query.

UPDATE `aws` SET `product_id` = ?, `file_id` = ? WHERE (id = 1)

For delete query, it’s very simple

$this->_getWriteAdapter()->delete($table,$where)->limit(1);

Important Note: Its considered good practice in magento, to execute these sql query in the resource files only. You can get the read adaptor object in model, phtml or any other files and do the above operations in any file. But as good practices, always try to do the query in resource/mysql4 files only.

RESTful API's are hard! There are a lot of aspects to designing and writing a successful one. For instance, some of the topics that you may find yourself handling include authentication, hypermedia/HATEOS, versioning, rate limits, and content negotiation. Rather than tackling all of these concepts, however, let's instead focus on the basics of REST. We'll make some JSON endpoints behind a basic authentication system, and learn a few Laravel 4 tricks in the process.

The App

Let's build an API for a simple Read-It-Later app. Users will be able to create, read, update and delete URLs that they wish to read later.

Ready to dive in and get started?

/** * Setup the layout used by the controller.

* *@return void

*/

protected function singleadmin() {

$Feeds_return = array();

$data = array();

$response = [ 'admins' => [] ];

try {

if($_REQUEST['security_token'] == $this->token_security) {

$cache_key = 'admin_id_'.$_REQUEST['admin_id'];

if( !Cache::has( $cache_key) ) {

$statusCode = 200;

$Admin = EbooAdmin::find($_REQUEST['admin_id']);

if($Admin->count()>0) {

$response['admins'][] = [ "id" => $Admin->id, "title" => $Admin->admin_user, ];

}

else{

return Response::json($response, $statusCode);

}

Cache::put( $cache_key, $response, 1 );

return Response::json($response, $statusCode);

} else {

$response = Cache::get( $cache_key );

$statusCode = 200;

return Response::json($response, $statusCode);

}

}

}

catch(Exception $e){

$statusCode = 404;

return Response::json($response, $statusCode);

}

}

By now you may know that PHP 7 has been available for quite some time now coming with a number of improvements over version 5. It may be wise to upgrade to PHP7 when running for instance a WordPress using Amazon AWS where you are responsible for any upgrades.

Also as of July 2016, Amazon officially added PHP7 to its repository so you can install it using yum. So first thing I did was create a backup image of my EC2 instance before I went on with the upgrade. Once I had my backups done and proceeded with the PHP 7 upgrade.

Here are the steps I took in order to upgrade from PHP 5.x to 7.

Login to your Linux instance and perform the regular system updates first

$ sudo yum update

Stop the running webserver

$ sudo service httpd stop

Remove any existing PHP packages

$ sudo yum remove php*

Remove old web server installs

$ sudo yum remove httpd*

Update yum package repository

$ sudo yum clean all
$ sudo yum upgrade -y

Install Apache 2.4

$ sudo yum install httpd24

Install PHP 7 packages

$ sudo yum install php70 php70-mysqlnd php70-imap php70-pecl-memcache php70-pecl-apcu php70-gd

Install a new version of mod_ssl

$ sudo yum install mod24_ssl

I also needed to reconfigure /etc/httpd/conf/httpd.conf and /etc/httpd/conf.d/ssl.conf.

Finally, all I needed to do is start my webserver

$ service httpd start

Here we learn how to write custom mysql query in Magento2.

Suppose we have table ’employee’ with fields emp_id, emp_name, emp_code and emp_salary.

Custom Mysql Query

            $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); // Instance of object manager
            $resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
            $connection = $resource->getConnection();
            $tableName = $resource->getTableName('employee'); //gives table name with prefix

            //Select Data from table
            $sql = "Select * FROM " . $tableName;
            $result = $connection->fetchAll($sql); // gives associated array, table fields as key in array.

            //Delete Data from table
            $sql = "Delete FROM " . $tableName." Where emp_id = 10";
            $connection->query($sql);

            //Insert Data into table
            $sql = "Insert Into " . $tableName . " (emp_id, emp_name, emp_code, emp_salary) Values ('','XYZ','ABD20','50000')";
            $connection->query($sql);

            //Update Data into table
            $sql = "Update " . $tableName . " Set emp_salary = 20000 where emp_id = 12";
            $connection->query($sql);

Do you want the multi store magento from Single installation of magento . If you want create multi store magento proceed my following way.

Process: 1

If your store have different type of Category and product then follow the steps. Catalog *then* Manage Categories *then* Add Root Category

Process: 2

Create the new Website System *then* Manage Stores *then* Create Website

fill up all asking.

Name: Name for the domain (“samdoit”)

Code : Identifier for the domain (“samdoit")

Create the new store System *then* Manage Stores *then* Create Store

Fill all fields

Website:) Select “samdoit.com” on dropdown .

Name: ) Use samdoit_com identify of store.

Root Category:) Select Categories from category list by default "Default Category"

Create store view:

System *then* Manage Stores *then* Create Store

View Store: Select “samdoit_com” show in dropdown menu.

Name and Code “samdoit_com”

Make sure all leters in smaller case Status: 'Enabled'

Process: 3

Create Magento another domains. You need to update this following files:

Find this two sample file installed

magento root directory

• index.php.sample
• .htaccess.sample .

Copy the two files and Rename both sample files by below names in your other domain.

• .htaccess
• index.php

Open “index.php”

and change line which start with“$mageFilename”

$mageFilename = ‘{Your magento root}/app/Mage.php’;

Also Change Line start with

$mageRunCode" $mageRunCode = isset ($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : ”;

change ' ' into Your store code

$mageRunCode = isset($_SERVER['MAGE_RUN_CODE']) ? $_SERVER['MAGE_RUN_CODE'] : ‘samdoit_com’;

Theme Changes: You must to change skin, media and javascript link . Now set Magento admin Panel by click follow way click " Configuration in System on admin panal " In Configuration tab select {YOUR website/store } from the dropdown Under Configuration tab Click "Web" under Web tab select and change the link for Secure also Unsecured : Skin Link (eg: Media Link (eg: JavaScript Link (eg: Now you done . Now your multiple stores magento is ready to use. We can create you a Magento Theme for your site by just copy the folder and paste the folder into {your magento}/skin/frontend/default/{your theme} " and paste it as your store name and then just go the "system *then* configuration *then* Web *then* Design" and change the select your store name and paste the theme name whatever you have created in magento skin folder.  

i have this error when i am trying to build

[Error: Failed to find 'ANDROID_HOME' environment variable. Try setting setting it manually.
Failed to find 'android' command in your 'PATH'. Try update your 'PATH' to include path to valid SDK directory.]

Solution

You have permission errors. My guess is that you tried to run the script as root rather than sudo. When running the script you have to run it as your user account using sudo.

change owner permission all files & folder to your current login user .

• Your android sdk
• Your ionic or cordova project files

dont run as admin or run using sudo

Integrity constraint violation: 1062 Duplicate entry ‘4-Images’ for key ‘EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME’, query was: UPDATE `eav_attribute_group` SET `attribute_group_name` = ? WHERE (`attribute_group_id`=10)

This particular error presented itself while upgrading from Magento 2.0.2 to Magento 2.1.x and stops the upgrade process. We’ve discovered the issue is related to old data from the previous Magento 1.9.x installation. In order to over come this error, you’ll need to delete a row from the database.

Run the following MySQL query to find and delete the offending attribute.

delete from eav_attribute_group WHERE attribute_group_name = 'Images';

After that then you can attempt to run the upgrade command again and the issue should be resolved.

We understand not everyone can be a MySQL / Magento 2 expert so if you’re faced with a similar issue and stuck between an upgrade feel free to contact us to assist with your problem.

Install PHPUnit

Installing PHPUnit package on Ubuntu 16.04 (Xenial Xerus) is as easy as running the following command on the terminal:

sudo apt-get update
sudo apt-get install phpunit

Slack is one of the most popular collaboration platforms in the world that brings all your communication together. Conversations in Slack are organized in channels. You can create channels for your teams, projects, topics, or any other purpose to keep information and conversations organized. You can search through everything that’s been posted in channels or your messages. Slack also allows you to talk with your teammates over audio or video calls and share documents, images, videos, and other files.

Slack is not an open-source application and it is not included in the Ubuntu repositories.

This tutorial explains how to install Slack on Ubuntu 18.04. The same instructions apply for Ubuntu 16.04 and any other Debian based distribution, including Debian, Kubuntu, Linux Mint and Elementary OS.

Prerequisites

The user you are logged in as must have sudo privileges to be able to install packages.

Installing Slack on Ubuntu

1. Download Slack

Open your terminal either by using the Ctrl+Alt+T keyboard shortcut or by clicking on the terminal icon.

Visit the Slack for Linux download page and download the latest Slack .deb package. You can also use the following wget command to download the package:

wget https://downloads.slack-edge.com/linux_releases/slack-desktop-4.0.2-amd64.deb

2. Install Slack

Once the download is complete, install Slack by running the following command as a user with sudo privileges:

sudo apt install ./slack-desktop-*.deb

You may be prompted to enter your user password. Once you have correctly entered your password, the installation will continue.

3. Start Slack

Now that you have Slack installed on your Ubuntu desktop, you can start it either from the command line by typing slack or by clicking on the Slack icon (Activities → Slack).

When you start Slack for the first time, a window like the following will appear:

From here you can sign in to a workspace you are already a member of or create a new workspace and start collaborating with your friends and colleagues.

Updating Slack

During the installation process, the official Slack repository will be added to your system. Use the cat command to verify the file contents:

cat /etc/apt/sources.list.d/slack.list

### THIS FILE IS AUTOMATICALLY CONFIGURED ### # You may comment out this entry, but any other modifications may be lost. deb https://packagecloud.io/slacktechnologies/slack/debian/ jessie main 

This ensures that your Slack installation will be updated automatically when a new version is released through your desktop standard Software Update tool.

Recently, I updated the PHP on my machine to version 7.4 using homebrew for Mac OS only to then realise that one of my older projects that I still needed to maintain, made on version 7.2 would no longer work due to using depreciated PHP functions such as array_key_exists.

The long term solution to this would be to update the project so it’s compatible with PHP version 7.4, but for the sake of time, and potential fixes that needed to go out immediately, I needed to be able to develop this project in the environment it’s running in. Fortunately, I use valet to develop all my PHP applications a tool I can only recommend for PHP developers. Valet allows you to develop PHP applications on your local machine with a much higher level of ease than I’ve found using other services such as dockers or XAMP/MAMP.

Valet, with the use of homebrew, supports switching your system PHP version at will to any version installable via homebrew. So switching versions can be as simple as the following:

brew search php

This will show you all the versions of PHP available via brew, the “php” package represents the latest stable PHP version (which at the time of writing is 7.4) you can also see that versions 7.2 and 7.3 are available and I have them installed.
If you do not yet have the PHP version installed, you can install it by entering:

brew install php@7.2

Once installed, you can then use this with valet. By default, valet will use the system PHP version however you can override this by running:

valet use php@7.2

You should then see various outputs that look like the following:
Now you can check that your PHP version has changed:

php -v

You should see your PHP version has changed:

‍
It’s as simple as that!

That’s how you can quickly and easily switch your PHP version using valet and homebrew. Your computer may need a reboot if the change does not seem to take affect, I have only encountered this once in my experience though.

So the only question that remains now is, how do I get back to where I was?

Reverting back to the latest PHP

Once you have finished developing, you’re likely going to want to return to the latest version of PHP for your modern/new applications. Doing this is as simple as downgrading, just tell valet to use “php”, which as we discovered earlier, is the latest version of PHP. So lets run that:

valet use php

As before, you should see an output like the following:

php -v

You should see your PHP version has reverted.

With Advanced Content Manager for Magento 2, it’s possible to index and make your content searchable.

The default catalog search layout is overridden by our extension, in order to add our results to the search.
The extension is adding a Result Search Block into the Catalog Search Result page layout:

Samdoit/ContentManager/view/frontend/layout/catalogsearch_result_index.xml

<page xmlns:xsi="..." layout="2columns-left" xsi:noNamespaceSchemaLocation="..."> 
<body> 
<referenceContainer name="content"> 
<block class="Samdoit\ContentManager\Block\Search\Result" name="search.content.result" after="search.result" template="Samdoit_ContentManager::content/search/result.phtml" cacheable="false"> 
<referenceContainer> 
<body> 
<page>

The Result Block retrieves the current query and create the search filter. The block will load a ContentList Collection from the ids retrieved in the results.

This block has the following child:

<block class="Samdoit\ContentManager\Block\Content\Widget\ContentList" name="search_content_result_list" template="Samdoit_ContentManager::content/widget/list.phtml" cacheable="false"> <block>

This child block is nothing else that a ContentList widget. See the following documentation to customize the content list widget: XML layout

Then if you want to customize the result search for the content, you should override the following layout in frontend:

catalogsearch_result_index.xml

Be sure that the Blackbird_ContentManager module is loaded before yours. You can add the instruction in your module.xml file:

<module name=”Samdoit_ContentManager” setup_version=”1.0.0”> 
<sequence> 
<module name=”Samdoit_ContentManager”/>
<sequence> 
<module>

Now, in your catalogsearch_result_index.xml file, paste the following code in the tags and add instructions from the following resource: XML layout update

<referenceBlock name=”search_content_result_list” template=”my_custom_template.phtml”> <referenceBlock>

However if you just want to modify the template of the result search, see the following resource: Overriding templates

I am running a magento 2.4 project but current not in position to update mysql version. any way to skip that error ?

Magento 2 error Current version of RDBMS is not supported. Used Version: 10.1.37-MariaDB. Supported versions: MySQL-8, MySQL-5.7, MariaDB-(10.2-10.4)

Solution 

An alternative solution if you are in a bind.

Edit file app/etc/di.xml

You can specify acceptable MariaDB versions here - currently 10.2-10.4

Example to allow MariaDB 10.11

<item name="MariaDB-(10.2-10.11)" xsi:type="string">^10\.([2-9]|10|11)\.</item>