Dev {Tricks}

You are here: Home / Archives for dev

by

Laragon – Powerful universal development environment

Laragon provides powerful tools for Apache, Nginx, MariaDB, MongoDB, PHP, Node.js, Redis, Memcached, npm, yarn, git. It has three different editions – Full, Lite and Portable.

Download laragon at https://laragon.org/download/

Laragon GitHub at https://github.com/leokhoa/laragon/releases/

Important Tutorials

How to install

Just download the latest version To start the journey with Laragon and then click Next, Next, Next…very easy!

Migrate to Laragon

Migrate from WAMP

Migrate from XAMPP

Migrate from others

 

by

XAMPP Error: MySQL shutdown unexpectedly.

Problems:

  • [mysql] Error: MySQL shutdown unexpectedly.
  • [mysql] This may be due to a blocked port, missing dependencies,
  • [mysql] improper privileges, a crash, or a shutdown by another method.
  • [mysql] Press the Logs button to view error logs and check
  • [mysql] the Windows Event Viewer for more clues
  • [mysql] If you need more help, copy and post this
  • [mysql] entire log window on the forums

Solution:

  1. Go to your xampp folder
  2. Then go to mysql/data/
  3. Delete ibdata1 or you may rename it to ibdata1.bak
  4. Start MySQL

It should fix it.

by

Gateway Timeout

  • Gateway Timeout
  • The gateway did not receive a timely response from the upstream server or application.
  • The timeout specified has expired
  • Fatal error: Maximum execution time of 300 seconds exceeded

It could be max_execution_time or max_input_time in .

This can usually be resolved by increasing the values for:

  • max_execution_time and/or max_input_time in the php.ini (DirectAdmin: /usr/local/lib/php.ini) and
  • fastcgi_read_timeout in /etc/nginx/nginx_limits.conf

Restart php-fpm and nginx after the changes

or

Open httpd.conf and add

TimeOut 120
ProxyTimeout 120

Solve the issue in WAMP and XAMPP

To increase the max_execution_time

  1. Go to C:\wamp\apps\phpmyadmin\libraries (path according to your installation)
  2. Open config.default.php and change value for $cfg[‘ExecTimeLimit’] to 0: 
    $cfg['ExecTimeLimit'] = 0;

This will resolve the issue for PhpMyAdmin imports.