big problem after update

[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

[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

[Angelo.pe]

dbprefix ? it is right?
so, I must delete all the tables with other prefixes?

[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

[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

[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

[Angelo.pe]

I can't delete Joomla because I'm working on the site and I don't feel like starting over. :-(

[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

[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.

[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...