Page 1 of 2

4.0.0RC Problem with registered user

Posted: 27 Feb 2022, 17:09
by Robx61
Good morning everyone.

I updated Phoca Cart on a back up copy of the site which is located on a server identical to the official one but under another domain. I work in this way to eliminate any interfacing problems that often occur between local and online jobs.
As I said I upgraded from Phoca Cart 4.0.0Beta to 4.0.0RC ... But I was surprised by a rather serious problem.
In the Beta version I have never had a problem between registered user and component ... Always worked excellently in all its functions.
With the RC version everything is fine until I log in with a registered user (test user) who immediately after logging in returns this message to me as a page not found: 1054 Unknown column 'c.params_shipping' in 'field list' ... and I can't explain why ...

How can I solve?

Thanks for any help you can ...

Re: 4.0.0RC Problem with registered user

Posted: 27 Feb 2022, 18:34
by Benno
Hi,
see: https://www.phoca.cz/documents/16-jooml ... ase-column
Backup your database and run this querry insite phpMyAdmin:

Code: Select all

ALTER TABLE `#__phocacart_cart_multiple` ADD COLUMN `params_shipping` text;
Change #_ to your database prefix before.

Kind regards,
Benno

Re: 4.0.0RC Problem with registered user

Posted: 28 Feb 2022, 09:38
by Robx61
Hi Benno and thanks for your kind reply.
I did what you suggested but sadly I have to tell you it didn't work. When I access the site the system should redirect me to a particular page but instead it always returns this error message: 1054 Unknown column 'c.params_payment' in 'field list'
and I'm also wondering where this column should be as having read the article following the suggested link I couldn't find anything that had that label ...

thank you
Roberto

Re: 4.0.0RC Problem with registered user

Posted: 28 Feb 2022, 09:57
by Benno
Hi,
1054 Unknown column 'c.params_payment' in 'field list'
Then run this querry:

Code: Select all

ALTER TABLE `#__phocacart_cart_multiple` ADD COLUMN `params_payment` text;
Change #_ to your database prefix before.

Kind regards,
Benno

Re: 4.0.0RC Problem with registered user

Posted: 28 Feb 2022, 10:11
by Robx61
Hi Benno I solved.

I used the same string in phpMyadmin that you suggested to me by inserting the new missing column and everything worked out ...

Thanks thanks thanks...

Good day and good work...

Roberto :twisted: :twisted: :twisted: :P :)

Re: 4.0.0RC Problem with registered user

Posted: 28 Feb 2022, 11:01
by Benno
You're welcome!

Kind regards,
Benno

Re: 4.0.0RC Problem with registered user

Posted: 03 Mar 2022, 03:42
by jeffslough8
Hello, following your instructions above I just get the following:

#1146 - Table '########__phocacart_cart_multiple' doesn't exist

I've hashed out the actual prefix, could you help me with this.

Thanks in advance

Re: 4.0.0RC Problem with registered user

Posted: 03 Mar 2022, 03:49
by jeffslough8
Ignore the above I have solved what I was doing wrong.

Re: 4.0.0RC Problem with registered user

Posted: 03 Mar 2022, 16:02
by Benno
Ok.

Kind regards,
Benno

Re: 4.0.0RC Problem with registered user

Posted: 15 Mar 2022, 17:38
by matrix630307
ok - after made the two sql's - it work's.
but i have other problems with icons, that not show's.
i will made for this a new item in forum.
thank you