Page 2 of 3
Re: big problem after update
Posted: 04 May 2020, 17:01
by Angelo.pe
Ok Benno, sorry but I 'm newbie .. :-(
when you write table prefix. Which one do you mean?
Regarding the phocacart, in the DB there are tables with two different prefixes
https://imgur.com/nCkOPuV
https://imgur.com/jvxecZe
Re: big problem after update
Posted: 04 May 2020, 17:30
by Benno
Hi,
when you write table prefix. Which one do you mean?
Regarding the phocacart, in the DB there are tables with two different prefixes
That's bad. You need to know the name of the database and the database prefix of your running Joomla! system.
Go to: backend --> System --> System Information --> Configuration File -->
Scroll down to the line:
database --> this is the name of your database of your running Joomla! system
Then:
dbprefix --> this is the prefix of the database of your running Joomla! system
Important: When you change the database prefix of the above query, there needs to be
only one underscore!
Hope this helps.
Kind regards,
Benno
Re: big problem after update
Posted: 04 May 2020, 17:45
by Angelo.pe
dbprefix ? it is right?
so, I must delete all the tables with other prefixes?
Re: big problem after update
Posted: 04 May 2020, 17:55
by Benno
Hi,
I have no idea why there are two different prefixes in your database. It is unusual. How you get the prefix of your running Joomla! I described to you in my last post. And no, I wouldn't delete anything if you don't know how the other prefix came about.
And once more, before you run the query, make a complete database backup!
Kind regards,
Benno
Re: big problem after update
Posted: 04 May 2020, 18:08
by Angelo.pe
I sent the query. the answer is
#1060 - Nome colonna duplicato 'download_days'
the problem's the same.
I have a question.
Since I am now starting to use phocacart and there are no data to save. If I delete all the component, plugins etc and then delete all the DB tables related to the pochacart. what happens?
So I create an installation from scratch
Re: big problem after update
Posted: 04 May 2020, 19:17
by Benno
Hi,
I think that's a very good idea, but I would go a step further. If you only have installed Phoca Cart as an external extension, I would recommend to delete Joomla! and the database completely and then reinstall Joomla! & Phoca Cart from scratch. This will also solve the problem with the two database prefixes.
Current Joomla! CMS
Current Phoca Cart Component
Current Phoca Cart Modules
Current Phoca Cart Manual
Kind regards,
Benno
Re: big problem after update
Posted: 04 May 2020, 19:28
by Angelo.pe
I can't delete Joomla because I'm working on the site and I don't feel like starting over. :-(
Re: big problem after update
Posted: 05 May 2020, 00:26
by Jan
At least you should update Joomla! to latest version and reinstall all Phoca Cart extensions as it really seems, a lot of updates (more than two years of updates) are missing on your website
If you uinstall Phoca Cart, all Phoca Cart data (products, categories, payment and shipping methods, every Phoca Cart data) will be removed.
Jan
Re: big problem after update
Posted: 06 May 2020, 13:17
by Angelo.pe
Hello Jan,
I uninstalled Phocacart and re-installed. I'm following the wizard and I made the menù. When I click on the categories I have this message:
Code: Select all
0 Cannot use object of type stdClass as array
Call stack
# Function Location
1 () JROOT/components/com_phocacart/layouts/product_image.php:12
2 include() JROOT/libraries/src/Layout/FileLayout.php:125
3 Joomla\CMS\Layout\FileLayout->render() JROOT/templates/jf_simone/html/com_phocacart/category/default.php:344
4 include() JROOT/libraries/src/MVC/View/HtmlView.php:701
5 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230
6 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_phocacart/views/category/view.html.php:231
7 PhocaCartViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672
8 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_phocacart/controller.php:43
9 PhocaCartController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
10 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_phocacart/phocacart.php:14
11 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
12 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
13 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
14 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
15 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
16 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
I think that the problems are with the old tables that are not deleted and maintain previous data...
I discovered that the problem is if I use the JF Simone template while with Protostar or Beeze (for example) is ok.
Re: big problem after update
Posted: 06 May 2020, 20:44
by Angelo.pe
I tried also with Premiere Template but Jf Simone and this template don't work together. My idea was to use Premiere only for the shop...