Uploads missing after changing section name
5 posts by 3 authors in: Forums > CMS Builder
Last Post: February 28, 2011 (RSS)
By aev - February 28, 2011
if we change the name for a section all the uploads for the section disappear. If we change the name back all the uploads reappear.
What is the best way to solve this right now? And could you please fix this for the next release?
-aev-
Re: [aev] Uploads missing after changing section name
By Jason - February 28, 2011
This happens because the uploads table stores the tables name and uses this to make sure certain records only appear in certain sections.
There are a couple of things you could do to get around this for right now. First, you can change the section's label without changing it's actual table name. This would keep all of your upload record where they are. If you absolutely need to change the name of the table, you can run an SQL query to change all the upload records with the old name to the new name.
EXAMPLE
UPDATE cms_uploads SET tableName = 'NEW NAME' WHERE tableName = 'OLD NAME'NOTE: Only attempt this if you are comfortable with MySQL. It is important to ALWAYS backup your database before attempting executing queries like this.
Hope this helps
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Uploads missing after changing section name
By aev - February 28, 2011
Thanks for clarifying this!
Will you improve this in a future version of CMSB? Feels like a bug to me..
-aev-
Re: [aev] Uploads missing after changing section name
By Jason - February 28, 2011
I've passed this along to be added to our features list for a future release.
Thanks.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Uploads missing after changing section name
By Deborah - February 28, 2011 - edited: February 28, 2011
I've experienced this on a couple of installations myself and arrived at the same table renaming solution offered.
I agree with aev... this gets my vote as a bug. [;)]
~ Deborah