Loading Profile...
Twitter,
Facebook, or email.
I've just upgraded my site to EE 2.1 from 1.6. A number of weblogs (now Channels) used Matrix and Fieldframe to add multiple images to a weblog entry. I *was* using the nGen File Field fieldtype in Matrix, with a corresponding caption field.
Now I've upgraded to EE 2.1, installed Matrix 2.0.8, got all my previously uploaded images to show up in the File Manager, and tweaked the custom fields that used to use nGen to now use the default File fieldtype.
This is maybe a stupid question, but how do I get the previously-entered data to show up in existing Channel entries? Put another way, my channel entries (i.e. all previous entries in the database) are still available via the new 2.1. Control Panel, and core data like the title, body text, URL title are intact.
But all Matrix data (i.e. the images and a text captions) no longer show up in EXISTING entires. I know this data is still in the database -- how do I reconnect the two? I really hope I don't have to recreate all this data... :-(
I’m
anxious
How do I get my Matrix data back after upgrade to EE2.1?
Official
Response
-
The issue here is that nGen File stored its file data differently than the File fieldtype (and Matrix’s File celltype counterpart). nGen just stored the filename, whereas the File field/celltypes store it in the "{filedir_XX}filename.ext" format.
I just came across this post by Rob Sanchez which outlines a SQL query you can run to update your field data, and this response that rejiggers the query for Matrix data.
Hope this helps others down the road.
EMPLOYEE
-
Have you installed Matrix 2 in Add-Ons > Fieldtypes yet?Comment
-
-
Yes, fully installed and appears to be working. I can go ahead and add new entries with it ok.
Oh, I should clarify: I re-setup the matrix fields as before, just tweaking to use the default 'file' fieldtype in EE2 in place of the old 'nGen File' fieldtype INSIDE the matrix fieldtype. -
-
Hmm. The installation process is supposed to check for previous Matrix fields and update them for you.
Did you delete your exp_ff_fieldtypes table during your EE2 upgrade perhaps? -
-
I’m
frustrated (very!)
No, I didn't do anything to the database (apart from a backup). Checking now.... exp_ff_fieldtypes table is still there.
Also, looks like this guy had a similar problem: http://expressionengine.com/forums/vi...
I really need help here.... I have **no** idea where/how I might run an SQL Query that would fix this problem -
-
I’m
undecided
Nick - did you eventually get the SQL fix to work with this? I'm currently having the same exact problem as you - all fields have survived the upgrade save the nGen one -- they're all blank. -
-
I’m
p*ssed
No I didn't. In the end I just re-entered the missing data for the Matrix fields (or in the case the 'file' fieldtype, reconnected with files/images via the new File Manager in EE 2.1).
This was my own portfolio site. The number of channel entries was relatively small, and I needed the site back up, so I went ahead and fixed it myself by re-entering the data. But I have other client sites that need upgrading from 1.6x to 2.x and they have literally thousands of entries that use the nGen file fieldtype inside Matrix.
I'm more than a little pissed off, actually. I got no help from Brandon, other than what you see above. He seems to imply that fieldtypes should automatically be translated as part of the EE 2.1 upgrade process, so its not his problem.
If that's the case, then we should be entitled to some sort of EE tech support on this as well, given that fieldtypes are now integrated into 2.1. I'm going to post something about this in the EE support forums shortly. I'll put a link back here later.
Clearly, I'm not the only one having this problem. There needs to be some sort of clear instruction, wiki entry or support path when upgrading 1.6.x to 2.1 etc with regards to fieldtypes inside Matrix. Especially since Matrix is now $55 and EE 2.1 is at least $50 for the upgrade. -
-
The issue here is that nGen File stored its file data differently than the File fieldtype (and Matrix’s File celltype counterpart). nGen just stored the filename, whereas the File field/celltypes store it in the "{filedir_XX}filename.ext" format.
I just came across this post by Rob Sanchez which outlines a SQL query you can run to update your field data, and this response that rejiggers the query for Matrix data.
Hope this helps others down the road. -
-
Ok, well, I give it a go... probably on a test site first(!)
Thanks Brandon -
