cBB Blockgets

Code: Select all

SQL ERROR [ mysqli ]

Table 'dbah3qvfgg1qov.soft_blockgets_blocks' doesn't exist [1146]

SQL

INSERT INTO soft_blockgets_blocks (block_title, block_content, block_alias, block_icon, block_order, block_position, block_page, block_groups, bbcode_bitfield, bbcode_uid) VALUES ('Menu', 'a:1:{s:4:\"list\";a:8:{i:0;a:7:{s:5:\"title\";s:4:\"Main\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:5:\"image\";s:0:\"\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";s:4:\"type\";i:0;}i:1;a:7:{s:5:\"title\";s:6:\"Portal\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:6:\"portal\";s:5:\"image\";s:7:\"fa-home\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";s:4:\"type\";i:1;}i:2;a:7:{s:5:\"title\";s:10:\"Index page\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:9:\"index.php\";s:5:\"image\";s:13:\"fa-comments-o\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";s:4:\"type\";i:1;}i:3;a:7:{s:5:\"title\";s:3:\"FAQ\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:7:\"faq.php\";s:5:\"image\";s:18:\"fa-question-circle\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";s:4:\"type\";i:1;}i:4;a:7:{s:5:\"title\";s:6:\"Search\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:10:\"search.php\";s:5:\"image\";s:9:\"fa-search\";s:6:\"window\";i:0;s:6:\"groups\";s:7:\"2,4,5,7\";s:4:\"type\";i:1;}i:5;a:7:{s:5:\"title\";s:14:\"Administration\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:0:\"\";s:5:\"image\";s:0:\"\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"4,5\";s:4:\"type\";i:0;}i:6;a:7:{s:5:\"title\";s:16:\"Moderation Panel\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:7:\"mcp.php\";s:5:\"image\";s:8:\"fa-legal\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"4,5\";s:4:\"type\";i:1;}i:7;a:7:{s:5:\"title\";s:20:\"Administration Panel\";s:11:\"description\";s:0:\"\";s:3:\"url\";s:13:\"adm/index.php\";s:5:\"image\";s:7:\"fa-cogs\";s:6:\"window\";i:0;s:6:\"groups\";s:1:\"5\";s:4:\"type\";i:1;}}}', 'menu_block', 'fa-home', 1, 1, 1, 'all', '', ''), ('Clock', 'tri_amber.swf', 'clock_block', 'fa-clock-o', 2, 1, 1, 'all', '', ''), ('Link Us', 'a:1:{s:10:\"banner_url\";s:28:\"./banners/canidev-banner.png\";}', 'link_us_block', 'fa-link', 3, 1, 1, 'all', '', ''), ('Welcome', 'a:2:{s:10:\"guest_text\";s:398:\"[html]<div style="text-align:center; font-size:1.2em;"><a href="https://www.canidev.com"><span class="blg-image logo-img"></span></a><br /><strong><i>Forum equipped with cBB Blockgets</i><br /><br />Welcome to our forum!<br />Register to access all the content!.</strong></div>[/html]\";s:11:\"member_text\";s:367:\"[html]<div style="text-align:center; font-size:1.2em;"><a href="https://www.canidev.com"><span class="blg-image logo-img"></span></a><br /><strong><i>Forum equipped with cBB Blockgets</i><br /><br />Welcome back to our forum {S_USERNAME}</strong></div>[/html]\";}', 'welcome_block', 'fa-flag', 1, 2, 1, 'all', '', ''), ('Dock menu', 'a:2:{s:10:\"item_width\";i:40;s:4:\"list\";a:4:{i:0;a:5:{s:5:\"title\";s:6:\"Portal\";s:3:\"url\";s:6:\"portal\";s:5:\"image\";s:16:\"./icons/home.png\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";}i:1;a:5:{s:5:\"title\";s:10:\"Index page\";s:3:\"url\";s:9:\"index.php\";s:5:\"image\";s:21:\"./icons/documents.png\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";}i:2;a:5:{s:5:\"title\";s:3:\"FAQ\";s:3:\"url\";s:7:\"faq.php\";s:5:\"image\";s:17:\"./icons/float.png\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";}i:3;a:5:{s:5:\"title\";s:6:\"Search\";s:3:\"url\";s:10:\"search.php\";s:5:\"image\";s:15:\"./icons/box.png\";s:6:\"window\";i:0;s:6:\"groups\";s:3:\"all\";}}}', 'dockmenu_block', 'fa-globe', 2, 2, 1, 'all', '', ''), ('Recent Topics', 'a:3:{s:11:\"topic_limit\";i:5;s:11:\"title_limit\";i:50;s:6:\"forums\";a:0:{}}', 'recent_topics_block', 'fa-comment', 3, 2, 1, 'all', '', ''), ('Who\'s online', 'a:2:{s:8:\"advanced\";i:1;s:9:\"usernames\";i:1;}', 'whos_online_block', 'fa-user', 4, 2, 1, 'all', '', ''), ('Login', 'a:2:{s:10:\"full_login\";i:1;s:13:\"show_register\";i:1;}', 'login_block', 'fa-user', 1, 3, 1, 'all', '', ''), ('Statistics', 'a:2:{s:12:\"stats_inline\";i:0;s:10:\"user_stats\";i:1;}', 'stats_block', 'fa-bar-chart', 2, 3, 1, 'all', '', ''), ('FORUM', '', 'forum_content', '', 1, 2, 2, 'all', '', ''), ('Most Posters', 'a:2:{s:12:\"poster_limit\";i:5;s:12:\"poster_range\";s:4:\"none\";}', 'most_poster_block', 'fa-edit', 1, 3, 2, 'all', '', '')

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1028
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 202
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 690
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 401
CALL: phpbb\db\driver\driver->sql_multi_insert()

