Be sure to checkout our newest add-on Reading Time Pro!

Compatibility updates:

  • Publisher is EE5 compatible, but it does not currently support the Fluid field (it's in the works).

Ticket: Preview template empty after submitting entry for first time

Status Resolved
Add-on / Version Bloqs 2.7.3
Severity
EE Version 3.5.14

Kees Internetbureau

Dec 03, 2018

On some pages I get the error seen in the image.

Here’s the stack trace:

Exception Caught
SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'L0':
SELECT DISTINCT L0.field_id as L0_field, L0.grid_field_id as L0_grid_field_id, L0.grid_col_id as L0_grid_col_id, L0.grid_row_id as L0_grid_row_id, L0.parent_id AS L0_parent, L0.child_id as L0_id, L0.order, L0.field_id as L0_field, L0.grid_field_id as L0_grid_field_id, L0.grid_col_id as L0_grid_col_id, L0.grid_row_id as L0_grid_row_id, L0.child_id AS L0_parent, L0.parent_id as L0_id, L0.order FROM (`exp_relationships` as L0, `exp_relationships` as L0) LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL LEFT JOIN `exp_relationships` as L1 ON `L0`.`parent_id` = `L1`.`parent_id` WHERE `L0`.`fluid_field_data_id` = 0 AND `L0`.`grid_field_id` = 0 AND `L0`.`parent_id` IN (531, 528, 523, 515, 508, 504, 500, 498, 494, 492, 490, 488, 486, 484, 474, 424, 420, 402, 401, 400, 399, 397, 396, 386, 381, 380, 379, 376, 375, 374, 362, 361, 353, 350, 347, 344, 341, 337, 326, 301, 300, 299, 297, 296, 290, 289, 287, 286, 279, 277, 276, 273, 272, 271, 270, 269, 268, 263, 262, 261, 237, 236, 229, 220, 214, 213, 211, 209, 207, 206, 205, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 192, 191, 189, 188, 187, 186, 185, 184, 183, 182, 181, 180, 179, 178, 177, 176, 175, 174, 173, 172, 171, 170, 169, 168, 167, 166, 165, 164, 162, 161, 160, 159, 158, 157, 156, 155, 154, 153, 152, 144, 143, 142, 141, 140, 139, 138, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 114, 113, 112, 89, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 33, 32, 31) AND `L0`.`child_id` IN (531, 528, 523, 515, 508, 504, 500, 498, 494, 492, 490, 488, 486, 484, 474, 424, 420, 402, 401, 400, 399, 397, 396, 386, 381, 380, 379, 376, 375, 374, 362, 361, 353, 350, 347, 344, 341, 337, 326, 301, 300, 299, 297, 296, 290, 289, 287, 286, 279, 277, 276, 273, 272, 271, 270, 269, 268, 263, 262, 261, 237, 236, 229, 220, 214, 213, 211, 209, 207, 206, 205, 204, 203, 202, 201, 200, 199, 198, 197, 196, 195, 194, 193, 192, 191, 189, 188, 187, 186, 185, 184, 183, 182, 181, 180, 179, 178, 177, 176, 175, 174, 173, 172, 171, 170, 169, 168, 167, 166, 165, 164, 162, 161, 160, 159, 158, 157, 156, 155, 154, 153, 152, 144, 143, 142, 141, 140, 139, 138, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 115, 114, 113, 112, 89, 69, 68, 67, 66, 65, 64, 63, 62, 61, 60, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 33, 32, 31) ORDER BY `L0`.`order` asc, `L0`.`order` asc
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117

Stack Trace: Please include when reporting this error
#0 webmanager\ee\legacy\database\drivers\mysqli\mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT DISTINCT…')
#1 webmanager\ee\legacy\database\DB_driver.php(270): CI_DB_mysqli_driver->_execute('SELECT DISTINCT…')
#2 webmanager\ee\legacy\database\DB_driver.php(180): CI_DB_driver->simple_query('SELECT DISTINCT…')
#3 webmanager\user\addons\bloqs\ext.bloqs.php(131): CI_DB_driver->query('SELECT DISTINCT…')
#4 webmanager\ee\legacy\libraries\Extensions.php(222): Bloqs_ext->relationships_query('parents', Array, Array, 'SELECT DISTINCT…')
#5 webmanager\ee\legacy\libraries\Extensions.php(117): EE_Extensions->call_class('Bloqs_ext', 'relationships_q…', Array, Array)
#6 webmanager\ee\legacy\models\relationship_model.php(184): EE_Extensions->call('relationships_q…', 'parents', Array, Array, 'SELECT DISTINCT…')
#7 webmanager\ee\legacy\models\relationship_model.php(39): Relationship_model->_run_node_query(Object(QueryNode), Array, NULL, NULL)
#8 webmanager\ee\legacy\libraries\relationship_parser\Tree_builder.php(131): Relationship_model->node_query(Object(QueryNode), Array, NULL, NULL)
#9 webmanager\ee\legacy\libraries\Relationships_parser.php(120): EE_relationship_tree_builder->build_tree(Array, '\n ...')
#10 webmanager\ee\legacy\libraries\channel_entries_parser\components\Relationship.php(69): EE_Relationships_parser->create(Array, Array)
#11 webmanager\ee\legacy\libraries\channel_entries_parser\Preparser.php(104): EE_Channel_relationship_parser->pre_process('\n ...', Object(EE_Channel_preparser))
#12 webmanager\ee\legacy\libraries\Channel_entries_parser.php(203): EE_Channel_preparser->__construct(Object(Channel), Object(EE_Channel_parser), Array, Array, Array)
#13 webmanager\ee\legacy\libraries\Channel_entries_parser.php(169): EE_Channel_parser->pre_parser(Object(Channel), Array, Array, Array)
#14 webmanager\ee\EllisLab\Addons\channel\mod.channel.php(2847): EE_Channel_parser->parse(Object(Channel), Array, Array)
#15 webmanager\ee\EllisLab\Addons\channel\mod.channel.php(290): Channel->parse_channel_entries()
#16 webmanager\ee\legacy\libraries\Template.php(1845): Channel->entries()
#17 webmanager\ee\legacy\libraries\Template.php(1694): EE_Template->process_tags()
#18 webmanager\ee\legacy\libraries\Template.php(1480): EE_Template->process_tags()
#19 webmanager\ee\legacy\libraries\Template.php(576): EE_Template->tags()
#20 webmanager\ee\legacy\libraries\Template.php(232): EE_Template->parse('{!-- ra:0000000…', false, 1, false)
#21 webmanager\ee\legacy\libraries\Template.php(165): EE_Template->fetch_and_parse('', Array, false)
#22 webmanager\ee\legacy\libraries\Core.php(661): EE_Template->run_template_engine('', '')
#23 webmanager\ee\legacy\controllers\ee.php(63): EE_Core->generate_page()
#24 [internal function]: EE->index('interest')
#25 webmanager\ee\EllisLab\ExpressionEngine\Core\Core.php(241): call_user_func_array(Array, Array)
#26 webmanager\ee\EllisLab\ExpressionEngine\Core\Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#27 webmanager\ee\EllisLab\ExpressionEngine\Boot\boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#28 public_html\index.php(177): require_once('D:\\Projecten\\eu…')
#28 public_html\index.php(177): require_once('D:\\Projecten\\eu…')
#1

BoldMinded (Brian)

Dec 03, 2018

Looks like you need to upgrade Bloqs. 2.7.3 is very very old.

#2

BoldMinded (Brian)

Dec 03, 2018

Actually looks like you’re running into this error. https://boldminded.com/support/ticket/1881

See the comment either the core EE fix. You’ll need to edit EE until the next release.

#3

BoldMinded (Brian)

Dec 03, 2018

If the version numbers you mentioned are correct then you’ll need to upgrade Bloqs, and make that core change to EE. I recommend upgrading to EE 5 if you can (you will still need to make that change).

Login to reply

Contact

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.