Madman_CZ Posted January 20, 2014 Share Posted January 20, 2014 (edited) Dear All, a friend of mine who has started her own online store has all of a sudden got this error message An error occurred while creating object. Category () when trying too add a new category to her shop. I have some experience with editing all sort of things in Prestashop, I have tested her store and I can confirm that the error is happening. Please see attachment. I have read forum threads about a similar error where people were not able to add a product to their shop. However, I have not been able to find a solution that I could try. I am at a loss with this one, I believe it could be caused by a database mismatch. If anyone could she some light on this issue I would be very greatful. Maybe someone has experience a similar or same error. Her store is 1.5.4.1 Using the Graphileom template Than you in advance for any help. Edited January 22, 2014 by vekia (see edit history) Link to comment Share on other sites More sharing options...
rambabuy Posted January 20, 2014 Share Posted January 20, 2014 why don't you upgrade your site to latest release to 1.5.6.1. many such problems has been rectified. Link to comment Share on other sites More sharing options...
Madman_CZ Posted January 20, 2014 Author Share Posted January 20, 2014 (edited) Thank you for your reply, I believe that installing the newest version does usually sove many problems, however, I have also come across threads where upgrading had caused more problems or the problems remained. Having spent hours of work translating the front end into Czech which is our local language, an upgrade would not be ideal. The Czech translation pack has many mistakes and then there are many phrases that are missing so it would take again more time to actually upgrade and get the store into the same place as we have it now. Plus there is no guarantee that this error will be solved by upgrading. Also the free template being used only supports Presta 1.5.4.1. So it could cause more problems. If anyone could help with fixing this error I would be greatful. Mad Edited January 20, 2014 by Madman_CZ (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 20, 2014 Share Posted January 20, 2014 what does this message mean? (error that you've got) Link to comment Share on other sites More sharing options...
Madman_CZ Posted January 20, 2014 Author Share Posted January 20, 2014 Dear Vekia, the error in the attachment is this > An error occurred while creating object. Category () - only it is in czech. Regards Mad Link to comment Share on other sites More sharing options...
vekia Posted January 20, 2014 Share Posted January 20, 2014 turn on error reporting, maybe there is some mysql error, will see then Link to comment Share on other sites More sharing options...
Madman_CZ Posted January 21, 2014 Author Share Posted January 21, 2014 Dear Veika, I have turned on error reporting but ti gave no new error, just the same as above, However, I have switched Prestashop into debug and dev mode and upon trying to create a category it gave me this. I am not sure if this will be much help to you. See attachment. Thank you for any tips Mad Link to comment Share on other sites More sharing options...
vekia Posted January 21, 2014 Share Posted January 21, 2014 this is what we were looked for! exactly this error message. for what purposes you use heureka_category column in category table? it's defintiely non default field. you use some overrides? create this new column in ps154_category table. Link to comment Share on other sites More sharing options...
Madman_CZ Posted January 22, 2014 Author Share Posted January 22, 2014 (edited) Dear Vekia, thank you for your reply, I thought as much that after finding the error, it would be in the database. My friend has a module Heureka which is used for xml export feed into a Heureka search engine where customers can compare prices and find the closes dealer. Seems like this module has an error where it doesn't create a field for the information input when creating a category. I have added a screenshot of how I have added the heureka_category_column to the database. I hope I had added it correctly. I am not really sure what NULL, Default, Collation mean. Maybe you can just check that it is correct. I can confirm that after adding this column to the database, i can create categories again without error. Thank you for your help, I still have faith in this forum Mad Edited January 22, 2014 by Madman_CZ (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted January 22, 2014 Share Posted January 22, 2014 everything is fine now new column added properly glad to hear that it works i marked whole topic as solved too. with regards, Milos Link to comment Share on other sites More sharing options...
Recommended Posts