Uploads missing after changing section name

5 posts by 3 authors in: Forums > CMS Builder
Last Post: February 28, 2011   (RSS)

Re: [aev] Uploads missing after changing section name

By Jason - February 28, 2011

Hi,

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

Hi,

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

Jason,

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