canvas: SQLSTATE[23000]: Integrity constraint violation
Hello,
I installed Canvas and I can access to the admin management. But when I want to publish my first blog post “Hello World”, I have this error message :
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'hello-world-2' for key 'posts_slug_unique' (SQL: insert into posts (user_id, title, slug, subtitle, page_image, content_raw, content_html, meta_description, is_draft, published_at, layout, updated_at, created_at) values (2, Hello World 2, hello-world-2, Y'en a pas, , aaaaa, <p>aaaaa</p>, , 0, 2016-12-30 16:34:56, canvas::frontend.blog.post, 2016-12-30 16:35:10, 2016-12-30 16:35:10))
Could you tell me what’s the issue ? I tried to create another blog with another name in case of but the result is the same. I did nothing manually regarding the database, simply installed Canvas. Thanks!
Environnement : Digital Ocean server through Cloudways PHP 5.6 MySQL 5.5
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Comments: 16 (8 by maintainers)
Ok @PastaGringo, the latest release is out and should solve this issue. Feel free to close it out when you see it work! 👍
Good to hear! Yes, the next release is a major upgrade. So if you can hold out just a short while, it’ll be worth it!
All right, wait and see 😉 Hope to use Cancas! Thanks
@PastaGringo Right now, Canvas is in the process of transforming into 2 separate repositories, so an issue like this falls under what is to be expected during this process. Apologies for the issue, but it will be resolved in the next available release.