MitchReferals 1.5.2 - Installation Errors

[BitaceS]

Hi,

Thank you for all the work first! Actually, by the installation on v. 2.3.7 we got following errors:

Error: Call to undefined method XF\Db\Mysqli\Adapter::getColumns() in src/addons/Mitch/MitchReferrals/Setup.php at line 288
Mitch\MitchReferrals\Setup->ensureClickSourceSchemaHard() in src/addons/Mitch/MitchReferrals/Setup.php at line 26
Mitch\MitchReferrals\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 62
Mitch\MitchReferrals\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 29
Mitch\MitchReferrals\Setup->install() in src/XF/Job/AddOnInstallBatch.php at line 297
XF\Job\AddOnInstallBatch->stepAction() in src/XF/Job/AddOnInstallBatch.php at line 95
XF\Job\AddOnInstallBatch->run() in src/XF/Job/Manager.php at line 275
XF\Job\Manager->runJobInternal() in src/XF/Job/Manager.php at line 205
XF\Job\Manager->runJobEntry() in src/XF/Job/Manager.php at line 121
XF\Job\Manager->runByIds() in src/XF/Admin/Controller/ToolsController.php at line 146
XF\Admin\Controller\ToolsController->actionRunJob() in src/XF/Mvc/Dispatcher.php at line 362
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2824
XF\App->run() in src/XF.php at line 806
XF::runApp() in admin.php at line 15

Error: Call to undefined method XF\Db\Mysqli\Adapter::getColumns() src/addons/Mitch/MitchReferrals/Setup.php:288
Generated by: BitaceS Jan 18, 2026 at 5:00 AM
Stack trace
#0 src/addons/Mitch/MitchReferrals/Setup.php(26): Mitch\MitchReferrals\Setup->ensureClickSourceSchemaHard()
#1 src/XF/AddOn/StepRunnerInstallTrait.php(62): Mitch\MitchReferrals\Setup->installStep1(Array)
#2 src/XF/AddOn/StepRunnerInstallTrait.php(29): Mitch\MitchReferrals\Setup->installStepRunner(1, Array)
#3 src/XF/Job/AddOnInstallBatch.php(297): Mitch\MitchReferrals\Setup->install(Array)
#4 src/XF/Job/AddOnInstallBatch.php(95): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#5 src/XF/Job/Manager.php(275): XF\Job\AddOnInstallBatch->run(8)
#6 src/XF/Job/Manager.php(205): XF\Job\Manager->runJobInternal(Array, 8)
#7 src/XF/Job/Manager.php(121): XF\Job\Manager->runJobEntry(Array, 8)
#8 src/XF/Admin/Controller/ToolsController.php(146): XF\Job\Manager->runByIds(Array, 8)
#9 src/XF/Mvc/Dispatcher.php(362): XF\Admin\Controller\ToolsController->actionRunJob(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\ToolsController), NULL)
#11 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\ToolsController), NULL)
#12 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2824): XF\Mvc\Dispatcher->run()
#14 src/XF.php(806): XF\App->run()
#15 admin.php(15): XF::runApp('XF\\Admin\\App')
#16 {main}
Request state
array(4) {
  ["url"] => string(24) "/admin.php?tools/run-job"
  ["referrer"] => string(46) "https://hytaletalk.com/admin.php?tools/run-job"
  ["_GET"] => array(1) {
    ["tools/run-job"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["_xfRedirect"] => string(82) "https://hytaletalk.com/admin.php?add-ons/install-from-archive-complete&batch_id=13"
    ["_xfToken"] => string(8) "********"
    ["only_ids"] => string(2) "31"
  }
}

Any way that it runs with PDO? Don't found any thread with that issue.

Kind regards
Luke

 

[Mitch]

Posting an update now that should fix

 

[BitaceS]

Posting an update now that should fix

Thank you works!

Now when added widget we got following:

XF\Db\Exception: MySQL query error [1048]: Column 'ref_source_url' cannot be null src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Jan 18, 2026 at 9:17 AM
Stack trace
INSERT  INTO `xf_mitchref_affiliate_click` (`referrer_user_id`, `ip_id`, `click_date`, `user_agent`, `landing_url`, `is_unique`, `ref_source_url`, `ref_source_domain`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1048, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1048, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/Mitch/MitchReferrals/ListenerRef.php(99): XF\Db\AbstractAdapter->insert('xf_mitchref_aff...', Array)
#5 src/XF/Extension.php(54): Mitch\MitchReferrals\ListenerRef::controllerPreDispatch(Object(XF\Pub\Controller\IndexController), 'Index', Object(XF\Mvc\ParameterBag))
#6 src/XF/App.php(3366): XF\Extension->fire('controller_pre_...', Array, 'XF\\Pub\\Controll...')
#7 src/XF/Mvc/Controller.php(140): XF\App->fire('controller_pre_...', Array, 'XF\\Pub\\Controll...')
#8 src/XF/Mvc/Dispatcher.php(361): XF\Mvc\Controller->preDispatch('Index', Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:Index', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\IndexController), NULL)
#10 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\IndexController), NULL)
#11 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2824): XF\Mvc\Dispatcher->run()
#13 src/XF.php(806): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(16) "/?ref=LPEN6NEXK4"
  ["referrer"] => bool(false)
  ["_GET"] => array(1) {
    ["ref"] => string(10) "LPEN6NEXK4"
  }
  ["_POST"] => array(0) {
  }
}

Is it on our side a problem or with some database / addon-entries?

Is there a guide on how to add banners, and is it possible that the ref only counts, when the user has made a minimum of 3 posts or similar?

Thanks!

Regards
Luke

 

[Mitch]

Hey Luke I'm glad the install worked for you now let me do some checking on the widget error for you.

As for how to add banners. Do you mean adding referral banners for other to use to refer traffic to you? If so they can be added by visiting the Banner link found under the Addons Menu in the ACP.

Now, your request to have the referrals not count until a certain post level has been reached. I will consider this and get back to you.

 

[Mitch]

I just released another update to address the widget error

 

[BitaceS]

Thank you once more working excellent! <3