shoke Posted December 4, 2008 Share Posted December 4, 2008 Hello, 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 More sharing options...
FIMBLE Posted December 4, 2008 Share Posted December 4, 2008 have you added the contribution for the activation? Its not there on a standard version Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
shoke Posted December 4, 2008 Author Share Posted December 4, 2008 have you added the contribution for the activation?Its not there on a standard version Nic No, but then, why do I receive the error? What addon do you recommend to me? Link to comment Share on other sites More sharing options...
shoke Posted December 4, 2008 Author Share Posted December 4, 2008 . Link to comment Share on other sites More sharing options...
shoke Posted December 4, 2008 Author Share Posted December 4, 2008 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 More sharing options...
FIMBLE Posted December 4, 2008 Share Posted December 4, 2008 This one http://addons.oscommerce.com/info/5241 Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
shoke Posted December 5, 2008 Author Share Posted December 5, 2008 This onehttp://addons.oscommerce.com/info/5241 Nic Thank´s, I´ve installed the addon and works fine. Link to comment Share on other sites More sharing options...
FIMBLE Posted December 5, 2008 Share Posted December 5, 2008 Great, well done Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.