Dev {Tricks}

You are here: Home / Home

by

HTTP 500 error

  • Enable FileInfo in PHP to resolve HTTP Error.
  • The memory limit is the maximum amount of memory this process can use. If you exceed it, the process fails and Apache reports an HTTP 500 error.

by

How To Find Duplicate Values in MySQL

Find duplicate values in one column

SELECT 
    col, 
    COUNT(col)
FROM
    table_name
GROUP BY col
HAVING COUNT(col) > 1;

Find duplicate values in multiple columns

SELECT 
    col1, COUNT(col1),
    col2, COUNT(col2),
    ...

FROM
    table_name
GROUP BY 
    col1, 
    col2, ...
HAVING 
       (COUNT(col1) > 1) AND 
       (COUNT(col2) > 1) AND 
       ...

 

 

 

 

by

Upgrade Issues – OJS (Open Journal System)

A database error has occurred: Duplicate entry ‘2-1-0-1’ for key ‘​review_round_files_pkey

  • Run following commend

    CREATE TABLE review_rounds_old SELECT * FROM review_rounds;
    DELETE FROM review_rounds WHERE review_round_id NOT IN (SELECT MIN(review_round_id) FROM review_rounds_old GROUP BY submission_id, round);
    DROP TABLE review_rounds_old;

by

How do I enable FileInfo in PHP

 How to Install a PHP Extension Using EasyApache 4

  • Log into WHM as root
  • Type ‘easy‘ into the search field of WHM
  • Click on EasyApache 4
  • Click on the Customize button in the Currently Installed Packages section
  • Then click on the PHP Extensions option from the left
  • In the Search field, type ‘fileinfo‘ to get the extension
  • Now toggle to enable or install the extension
  • Click on the Review option from the left
  • Then, click the Provision button
  • Finally Done to complete the task