Calendar Unable to install 1.0.0 Beta 7

Mouth · May 8, 2018

Server Error
Mysqli prepare error: Unknown column 'min_tags' in 'field list'

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in NixFifty/Calendar/Install.php at line 39
NixFifty_Calendar_Install::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in AddOnInstaller/XenForo/ControllerAdmin/AddOn.php at line 558
AddOnInstaller_XenForo_ControllerAdmin_AddOn->actionStepInstall() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in admin.php at line 13

Mouth · May 10, 2018

@NixFifty Sorry, please move thread to https://nixfifty.com/forums/bug-reports.26/
Fix available?

Naz · May 13, 2018

@Mouth Sorry, I've been a bit under the weather so totally missed this. Anyway, I'm not sure how you've run in to this either.

Is this a fresh install or an upgrade?

Mouth · May 13, 2018

NixFifty said:
I'm not sure how you've run in to this either. Is this a fresh install or an upgrade?

Fresh install.
Copy my production site to DEV, then install on dev.

Naz · May 14, 2018

Give this query a whirl.

Code:

CREATE TABLE IF NOT EXISTS `xf_nf_event_calendar` (
              `calendar_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
              `calendar_title` varchar(100) NOT NULL,
              `calendar_description` text NOT NULL,
              `parent_calendar_id` int(10) unsigned NOT NULL DEFAULT '0',
              `depth` smallint(5) unsigned NOT NULL DEFAULT '0',
              `lft` int(10) unsigned NOT NULL DEFAULT '0',
              `rgt` int(10) unsigned NOT NULL DEFAULT '0',
              `display_order` int(10) unsigned NOT NULL DEFAULT '0',
              `event_count` int(10) unsigned NOT NULL DEFAULT '0',
              `last_event` int(10) unsigned NOT NULL DEFAULT '0',
              `last_event_title` varchar(100) NOT NULL DEFAULT '',
              `last_event_id` int(10) unsigned NOT NULL DEFAULT '0',
              `calendar_breadcrumb` blob NOT NULL,
              `thread_node_id` int(10) unsigned NOT NULL DEFAULT '0',
              `thread_prefix_id` int(10) unsigned NOT NULL DEFAULT '0',
              `background_color` varchar(6) NOT NULL DEFAULT '',
              `border_color` varchar(6) NOT NULL DEFAULT '',
              `text_color` varchar(6) NOT NULL DEFAULT '',
              `background_event_display` tinyint(3) unsigned NOT NULL DEFAULT '0',
              `min_tags` smallint(5) unsigned NOT NULL DEFAULT '0',
              `field_cache` mediumblob NOT NULL,
              PRIMARY KEY (`calendar_id`),
              KEY `parent_calendar_id_lft` (`calendar_id`,`lft`),
              KEY `lft_rgt` (`lft`,`rgt`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Mouth · May 14, 2018

NixFifty said:
Give this query a whirl.

Thanks, that worked.
Had to drop table first. It was ...

Code:

mysql> describe xf_nf_event_calendar;
+--------------------------+----------------------+------+-----+---------+----------------+
| Field                    | Type                 | Null | Key | Default | Extra          |
+--------------------------+----------------------+------+-----+---------+----------------+
| calendar_id              | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| calendar_title           | varchar(100)         | NO   |     | NULL    |                |
| calendar_description     | text                 | NO   |     | NULL    |                |
| parent_calendar_id       | int(10) unsigned     | NO   |     | 0       |                |
| depth                    | smallint(5) unsigned | NO   |     | 0       |                |
| lft                      | int(10) unsigned     | NO   | MUL | 0       |                |
| rgt                      | int(10) unsigned     | NO   |     | 0       |                |
| display_order            | int(10) unsigned     | NO   |     | 0       |                |
| event_count              | int(10) unsigned     | NO   |     | 0       |                |
| last_event               | int(10) unsigned     | NO   |     | 0       |                |
| last_event_title         | varchar(100)         | NO   |     |         |                |
| last_event_id            | int(10) unsigned     | NO   |     | 0       |                |
| calendar_breadcrumb      | blob                 | NO   |     | NULL    |                |
| thread_node_id           | int(10) unsigned     | NO   |     | 0       |                |
| thread_prefix_id         | int(10) unsigned     | NO   |     | 0       |                |
| background_color         | varchar(6)           | NO   |     |         |                |
| border_color             | varchar(6)           | NO   |     |         |                |
| text_color               | varchar(6)           | NO   |     |         |                |
| background_event_display | tinyint(3) unsigned  | NO   |     | 0       |                |
+--------------------------+----------------------+------+-----+---------+----------------+
19 rows in set (0.00 sec)

Confirmed my production DB has no xf_nf_event* tables, refreshed DEV environment from production again, reconfirmed no xf_nf_event* in DEV db, then ran Calendar install again, and same error. Thus, almost definantly an issue with Calendar fresh install condition.

Naz · May 14, 2018

Mouth said:

Thanks, that worked.
Had to drop table first. It was ...

Code:

mysql> describe xf_nf_event_calendar;
+--------------------------+----------------------+------+-----+---------+----------------+
| Field                    | Type                 | Null | Key | Default | Extra          |
+--------------------------+----------------------+------+-----+---------+----------------+
| calendar_id              | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| calendar_title           | varchar(100)         | NO   |     | NULL    |                |
| calendar_description     | text                 | NO   |     | NULL    |                |
| parent_calendar_id       | int(10) unsigned     | NO   |     | 0       |                |
| depth                    | smallint(5) unsigned | NO   |     | 0       |                |
| lft                      | int(10) unsigned     | NO   | MUL | 0       |                |
| rgt                      | int(10) unsigned     | NO   |     | 0       |                |
| display_order            | int(10) unsigned     | NO   |     | 0       |                |
| event_count              | int(10) unsigned     | NO   |     | 0       |                |
| last_event               | int(10) unsigned     | NO   |     | 0       |                |
| last_event_title         | varchar(100)         | NO   |     |         |                |
| last_event_id            | int(10) unsigned     | NO   |     | 0       |                |
| calendar_breadcrumb      | blob                 | NO   |     | NULL    |                |
| thread_node_id           | int(10) unsigned     | NO   |     | 0       |                |
| thread_prefix_id         | int(10) unsigned     | NO   |     | 0       |                |
| background_color         | varchar(6)           | NO   |     |         |                |
| border_color             | varchar(6)           | NO   |     |         |                |
| text_color               | varchar(6)           | NO   |     |         |                |
| background_event_display | tinyint(3) unsigned  | NO   |     | 0       |                |
+--------------------------+----------------------+------+-----+---------+----------------+
19 rows in set (0.00 sec)

Confirmed my production DB has no xf_nf_event* tables, refreshed DEV environment from production again, reconfirmed no xf_nf_event* in DEV db, then ran Calendar install again, and same error. Thus, almost definantly an issue with Calendar fresh install condition.

Thanks for that, that's helpful. Nonetheless, the installer (specifically the code path for fresh install) is all correct now so this should be sorted.

Mouth · May 15, 2018

NixFifty said:
Thanks for that, that's helpful. Nonetheless, the installer (specifically the code path for fresh install) is all correct now so this should be sorted.

When will a Beta 8 be released? I'll wait until that's available to try again. I'm getting many SQL unknown column errors that it just makes the add-on unusable.

Mouth · May 21, 2018

Mouth said:
When will a Beta 8 be released? I'll wait until that's available to try again. I'm getting many SQL unknown column errors that it just makes the add-on unusable.

@NixFifty ??

Naz · May 21, 2018

Mouth said:
When will a Beta 8 be released? I'll wait until that's available to try again. I'm getting many SQL unknown column errors that it just makes the add-on unusable.

Mouth said:
@NixFifty ??

Should be pushing it out today. Sorry about the wait.

Calendar Unable to install 1.0.0 Beta 7

Mouth

Member

Mouth

Member

Naz

Administrator

Mouth

Member

Naz

Administrator

Mouth

Member

Naz

Administrator

Mouth

Member

Mouth

Member

Naz

Administrator

Similar threads