Problem: When we use Microsoft SQL Server Management Studio to export the database, by default it will export the database schema only. When I was trying to export the database to import it into my other local machine, I faced [...]
Azure SQL Database is a relational database provided as Database-as-a-Service, which is a part of Microsoft's Cloud Infrastructure Platform, Microsoft Azure. It is also called SQL Azure. It provides database-backed managed service in the cloud with a petabyte-scale infrastructure. It [...]
Growing your business isn’t simple. It needs boosting sales however it’s not simply selling the services or products to prospective and prevailing customers. A business is a scientific and economical method of collecting leads so they will be born-again to [...]
To install Openssl, we have to perform all steps with the root user. Please check the steps below: sudo su (Do all operation with root user) Change the directory to your desire location cd /var/www/html/ Make two directories mkdir Release [...]
How to generate an access token? Step 1: From Setup, enter Apps in the Quick Find box, then select App Manager. Step 2: Locate the OAuth connected app in the apps list, click and select View. Step 3: In the [...]
Introduction: Event Hubs is a real-time data ingestion service that is fully managed, simple, scalable, and trusted. It can stream, process, and receive millions of events per second from any of the sources, which builds data pipelines that are dynamic [...]
Issue: #1553 - Cannot drop index ‘index_name’: needed in a foreign key constraint An issue is generally faced when we are going to drop a unique index from a table. For example, here I have the table articles that have [...]
Solution: If your system is having a current version of MySQL installed i.e 5.6 and you also need 5.5 version then follow the below steps. You can also play with different versions also. Installing Docker To install Docker on your [...]
Introduction to ACLs of Key on S3 Many times when you need to change the access control list (ACL) of a key on the S3 to make it public to private or private to public. This is easy as we [...]
Introduction to Firebase Cloud Earlier known as Google Cloud Messaging and now called Firebase Cloud Messaging (FCM) is a messaging solution for cross-platform provided by Google itself. This service lets you reliably deliver messages or notifications at no cost. One [...]
Below are the steps to integrate Firebase with Laravel 6.x Step 1 To integrate Firebase with Laravel we first need a Laravel project. Create a new Laravel project using the given composer command. composer create-project --prefer-dist laravel/laravel firebase Step 2 [...]
Introduction The SQL database provides a lot of commands and functions. With the help of them, we can manage a huge amount of data easily in the database. Following are some of the examples: INDEX: In the SQL database Index [...]
Issue #1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by After upgrading ubuntu 14.04 to [...]
The mysqli_query statement Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation [...]
Problem - Getting "Class 'MongoDB\Driver\Manager' not found" error while inserting some data in the collection (Laravel) Check the following three points in order to resolve the MongoDB driver issue in Laravel: 1. PHP Module 2. MongoDB Extension 3. MongoDB Library [...]
How to Migrate MySql to MariaDB in Ubuntu 18.04 We need to perform few steps to migrate the MySql database to Maria database, I have mentioned the steps below: Log in to your MySql server with root password. $ mysql [...]
Detect mobile device php code We often need to detect if site visitor is using an iPad, a smartphone or any other mobile device in order to change website appearance and even make it faster by reducing data load. Normally [...]
How to resolve "Class 'App\Controller\Aws\S3\S3Client' not found" error in CakePHP 3.* Problem: Class 'App\Controller\Aws\S3\S3Client' not found error occurs when we are trying to create S3Client class object with given code (code copied from github): $s3 = new Aws\S3\S3Client ( [ [...]
Introduction to Laravel Eloquent ORM Introduction: Eloquent ORM is an Object Relational Mapper that interacts with the database. It is a package separate from laravel so can be used outside the laravel too. It implements active record pattern. Laravel Eloquent [...]
Steps to Change Innodb storage Format for Moodle/Totara Description: You may face this problem in Totara: Advanced Totara features require innodb Barracuda storage format Reason: The error usually occurs because of Mysql 5.6 and below using file format “Antelope”. This [...]