Skip to main content
UNA Community Management System UNA Community Management System UNA Community Management System UNA Community Management System
  • Platform
  • Resources
  • Community
  • Pricing
Comment 'Hello @BIG Marketin...' to 'Timeline error with UNA 13.1.0-B1'
Comment to Timeline error with UNA 13.1.0-B1
    •  ·  LeonidS
    •  ·  In reply to
      BIG Marketing Solutions LLC
    •  ·  2023-09-01T18:57:29+0000

    Hello @BIG Marketing Solutions LLC !

    That's weird because the `promoted` field was added there long ago. Try to fix it by running the following query:

    ALTER TABLE `bx_timeline_events` ADD `promoted` int(11) NOT NULL default '0';

    • See older replies...
      •  ·  InPage
      •  ·  In reply to
        LeonidS
      •  ·  2023-09-01T20:21:34+0000

      I get a SQL error running that command:

      SQL Error [1064] [42000]: (conn=1740) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ALTER TABLE `bx_timeline_events` ADD `promoted` int(11) NOT NULL default '0'' at line 1

        •  ·  BIG Marketing Solutions LLC
        •  ·  In reply to
          LeonidS
        •  ·  2023-09-01T20:36:36+0000

        table 'bx_timeline_events' already has the row 'promoted' which is apparently populated by a 0 by default or 10 digits such as "1681045440".

        Is the field supposed to have 11 digits or just 'allow' 11 digits? Do you still recommend this fix?

          •  ·  InPage
          •  ·  In reply to
            LeonidS
          •  ·  2023-09-01T20:55:30+0000

          image_transcoder.php?o=sys_images_editor&h=1544&dpx=2&t=1693601713

        See more...
        • Features
        • Pricing
        • Forum
        • Blog
        • Market
        • About
        • Copyright
        • Contact
        • Terms
        • Privacy
        • 𝕏
        Search
        UNA Community Management System UNA Community Management System UNA Community Management System UNA Community Management System
      • Platform
        • Features
        • Core CMS
      • Resources
        • Documentation
        • Marketplace
        • Discussions
        • Support Groups
        • API Reference
        • UNA CMS on GitHub
        • Webinars
        • Blog
      • Community
        • Discussions
        • Groups
        • Webinars
      • Pricing
      • Are you sure?
        Please, enter a value here