You can disable the foreign keys check using:


And for return back to original state:


File -> Settings -> Languages & Framework > PHP -> Choose correct interpreter for PHP -> Apply

To solve this issue using Ubuntu or Elementary OS, we should run this command:

curl | sudo apt-key add -

If you are on Linux Ubuntu based:

sudo apt-get install pulseaudio-module-bluetooth
pactl load-module module-bluetooth-discover
cat ~/.ssh/ | ssh user@hostname 'cat >> .ssh/authorized_keys'

I had this problem trying to configure one Elastic Search instance. Seems that this issue is related with low space in your hard drive. Try to make more space in your hard drive or use:

docker rmi $(docker images -q --filter "dangling=true")

This issue got resolved adding this parameters to the Elastic Search configuration (elasticsearch.xml or docker-composer.xml):

cluster.routing.allocation.disk.threshold_enabled: false
cluster.routing.allocation.disk.watermark.low: 500mb
cluster.routing.allocation.disk.watermark.high: 600mb 1m

We are very happy to announce the release of jUpgradePro v3.9.0. In this version we tried to focus on the excess weight of the package because the composer libraries dragged a lot of ballast. Also we focus on Joomla! 3.9 compatibility and working for support Joomla! 4.0 soon!

The list of changes and features:

• Fix `composer install` issues

Decrease in package weight

• Joomla! 3.9 compatibility

• Fix problems migrating from Joomla! 1.0

• Huge list of small issues


jUpgradePro v3.9.0 is developed only for Joomla! 3.8 and greater. If you use Joomla! 3.7 or less, we strongly recommend to use jUpgradePro 3.4.



Sometimes if we read an external document like a PDF we got some 'strange' whitespace characters that cannot be removed using trim(), so one good solution for this is to use str_replace()

$value = str_replace("\xA0", ' ', $value);

This way replaces the non existing IS_NUMERIC() function in MySQL:

SELECT unit FROM testTable WHERE unit NOT REGEXP '^[+-]?[0-9]*([0-9]\\.|[0-9]|\\.[0-9])[0-9]*(e[+-]?[0-9]+)?$'

Sometimes we need to look for first letter of one column so we can use this syntax:

SELECT * FROM testTable WHERE LEFT (name, 1) = 'H';