- RMS Version
- 2.3.6
- XenForo Version
- 2.3.13
- PHP Version
- 8.4
- Database & Version
- MySQL 8.4
- Are there any errors being throw?
- Yes
Hi, Bob!
I am trying to install RMS 2.3.6 on a clean XenForo installation and have an error. So, try to understand with AI and get some explanation..
Installation fails during installStep1() when creating the xf_xa_rms_vendor table:
XF\Db\InvalidQueryException:
xf_xa_rms_vendor: MySQL statement prepare error [1101]:
BLOB, TEXT, GEOMETRY or JSON column 'vendor_dashboard_url'
can't have a default value
In src/addons/XenAddons/RMS/Install/Data/MySql.php, both URL columns are defined as:
$table->addColumn('vendor_dashboard_url', 'text')->setDefault('');
$table->addColumn('vendor_website_url', 'text')->setDefault('');
The initial vendor INSERT/REPLACE statement in getData() also omits these two columns, so removing their defaults may require adjusting the seed data as well.
Could you please have look at this.
By the way, AMS, IMS and SC are fine and installed normally.
Thank you.
I am trying to install RMS 2.3.6 on a clean XenForo installation and have an error. So, try to understand with AI and get some explanation..
Installation fails during installStep1() when creating the xf_xa_rms_vendor table:
XF\Db\InvalidQueryException:
xf_xa_rms_vendor: MySQL statement prepare error [1101]:
BLOB, TEXT, GEOMETRY or JSON column 'vendor_dashboard_url'
can't have a default value
In src/addons/XenAddons/RMS/Install/Data/MySql.php, both URL columns are defined as:
$table->addColumn('vendor_dashboard_url', 'text')->setDefault('');
$table->addColumn('vendor_website_url', 'text')->setDefault('');
The initial vendor INSERT/REPLACE statement in getData() also omits these two columns, so removing their defaults may require adjusting the seed data as well.
XenForo_test
XF\Db\InvalidQueryException: xf_xa_rms_vendor: MySQL statement prepare error [1101]: BLOB, TEXT, GEOMETRY or JSON column 'vendor_dashboard_url' can't have a default value in src/XF/Db/AbstractStatement.php at line 225- XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
- XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 43
- XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 61
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/Schema/AbstractDdl.php at line 158
- XF\Db\Schema\AbstractDdl->apply() in src/XF/Db/SchemaManager.php at line 194
- XF\Db\SchemaManager->createTable() in src/addons/XenAddons/RMS/Setup.php at line 33
- XenAddons\RMS\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 62
- XenAddons\RMS\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 29
- XenAddons\RMS\Setup->install() in src/XF/Admin/Controller/AddOnController.php at line 431
- XF\Admin\Controller\AddOnController->actionInstall() in src/XF/Mvc/Dispatcher.php at line 364
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 266
- 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 2840
- XF\App->run() in src/XF.php at line 850
- XF::runApp() in admin.php at line 15
Could you please have look at this.
By the way, AMS, IMS and SC are fine and installed normally.
Thank you.
