Support Forum

Every time that you post a problem, PLEASE add the Joomla and the extension's versions and revisions (for example: Joomla 3.3.6, Contact Enhanced 3.3.5), PHP version and Server's Operating System. If you only manage only one site it is easier if you edit your profile and just add that information to your signature. Don't forget to add a detailed description of the problem. If possible, write down all steps to simulate the problem.

Before submitting a new post, PLEASE make sure you are running the latest version, test in different browsers (IE, FF, Chrome,..) and clear Joomla and browser's cache after every change you make.

Also, most questions are already answered in our FAQ and in iFAQ and Contact Enhanced documentation pages.

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. CE Plugins
  9. Error on recorded message

Error on recorded message

11 years 6 months ago #12652 by razlie
Hi, I've installed the latest Contact Enhance and my Joomla version is 2.5.7
When i click on the recorded message i got this error

SELECT msg.*,cat.title AS category_title,con.name AS contact_name,l.title AS language_title,ag.title AS access_level FROM nurijos_ce_messages AS msg LEFT JOIN `nurijos_categories` AS cat ON cat.id = msg.catid LEFT JOIN `nurijos_ce_details` AS con ON con.id = msg.contact_id LEFT JOIN `nurijos_languages` AS l ON l.lang_code = msg.language LEFT JOIN nurijos_viewlevels AS ag ON ag.id = msg.access WHERE msg.parent= 0 AND (msg.published = 0 OR msg.published = 1) ORDER BY msg.id desc Unknown column 'msg.catid' in 'on clause' SQL=SELECT msg.*,cat.title AS category_title,con.name AS contact_name,l.title AS language_title,ag.title AS access_level FROM nurijos_ce_messages AS msg LEFT JOIN `nurijos_categories` AS cat ON cat.id = msg.catid LEFT JOIN `nurijos_ce_details` AS con ON con.id = msg.contact_id LEFT JOIN `nurijos_languages` AS l ON l.lang_code = msg.language LEFT JOIN nurijos_viewlevels AS ag ON ag.id = msg.access WHERE msg.parent= 0 AND (msg.published = 0 OR msg.published = 1) ORDER BY msg.id desc LIMIT 0, 20 Unknown column 'msg.catid' in 'on clause' SQL=SELECT msg.*,cat.title AS category_title,con.name AS contact_name,l.title AS language_title,ag.title AS access_level FROM nurijos_ce_messages AS msg LEFT JOIN `nurijos_categories` AS cat ON cat.id = msg.catid LEFT JOIN `nurijos_ce_details` AS con ON con.id = msg.contact_id LEFT JOIN `nurijos_languages` AS l ON l.lang_code = msg.language LEFT JOIN nurijos_viewlevels AS ag ON ag.id = msg.access WHERE msg.parent= 0 AND (msg.published = 0 OR msg.published = 1) ORDER BY msg.id desc

Any help?

Please Log in or Create an account to join the conversation.

11 years 6 months ago #12653 by douglas
Dear razlie,

Did you try to install the Joomla 1.5 version or was this Joomla install migrated from Joomla 1.5?

This should be fixed already.
You have two possible fixes:
1. Try to install the package again, on top of the current installation;
2. Run the SQL query in this post:
ALTER TABLE `#__ce_messages` CHANGE `category_id` `catid` INT(11) NOT NULL;
ALTER TABLE `#__ce_messages` 
	  ADD `access` INT( 11 ) UNSIGNED NOT NULL
	, ADD `language` CHAR( 7 ) NOT NULL

If you opt for the second option, please do not forget to change #__ for your database table prefix;


All the best,

Please Log in or Create an account to join the conversation.

11 years 6 months ago #12654 by razlie
Thanks man! it's good now..

Yes i'm upgrading form Joomla 1.5 to Joomla 2.5.7

Thanks a bunch!

Please Log in or Create an account to join the conversation.

  1. Forum
  3. Ideal Joomla Extensions
  5. Component: Contact Enhanced
  7. CE Plugins
  9. Error on recorded message
Powered by Kunena Forum

Copyright © 2018 IdealExtensions.com. All Rights Reserved.

This site is not affiliated with or endorsed by the Joomla!™ Project. It is not supported or warranted by the Joomla!™ Project or Open Source Matters™. The Joomla!™ logo is used under a limited license granted by Open Source Matters™, the trademark holder in the United States and other countries.
We may collect your IP address and your browser's User Agent string while using our site for security reasons and deriving aggregate information (analytics). This information is retained for a minimum of 1 and a maximum of 24 months.
Feedback