test

1054 Unknown column ‘images’ in ‘field list’ SQL=INSERT INTO

Forums    Joomla Templates Club    JA Teline V    1054 Unknown column 'images' in 'field list' SQL=INSERT INTO
Viewing 15 posts - 1 through 15 (of 43 total)
1 2 3
  • Author
    Posts
  • timtecsa Friend
    September 24, 2015 at 1:07 pm #692307

    I’m trying to add a category called Blog.

    1054 Unknown column ‘images’ in ‘field list’ SQL=INSERT INTO `huspe_categories`

    Please advise in detail how to fix this. I have it on several sites.

    jooservices Friend
    September 24, 2015 at 2:44 pm #692364

    Hi there
    In quick can you add that field images into table _categories. Type TEXT

    Thank you,
    Viet Vu

    1 user says Thank You to jooservices for this useful post

    1. timtecsa
    jooservices Friend
    September 24, 2015 at 2:44 pm #749623

    Hi there
    In quick can you add that field images into table _categories. Type TEXT

    Thank you,
    Viet Vu

    1 user says Thank You to jooservices for this useful post

    1. timtecsa
    timtecsa Friend
    September 25, 2015 at 3:57 pm #692578

    @jooservices I added ‘images’ columns to _categories and _menu tables which worked fine.

    Now I tried to add a Tag in the component but got error message below.

    Error Save failed with the following error: exception ‘UnexpectedValueException’ with message ‘TagsTableTag::_getNode(1, ) failed.’ in /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/joomla/table/nested.php:1542 Stack trace: #0 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/joomla/table/nested.php(783): JTableNested->_getNode(‘1’) #1 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/components/com_tags/tables/tag.php(254): JTableNested->store(false) #2 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/components/com_tags/models/tag.php(343): TagsTableTag->store() #3 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/legacy/controller/form.php(736): TagsModelTag->save(Array) #4 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/legacy/controller/legacy.php(728): JControllerForm->save() #5 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/components/com_tags/tags.php(19): JControllerLegacy->execute(‘apply’) #6 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/component/helper.php(392): require_once(‘/var/www/vhosts…’) #7 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent(‘/var/www/vhosts…’) #8 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent(‘com_tags’) #9 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch() #10 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute() #11 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/index.php(47): JApplicationCms->execute() #12 {main}

    Hard to find any thread on this on http://forum.joomla.org/ as no longer has any search feature 🙁 I posted to this thread: http://forum.joomla.org/viewtopic.php?f=708&t=843407

    Any ideas?

    timtecsa Friend
    September 25, 2015 at 3:57 pm #749735

    @jooservices I added ‘images’ columns to _categories and _menu tables which worked fine.

    Now I tried to add a Tag in the component but got error message below.

    Error Save failed with the following error: exception ‘UnexpectedValueException’ with message ‘TagsTableTag::_getNode(1, ) failed.’ in /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/joomla/table/nested.php:1542 Stack trace: #0 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/joomla/table/nested.php(783): JTableNested->_getNode(‘1’) #1 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/components/com_tags/tables/tag.php(254): JTableNested->store(false) #2 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/components/com_tags/models/tag.php(343): TagsTableTag->store() #3 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/legacy/controller/form.php(736): TagsModelTag->save(Array) #4 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/legacy/controller/legacy.php(728): JControllerForm->save() #5 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/components/com_tags/tags.php(19): JControllerLegacy->execute(‘apply’) #6 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/component/helper.php(392): require_once(‘/var/www/vhosts…’) #7 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent(‘/var/www/vhosts…’) #8 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/application/administrator.php(98): JComponentHelper::renderComponent(‘com_tags’) #9 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/application/administrator.php(152): JApplicationAdministrator->dispatch() #10 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/libraries/cms/application/cms.php(252): JApplicationAdministrator->doExecute() #11 /var/www/vhosts/de2107.ispfr.net/httpdocs/mt5r/administrator/index.php(47): JApplicationCms->execute() #12 {main}

    Hard to find any thread on this on http://forum.joomla.org/ as no longer has any search feature 🙁 I posted to this thread: http://forum.joomla.org/viewtopic.php?f=708&t=843407

    Any ideas?

    jooservices Friend
    September 25, 2015 at 4:01 pm #692579

    Hi there
    I’m not remember exactly about solution but you can try go to backend and do repair or update db via Extensions Management .
    It would help you fix it.

    I assume it’s something in Joomla!.

    Thank you,
    Viet Vu

    jooservices Friend
    September 25, 2015 at 4:01 pm #749736

    Hi there
    I’m not remember exactly about solution but you can try go to backend and do repair or update db via Extensions Management .
    It would help you fix it.

    I assume it’s something in Joomla!.

    Thank you,
    Viet Vu

    timtecsa Friend
    September 25, 2015 at 5:04 pm #692582

    I tried ‘Fix’ first but no effect.
    I have this error on all my joomla 3.4.4 sites regardless of joomlart template.

    There is a tag cloud on teline v demo site so …. ?
    http://ja-teline_v.demo.joomlart.com/index.php/en/teline-v-blog

    Running on J 3.4.4 ???

    Just tried to update ‘com_tags’ via joomlart extensions manager and got this message ???

    Response from JoomlArt Updater Service: Sorry, this extension is invalid, unpublished or no longer supported: com_tags
    Please update the service setting or contact with service provider.

    WTF?

    Conclusion:

    I looked in another of my j344 sites which has existing tags and was updated from j323 recently. adding a new tag worked fine. So it seems that if tags are not already existing you can’t add them to a site updated to j344.

    P.S. I also replaced com_tags component with files from https://www.joomla.org/download.html but same error appears.

    P.P.S Same error on a Joomla 3.3.6 site (Teline IV) which has no pre-existing tags. Bizarre.

    P.P.P.S. A fresh installation of Joomla 3.4.4 with or without demo content and Protostar template does NOT exhibit the same error when adding a new Tag. http://j344tag.gpmnews.com/

    timtecsa Friend
    September 25, 2015 at 5:04 pm #749739

    I tried ‘Fix’ first but no effect.
    I have this error on all my joomla 3.4.4 sites regardless of joomlart template.

    There is a tag cloud on teline v demo site so …. ?
    http://ja-teline_v.demo.joomlart.com/index.php/en/teline-v-blog

    Running on J 3.4.4 ???

    Just tried to update ‘com_tags’ via joomlart extensions manager and got this message ???

    Response from JoomlArt Updater Service: Sorry, this extension is invalid, unpublished or no longer supported: com_tags
    Please update the service setting or contact with service provider.

    WTF?

    Conclusion:

    I looked in another of my j344 sites which has existing tags and was updated from j323 recently. adding a new tag worked fine. So it seems that if tags are not already existing you can’t add them to a site updated to j344.

    P.S. I also replaced com_tags component with files from https://www.joomla.org/download.html but same error appears.

    P.P.S Same error on a Joomla 3.3.6 site (Teline IV) which has no pre-existing tags. Bizarre.

    P.P.P.S. A fresh installation of Joomla 3.4.4 with or without demo content and Protostar template does NOT exhibit the same error when adding a new Tag. http://j344tag.gpmnews.com/

    timtecsa Friend
    September 28, 2015 at 2:24 am #693158

    @jooservices http://forum.joomla.org/viewtopic.php?f=708&t=895143&p=3331738#p3331738 longread.

    timtecsa Friend
    September 28, 2015 at 2:24 am #749846

    @jooservices http://forum.joomla.org/viewtopic.php?f=708&t=895143&p=3331738#p3331738 longread.

    jooservices Friend
    September 28, 2015 at 2:26 am #693159

    Good morning
    I’m checking this topic. Please wait moment

    Thank you,
    Viet Vu

    jooservices Friend
    September 28, 2015 at 2:26 am #749847

    Good morning
    I’m checking this topic. Please wait moment

    Thank you,
    Viet Vu

    jooservices Friend
    September 28, 2015 at 3:23 am #693166

    Hi there
    I have read Joomla! topic and also checked your site.
    At moment i can see it’s working fine. And also checked into database also can see root tag record.

    I hope everything fine now on your site ?

    Thank you,
    Viet Vu

    jooservices Friend
    September 28, 2015 at 3:23 am #749854

    Hi there
    I have read Joomla! topic and also checked your site.
    At moment i can see it’s working fine. And also checked into database also can see root tag record.

    I hope everything fine now on your site ?

    Thank you,
    Viet Vu

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 43 total)
1 2 3

This topic contains 43 replies, has 2 voices, and was last updated by  timtecsa 9 years, 1 month ago.

We moved to new unified forum. Please post all new support queries in our New Forum

Important Notice :

New Unified Portal is live

Must Read

Jump to forum

Categories