xfCheck [Deleted]

Matthew Hawley · Jun 17, 2013

I get this when I try to install.

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 'NONE' 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 xfCheck/Install.php at line 12
xfCheck_Install::installLicenseCheck()
call_user_func() 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/ControllerAdmin/AddOn.php at line 42
AddOnInstaller_ControllerAdmin_AddOn->actionInstallUpgrade() in XenForo/FrontController.php at line 313
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/xxx/public_html/xxx/store/admin.php at line 13

Chris D · Jun 17, 2013

I don't understand how anyone has been able to install this...

There's at least two queries in the install that do not work:

Code:

ALTER TABLE `xf_user` ADD COLUMN `token` BLOB DEFAULT NONE

NONE is not valid.

It should be:

Code:

ALTER TABLE `xf_user` ADD COLUMN `token` BLOB DEFAULT NULL

@Matthew Hawley

If you edit Install.php you can change the two queries that contain DEFAULT NONE to DEFAULT NULL and it should install.

Matthew Hawley · Jun 17, 2013

Chris Deeming said:
I don't understand how anyone has been able to install this...

There's at least two queries in the install that do not work:

Code:

ALTER TABLE `xf_user` ADD COLUMN `token` BLOB DEFAULT NONE

NONE is not valid.

It should be:

Code:

ALTER TABLE `xf_user` ADD COLUMN `token` BLOB DEFAULT NULL

@Matthew Hawley

If you edit Install.php you can change the two queries that contain DEFAULT NONE to DEFAULT NULL and it should install.

I tried and I still get the same error.

Code:

<?php

class xfCheck_Install
{
    public static function installLicenseCheck($existingAddOn, $addOnData)
    {
        $db = XenForo_Application::get('db');
        $tokenColumn = $db->fetchOne("SHOW COLUMNS FROM `xf_user` LIKE 'xftoken'");
        if (empty($tokenColumn)) {
            $db->query("ALTER TABLE `xf_user` ADD COLUMN `token` BLOB DEFAULT NULL");
        }
        $domainColumn = $db->fetchOne("SHOW COLUMNS FROM `xf_user` LIKE 'domain'");
        if (empty($domainColumn)) {
            $db->query("ALTER TABLE `xf_user` ADD COLUMN `domain` VARCHAR(100) DEFAULT 0");
        }
        $ivColumn = $db->fetchOne("SHOW COLUMNS FROM `xf_user` LIKE 'iv'");
        if (empty($ivColumn))
        {
            $db->query("ALTER TABLE `xf_user` ADD COLUMN `iv` BLOB DEFAULT NULL");
        }
        $validColumn = $db->fetchOne("SHOW COLUMNS FROM `xf_user` LIKE `token_valid`");
        if (empty($validColumn))
        {
            $db->query("ALTER TABLE `xf_user` ADD COLUMN `token_valid` INT(1) DEFAULT 0");
        }
    }
    public static function uninstallLicenseCheck(array $addonInfo)
    {
        $db = XenForo_Application::get('db');
        $db->query("ALTER TABLE `xf_user` DROP COLUMN `token`");
        $db->query("ALTER TABLE `xf_user` DROP COLUMN `domain`");
        $db->query("ALTER TABLE `xf_user` DROP COLUMN `iv`");
        $db->query("ALTER TABLE `xf_user` DROP COLUMN `token_valid`");
    }
}
?>

Chris D · Jun 17, 2013

You will need to check the error again, because the error is:

Rich (BB code):

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 'NONE' at line 1

The error should be different because you've removed the "NONE" parts of the query. There may be other errors but I haven't tried it myself.

Also, if you're using my add-on installer, don't forget if you edit the file on your server, then use the add-on installer with the Zip file it will overwrite the existing files.

Cupara · Jun 17, 2013

Hmmm, not sure how I ended up putting NONE in there when I had NULL I thought.

Cupara · Jun 17, 2013

There is currently an error with using NULL with Blob so I'm working on a fix to make sure default values are set when updating the registration.

Chris D · Jun 17, 2013

Yeah, actually, that's a good point.

You don't need (and can't have) a default value for a BLOB.

Code:

$db->query("ALTER TABLE `xf_user` ADD COLUMN `iv` BLOB");

That's all you need.

Cupara · Jun 17, 2013

I know, don't know why I put DEFAULT. Right now there is an issue when users register that will error out due to no default value being set.

Chris D · Jun 17, 2013

You shouldn't get an error about a BLOB not having a default value... what is the error?

Cupara · Jun 17, 2013

That is what I thought too but people trying to register on my site get the following error:

Dangerously Dreaming
Server Error
Mysqli statement execute error : Field 'token' doesn't have a default value

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317

Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479

Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574

Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591

XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580

XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381

XenForo_DataWriter->save() in XenForo/ControllerPublic/Register.php at line 317

XenForo_ControllerPublic_Register->actionRegister() in XenForo/FrontController.php at line 310

XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132

XenForo_FrontController->run() in /home/ddream/public_html/index.php at line 13

Chris D · Jun 17, 2013

I think you need to eyeball the actual table as it appears in MySQL or PHP My Admin.

BLOB fields just can't have a default value so I'm guessing that perhaps from some previous testing you maybe have it defined as a varchar or similar.

Cupara · Jun 17, 2013

I checked, it is blob.

http://awesomescreenshot.com/0391eofobe

Cupara · Jun 17, 2013

Odd managed to fix it, just have to update the install file to remove the unneeded nonsense when installing.

Cupara · Jun 17, 2013

Mythotical updated xfCheck with a new update entry:

1 Change

Changed Install.php to properly add both new fields

Read the rest of this update entry...

Allan · Jun 24, 2013

Work on XenForo 1.2.0 ?

Cupara · Jun 25, 2013

So far all my mods work on XenForo 1.2 Beta but as with anything on a beta I do not suggest running it all on a live site.

Allan · Jun 25, 2013

The member will automatically returns to the previous group the license is no longer valid?

Cupara · Jun 27, 2013

Cupara · Jul 14, 2013

FYI, if you have experienced problems with users not getting upgraded fully, you will have to manually rebuild user cache which will update all users still in the awaiting validation usergroup.

Cupara · Jul 18, 2013

Mythotical updated xfCheck with a new update entry:

1 Fix

There was an error when the cron ran.

Fixed attempting to decrypt empty or NULL values.

Read the rest of this update entry...

xfCheck [Deleted]

Well-known member

XenForo developer

Well-known member

XenForo developer

Well-known member

Well-known member

XenForo developer

Well-known member

XenForo developer

Well-known member

XenForo developer

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Similar threads

We value your privacy