Imported images on new server not showing

[Wayne Workman]

@FallingWax I messaged you, top right, the talk bubble.

[FallingWax]

@Wayne-Workman looks like the csv format does not match up to the columns in mysql. If i try to add the .csv in manually its only taking the first row but all of the data is off. I think if i manipulate the csv I can get the images to come through correctly. Can you verify my findings? If so, any chance you know the command to copy the table to csv with headers? I tried SELECT * FROM images ‘OUTPUT FILE \images\test.csv’ but that gave me no result. said 1 row affect but no file was generated and I am sure it wouldn’t have the headers.

[Wayne Workman]

@FallingWax If you’re just wanting to know the field names you can do describe images;

[Tom Elliott]

@FallingWax you say you exported images from an older version, but what is that older version of fog?

[FallingWax]

@Tom-Elliott the old server is on 1.3.0-RC-14 as well. I had just updated prior to moving. Figured it was best to move to move to the same version.

[FallingWax]

@Wayne-Workman I ended up editing the CSV and manually importing it to SQL. I am not sure how the export/import is working but the exported file is missing a number of columns. imageID, imageProtect, imageMagnetUri, imageFormat
Once i added those I was able to import and everything is in the GUI now.

[Tom Elliott]

@FallingWax If it’s missing that many fields, I would like this is what’s causing the issue, though if you exported from 14 and imported into 14, I imagine you are seeing:

imageName,imageDesc,,,,,,,,, or similar.

Like people already said, the image ID is not exported, so that is fine. Data missing (but wrapped by blank comma’s) is fine.

[FallingWax]

@Tom-Elliot that explains why manually importing in to mysql I would need to fix the fields, but not why the initial import did not add to the table. It gave a good confirmation in the GUI after importing as well. I got everything in there now and it sees the images fine so I guess for now all is well. thanks

[Tom Elliott]

i think we need an example file to give you more information.

[FallingWax]

@Tom-Elliott I emailed it to Wayne yesterday.

[Wayne Workman]

@Tom-Elliott I just shared the file with you.