PHP

White screen of death or HTTP error 500 due to Memory limit

Posted on

Recently, we have got an error called as White screen of death (HTTP error 500), when trying to setup an Woocommerce store. The error was appearing immediately when the Woocommerce plugin is activated. We thought it is an random issue hence,have re-installed WordPress also few times, disabled/enabled and installed/uninstalled Woocommerce so many times but nothing […]

Magento

Updating attributes in Magento 2

Posted on

Today we have faced some issues while working on updating the attributes in Magento. Magento2: Use default for product attributes in bulk updates If we had  set ‘New From Date’ and ‘New To Date’ to an incorrect value in store view level, But later to set the correct value In default config is a hectic to […]

Image Optimization

Image optimization in Servers

Posted on

As you all aware that images place an important role in the current generation web but it also brings the issue of dealing with lot of data (bytes in size) between the server and client.For those, there are several types of solutions to implement at various levels like compressing/optimizing image while uploading at client side […]

Video

how to embed responsive youtube video for all devices

Posted on

In the age of dynamic and interactive content, now or then we need to show playing media on web pages. The media should be compatible with all the devices across all the browsers i.e. responsive according the page layout rendering in the device (Phone, Tablet, Laptop or Desktop). Lets see the below article to know […]

MySQL

how to connect mysql database remotely in windows

Posted on

Every developer needs to connect to database to access the data stored. The direct database access will make creating new reports, analyzing the table structure and creating new data structures. Accessing database will take more time than the PhpMyAdmin and it is known that SQL tools tike MySQL Workbench will speed up the work. We […]

Database

expdp : Exporting datadump in Oracle 11g

Posted on

The export can be done in two ways from local machine from Server From Local MachineFor Windows operating system Follow the steps# create directorycreate directory dmpdir as ‘c:/temp’;select directory_name,directory_path from dba_directories; # expdp ownercreate user scott identified by tiger;grant connect, resource to scott; grant read, write on directory dmpdir to scott;expdp scott/tiger@xe directory=dmpdir dumpfile=scott.dmp logfile=expdp.log […]

Database

OLAP vs OLTP vs Datawarehouse Database

Posted on

There is nothing about the database itself that “makes” it an OLAP, or a DW, or an OLTP.That is all a matter of how it is used. Kind of like trying to tell if the Honda Accord parked in my driveway is a family sedan or a pizza delivery vehicle. In fact very few databases […]