Categories

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

Rating: 5.0. From 1 vote.
Please wait...

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

Joomla 3.x Troubleshooter. How to get rid of Unknown column 'otpKey' in 'field list' error upon sample data installation-1
  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', 'demo@demolink.org', '$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', 'lorem_ipsum@demolink.org', '$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', 'dolor_sit@demolink.org', '$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.

    Joomla 3.x Troubleshooter. How to get rid of Unknown column 'otpKey' in 'field list' error upon sample data installation-2
  3. Open the database. Go to the SQL tab. Paste the query. Click on the Go button in order to execute the query.

    Joomla 3.x Troubleshooter. How to get rid of Unknown column 'otpKey' in 'field list' error upon sample data installation-3
  4. Query was executed successfully.

    Joomla 3.x Troubleshooter. How to get rid of Unknown column 'otpKey' in 'field list' error upon sample data installation-4
  5. Feel free to check your site now. Sample data was applied successfully.

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

In case you need high-quality designs for your Joomla based website, take a look at the collection of Joomla templates.

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
Joomla Web templates
This entry was posted in Joomla! Tutorials and tagged database, error, installation, joomla, sample data, SQL. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket