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: Exception Caught on creating a Cartthrob Product Entry
Status | Resolved |
Add-on / Version | Publisher 3.1.5 |
Severity | |
EE Version | 5.3.1 |
pixi
Apr 20, 2020Hi,
Just bought and installed Cartthrob on my dev website with publisher installed.
When creating a an entry in the Store Product channel, I got this when trying to open it in the CP :
Exception Caught
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydb.exp_publisher_data_field_30' doesn't exist:
SELECT `t`.*, `exp_publisher_data_field_30`.`field_id_30` AS field_id_30, `exp_publisher_data_field_31`.`field_id_31` AS field_id_31, `exp_publisher_data_field_32`.`field_id_32` AS field_id_32, `exp_publisher_data_field_33`.`field_id_33` AS field_id_33, `exp_publisher_data_field_34`.`field_id_34` AS field_id_34, `exp_publisher_data_field_35`.`field_id_35` AS field_id_35, `exp_publisher_data_field_36`.`field_id_36` AS field_id_36, `exp_publisher_data_field_37`.`field_id_37` AS field_id_37, `exp_publisher_data_field_38`.`field_id_38` AS field_id_38, `exp_publisher_data_field_39`.`field_id_39` AS field_id_39, `exp_publisher_data_field_40`.`field_id_40` AS field_id_40, `exp_publisher_data_field_41`.`field_id_41` AS field_id_41, `exp_publisher_data_field_43`.`field_id_43` AS field_id_43, `exp_publisher_data_field_45`.`field_id_45` AS field_id_45, `exp_publisher_data_field_46`.`field_id_46` AS field_id_46 FROM (`exp_publisher_titles` AS t) JOIN `exp_channel_titles` AS ct ON `ct`.`entry_id` = `t`.`entry_id` JOIN `exp_channels` AS c ON `c`.`channel_id` = `t`.`channel_id` LEFT JOIN `exp_publisher_data_field_30` ON `t`.`entry_id` = `exp_publisher_data_field_30`.`entry_id` AND t.lang_id = exp_publisher_data_field_30.lang_id AND t.status = exp_publisher_data_field_30.status AND exp_publisher_data_field_30.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_31` ON `t`.`entry_id` = `exp_publisher_data_field_31`.`entry_id` AND t.lang_id = exp_publisher_data_field_31.lang_id AND t.status = exp_publisher_data_field_31.status AND exp_publisher_data_field_31.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_32` ON `t`.`entry_id` = `exp_publisher_data_field_32`.`entry_id` AND t.lang_id = exp_publisher_data_field_32.lang_id AND t.status = exp_publisher_data_field_32.status AND exp_publisher_data_field_32.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_33` ON `t`.`entry_id` = `exp_publisher_data_field_33`.`entry_id` AND t.lang_id = exp_publisher_data_field_33.lang_id AND t.status = exp_publisher_data_field_33.status AND exp_publisher_data_field_33.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_34` ON `t`.`entry_id` = `exp_publisher_data_field_34`.`entry_id` AND t.lang_id = exp_publisher_data_field_34.lang_id AND t.status = exp_publisher_data_field_34.status AND exp_publisher_data_field_34.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_35` ON `t`.`entry_id` = `exp_publisher_data_field_35`.`entry_id` AND t.lang_id = exp_publisher_data_field_35.lang_id AND t.status = exp_publisher_data_field_35.status AND exp_publisher_data_field_35.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_36` ON `t`.`entry_id` = `exp_publisher_data_field_36`.`entry_id` AND t.lang_id = exp_publisher_data_field_36.lang_id AND t.status = exp_publisher_data_field_36.status AND exp_publisher_data_field_36.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_37` ON `t`.`entry_id` = `exp_publisher_data_field_37`.`entry_id` AND t.lang_id = exp_publisher_data_field_37.lang_id AND t.status = exp_publisher_data_field_37.status AND exp_publisher_data_field_37.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_38` ON `t`.`entry_id` = `exp_publisher_data_field_38`.`entry_id` AND t.lang_id = exp_publisher_data_field_38.lang_id AND t.status = exp_publisher_data_field_38.status AND exp_publisher_data_field_38.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_39` ON `t`.`entry_id` = `exp_publisher_data_field_39`.`entry_id` AND t.lang_id = exp_publisher_data_field_39.lang_id AND t.status = exp_publisher_data_field_39.status AND exp_publisher_data_field_39.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_40` ON `t`.`entry_id` = `exp_publisher_data_field_40`.`entry_id` AND t.lang_id = exp_publisher_data_field_40.lang_id AND t.status = exp_publisher_data_field_40.status AND exp_publisher_data_field_40.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_41` ON `t`.`entry_id` = `exp_publisher_data_field_41`.`entry_id` AND t.lang_id = exp_publisher_data_field_41.lang_id AND t.status = exp_publisher_data_field_41.status AND exp_publisher_data_field_41.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_43` ON `t`.`entry_id` = `exp_publisher_data_field_43`.`entry_id` AND t.lang_id = exp_publisher_data_field_43.lang_id AND t.status = exp_publisher_data_field_43.status AND exp_publisher_data_field_43.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_45` ON `t`.`entry_id` = `exp_publisher_data_field_45`.`entry_id` AND t.lang_id = exp_publisher_data_field_45.lang_id AND t.status = exp_publisher_data_field_45.status AND exp_publisher_data_field_45.is_fluid = 0 LEFT JOIN `exp_publisher_data_field_46` ON `t`.`entry_id` = `exp_publisher_data_field_46`.`entry_id` AND t.lang_id = exp_publisher_data_field_46.lang_id AND t.status = exp_publisher_data_field_46.status AND exp_publisher_data_field_46.is_fluid = 0 WHERE `t`.`entry_id` IN (69) AND `t`.`lang_id` = 1 AND `t`.`status` = 'open'
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT `t`.*, `...')
#1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute('SELECT `t`.*, `...')
#2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query('SELECT `t`.*, `...')
#3 user/addons/publisher/Service/Entry/EntryQuery.php(231): CI_DB_driver->query('SELECT `t`.*, `...')
#4 user/addons/publisher/Service/Entry/Entry.php(181): BoldMinded\Publisher\Service\Entry\EntryQuery->getResultArray()
#5 user/addons/publisher/ext.publisher.php(1014): BoldMinded\Publisher\Service\Entry\Entry->find(69, 1, 'open')
#6 ee/legacy/libraries/Extensions.php(222): Publisher_ext->publish_form_entry_data(Array)
#7 ee/legacy/libraries/Extensions.php(117): EE_Extensions->call_class('Publisher_ext', 'publish_form_en…', Array, Array)
#8 ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(441): EE_Extensions->call('publish_form_en…', Array)
#9 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->entry('69')
#10 ee/EllisLab/ExpressionEngine/Core/Core.php(241): call_user_func_array(Array, Array)
#11 ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#12 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#13 adminme.php(153): require_once('...')
#13 adminme.php(153): require_once('...')
Can you help me to fix this conflict please?
Thank you in advance.
BoldMinded (Brian)
Apr 20, 2020
Did you check to see if the “exp_publisher_data_field_30” table exists in the database?
pixi
Apr 20, 2020
it doesn’t exist but I don’t know why.
No need to mention : I’m a poor debugger
BoldMinded (Brian)
Apr 20, 2020
Have you tried clearing all caches? For some reason Carthrob or Publisher seems to think that field exists.
What happens when you go to /admin.php?/cp/fields/edit/30
pixi
Apr 21, 2020
Yes I cleared the caches but that doesn’t do anything. It exists actually, it is a textarea field (product description) created by Cartthrob during the addon’s installation.
BoldMinded (Brian)
Apr 21, 2020
Ok, that’s the problem then. It is creating fields and Publisher doesn’t know about it. Can you send me a copy of Carthrob bc I don’t have one to test with. Just link to a Dropbox folder in a private comment or email it to support at BoldMinded dot com.
pixi
Apr 21, 2020
Comment has been marked private.
BoldMinded (Brian)
Apr 21, 2020
Comment has been marked private.
pixi
Apr 21, 2020
Thanks. Just installed it but I don’t have “Database Sync”. There is only “Diagnostics” and “Install Step 2”.
BoldMinded (Brian)
Apr 21, 2020
Comment has been marked private.
pixi
Apr 22, 2020
Yes it fixed the issue. Thank you Brian.
BoldMinded (Brian)
Apr 23, 2020
Excellent, good to hear!