Calendar Alpha 3 upgrade - Server Error - SQL Syntax

[Mouth]

XF 1.5.15
Calendar 1.0.0 Alpha 3

Attempting Alpha 2 to Alpha 3 upgrade ...

Server Error

Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ip_id` int(10) unsigned NOT NULL DEFAULT 0' at line 1

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 278
NixFifty_Calendar_Install::addColumn() in NixFifty/Calendar/Install.php at line 55
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 554
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

Upgrade unable to proceed.

 

[Mouth]

And also ...

Server Error

Mysqli statement execute error : Table 'xf_nf_event_response' already exists

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in NixFifty/Calendar/Install.php at line 53
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 554
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

 

[Freelancer]

Upgrade from Alpha 2 to Alpha 3

Error Info
Mysqli prepare error: 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 '`ip_id` int(10) unsigned NOT NULL DEFAULT 0' at line 1 - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace
#0 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('ALTER TABLE `xf...')
#1 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'ALTER TABLE `xf...')
#2 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('ALTER TABLE `xf...')
#3 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/NixFifty/Calendar/Install.php(278): Zend_Db_Adapter_Abstract->query('ALTER TABLE `xf...')
#4 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/NixFifty/Calendar/Install.php(55): NixFifty_Calendar_Install::addColumn('xf_nf_calendar_...', 'ip_id', '`ip_id` int(10)...')
#5 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/XenForo/Model/AddOn.php(214): NixFifty_Calendar_Install::install(Array, Array, Object(SimpleXMLElement))
#6 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), 'NixFifty_Calend...')
#7 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/XenForo/ControllerAdmin/AddOn.php(237): XenForo_Model_AddOn->installAddOnXmlFromFile('/Applications/X...', 'NixFifty_Calend...')
#8 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_AddOn->actionUpgrade()
#9 /Applications/XAMPP/xamppfiles/htdocs/stronghold/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /Applications/XAMPP/xamppfiles/htdocs/stronghold/admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State
Array
(
    [url] => http://localhost/mywebsite/admin.php?add-ons/NixFifty_Calendar/upgrade
    [_GET] => Array
        (
            [add-ons/NixFifty_Calendar/upgrade] => 
        )

    [_POST] => Array
        (
            [server_file] => 
            [_xfConfirm] => 1
            [_xfToken] => ********
        )

)

 

[Naz]

I smell a typo

 

[Mouth]

I smell a typo

Re-download?

 

[Naz]

Re-download?

Give me a bit and I’ll push a new package.

 

[Mouth]

Give me a bit and I’ll push a new package.

Cool. How long is a bit?

 

[Naz]

Cool. How long is a bit?

I got distracted with something and ended up adding more to the add-on lol. I have a few errands to run today and then I’ll drop another build.