Yesterday, I exported my Resource Library as CSV so that I could more efficiently edit image alt attributes in Excel.
When I finished editing, I saved the csv and imported it.
On the AbanteCart import screen, there is an option to "Run in a test mode, to see if any issues are present".
Since this was my first csv import, Test mode seemed like a good idea, so I checked that box, and then I clicked Import.
I got no errors.
I then assumed that since the "test" worked, I should Import the csv file "for real", without the Test box checked.
So I unchecked the Test box and clicked Import again.
I got 500 errors.
I guess I didn't (and still don't) understand the actual purpose of Test mode. I used test mode, received no errors, so common sense suggests that I should import in "Real" mode, right?
It seems like my 1st "Test" import actually loaded the import file, and my 2nd "non-Test" import loaded it again, causing duplicate errors. I guess.
These errors are all the same type of error:
"
insert data error in resource_map. SQL Error: Duplicate entry '100019-products-2' for key 'PRIMARY'
Error No: 1062
SQL: INSERT INTO `bebo_resource_map` SET `resource_id` = '100019', `object_name` = 'products', `object_id` = '2', `default` = '0', `sort_order` = '2', `date_added` = '2017-06-10 12:46:34', `date_modified` = '2017-06-10 12:46:34'
"
My site still works. All of my alt tag edits were properly loaded. So the import process worked. But I still have the issue of 500 errors.
Today, I used Export/Import again to edit Category meta, because the process is fast and efficient. Today, when I imported the edited-&-saved csv file back into AbanteCart, I did not use "Test" mode. Everything was perfect. I got no errors.
So I tried to fix my resource-library error problem by doing a phpmyadmin Check Table command on the resource library table. No problems reported.
So I did a Check Table on the entire database. Only one problem was reported: a zero value in the auto-increment column of the stores table, which contains only one store, my store. Not really a problem.
So I used AbanteCart Admin panel to export my live resource-library and then I immediately re-imported it with no changes made.
I got the 500 errors.
My site works fine, but this error flag problem with that file cannot be a good thing. I need to address it.
I need somebody who understands the Import Test function to tell me what happened during the "resource-library" "Test Import" sequence of events described above, and more importantly, how do I fix it?
Thanks.