Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in cron when split databases #887

Closed
gonzaloebiz opened this issue Oct 3, 2019 · 0 comments
Closed

Error in cron when split databases #887

gonzaloebiz opened this issue Oct 3, 2019 · 0 comments

Comments

@gonzaloebiz
Copy link
Collaborator

When split the databases in 3

magento for default
magento_sales for sales
magento_quote

Looks like magento is not capable to do a join from tables from different databases.

Cron Job ebizmarts_ecommerce has an error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento23ee_sales.mailchimp_sync_ecommerce' doesn't exist, query was: SELECT main_table., m4m. FROM sales_order AS main_table
LEFT JOIN mailchimp_sync_ecommerce AS m4m ON m4m.related_id = main_table.entity_id and m4m.type = 'ORD' and m4m.mailchimp_store_id = 'xxxxxxxxxxxxxxxxxx' WHERE (store_id = 1) AND (m4m.mailchimp_sync_modified = 1 AND m4m.mailchimp_store_id = 'xxxxxxxxxxxxxxxxxx') LIMIT 50.

@gonzaloebiz gonzaloebiz added this to the 10x.x.38 milestone Oct 3, 2019
@gonzaloebiz gonzaloebiz self-assigned this Oct 3, 2019
@gonzaloebiz gonzaloebiz changed the title Error in cron when the split databases Error in cron when split databases Oct 3, 2019
gonzaloebiz added a commit that referenced this issue Oct 3, 2019
gonzaloebiz added a commit that referenced this issue Oct 3, 2019
gonzaloebiz added a commit that referenced this issue Oct 3, 2019
gonzaloebiz added a commit that referenced this issue Oct 3, 2019
gonzaloebiz added a commit that referenced this issue Oct 3, 2019
gonzaloebiz added a commit that referenced this issue Oct 3, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant