InMotion Hosting Support Center

Can't add new product in Prestashop

Category: Prestashop 15

InMotionFans
n/a Points
Asked:
2014-03-18 8:12 am EST

Hits: 4,017
I am having issues adding or duplicating products in the Prestashop website I just created. The error message I am getting is: An error occurred while creating an object. I am new to Prestashop and don't know how to troubleshoot this issue.

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

John-Paul
Staff
31,633 Points
2014-03-18 9:13 am EST
Hello,

Thank you for your question. I found a possible solution in the Official Prestashop forum.

As a test, you can try disabling mod_security; if works after it is most likely being flagged by mod_security rules.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul

You must login before you can post a comment about this answer.

Hi,

I have tried disabling mod_security and it is still doing the same thing. When it is changed, does it take a while for the change to take effect?
mj.ajimine
12 Points
2014-03-18 11:10 pm EST
Hi,
Here is the error I get when I turn on debugging:
PrestaShopDatabaseException]

Table 'mddesi5_tribal.ps_tab_module_preference' doesn't exist

SELECT module
FROM ps_tab_module_preference
WHERE `id_tab` = 21
AND `id_employee` = 1


at line 613 in file classes/db/Db.php

607. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608. }
609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610. {
611. if ($sql)
612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613. throw new PrestaShopDatabaseException($this->getMsgError());
614. }
615. }
616.
617. /**

DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 534 - classes/Tab.php] - [1 Arguments]
TabCore::getTabModulesList - [line 1526 - classes/controller/AdminController.php] - [1 Arguments]
AdminControllerCore->initTabModuleList - [line 1484 - classes/controller/AdminController.php] - [0 Argument]
AdminControllerCore->initContent - [line 2296 - controllers/admin/AdminProductsController.php] - [0 Argument]
AdminProductsControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]
ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
DispatcherCore->dispatch - [line 53 - admintribe/index.php] - [0 Argument]

How can I fix this error?
mj.ajimine
12 Points
2014-03-18 11:21 pm EST
I have also noticed that when I click on Add to Cart... nothing happens. Sorry but there are just quite a few things I am noticing as I am finalizing the site. Your help is much appreciated.
mj.ajimine
12 Points
2014-03-18 11:40 pm EST
It appears that this database table does not exist which is why you are getting the error. Did you install PrestaShop using Softaculous or manually? What version of PrestaShop did you install?
JeffMa
11,186 Points
Staff
2014-03-19 7:33 am EST
I used Softaculous to install Prestashop. I believe it's 1.5.5. But as for my database, I worked on the site on a test server using WAMP. Then I imported the database's tables into the database created by Softaculous. I hope that makes sense.
mj.ajimine
12 Points
2014-03-19 7:53 pm EST
As things may be slightly different with the either installation, you are always best off when moving a site from a testing environment, to simply move the files from the testing environment over as well. I recommend replacing everything on the server with the files from your test environment to the live environment.
JeffMa
11,186 Points
Staff
2014-03-20 7:59 am EST
Like this Question?

Related Articles

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Need more Help?

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!