Publisher is EE6 compatible, but it does not support the Fluid field.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Error When Trying To Access Bloqs Settings and Edit Pages Containing Bloqs

Status Open
Add-on / Version Bloqs 4.9.0
Severity
EE Version 6.0.6

Michael Coogan

6 days ago

I updated from EE 3.5.4 and Bloqs 3.1.0.

Error when trying to access settings:

Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'c.componentdefinition_id' in 'field list':
SELECT DISTINCT c.blockdefinition_id as 'bd_id', c.componentdefinition_id as 'c_id' FROM exp_blocks_components AS c JOIN exp_blocks_blockdefinition AS bd ON bd.id = c.componentdefinition_id AND bd.id != c.blockdefinition_id

ee/legacy/database/drivers/mysqli/mysqli_connection.php:114
Stack Trace: Please include when reporting this error

    #0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT DISTINCT…')
    #1 ee/legacy/database/DB_driver.php(260): CI_DB_mysqli_driver->_execute('SELECT DISTINCT…')
    #2 ee/legacy/database/DB_driver.php(175): CI_DB_driver->simple_query('SELECT DISTINCT…')
    #3 user/addons/bloqs/Database/Adapter.php(1679): CI_DB_driver->query('SELECT DISTINCT…')
    #4 user/addons/bloqs/Database/Adapter.php(682): BoldMinded\Bloqs\Database\Adapter->query('SELECT DISTINCT…')
    #5 user/addons/bloqs/mcp.bloqs.php(194): BoldMinded\Bloqs\Database\Adapter->getBlocksUsedInComponents()
    #6 [internal function]: Bloqs_mcp->index()
    #7 ee/ExpressionEngine/Controller/Addons/Addons.php(1397): call_user_func_array(Array, Array)
    #8 ee/ExpressionEngine/Controller/Addons/Addons.php(701): ExpressionEngine\Controller\Addons\Addons->getModuleSettings('bloqs', 'index', Array)
    #9 [internal function]: ExpressionEngine\Controller\Addons\Addons->settings('bloqs')
    #10 ee/ExpressionEngine/Core/Core.php(251): call_user_func_array(Array, Array)
    #11 ee/ExpressionEngine/Core/Core.php(111): ExpressionEngine\Core\Core->runController(Array)
    #12 ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
    #13 public_html/manage.php(144): require_once('...')
    #13 public_html/manage.php(144): require_once('...')

Error when trying to edit pages with bloqs:

Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.componentdefinition_id' in 'field list':
SELECT bd.id as bd_id, bd.group_id as bd_group_id, bd.shortname as bd_shortname, bd.name as bd_name, bd.instructions as bd_instructions, bd.deprecated as bd_deprecated, bd.deprecated_note as bd_deprecated_note, bd.preview_image as bd_preview_image, bd.preview_icon as bd_preview_icon, bd.settings as bd_settings, bd.is_component as bd_is_component, bd.is_editable as bd_is_editable, b.id as b_id, b.order as b_order, b.parent_id as b_parent_id, b.depth as b_depth, b.lft as b_lft, b.rgt as b_rgt, b.componentdefinition_id as b_componentdefinition_id, ad.id as ad_id, ad.shortname as ad_shortname, ad.name as ad_name, ad.instructions as ad_instructions, ad.order as ad_order, ad.type as ad_type, ad.settings as ad_settings, a.id as a_id FROM exp_blocks_components b LEFT JOIN exp_blocks_blockdefinition bd ON b.blockdefinition_id = bd.id LEFT JOIN exp_blocks_atomdefinition ad ON ad.blockdefinition_id = bd.id LEFT JOIN exp_blocks_atom a ON a.block_id = b.id AND a.atomdefinition_id = ad.id LEFT JOIN exp_blocks_blockgroup bg ON bd.group_id = bg.id WHERE b.componentdefinition_id = 2 ORDER BY b.order, ad.order

