Joomla 3.x Troubleshooter. How to get rid of "Unknown column otpKey in field list" error upon sample data installation

This tutorial shows how to get rid of the "Unknown column ‘otpKey’ in ‘field list’" error upon sample data installation.

1. Copy the following sql query:

   INSERT INTO 'jos_users' ('id', 'name', 'username', 'email', 'password', 'block', 'sendEmail', 'registerDate', 'lastvisitDate', 'activation', 'params', 'lastResetTime', 'resetCount') VALUES(846, 'Demo User', 'demo', '[email protected]', '$2y$10$Kx9.xksMc0Rh19yJxOtqUOIQZ7OaxfheK7zSAsak7elym/kwAzjqW', 0, 0, '2012-10-17 10:56:12', '2014-12-10 07:17:39', '', '{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""}', '0000-00-00 00:00:00', 0),(847, 'Lorem Ipsum', 'lorem_ipsum', '[email protected]', '$2y$10$Q7Bx5hmTOcx6Cn/FxAHYMOjEIrvvJdKPfz4UB.qc9Fm1/eXeXc.ci', 0, 0, '2014-12-09 10:29:04', '2014-12-09 10:46:07', '', '{}', '0000-00-00 00:00:00', 0),(848, 'Dolor Sit', 'dolor_sit', '[email protected]', '$2y$10$riCCfC6p3sOqQUb5I6mvHuevAlCuThyt5TsVgLLUzZNYLP4zm/JUy', 0, 0, '2014-12-09 10:37:28', '2014-12-09 14:09:16', '', '{}', '0000-00-00 00:00:00', 0);

2. Replace standard jos_ prefix with your Joomla database table prefix. In our case database tables have the cpj26_ prefix.

   

3. Open the database.
   Go to the SQL tab.
   Paste the query.
   Click on the Go button in order to execute the query.

   

4. Query was executed successfully.

   

5. Feel free to check your site now. Sample data was applied successfully.

   

Feel free to check the detailed video tutorial below:

Joomla 3.x Troubleshooter. How to get rid of “Unknown column ‘otpKey’ in ‘field list'” error upon sample data installation