Be sure to checkout our newest add-on Speedy!

EE compatibility updates:

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

ExpressionEngine.com licenses:

  • 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, 2020

Hi,

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.

#1

BoldMinded (Brian)

Apr 20, 2020

Did you check to see if the “exp_publisher_data_field_30” table exists in the database?

#2

pixi

Apr 20, 2020

it doesn’t exist but I don’t know why.
No need to mention : I’m a poor debugger

#3

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

#4

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.

#5

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.

#6

pixi

Apr 21, 2020

Comment has been marked private.

#7

BoldMinded (Brian)

Apr 21, 2020

Comment has been marked private.

#8

pixi

Apr 21, 2020

Thanks. Just installed it but I don’t have “Database Sync”. There is only “Diagnostics” and “Install Step 2”.

#9

BoldMinded (Brian)

Apr 21, 2020

Comment has been marked private.

#10

pixi

Apr 22, 2020

Yes it fixed the issue. Thank you Brian.

#11

BoldMinded (Brian)

Apr 23, 2020

Excellent, good to hear!

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.