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.

× Contact Enhanced is a contact component manager created to replace Joomla! core contacts component and add lots of advantages and new features (see Features ) and it offers many plugins and modules for several different purposes,
Product page | Documentation Page

Form Fields Errors

9 months 2 weeks ago #26910 by trlbldr
I had big problems attempting to add form fields to a newly created category but CE Pro returned an error stating that the "metakey" had not been defined. I searched the forum and found the same issue previously reported by another subscriber and the solution was to drop the SQL keys 'metakey' and 'metadesc' (or something like that) from the #ce_formfields table. I did that and now I get this error when attempting to enter or check on any form field:

Unknown column 'a.language' in 'field list' Unknown column 'a.language' in 'on clause'.

Now I have to reinstall the last Akeeba Backup I made in order to make the forms I previously created work for our users; losing a lot of work I did today.

Oh, and the update to version 4.3.11 doesn't work, either.

Don White
Sr. Technical Communicator

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

9 months 2 weeks ago #26911 by support
Dear Don,

Can you please take a screenshot of the #__ce_formfields table or export the table structure and post the CREATE TABLE statement here?

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

9 months 2 weeks ago #26913 by trlbldr
I successfully installed the updated 4.3.11 package; Thanks!

However, I continue to receive this error when attempting to add a form field: "Save failed with the following error: Field 'metakey' doesn't have a default value".

Check the attached ZIP folder.
This attachment is hidden for guests.
Please log in or register to see it.


Cheers!

Don White
Sr. Technical Communicator

This message has an attachment file.
Please log in or register to see it.

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

9 months 2 weeks ago #26914 by support
Dear Don,

I'm investigating this issue and the metakey and metadesc should have been removed automatically when you upgraded to Joomla 4. I'm adding this to the next update again to make sure they are removed from your site.

I'll send you an updated version which will drop these columns.

As for the "Unknown column 'a.language' in 'on clause'" error, your #__ce_formfields database table does have the language column. I would need Joomla's System Debug enable to see the PHP Call stack in order to make sure it's related to this table.

PS: I usually recommend creating a full back as well as a table backup when you change a database table directly, this way makes it easier for you when you need to restore the changes you just made. You just have to restore that database table backup. In PHPMyAdmin, all you need to do to is copy the table with a prefix and add a backup_ prefix (for example).

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

9 months 2 weeks ago #26915 by trlbldr
Thanks, Douglas. I think you're telling me to use PHPMyAdmin and drop 'metakey' and 'metadesc' from #ce_formfields. I will do that after I've downloaded the SQL table for easy restoration.
I'm planning this because I have a rather urgent need to create a new form for our members to use.
Cheers!

Don White
Sr. Technical Communicator

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

9 months 2 weeks ago #26916 by support
Dear Don,

I sent a new package to you, so you can update your site and remove the metake and metadesc columns automatically.

I have just tested and it worked perfectly.

Best regards,

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

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