[SOLVED]..but want to rerun sql upgrade? ..Create new account in front office does not work anymore after upgrade???

[deech123]

UPDATE :
the problem was that the update procedure seems to forgot my sql table to update.
is there any way I can rerun the sql update only?
where can I find the page or tool to update the sql tables?

thx

Hi guys,

I've done the update from 1.3.02 to the final release 1.3.

now I see that creating a new account in the front office is not working.
I always get the error :er is een fout opgetreden bij het aanmaken van uw account.
(dutch :- )

in the back office I get the error:
1 fout
er is een fout opgetreden tijdens het aanmaken customer (Unknown column 'id_default_group' in 'field list')


so unknow column 'id_default_group' in 'field list'?

in the version 1.3.02 I had an enountered no problems.

please anybody who can help me out.
I didn't changed a thing....but this if really necessary since clients can no longer buy or register.

hope to receive any tip very quick.

with my best regards.

[Carlv1428]

Hello,

I have the same problem and i don't see the solution to your request.
However it is set to solved....

Can you share your workaround?

Thanks

[deech123]

well,

the problem is that for me the update did no do all the sql updates.
the problem is that there is a missing field.

so best you can do is looking with version you have now.
then in the prestashopV1.3 (final release) go to the install folder,
then in the folder sql,
then the folder upgrade,
you see .sql files.

so I had v 1.3.0.2
so I opened the file 1.3.0.3 in a text editor,
I copied the entire text.
and paste it in mysqladmin, and execute it.
and so on for all files that are not empty.

that's how I solved it.

[Carlv1428]

It seems that i don't have empty sql files...
So i don't know how the upgrade of the db has gone...

But i see that in the table Customer i don't see the field 'id_default_group'.

However the db version as i see in the admin part is "Powered by PrestaShop™ [ forum & contact ] - Version 1.3.0.10 - 0.122s"

[deech123]

then you need to run the sql packages.

because the add field id_default_group is in one of them.

so check them out.

[choussamaster]

thanks this solve my problem by executing all sql command via phpmyadmin

[deech123]

with pleasure.

therefore we have this forum.

[PierreL]

Hi Guys

I did a new install as this is the first time i am using Prestashop.

The upgrade fix does not work for me. Dont know how to fix this.

I have the following error when adding a new client via admin

an error occurred while creating object customer (Unknown column 'id_default_group' in 'field list')

Regards

Pierre