Error Installing new CB Subs
- PaceOnline
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 2
- Karma: 0
1 year 2 months ago #332640
by PaceOnline
Error Installing new CB Subs was created by PaceOnline
Hi guys I get the following error when I try to install CB Subs
System Information
Joomla: 4.2.6
PHP: 8.0.27
Database: mysql 10.3.37-MariaDB
Package
File: 000_cbplug_CBSubs_MAIN-4.6.1+build.2023.01.18.18.35.11.074602ba8.zip
Log:
System Information
Joomla: 4.2.6
PHP: 8.0.27
Database: mysql 10.3.37-MariaDB
Package
File: 000_cbplug_CBSubs_MAIN-4.6.1+build.2023.01.18.18.35.11.074602ba8.zip
Log:
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68491
- Thanks: 9079
- Karma: 1434
1 year 2 months ago #332643
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Error Installing new CB Subs
Enable debug mode and maximum error reporting then retry. See if it provides any further information. If none please check MySQL error log (contact host if unsure how) as would need to know what database table is erroring for you. Please also see the below topic with same issue as it's usually due to a collation problem in the database columns.
www.joomlapolis.com/forum/cb-paid-subscriptions-support/245361-solved-row-size-too-large-8126
www.joomlapolis.com/forum/cb-paid-subscriptions-support/245361-solved-row-size-too-large-8126
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- PaceOnline
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 2
- Karma: 0
1 year 2 months ago #332666
by PaceOnline
Replied by PaceOnline on topic Error Installing new CB Subs
I have gotten this:
System Information
Joomla: 4.2.6
PHP: 8.1.14
Database: mysql 10.3.37-MariaDB
Package
File: 000_cbplug_CBSubs_MAIN-4.6.1+build.2023.01.18.18.35.11.074602ba8.zip
Log:
I can't see how to export the debug information though. This is what I got from the mysql error log:
2023-01-31 12:30:10 7903714 [ERROR] InnoDB: Cannot add field `option_selection2` in table `demopivotal_erp`.`j6ox4_cbsubs_notifications` because after adding it, the row size is 8298 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
2023-01-31 16:21:56 7943737 [Warning] IP address '205.210.31.43' could not be resolved: Name or service not known
2023-01-31 21:31:55 7981706 [Warning] Hostname 'zg-1220i-84.stretchoid.com' does not resolve to '162.243.132.24'.
2023-01-31 21:31:55 7981706 [Note] Hostname 'zg-1220i-84.stretchoid.com' has the following IP addresses:
2023-01-31 21:31:55 7981706 [Note] - 127.0.0.1
2023-01-31 22:02:09 7985609 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2023-01-31 22:03:51 7985776 [Warning] Hostname 'zg-1220a-7.stretchoid.com' does not resolve to '107.170.247.5'.
2023-01-31 22:03:51 7985776 [Note] Hostname 'zg-1220a-7.stretchoid.com' has the following IP addresses:
2023-01-31 22:03:51 7985776 [Note] - 127.0.0.1
2023-02-01 0:28:48 8000354 [ERROR] InnoDB: Cannot add field `option_selection2` in table `demopivotal_erp`.`j6ox4_cbsubs_notifications` because after adding it, the row size is 8298 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
System Information
Joomla: 4.2.6
PHP: 8.1.14
Database: mysql 10.3.37-MariaDB
Package
File: 000_cbplug_CBSubs_MAIN-4.6.1+build.2023.01.18.18.35.11.074602ba8.zip
Log:
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
#0 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php(433): mysqli_stmt->execute()
#1 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php(675): Joomla\Database\Mysqli\MysqliStatement->execute()
#2 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(325): Joomla\Database\DatabaseDriver->execute()
#3 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(1813): CBLib\Database\Driver\CmsDatabaseDriver->query()
#4 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(1784): CBLib\Database\DatabaseUpgrade->doQuery('CREATE TABLE `#...')
#5 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(295): CBLib\Database\DatabaseUpgrade->createTable(Object(CBLib\Xml\SimpleXMLElement), 'cbpaidsubscript...')
#6 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(249): CBLib\Database\DatabaseUpgrade->checkXmlTableDescription(Object(CBLib\Xml\SimpleXMLElement), 'cbpaidsubscript...', true, true, NULL)
#7 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/CBLib/CB/Legacy/cbInstallerPlugin.php(379): CBLib\Database\DatabaseUpgrade->checkXmlDatabaseDescription(Object(CBLib\Xml\SimpleXMLElement), 'cbpaidsubscript...', true, NULL, NULL)
#8 /mnt/volume_lon1_01/home/demopivotal/public_html/administrator/components/com_packageinstaller/admin.packageinstaller.php(391): cbInstallerPlugin->install()
#9 /mnt/volume_lon1_01/home/demopivotal/public_html/administrator/components/com_packageinstaller/admin.packageinstaller.php(145): packageinstallerInstall->installCBPlugin('000_cbplug_CBSu...', '/mnt/volume_lon...')
#10 /mnt/volume_lon1_01/home/demopivotal/public_html/administrator/components/com_packageinstaller/admin.packageinstaller.php(80): packageinstallerInstall->prepare()
#11 /mnt/volume_lon1_01/home/demopivotal/public_html/administrator/components/com_packageinstaller/packageinstaller.php(16): packageinstallerInstall->install()
#12 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/mnt/volume_lon...')
#13 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/mnt/volume_lon...')
#14 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/src/Component/ComponentHelper.php(355): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
#15 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_packageinst...')
#16 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#17 /mnt/volume_lon1_01/home/demopivotal/public_html/libraries/src/Application/CMSApplication.php(294): Joomla\CMS\Application\AdministratorApplication->doExecute()
#18 /mnt/volume_lon1_01/home/demopivotal/public_html/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#19 /mnt/volume_lon1_01/home/demopivotal/public_html/administrator/index.php(32): require_once('/mnt/volume_lon...')
#20 {main}I can't see how to export the debug information though. This is what I got from the mysql error log:
2023-01-31 12:30:10 7903714 [ERROR] InnoDB: Cannot add field `option_selection2` in table `demopivotal_erp`.`j6ox4_cbsubs_notifications` because after adding it, the row size is 8298 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
2023-01-31 16:21:56 7943737 [Warning] IP address '205.210.31.43' could not be resolved: Name or service not known
2023-01-31 21:31:55 7981706 [Warning] Hostname 'zg-1220i-84.stretchoid.com' does not resolve to '162.243.132.24'.
2023-01-31 21:31:55 7981706 [Note] Hostname 'zg-1220i-84.stretchoid.com' has the following IP addresses:
2023-01-31 21:31:55 7981706 [Note] - 127.0.0.1
2023-01-31 22:02:09 7985609 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
2023-01-31 22:03:51 7985776 [Warning] Hostname 'zg-1220a-7.stretchoid.com' does not resolve to '107.170.247.5'.
2023-01-31 22:03:51 7985776 [Note] Hostname 'zg-1220a-7.stretchoid.com' has the following IP addresses:
2023-01-31 22:03:51 7985776 [Note] - 127.0.0.1
2023-02-01 0:28:48 8000354 [ERROR] InnoDB: Cannot add field `option_selection2` in table `demopivotal_erp`.`j6ox4_cbsubs_notifications` because after adding it, the row size is 8298 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68491
- Thanks: 9079
- Karma: 1434
1 year 2 months ago #332667
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Error Installing new CB Subs
Probably same issue as the topic provided. Your database collation likely isn't set correctly. Within your database using phpmyadmin navigate to _cbsubs_notifications table. Next under the Operations tab find the "Table options" section. Next set "Collation" to utf8mb4_unicode_ci then click the checkbox for "Change all column collations" then click Go to try and fix the collation.
Additionally we aren't using the column it's trying to create so am working on a new release that is removing some unnecessary database columns.
forge.joomlapolis.com/issues/9120
Additionally we aren't using the column it's trying to create so am working on a new release that is removing some unnecessary database columns.
forge.joomlapolis.com/issues/9120
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68491
- Thanks: 9079
- Karma: 1434
1 year 2 months ago #332669
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Error Installing new CB Subs
A new CBSubs build release is now available that removes several unused database columns. That should reduce the row size substantially, but you'll likely still want to apply the collation fix.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- PaceOnline
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 2
- Karma: 0
1 year 2 months ago #332676
by PaceOnline
Replied by PaceOnline on topic Error Installing new CB Subs
So I tried applying the fix and the table
_cbsubs_notifications is never created on my system, I assume because it is a new site. I tried creating it that also failed. I tried the new package (thank you) that also failed so now I am stuck.
"2023-02-02 5:17:59 8177662 [ERROR] InnoDB: Cannot add field `auth_status` in table `demopivotal_erp`.`j6ox4_cbsubs_notifications` because after adding it, the row size is 8305 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page."
This is the latest error.Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.218 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- Error Installing new CB Subs