dandycandy Posted April 19, 2013 Share Posted April 19, 2013 (edited) Folks, I tried to upload new categories through CSV and got tons of errors. I accidentally clicked "DELETE ALL CATEGORIES" when uploading since it was giving me grief (probably my own error). Having no HOME category wiped all products from the the front office, even though they're still in the catalog. After that, now I get a REDIRECT LOOP when trying to access the tab CATEGORIES in BO and there's no products in my home page. I've been searching for an answer for the last couple of hours and got nothing. I tried messing with phpmyAdmin and got nowhere. I need to get rid of this stupid redirect loop as below so I can access the Categories tab and restore the HOME category. The webpage at http://www.greenbodi...b346976706eb3d3 has resulted in too many redirects. Clearing your cookies for this site or allowing third-party cookies may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer. Any and all pointers on how to restore this will be appreciated. Thank you!! Edited April 19, 2013 by dandycandy (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted April 19, 2013 Share Posted April 19, 2013 Try adding the home category back in the database. ps_category, add a new one without id, then take note of the ID and att it to category_lang, so that it has a name. Be sure you add it to category_shop too, with id_shop = 1. The try accessing the admin categories page once more Link to comment Share on other sites More sharing options...
prestamax Posted April 19, 2013 Share Posted April 19, 2013 (edited) try to upload a new csv file with just one category. Don't forget to skip line one before starting the import. Then, try to import the other categories as well. I wouldn't touch the categories via phpMyadmin unless you know what you are doing. Chances are that you are just adding errors here .. (as far as I know the home category won't be deleted if you click on delete all categories before importing new categories) Edited April 19, 2013 by prestamax (see edit history) Link to comment Share on other sites More sharing options...
dandycandy Posted April 19, 2013 Author Share Posted April 19, 2013 (edited) Thanks guys. Can you explain a little better how to do this? What does "skip line one" mean? Line or column? Is this the ID column? I tried uploading the CSV file with one category but I'm not sure if I'm doing something wrong, I keep getting the same error over and over. Here's a copy of my file BTW there is no category_shop in the 1.5.4 database I remember that shortly before this problem, I saw a ROOT category in the list of categories which I didn't add. Edited April 19, 2013 by dandycandy (see edit history) 1 Link to comment Share on other sites More sharing options...
dandycandy Posted April 19, 2013 Author Share Posted April 19, 2013 (edited) . Edited April 19, 2013 by dandycandy (see edit history) Link to comment Share on other sites More sharing options...
prestamax Posted April 19, 2013 Share Posted April 19, 2013 Thanks guys. Can you explain a little better how to do this? What does "skip line one" mean? Line or column? Is this the ID column? I tried uploading the CSV file with one category but I'm not sure if I'm doing something wrong, I keep getting the same error over and over. Here's a copy of my file If importing a csv file you need to skip line 1 of the csv table (the headings) otherwise you will get error messages 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts