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

Import Blog post #8

Open
Tim-VL opened this issue Sep 18, 2024 · 4 comments
Open

Import Blog post #8

Tim-VL opened this issue Sep 18, 2024 · 4 comments
Labels
bug Something isn't working

Comments

@Tim-VL
Copy link

Tim-VL commented Sep 18, 2024

Would be great if there is a option to import/convert blog post from the older versions/SasBlogModule

@7underlines 7underlines added the bug Something isn't working label Sep 19, 2024
@7underlines
Copy link
Member

7underlines commented Sep 24, 2024

Back up your database, then run these SQL commands right after switching to the new version.

INSERT INTO werkl_blog_author
SELECT * FROM sas_blog_author
WHERE id != UNHEX('64F4C60194634128B9B85D9299797C45');

INSERT INTO werkl_blog_author_translation
SELECT * FROM sas_blog_author_translation;

INSERT INTO werkl_blog_blog_category
SELECT * FROM sas_blog_blog_category;

DELETE FROM werkl_blog_category;
INSERT INTO werkl_blog_category
SELECT * FROM sas_blog_category;

DELETE FROM werkl_blog_category_translation;
INSERT INTO werkl_blog_category_translation
SELECT * FROM sas_blog_category_translation;

INSERT INTO werkl_blog_entries
SELECT * FROM sas_blog_entries;

INSERT INTO werkl_blog_entries_translation
SELECT * FROM sas_blog_entries_translation;

# Edit: I forgot the seo_url_template
INSERT INTO `seo_url_template` (`id`, `sales_channel_id`, `route_name`, `entity_name`, `template`, `is_valid`, `custom_fields`, `created_at`, `updated_at`) VALUES
(UNHEX('0193EA8AA36073C48660FC113F43FCA7'),	NULL,	'werkl.frontend.blog.detail',	'werkl_blog_entries',	'blog/{{ entry.translated.title|lower }}',	1,	NULL,	'2024-12-21 18:46:14.624',	NULL);

@phit
Copy link
Contributor

phit commented Dec 9, 2024

why is this not a migration in the plugin?

@7underlines
Copy link
Member

Sure, we could also implement it as a migration in the plugin. Pull requests are welcome.

@7underlines 7underlines reopened this Jan 15, 2025
@7underlines
Copy link
Member

Hi everyone,

I have just reopened this issue and wanted to check if this is still relevant. Have most users already migrated manually, or was the old version never widely used, making this unnecessary now?

Please let me know if this is still something we need to address or if it can be safely closed.

Thanks for your input!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants