InMotion Hosting Support Center

Prestashop CMS in Preferences.

Category: Prestashop 15

heartlandpet
333 Points
Asked:
2015-03-13 7:35 pm EST

Hits: 857
Right now I do not have access to PREFERENCES>CMS, in my back office. The following error shows.
Category cannot be loaded.

Please advise.

r,

Bruce

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

You must login before you can submit an answer.

Arn,

No, it is not theme related. Does the same thing on the default theme. I see by doing a Google search that you guys have dealt with this before although the solution offered by Scott at that time was extraordinarily vague. It is in the database. Remember, your techs recently did a transfer of my databases from my old theme into my fresh install. They did a great jog, everything works except this. I need the solution to getting the access to my CMS page again.
heartlandpet
333 Points
2015-03-13 09:17 pm EST
OR I COULD CHANGE BACK TO 1.6.11
heartlandpet
333 Points
2015-03-16 12:46 pm EST
Arnel,

I will go ahead and DOWNGRADE to 1.6.11. Truth is I could probably just leave it there. My theme goes to 1.6.13. I will make a decision then. Are you saying that the software will AUTOMATICALLY pick up the database?
heartlandpet
333 Points
2015-03-16 04:53 pm EST
Scott,

What I would like is for (one) thing to go right in Prestashop. I have tried three times to roll back and it keeps rolling it back to 1.6.13. That is what I have. I give up. 1-Click upgrade gives me no option for 1.6.11..............so.......you want to do it for me? 1.6.11

r,

Bruce
heartlandpet
333 Points
2015-03-16 06:17 pm EST
Oh...and by the way. Now I can't log into my dashboard (say's NO CONTROLLER) it just keeps getting better.

I love Prestashop!!
heartlandpet
333 Points
2015-03-16 06:27 pm EST
Scott,

If possible I would like to work on my website in the morning.

Bruce
heartlandpet
333 Points
2015-03-16 10:22 pm EST
Hey guys,

Are we ready to go yet?
heartlandpet
333 Points
2015-03-17 11:10 am EST
Today I can log into my dashboard. Below is the error with the CMS page.
[PrestaShopDatabaseException]

Table 'heartl43_presta.ps_cms_category_shop' doesn't exist

SELECT *
FROM `ps_cms_category` a
LEFT JOIN `ps_cms_category_shop` `c` ON a.id_cms_category = c.id_cms_category AND c.id_shop = 1
WHERE (a.id_cms_category = 1) LIMIT 1


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

641. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642. }
643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644. {
645. if ($sql)
646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647. throw new PrestaShopDatabaseException($this->getMsgError());
648. }
649. }
650.
651. /**

DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 558 - classes/db/Db.php] - [1 Arguments]
DbCore->getRow - [line 233 - classes/ObjectModel.php] - [1 Arguments]
ObjectModelCore->__construct - [line 43 - controllers/admin/AdminCmsContentController.php] - [1 Arguments]
AdminCmsContentControllerCore->__construct - [line 135 - classes/controller/Controller.php] - [2 Arguments]
ControllerCore::getController - [line 366 - classes/Dispatcher.php] - [1 Arguments]
DispatcherCore->dispatch - [line 54 - admin/index.php]
heartlandpet
333 Points
2015-03-17 11:29 am EST

OTHER ANSWERS

0

Arn
Staff
42,973 Points
2015-03-13 8:15 pm EST
Hello Bruce,

Sorry for the problem with the Preferences > CMS. It appears to be theme related. I tried that same section on my test server and it's referencing a section of the site that appears to be different in your current theme. I would rather not test on your site, though we do have a test version of your site setup (on Scott's computer). We would need test on that, but I will not have access until Monday. If you wish to try, I would recommend you backup up everything, then try to change your theme back to DEFAULT. If you see the CMS option working, then it's definitely theme related. I couldn't find anything on the forums and with the default theme, I didn't have any trouble.

Apologies that I don't a more direct answer for you Bruce. We will continue the search for this issue on Monday. If you have any further questions or comments, please let us know.

Regards,
Arnel C.

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

Hello Bruce,

So, after some looking in the PrestaShop fourms, your database, my testshop's database, and upgraded shop's database, we saw some things that point to the solution of the problem. First, your database is basically missing a table that is present in 1.6.0.13 and 1.6.0.14 . When I checked my old 1.6.0.11 version, it was also missing the table. This points to upgrade process. When we we installed your site, we simply pointed over your database (from 1.6.0.11) we didn't upgrade it. The install files were based on 1.6.0.13, however. This is the reason that there's an error with the CMS. So, how do we fix it? The best way is to take your database and then upgrade it. I'm working on that now (though with a backup of the db - not the actual db). Once it's upgraded, I'll test that database in place of your old one. I'll post the results once we have it all completed.

Regards,
Arnel C.
Arn
42,973 Points
Staff
2015-03-16 10:50 am EST
Hello Bruce,

I actually did try to upgrade from .13 to .14 but PrestaShop's 1-click upgrade did not like it. I talked to Scott, and as you're saying, the next step would be to use the 1.6.0.11 install and then upgrade it 1.6.0.13. That would take care of the missing table. If you wish to change it over yourself, you're welcome to do so . Please let us know how you want to proceed.

Regards,
Arnel C.
Arn
42,973 Points
Staff
2015-03-16 2:02 pm EST
Hello Bruce,

Yes, the update to .13 should add any new tables to the database.

Kindest Regards,
Scott M
scott
43,761 Points
Staff
2015-03-16 5:59 pm EST
Hello Bruce,

It will likely take a deletion of the current version and then a manual install of the .11 version. Arnel and I will take a look to see what it entails tomorrow and see if we can make it less painful. It does sound like it is giving you quite the adventure recently.

Kindest Regards,
Scott M
scott
43,761 Points
Staff
2015-03-16 8:58 pm EST
Hello Bruce,

I spent yesterday attempting different things with test copies of your site to see what the best course of action may be. I finally got things down to two options.

With the current setup, I was able to manually add the missing table and a couple of other columns that were added to the database during one of the version updates. While this seemed to get everything working, the issue is that I have no idea how many other changes were made that we are unaware of. It is probable that working in another area could bring up another error. I did not run into any other issues at the time, however and everything 'seemed' to run fine.

The second was to attempt a rollback. I installed a fresh 11 version and then simply switched the configuration to point to the test copy of the current database. Then I was able to log into the back office and switch the theme to the default. It took a few tries as a particular module had to be disabled when it was switched. There are also a few other modules that are related to the pts_furniture theme that needed to be disabled. I was able to get that done for the most part. The only issue I saw then was a 404 on a portion of the home page but I am unsure what that was related to. It could be that I needed to then copy over your images and modules folders to the test copy, I am not sure. It seemed to be ready to either use from there or upgrade to the newest version.

I am not sure either option will be 100%, so you will want to decide how you want to proceed. We will certainly help, advise, assist, etc as best we can.

Kindest Regards,
Scott M
scott
43,761 Points
Staff
2015-03-18 9:45 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!