Joomla: Unknown column client_id in where clause

Problem: after update from 3.6.5 to 3.7.0, the modules menu shows the following error: Unknown column ‘client_id’ in ‘where clause   The solution is to use phpMyadmin and run these queries Replace `#_` by your db prefix

MySQL Update Category Count

Update Category Count after database transition in WordPress via SQL query Run the following script in your WP database

Migrate WordPress Database localhost to live (vice versa)

Use this SQL script when changing domains on a WordPress site. Whether you’re moving from an old domain to a new domain or you’re changing from a development domain to a production domain this will work. __STEP1: always backup your database. __STEP2: change the ‘oldsite.com’ and ‘newsite.com’ variables to your own. __STEP3: Login to your […]