Weird content issue after manual update in SQL

lawrence whittemore asked on July 7, 2017 17:23

I have no idea how to explain this so it makes sense but here goes. I imported a bunch of content from an excel spread sheet after the import I updated the content via a sql statement (I updated the data with user names from a different table) when I view the content in sql I see the changes, I also see the changes when I view the content being pulled in from a repeater on the site. when I go to make an update however, the old content shows back up in the admin under the form tab. the pages were part of a workflow process, so I think it may have to do with that.

any thoughts?

sql content pages

Recent Answers

Brenden Kehren answered on July 7, 2017 17:33

Workflow and versioning, are they enabled? If so, your import only updated the page type table and possibly the cms_document table. If it is versioned, there are a lot of other tables that need to be updated and actually cause quite a bit of problems if not done right.

I think you can use the import toolkit to perform the updates if something already exists?

0 votesVote for this answer Mark as a Correct answer

lawrence whittemore answered on July 7, 2017 18:31

Interestingly enough I was able to copy all the pages to a new folder and it seemed to fix the issue.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on July 7, 2017 18:44

Yes, that would create a new version of them based on the current data in the page type field since they are new cms_document records. Still doesn't fix the underlying issue of running the SQL query manually against the database.

0 votesVote for this answer Mark as a Correct answer