Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
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: 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, 2018On 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…')
BoldMinded (Brian)
Looks like you need to upgrade Bloqs. 2.7.3 is very very old.
BoldMinded (Brian)
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.
BoldMinded (Brian)
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).