EE4 compatibility updates:

  • Publisher is EE4 and EE5 compatible, but it does not currently support the Fluid field.
  • Reel is EE4 and EE5 compatible, but it does not currently support the Fluid field.

Ticket: Preview template empty after submitting entry for first time

Status Client Wait
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 violation1066 Not unique table/alias'L0':
SELECT DISTINCT L0.field_id as L0_fieldL0.grid_field_id as L0_grid_field_idL0.grid_col_id as L0_grid_col_idL0.grid_row_id as L0_grid_row_idL0.parent_id AS L0_parentL0.child_id as L0_idL0.orderL0.field_id as L0_fieldL0.grid_field_id as L0_grid_field_idL0.grid_col_id as L0_grid_col_idL0.grid_row_id as L0_grid_row_idL0.child_id AS L0_parentL0.parent_id as L0_idL0.order FROM (`exp_relationships` as L0, `exp_relationships` as L0LEFT 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_idWHERE `L0`.`fluid_field_data_id` = AND `L0`.`grid_field_id` = AND `L0`.`parent_idIN (531528523515508504500498494492490488486484474424420402401400399397396386381380379376375374362361353350347344341337326301300299297296290289287286279277276273272271270269268263262261237236229220214213211209207206205204203202201200199198197196195194193192191189188187186185184183182181180179178177176175174173172171170169168167166165164162161160159158157156155154153152144143142141140139138137136135134133132131130129128127126125124123122121120119118117116115114113112896968676665646362616050494847464544434241403938373635333231) AND `L0`.`child_idIN (531528523515508504500498494492490488486484474424420402401400399397396386381380379376375374362361353350347344341337326301300299297296290289287286279277276273272271270269268263262261237236229220214213211209207206205204203202201200199198197196195194193192191189188187186185184183182181180179178177176175174173172171170169168167166165164162161160159158157156155154153152144143142141140139138137136135134133132131130129128127126125124123122121120119118117116115114113112896968676665646362616050494847464544434241403938373635333231ORDER BY `L0`.`orderasc, `L0`.`orderasc
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.