[Solved] SOS : Urgent Help Needed : Problem with default Group

[Kalpesh]

Hi,
recently i have done some changes with my Ps_group table now i am not able to create any group from admin end...
its giving the error message

1 error

an error occurred while creating object group (Unknown column 'price_display_method' in 'field list')
also i am not able to assign any group to my product category
i have upgaded my version from 1.2.5 to 1.3.1
also i have attached screenshots of the same please revert asap

[Kalpesh]

No body here who can help me?????? please help friends!!!

[olea]

The column ‘price_display_method’ should have been created during the upgrade

The prestashop 1.3 code expects such column from Database

[Kalpesh]

Thanks for your reply,
Mistakenly I haven't created it at the time of up-gradation, is there any way to repair existing DB because my Store is live now is there any other way to do this from PHP my admin i am new to all database stuff...please guide in detail if possible it will be really helpful for me...I am not able to create any Group from front end also there is no option to chose a group to access category or access level

[espresso]

So do I, can't create user or registration new customer, group product, group customer. (prestashop upgrade 1.2.5 to 1.3.2.3)

[Kalpesh]

Hi,
please refer following topic as you have to do some necessary changes manually from php my admin

http://www.prestashop.com/forums/viewthread/32052/installing_prestashop/solvedunknown_column_g_dot_price_display_method_in_field_list
Also you can compare the tables which are giving errors and update them accordingly at Php My admin

i have successfully fixed my problem...Thanks to this topic...

Cheers !

[espresso]

SOLVED!!
I change last line in ../config/setting.inc.php
from :

define('_PS_VERSION_', '1.3.2.3');

change to

define('_PS_VERSION_', '1.2.5');

then re-run installation .. select upgrade .. thats it ..

Thanks all..