1054 error on creating or updating content

Shieldfire
Topic Author
Offline
Junior Member

8 years 2 months ago #64412 by Shieldfire

1054 error on creating or updating content was created by Shieldfire

Hi,

I searched your forums and found the similar www.flexicontent.org/forum/30-feature-re...-on-alias.html#62305

However, I get

Code:

1054 Unknown column 'i.alias' in 'where clause' SQL=SELECT COUNT(*) FROM #__flexicontent_items_tmp AS i JOIN #__flexicontent_items_ext AS e ON i.id = e.item_id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON i.id = rel.itemid WHERE i.alias='test' AND (i.catid=236 OR rel.catid IN (SELECT catid FROM #__flexicontent_cats_item_relations WHERE itemid=236) ) AND e.language = '*' AND i.id <> 236 

Upon either creating or updating an article. The article gets created, but the error message is very confusing to our editors. Any suggestions?

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

micker
Offline
Administrator

8 years 2 months ago #64413 by micker

Replied by micker on topic 1054 error on creating or updating content

hello FLEXIcontent and joomla Version ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

Shieldfire
Topic Author
Offline
Junior Member

8 years 2 months ago #64415 by Shieldfire

Replied by Shieldfire on topic 1054 error on creating or updating content

Sorry, too early in the morning ...

Flexi 3.1.0-rc2
Joomla 3.6.2 Stable

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

micker
Offline
Administrator

8 years 2 months ago #64416 by micker

Replied by micker on topic 1054 error on creating or updating content

can you update to last version on github to repair your bdd ?

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

Shieldfire
Topic Author
Offline
Junior Member

8 years 2 months ago #64417 by Shieldfire

Replied by Shieldfire on topic 1054 error on creating or updating content

Currently I have limited access to the backend unfortunately, so not atm. I am working on this with the hosting provider.

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

ggppdk
Offline
Administrator

8 years 2 months ago #64506 by ggppdk

Replied by ggppdk on topic 1054 error on creating or updating content

This can not be right, the column can not be missing

- try selecting all tables from phpmyadming and clicking repair

then re-upload the flexicontent package via joomla installer

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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