Support

  1. carnalimr
  2. Support
  3. Monday, July 27 2015, 05:01 PM
Hello,
On the front end whenever I click into a user it is directed to this error:
1146 - Error 1146
No idea what that means or how to fix.
admin Accepted Answer
Admin
hi,
this is some DB error.

please post me your site details, you can use the form below the reply in site details tab.

please specify:
- have you some override or custom plugin enabled?
- is a production site?
  1. more than a month ago
  2. Support
  3. # 1
carnalimr Accepted Answer
Pro
Added Site Details into the reply.
  1. more than a month ago
  2. Support
  3. # 2
admin Accepted Answer
Admin
Hi when I try to access on backend your site redirect me on site homepage. Have you some special parameter to access on Backend?
  1. more than a month ago
  2. Support
  3. # 3
carnalimr Accepted Answer
Pro
sorry have a secret parameter. I added the new siteURL
  1. more than a month ago
  2. Support
  3. # 4
carnalimr Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Support
  3. # 5
admin Accepted Answer
Admin
Hi,
error is this:
exception 'RuntimeException' with message 'Table 'xxxx_contact_details' doesn't exist SQL=SELECT `id` FROM xxxx_contact_de....

we have integration with Joomla built-in Contact component*. This is a Joomla core component but missing on your site.

* this integration provide a "email" button on profile page when user is linked to a Joomla contact
  1. more than a month ago
  2. Support
  3. # 6
carnalimr Accepted Answer
Pro
Okay great thanks, do you know how to reinstall this core extension I can't find it anywhere.
  1. more than a month ago
  2. Support
  3. # 7
admin Accepted Answer
Admin
No sorry, but to easy fix this problem you can launch follow query to create contact table (this query become from Joomla installation SQL file):
CREATE TABLE IF NOT EXISTS `#__contact_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`con_position` varchar(255) DEFAULT NULL,
`address` text,
`suburb` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`postcode` varchar(100) DEFAULT NULL,
`telephone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`misc` mediumtext,
`image` varchar(255) DEFAULT NULL,
`email_to` varchar(255) DEFAULT NULL,
`default_con` tinyint(1) unsigned NOT NULL DEFAULT 0,
`published` tinyint(1) NOT NULL DEFAULT 0,
`checked_out` int(10) unsigned NOT NULL DEFAULT 0,
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT 0,
`params` text NOT NULL,
`user_id` int(11) NOT NULL DEFAULT 0,
`catid` int(11) NOT NULL DEFAULT 0,
`access` int(10) unsigned NOT NULL DEFAULT 0,
`mobile` varchar(255) NOT NULL DEFAULT '',
`webpage` varchar(255) NOT NULL DEFAULT '',
`sortname1` varchar(255) NOT NULL,
`sortname2` varchar(255) NOT NULL,
`sortname3` varchar(255) NOT NULL,
`language` char(7) NOT NULL,
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(10) unsigned NOT NULL DEFAULT 0,
`created_by_alias` varchar(255) NOT NULL DEFAULT '',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(10) unsigned NOT NULL DEFAULT 0,
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`metadata` text NOT NULL,
`featured` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
`xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`version` int(10) unsigned NOT NULL DEFAULT 1,
`hits` int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`published`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_featured_catid` (`featured`,`catid`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  1. more than a month ago
  2. Support
  3. # 8
carnalimr Accepted Answer
Pro
One last quick question,
I replace the # (#__contact_details)
with my table prefix correct?
  1. more than a month ago
  2. Support
  3. # 9
admin Accepted Answer
Admin
Hi,
sorry for late reply.

I replace the # (#__contact_details)
with my table prefix correct?
Yes you need to replace "#_" with your table prefix, so for example:
#__contact_details became xxyyz_contact_details
  1. more than a month ago
  2. Support
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.