australisagencies Posted October 4, 2018 Share Posted October 4, 2018 tttttt Link to comment Share on other sites More sharing options...
0 dosbiner Posted October 4, 2018 Share Posted October 4, 2018 please enable debug mode on BO > advance parameters > performance, and refresh the peage, it will display the error details Link to comment Share on other sites More sharing options...
0 musicmaster Posted October 4, 2018 Share Posted October 4, 2018 If you deleted the Home category then all bets are off. Much of the software assumes there is a home category. Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 4, 2018 Author Share Posted October 4, 2018 @dosbiner thanks - I'll try this now Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 4, 2018 Author Share Posted October 4, 2018 @musicmaster uh-oh... I really don't know if I did this or if it was done by the upload. I have to assume it was manual, because if the upload deletes a critical category then the deletion feature is not usable. Start over? Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 4, 2018 Author Share Posted October 4, 2018 @dosbiner the plot thickens... [ThirtyBeesException] Root category must be an integer value at line 350 in file classes/helper/HelperTreeCategories.php @version 1.0.0 Initial version */ public function setRootCategory($value) { if (!Validate::isInt($value)) { throw new PrestaShopException('Root category must be an integer value'); } $this->rootcategory = $value; return $this; HelperTreeCategoriesCore->setRootCategory - [line 3258 - controllers/admin/AdminProductsController.php] - [1 Arguments] AdminProductsControllerCore->initContent - [line 366 - classes/controller/Controller.php] ControllerCore->run - [line 837 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 63 - admin/index.php] Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 4, 2018 Author Share Posted October 4, 2018 Hi guys, Okay, it looks like a good solution would be to wipe the DB and start over. I would hate to waste the rest of the work I've done by nuking the whole site. Can I upload a blank database from a new installation elsewhere? Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 5, 2018 Author Share Posted October 5, 2018 Hmm, this doesn't seem to be working at all. I've installed a new instance, backed up that database, then tried to import it into my existing one. It does nothing - the new products I created are still there (tables should all have been dropped, so nothing should be there after the restore). Any suggestions? I'm really lost. I don't wanna have to recreate all the terms, legals, etc. Link to comment Share on other sites More sharing options...
0 lesley Posted October 5, 2018 Share Posted October 5, 2018 What is still there? It could be there are errors in your import files. Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 5, 2018 Author Share Posted October 5, 2018 Fixed it!! Okay, I had a few gremlins here. I must have deleted (and forgotten doing so) the Home and Root categories to eliminate the clash of categories. I didn't know this was fatal - would be good to have this as a warning popup. What was confusing was that I was dropping the category tables, but the categories were still showing in the BackOffice. I was expecting PHP database miss errors, or something like that. Another issue I wsa having was that I was importing database tables from the new installation, but not renaming them properly. I had tables called "tbsicategoryshop" and I was copying them over "tbg8categoryshop". For anyone in future who trashes their database and doesn't want to nuke the site and lose their theme and text changes, you can import the database tables from a new installation. You just need to make sure you use the correct table names. Just install to another directory, then copy the tables. My site is hosted with CPanel, and I used PHPmyadmin to get to the database files. Also... DO NOT DELETE THE HOME CATEGORY. Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 5, 2018 Author Share Posted October 5, 2018 The interface suggests you can choose whatever category IDs you like. You can't. I now start mine with 1000. I'm actually not going to bother specifying category IDs,, as for me there's no apparent use to them, and the redundant desire to use them for the hell of it started me on this stupid journey. I have learned a bit more about site admin through this experience, though. Link to comment Share on other sites More sharing options...
0 musicmaster Posted October 5, 2018 Share Posted October 5, 2018 @australisagencies said in Catalog totally trashed: Another issue I wsa having was that I was importing database tables from the new installation, but not renaming them properly. I had tables called “tbsicategoryshop” and I was copying them over “tbg8categoryshop”. Are you really deleting categories directly in the database? That is almost impossible to do right. Not only should you delete all the related tables and take care that no orphaned categories remain but you should also set the nleft and nright fields correctly. Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 5, 2018 Author Share Posted October 5, 2018 @musicmaster hi, sorry if my phrasing wasn't very precise. No, I don't mean I was running SQL queries, editing individual entries within a table. I did very well with SQL in university, but have never used it since and that was about 15 years ago, so no, that's not an option for me in the slightest! I mean I dropped tables and then copied vanilla, blank, brand-new tables from a new installation. Happily, replacing the tables holus-bolus worked a treat. Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 10, 2018 Author Share Posted October 10, 2018 I can't mark this SOLVED Link to comment Share on other sites More sharing options...
0 lesley Posted October 10, 2018 Share Posted October 10, 2018 I marked it. Link to comment Share on other sites More sharing options...
0 australisagencies Posted October 10, 2018 Author Share Posted October 10, 2018 Thanks Lesley. Link to comment Share on other sites More sharing options...
Question
australisagencies
tttttt
Link to comment
Share on other sites
15 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now