ee/legacy/database/drivers/mysqli/mysqli_connection.php:114
Stack Trace: Please include when reporting this error

    #0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT\n bd.i…')
    #1 ee/legacy/database/DB_driver.php(260): CI_DB_mysqli_driver->_execute('SELECT\n bd.i…')
    #2 ee/legacy/database/DB_driver.php(175): CI_DB_driver->simple_query('SELECT\n bd.i…')
    #3 user/addons/bloqs/Database/Adapter.php(1679): CI_DB_driver->query('SELECT\n bd.i…')
    #4 user/addons/bloqs/Database/Adapter.php(1593): BoldMinded\Bloqs\Database\Adapter->query('SELECT\n bd.i…', Array)
    #5 user/addons/bloqs/Database/Adapter.php(161): BoldMinded\Bloqs\Database\Adapter->getBlocksInComponent(2)
    #6 user/addons/bloqs/ft.bloqs.php(290): BoldMinded\Bloqs\Database\Adapter->getBlocks(182, 36)
    #7 ee/legacy/fieldtypes/EE_Fieldtype.php(320): Bloqs_ft->display_field(' ')
    #8 ee/legacy/libraries/api/Api_channel_fields.php(377): EE_Fieldtype->display_publish_field(' ')
    #9 ee/ExpressionEngine/Model/Content/FieldFacade.php(250): Api_channel_fields->apply('display_publish…', Array)
    #10 ee/ExpressionEngine/Model/Content/Display/FieldDisplay.php(70): ExpressionEngine\Model\Content\FieldFacade->getForm()
    #11 ee/ExpressionEngine/View/publish/partials/publish_form.php(83): ExpressionEngine\Model\Content\Display\FieldDisplay->getForm()
    #12 ee/ExpressionEngine/Service/View/View.php(137): include('...')
    #13 ee/ExpressionEngine/Service/View/View.php(106): ExpressionEngine\Service\View\View->parse('...', Array)
    #14 ee/ExpressionEngine/Service/View/View.php(165): ExpressionEngine\Service\View\View->render(Array)
    #15 ee/ExpressionEngine/View/publish/entry.php(5): ExpressionEngine\Service\View\View->embed(Object(ExpressionEngine\Service\View\View))
    #16 ee/ExpressionEngine/Service/View/View.php(137): include('...')
    #17 ee/ExpressionEngine/Service/View/View.php(106): ExpressionEngine\Service\View\View->parse('...', Array)
    #18 ee/legacy/libraries/View.php(40): ExpressionEngine\Service\View\View->render(Array)
    #19 ee/legacy/libraries/Cp.php(319): View->render('publish/entry', Array, false)
    #20 ee/ExpressionEngine/Controller/Publish/Edit.php(530): Cp->render('publish/entry', Array)
    #21 [internal function]: ExpressionEngine\Controller\Publish\Edit->entry('182')
    #22 ee/ExpressionEngine/Core/Core.php(251): call_user_func_array(Array, Array)
    #23 ee/ExpressionEngine/Core/Core.php(111): ExpressionEngine\Core\Core->runController(Array)
    #24 ee/ExpressionEngine/Boot/boot.php(161): ExpressionEngine\Core\Core->run(Object(ExpressionEngine\Core\Request))
    #25 public_html/manage.php(144): require_once('...')
    #25 public_html/manage.php(144): require_once('...')
#1

BoldMinded (Brian)

6 days ago

Hi Michael. If you’re using 4.9 this should have been fixed. Are you sure the upgrade process completed without error?

#2

BoldMinded (Brian)

6 days ago

And the old Bloqs addon folder is not renamed to bloqs_backup or anything? All the files from 4.9 replaced the old version?

#3

Jelle Dijkstra

6 days ago

Hi Brian, I’m experiencing the same issue on my EE 5.4.2 install

#4

BoldMinded (Brian)

6 days ago

Jelle, can you provide the stack trace you’re receiving? Are you on 5.4.2 and upgrading EE? What version of Bloqs do you currently have and I assume you’re trying to upgrade to 4.9?

#5

BoldMinded (Brian)

6 days ago

If you’re getting this error it indicates to me that the 4.8 upgrade process didn’t execute successfully. Did either of you encounter issues when upgrading?

#6

Jelle Dijkstra

6 days ago

Hi Brian,
I’ve got a site that i’m preparing to go to EE6, which is on 5.4.2 at the moment. My bloqs version is currently 4.5.1.
My stack trace is the same as the one above. Happy to provide you with a fresh one (though i just rolled back everything 😉
I tried it a week or so ago with the bloqs 4.8.1 version, now with the 4.9.0 version it still happens
No other issues i’ve seen

#7

BoldMinded (Brian)

5 days ago

I fired up my EE 5 environment, rolled Bloqs back to version 4.5.0, ran an upgrade to 4.6.0, and then to 4.9.0, and it went fine, all the database tables updated successfully. 4.6.0 is where the tables it can’t find are introduced to the schema. I then rolled back to 4.5.0, and upgraded straight to 4.9.0 and it too upgraded successfully. I’m not sure under what conditions you two are running into in which the componentdefinition_id column is not present in the exp_blocks_block table. When 4.6.0 is installed it creates the templatedefinition_id column, which is renamed to componentdefinition_id in the 4.8.0 upgrade. When I was executing the upgrade I watched the column get created, and then renamed.

Run each of these queries on your database, and then paste the results here.

SHOW CREATE TABLE exp_blocks_atom;
SHOW CREATE TABLE exp_blocks_atomdefinition;
SHOW CREATE TABLE exp_blocks_block;
SHOW CREATE TABLE exp_blocks_blockdefinition;
SHOW CREATE TABLE exp_blocks_blockfieldusage;
SHOW CREATE TABLE exp_blocks_blockgroup;
SHOW CREATE TABLE exp_blocks_components;

Each query will result in something like this:

CREATE TABLE `exp_blocks_components` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `blockdefinition_id` bigint(20) NOT NULL,
  `componentdefinition_id` int(11) NOT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `depth` int(11) NOT NULL DEFAULT 0,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
#8

Jelle Dijkstra

5 days ago

I’m not much of an sql wizzard, so when i ran the queries i got success messages such as this

exp_blocks_atom
CREATE TABLE `exp_blocks_atom` (
`id` bigint(20)...

seems like the tables are created properly this way

#9

BoldMinded (Brian)

5 days ago

The tables are already there, those queries don’t create anything, they just show the syntax used if you were to create the tables based off their current schema, so the full output will tell me what the schema is for your tables right now, and if they are correct.

Run each query one at a time, and it looks like you copied the abbreviated output… I’ll need the entire output for each.

#10

Dave de Bruin

5 days ago

Comment has been marked private.

#11

BoldMinded (Brian)

5 days ago

And you’re 100% sure you clicked the run update button for Bloqs? And Bloqs is now displaying as version 4.9.0 on the add-ons page?

#12

Jelle Dijkstra

5 days ago

exp_blocks_atom CREATE TABLE `exp_blocks_atom` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `block_id` bigint(20) NOT NULL, `atomdefinition_id` bigint(20) NOT NULL, `data` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_blocks_atom_blockid_atomdefinitionid` (`block_id`,`atomdefinition_id`), KEY `fk_blocks_atom_block` (`atomdefinition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3337 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_atomdefinition CREATE TABLE `exp_blocks_atomdefinition` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `blockdefinition_id` bigint(20) NOT NULL, `shortname` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `instructions` text COLLATE utf8mb4_unicode_ci NOT NULL, `order` int(11) NOT NULL, `type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_blocks_atomdefinition_blockdefinition` (`blockdefinition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_block CREATE TABLE `exp_blocks_block` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `blockdefinition_id` bigint(20) NOT NULL, `entry_id` int(11) NOT NULL, `field_id` int(6) NOT NULL, `order` int(11) NOT NULL DEFAULT 0, `parent_id` int(11) DEFAULT 0, `draft` int(1) DEFAULT 0, `depth` int(11) DEFAULT 0, `lft` int(11) DEFAULT 0, `rgt` int(11) DEFAULT 0, `componentdefinition_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `fk_blocks_blockdefinition_block` (`blockdefinition_id`), KEY `ix_blocks_block_siteid_entryid_fieldid` (`entry_id`,`field_id`) ) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_blockdefinition CREATE TABLE `exp_blocks_blockdefinition` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` int(10) DEFAULT 0, `shortname` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `instructions` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `preview_image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `preview_icon` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deprecated` int(1) NOT NULL DEFAULT 0, `deprecated_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_hidden` int(1) NOT NULL DEFAULT 0, `is_editable` int(1) NOT NULL DEFAULT 0, `is_component` int(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_blockfieldusage CREATE TABLE `exp_blocks_blockfieldusage` ( `id` int(20) NOT NULL AUTO_INCREMENT, `field_id` int(6) NOT NULL, `blockdefinition_id` bigint(20) NOT NULL, `order` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_blocks_blockfieldusage_fieldid_blockdefinitionid` (`field_id`,`blockdefinition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_blockgroup CREATE TABLE `exp_blocks_blockgroup` ( `id` int(20) NOT NULL AUTO_INCREMENT, `order` int(11) NOT NULL DEFAULT 0, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_components CREATE TABLE `exp_blocks_components` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `blockdefinition_id` bigint(20) NOT NULL, `componentdefinition_id` int(11) NOT NULL, `order` int(11) NOT NULL DEFAULT 0, `parent_id` int(11) NOT NULL DEFAULT 0, `depth` int(11) NOT NULL DEFAULT 0, `lft` int(11) NOT NULL DEFAULT 0, `rgt` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

 

#13

Jelle Dijkstra

5 days ago

oh hang on! that was not the right site! Doing 3 at once so got a bit confused

#14

Dave de Bruin

5 days ago

Yes, Im sure, the tab next installed said Update, I proceded from there.

#15

Jelle Dijkstra

5 days ago

exp_blocks_atom CREATE TABLE `exp_blocks_atom` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `block_id` bigint(20) NOT NULL, `atomdefinition_id` bigint(20) NOT NULL, `data` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `uk_blocks_atom_blockid_atomdefinitionid` (`block_id`,`atomdefinition_id`), KEY `fk_blocks_atom_block` (`atomdefinition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=37747 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_atomdefinition CREATE TABLE `exp_blocks_atomdefinition` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `blockdefinition_id` bigint(20) NOT NULL, `shortname` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `instructions` text COLLATE utf8mb4_unicode_ci NOT NULL, `order` int(11) NOT NULL, `type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `settings` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `fk_blocks_atomdefinition_blockdefinition` (`blockdefinition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_block CREATE TABLE `exp_blocks_block` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `blockdefinition_id` bigint(20) NOT NULL, `entry_id` int(11) NOT NULL, `field_id` int(6) NOT NULL, `order` int(11) NOT NULL DEFAULT '0', `parent_id` int(11) DEFAULT '0', `draft` int(1) DEFAULT '0', `depth` int(11) DEFAULT '0', `lft` int(11) DEFAULT '0', `rgt` int(11) DEFAULT '0', `componentdefinition_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `fk_blocks_blockdefinition_block` (`blockdefinition_id`), KEY `ix_blocks_block_siteid_entryid_fieldid` (`entry_id`,`field_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1044 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_blockdefinition CREATE TABLE `exp_blocks_blockdefinition` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `group_id` int(10) DEFAULT '0', `shortname` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `instructions` text COLLATE utf8mb4_unicode_ci, `settings` text COLLATE utf8mb4_unicode_ci, `preview_image` text COLLATE utf8mb4_unicode_ci, `preview_icon` text COLLATE utf8mb4_unicode_ci, `deprecated` int(1) NOT NULL DEFAULT '0', `deprecated_note` text COLLATE utf8mb4_unicode_ci, `is_editable` int(1) NOT NULL DEFAULT '0', `is_component` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_blockfieldusage CREATE TABLE `exp_blocks_blockfieldusage` ( `id` int(20) NOT NULL AUTO_INCREMENT, `field_id` int(6) NOT NULL, `blockdefinition_id` bigint(20) NOT NULL, `order` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_blocks_blockfieldusage_fieldid_blockdefinitionid` (`field_id`,`blockdefinition_id`), KEY `fk_blocks_blockfieldusage_blockdefinition` (`blockdefinition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=498 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_blockgroup CREATE TABLE `exp_blocks_blockgroup` ( `id` int(20) NOT NULL AUTO_INCREMENT, `order` int(11) NOT NULL DEFAULT '0', `name` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

exp_blocks_components CREATE TABLE `exp_blocks_components` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `blockdefinition_id` bigint(20) NOT NULL, `templatedefinition_id` int(11) NOT NULL, `order` int(11) NOT NULL DEFAULT '0', `parent_id` int(11) NOT NULL DEFAULT '0', `depth` int(11) NOT NULL DEFAULT '0', `lft` int(11) NOT NULL DEFAULT '0', `rgt` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

 

 

#16

Dave de Bruin

5 days ago

Yes, Im sure, the tab next installed said Update, I proceded from there.

#17

Dave de Bruin

5 days ago

I get the same results as Jelle when I run the queries your suggested

#18

BoldMinded (Brian)

5 days ago

What version of MySQL are you all running? This isn’t making any sense. I’ve upgraded my dev sites and a production site with the same update routine and they all worked. Based on your error messages, and the create tables queries in comment #15, the first query here did not work, but the other two did, and no error messages were thrown. This is the part I’m confused about. In the blocks_components table the templatedefinition_id column still exists, but it should have been renamed to componentdefinition_id. The following query which is identical, but on a different table worked fine, as well as the renaming of the table itself.

ee()->smartforge->modify_column('blocks_templates', [
            'templatedefinition_id' => [
                'name' => 'componentdefinition_id',
                'type' => 'int',
                'constraint' => '11',
                'null' => false,
            ],
        ]);

        ee()->smartforge->modify_column('blocks_block', [
            'templatedefinition_id' => [
                'name' => 'componentdefinition_id',
                'type' => 'int',
                'constraint' => '11',
                'null' => false,
            ]
        ]);

        // Now rename the table
        ee()->smartforge->rename_table('blocks_templates', 'blocks_components');
#19

BoldMinded (Brian)

5 days ago

Jelle, so the upgrade worked on one site but not another? In the first sql dump you shared the exp_blocks_components table does have the componentdefinition_id column name, but in the 2nd sql dump it does not. What is the difference between the 2 sites?

#20

Dave de Bruin

5 days ago

I’m on a 10.5.12-MariaDB

#21

Jelle Dijkstra

5 days ago

@brian the first dump is a new site that i started on EE6 with - i believe - 4.8.1
The second one is an update from a fresh build ast year, which is using 4.5.1
from what is see it’s
Server: Localhost via UNIX socket
Servertype: MySQL
Serververbinding: SSL wordt niet gebruikt Documentatie
Serverversie: 5.7.35 - MySQL Community Server (GPL)
Protocolversie: 10
Gebruiker: cpses_hewd6b8d44@localhost
Karakterset van server: cp1252 West European (latin1)
Webserver
cpsrvd 11.98.0.8
Cliëntversie van database: libmysql - 5.6.43
PHP-uitbreiding: mysqliDocumentatie curlDocumentatie mbstringDocumentatie
PHP-versie: 7.3.30

#22

Jelle Dijkstra

5 days ago

that’s what phpmyadmin says. phpinfo suggests php7.4.24

#23

BoldMinded (Brian)

4 days ago

Are any of you able to package up your site with a full sql dump of the database so that I can take a closer look at this locally? If so, just the necessary files to run the site (I don’t need any front-end assets), and a CP super admin login.

#24

Jelle Dijkstra

4 days ago

sent you an email!

#25

Dave de Bruin

4 days ago

Great! Keep me posted over here please.

#26

BoldMinded (Brian)

4 days ago

Jelle it looks like you just sent an sql dump. I’m going to need an entire site folder, EE and everything, so I can setup docker container and run it locally and step debug this.

#27

BoldMinded (Brian)

4 days ago

By “front-end assets” I meant images, css, and js files, but I do need the ee system folder, htaccess, index files etc.

#28

BoldMinded (Brian)

4 days ago

Just to re-iterate, if anyone can provide a copy of the site, I need it in the pre-upgraded state - older version of Bloqs prior to 4.6.

#29

Dave de Bruin

4 days ago

Hi Brian,

I sent you an e-mail with a link from Dropbox for the files and DB an login.

#30

BoldMinded (Brian)

4 days ago

Got it, thanks!

#31

Jelle Dijkstra

4 days ago

Comment has been marked private.

#32

BoldMinded (Brian)

4 days ago

Dave, there are a lot of missing files… the config/constants.php, Boot/boot.common.php… Getting lots of errors so I can’t run the site.

#33

BoldMinded (Brian)

4 days ago

Jelle, what is a user/pass I can use to login to the CP?

#34

Dave de Bruin

4 days ago

Maybe Dropbox was still synchronizing?

#35

Jelle Dijkstra

4 days ago

Comment has been marked private.

#36

Jelle Dijkstra

4 days ago

oh yeah the db is in the cache folder

#37

BoldMinded (Brian)

4 days ago

Emailing each of you a new build.

#38

BoldMinded (Brian)

4 days ago

Posted in the other ticket:

I think I know what the issue is and will have a fix today. Apparently EE’s database smart forge class caches the existing tables for the entire request, and since you’re updating from a specific version that does _not_ have the exp_blocks_template table yet, it is not in the cache, so when it tries to modify the column name it fails b/c it thinks the table does not exist.

(╯°□°)╯︵ ┻━┻

#39

BoldMinded (Brian)

4 days ago

Comment has been marked private.

#40

Dave de Bruin

19 hours ago

Hi Brian,

Thanks for the update, It worked for me.

Best Dave

Login to reply