Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1054 in account creation


Recommended Posts



I have received this error when I was trying to register a new client:

1054 - Unknown column 's.public_flag' in 'where clause'


select count(*) as total from orders o, orders_status s where o.customers_id = '6' and o.orders_status = s.orders_status_id and s.language_id = '3' and s.public_flag = '1'


I have input all cells from register form, and I have clicked on send button, then I have received a mail with information of some privileges about the new account, but I haven't received any mail with the activation link.


I have searched in this forum, but I only found this error about the names of products manufacturers.


Sorry for my bad english.

Link to comment
Share on other sites

Ok I've repaired with this:


Run this SQL statement to fix your issue. This will create the table elements that are missing.


alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';


What addon do you recommend to me?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...