Joomla 2.5.x. Troubleshooter. How to deal with “Base table or view not found: 1146…” error

This tutorial shows how to get rid of “Base table or view not found: 1146” error in Joomla 2.5.x.

Joomla 2.5.x Troubleshooter. How to deal with “Base table or view not found: 1146…” error

You should follow the steps below to resolve “Base table or view not found: 1146” and the following error:

Some errors occurred while populating the database: Table 'xxx_fp1.fuirx_usergroups' doesn't exist.

1. Download and open installation\sql\joomla.sql file in your editor. Search usergroups table. Find USING BTREE code:

   

2. Remove USING BTREE code. Modified file should look like on the screenshot below:

   

3. Save changes and upload the modified file. Perform Joomla installation.

4. We have installed Joomla without errors. Please check the screenshot:

   

Feel free to check the detailed video tutorial below:

Joomla 2.5.x Troubleshooter. How to deal with “Base table or view not found: 1146…” error