madhu.iyengar Posted October 22, 2013 Share Posted October 22, 2013 HI Backoffice when trying to create a new order, adding a new address there are no states in the drop down list. Unable to create orders. This works for the SuperAdmin user but not for others. Looks like a permission issue but not sure what and where might be causing it. Any ideas? Thanks M Link to comment Share on other sites More sharing options...
vekia Posted October 22, 2013 Share Posted October 22, 2013 maybe it's related to language version that you use in front office? it is the same as you've got in bo or it's different? can you verify it please? Link to comment Share on other sites More sharing options...
madhu.iyengar Posted October 22, 2013 Author Share Posted October 22, 2013 They are both english. Never meddled with that. Link to comment Share on other sites More sharing options...
NemoPS Posted October 23, 2013 Share Posted October 23, 2013 Do other employees (the broken ones) have access to the localization tab, and its sub-tabs? Link to comment Share on other sites More sharing options...
madhu.iyengar Posted October 24, 2013 Author Share Posted October 24, 2013 Nemo1 No they do not have access... trying that out as we speak to see if that helps... M Link to comment Share on other sites More sharing options...
madhu.iyengar Posted October 24, 2013 Author Share Posted October 24, 2013 Nemo1 You are right. Adding View Localization States and Countries to the roles did the trick. Thanks M Link to comment Share on other sites More sharing options...
NemoPS Posted October 24, 2013 Share Posted October 24, 2013 Glad to hear it! I marked the topic as solved Link to comment Share on other sites More sharing options...
madhu.iyengar Posted October 25, 2013 Author Share Posted October 25, 2013 Nemo1 We are unable to add a new message same scenario. SuperAdmin can but others cannot. Do you think its related? We see this is the mysql error.log 131025 1:40:36 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave. Statement: UPDATE `ps_employee`^M SET `id_last_order` = (^M SELECT IFNULL(MAX(`id_order`), 0)^M FROM `ps_orders`^M )^M WHERE `id_employee` = 6 Link to comment Share on other sites More sharing options...
madhu.iyengar Posted October 25, 2013 Author Share Posted October 25, 2013 Referring to adding a new Message for an order in the Backoffice. Thanks M Link to comment Share on other sites More sharing options...
madhu.iyengar Posted October 25, 2013 Author Share Posted October 25, 2013 Discard did not realize they had changed the functionality Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now