Data base error " Table does not exist sql=insert"

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Aug 31, 2016 10:02 am

Data base error " Table does not exist sql=insert"

Post by claudio28103 » Fri Sep 02, 2016 3:51 pm

Good Morning,
I have trouble to install my template , when it arrives in the latter case it sends this error below ;

Table 'andro2016.jos_users' doesn't exist SQL=INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`) VALUES (846, 'Demo User', 'demo', '[email protected]', 'ad358a48fb2891854aa8b547c7b151be:jGftU2FbdRXUNikAQrKKeAQl9Is104QE', 0, 0, '2012-10-17 10:56:12', '0000-00-00 00:00:00', '', '{"admin_style":"","admin_language":"","language":"","editor":"none","helpsite":"","timezone":""}', '0000-00-00 00:00:00', 0)

Table 'andro2016.jos_user_usergroup_map' doesn't exist SQL=INSERT INTO `jos_user_usergroup_map` (`user_id`, `group_id`) VALUES (846, 8);

Please I need help
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Fri Sep 02, 2016 4:36 pm, edited 1 time in total.
Reason: mod note: moved, not related to Programming and in English - please do not post in English in international forums in the future; cross posting is also not allowed

User avatar
Joomla! Master
Joomla! Master
Posts: 24592
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands

Re: Data base error " Table does not exist sql=insert"

Post by pe7er » Fri Sep 02, 2016 5:07 pm

What's the prefix of your Joomla database tables?
You can check that in Site > Global Configuration, or using phpMyAdmin to check it directly in the database.

It seems that the template that you are trying to install, tries to add information to your database,
but it is using the hard-coded prefix jos_ which was used with old Joomla versions.
If that's the case you'd better contact the developer to solve that issue.
Kind Regards,
Peter Martin, Global Moderator
Company website: - Joomla specialist, Nijmegen, Netherlands
The best website:


Return to “General Questions/New to Joomla! 3.x”