urgent! big error after update to 3.5.8

Phoca Cart - complex e-commerce extension
User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 106
Joined: 02 May 2020, 12:42

urgent! big error after update to 3.5.8

Post by Angelo.pe » 14 Oct 2021, 18:58

Hello Jan,
just now I update the version to 3.5.8 from 3.5.6.
I'm checking that is ok and I fund this big error in the order section. I can't see them!!
https://imgur.com/smi6xUk
https://imgur.com/5FJkpw8

Please, could you help me?
thank you so much

Joomla installed: 3.10.2

User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 106
Joined: 02 May 2020, 12:42

Re: urgent! big error after update to 3.5.8

Post by Angelo.pe » 14 Oct 2021, 19:13

Here the debug messages:
https://imgur.com/Hh5aDLj

User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 7902
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: urgent! big error after update to 3.5.8

Post by Benno » 15 Oct 2021, 07:39

Hi,
see: https://www.phoca.cz/documents/16-jooml ... ase-column
Run this query inside phpMyAdmin:

Code: Select all

ALTER TABLE `#__phocacart_order_statuses` ADD COLUMN `activate_gift` tinyint(1) NOT NULL DEFAULT '0';
Backup your database first and change #_ to your database prefix.

Kind regards,
Benno

User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 106
Joined: 02 May 2020, 12:42

Re: urgent! big error after update to 3.5.8

Post by Angelo.pe » 19 Oct 2021, 11:37

Good morning Benno,
the system show this message
https://imgur.com/vhW0WZn

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 44318
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: urgent! big error after update to 3.5.8

Post by Jan » 19 Oct 2021, 19:27

Hi, you have added to the SQL query even the "code: SELECT ALL" which does not belong to the SQL query:

Image

Jan
If you find Phoca extensions useful, please support the project

User avatar
Angelo.pe
Phoca Professional
Phoca Professional
Posts: 106
Joined: 02 May 2020, 12:42

Re: urgent! big error after update to 3.5.8

Post by Angelo.pe » 20 Oct 2021, 12:02

Good morning jan,
this is the message of system:
https://imgur.com/zjQ6AMh

Post Reply