Calendar Unable to install 1.0.0 Beta 7

Mouth

Mouth

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

  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in NixFifty/Calendar/Install.php at line 39
  5. NixFifty_Calendar_Install::install() in XenForo/Model/AddOn.php at line 214
  6. XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
  7. XenForo_Model_AddOn->installAddOnXmlFromFile() in AddOnInstaller/XenForo/ControllerAdmin/AddOn.php at line 558
  8. AddOnInstaller_XenForo_ControllerAdmin_AddOn->actionStepInstall() in XenForo/FrontController.php at line 369
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
  10. XenForo_FrontController->run() in admin.php at line 13
 
@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?
 
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;
 
NixFifty said:
Give this query a whirl.
Click to expand...
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.
 
  • Like
Reactions: Naz
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.
Click to expand...
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.
 
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.
Click to expand...
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.
 
You must log in or register to reply here.

Similar threads

Alpha1
Calendar Unknown column 'event_image_required' in 'field list'
Replies
6
Views
3K
Alpha1
Alpha1
Alpha1
Calendar BIGINT UNSIGNED value is out of range in '`xxx`.`xf_user`.`nf_calendar_event_count`
Replies
6
Views
3K
Alpha1
Alpha1
Freelancer
Calendar 1.0.6 Server Error on Event Creation
Replies
3
Views
2K
Naz
Naz
Alpha1
Calendar 1.0.5 Table 'database_name.tableprefix_' doesn't exist
Replies
6
Views
2K
Alpha1
Alpha1
Edwin
Calendar Server error after installing 1.0.0
Replies
5
Views
2K
Mouth
Mouth
Back
Top