Changes in Media directories

[Paulo Ries]

Hello guys,

A user has changed the default directory names in Media, and move several directories. With this, even Media opens functionality. An error 500 and the message:

SQLSTATE [23000]: Integrity constraint Violation: 1062 Duplicate entry '' for key 'rel_path'

Someone would know how to fix this?

Thanks!

[4levels]

Hi Paulo,

you can try to clear the dm_media & dm_media_folder tables (make sure you disable foreign key checks) and run dm:setup again.  This might take a long time on large media collections though..  make sure you have enough memory available when running this.

I always make sure that the columns in those tables containing path names are using a charset like utf8_bin. 

On *Nix systems filenames are case sensitive and using a *_ci (case insensitive) charset will clash as logo.png and Logo.png will be considered the same entry in the database while being 2 different files on filesystem.  The same applies for folder names in dm_media_folder..

Hope this gets you going ;-)

Kind regards,

Erik aka 4levels

--

---
You received this message because you are subscribed to the Google Groups "diem-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to diem-users+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.