4.0.0RC Problem with registered user

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

[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

[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

[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

[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

[Benno]

You're welcome!

Kind regards,
Benno

[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

[jeffslough8]

Ignore the above I have solved what I was doing wrong.

[Benno]

Ok.

Kind regards,
Benno

[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