FILE: [ROOT]/ext/canidev/blockgets/migrations/v200.php
LINE: 443
CALL: phpbb\db\driver\factory->sql_multi_insert()

FILE: (not given by php)
LINE: (not given by php)
CALL: canidev\blockgets\migrations\v200->add_table_data()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 715
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 662
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 437
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/ext/canidev/blockgets/ext.php
LINE: 72
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 231
CALL: canidev\blockgets\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

[IvanPF]

It appears that the phpBB installer has failed and has not inserted all tables into the database.
If the extension is listed in the ACP, please uninstall it and try again.

Hi，I reinstalled it and it still gives me an error

[IvanPF]

The installation process can fail for many reasons beyond its control. If you have access to the error log, see if anything appears at the time of installation.

Have you completely uninstalled it, disabling and erasing data?
Do you have access to the database to see which tables are created? If so, check if the blockgets tables are there.

Yes, after I deleted the table containing blockgets from MYSQL again, and reinstalled it, it still reported an error

[IvanPF]

You may be having problems with leftovers from the incomplete installation. I can tell you the steps to clean it up directly in the database.
I also attach the queries to do it more quickly.

First, backup the database and uninstall the extension in ACP

Some of the records may not exist, this is to make sure everything is clean.

In table soft_config remove all entries with "config_name" starts with "blg_"

Code: Select all

DELETE FROM soft_config WHERE config_name LIKE 'blg_%';

In table soft_ext remove entry with "ext_name" equal to "canidev/blockgets"

Code: Select all

DELETE FROM soft_ext WHERE ext_name = 'canidev/blockgets';

In table soft_migrations remove all entries with "migration_name" starts with "\canidev\blockgets\"
This is the most important thing, the records in this table directly influence the installation.

Code: Select all

DELETE FROM soft_migrations WHERE migration_name LIKE '\\\\canidev\\\\blockgets%'

Remove all extensions tables
soft_blockgets_blocks, soft_blockgets_data, soft_blockgets_pages

Code: Select all

DROP TABLE `soft_blockgets_blocks`;
DROP TABLE `soft_blockgets_data`;
DROP TABLE `soft_blockgets_pages`;

Clear the cache in ACP and reinstall.

Hi,

Remove all extensions tables

The error returned when I execute the SQL

#1051 - Unknown table 'dbah3qvfgg1qov.soft_blockgets_blocks'

ACP:
Something went wrong during the request and an exception was thrown. The changes made before the error occurred were reversed to the best of our abilities, but you should check the board for errors.

A module already exists: ACP_BLOCKGETS

Even if I delete the module inside the system and activate it again, I still get the same problem!

I solved it.