urgent! big error after update to 3.5.8

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

urgent! big error after update to 3.5.8

Post by Angelo.pe »

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: 140
Joined: 02 May 2020, 12:42

Re: urgent! big error after update to 3.5.8

Post by Angelo.pe »

Here the debug messages:
https://imgur.com/Hh5aDLj
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9112
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: urgent! big error after update to 3.5.8

Post by Benno »

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: 140
Joined: 02 May 2020, 12:42

Re: urgent! big error after update to 3.5.8

Post by Angelo.pe »

Good morning Benno,
the system show this message
https://imgur.com/vhW0WZn
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47870
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: urgent! big error after update to 3.5.8

Post by Jan »

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
Post Reply