Can't register and authenticate in shopizer 2.0

[Chaker Chaker]

Hi,

I have tried to register a client in Shopizer 2.0.

I can see that the client entry is properly created in the admin module but I'm not able to authenticate with this client.

When I try to connect, I have a message saying the Unable to complete registration, please try again later 

Thanks

[shopizer]

If i understand well you can register a client using shop ui, you can see the client in the admin

When you try to log on from shop you get the message displayed in the last post ?

Any message un the console ?

[Chaker Chaker]

Sorry, I was meaning when I register the new user I have the following error message Unable to complete registration, please try again later 

And when I try to logon with this new user (cause I see that it has been created in the admin) I have the following error message : LOGIN FAILED. USERNAME OR PASSWORD IS INCORRECT

[shopizer]

Ok then that means there should be a error message in the console. I suspect an incomplete configuration of the system, for instance have you configured the email settings from the admin.

[Chaker Chaker]

You'r right I did not configure the email setting in the admin.

What should I put just for testing?

[n4nd...@gmail.com]

hello

i have same problem above disscuss. i have configure the email setting in the admin. after its still that problem are come

[shopizer]

1- Make sure you are using Shopizer 2.0.0

2- Configure your email server correctly, it is required to complete the registration process

[n4nd...@gmail.com]

hello Sir,
             i have drop my Database and create new database but still problem are occurred.  so plz give me step for Register Customer and how it Login.

I have below Error in my log file and Tomcat Consol.


Tomcat Consol error

INFO : com.salesmanager.web.utils.EmailTemplatesUtils - Sending welcome email to
 customer
DEBUG: com.salesmanager.web.utils.EmailTemplatesUtils - Sending email to test on
 their  registered email id some...@gmail.com
Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_149_0_, merchants
t1_.MERCHANT_ID as MERCHANT1_135_1_, merchantco0_.DATE_CREATED as DATE2_149_0_,
merchantco0_.DATE_MODIFIED as DATE3_149_0_, merchantco0_.UPDT_ID as UPDT4_149_0_
, merchantco0_.CONFIG_KEY as CONFIG5_149_0_, merchantco0_.TYPE as TYPE149_0_, me
rchantco0_.MERCHANT_ID as MERCHANT8_149_0_, merchantco0_.VALUE as VALUE149_0_, m
erchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CON
TINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENC
Y_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_13
5_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as
 DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVO
ICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_,
 merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_1
35_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS
 as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STOR
E_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst
1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17
_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as
WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_ from SALESMANAGER.MERCHA
NT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1
_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHA
NT_ID=? and merchantco0_.CONFIG_KEY=? limit ?




log File Error

Sep 30, 2014 12:01:39 PM org.apache.catalina.core.StandardWrapperValve invoke
INFO: DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/shop/customer/register.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /shop/customer/register.html
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public java.lang.String com.salesmanager.web.shop.controller.customer.CustomerRegistrationController.registerCustomer(com.salesmanager.web.entity.customer.SecuredShopPersistableCustomer,org.springframework.validation.BindingResult,org.springframework.ui.Model,javax.servlet.http.HttpServletRequest,java.util.Locale) throws java.lang.Exception]
Hibernate: select zone0_.ZONE_ID as ZONE1_138_, zone0_.ZONE_CODE as ZONE2_138_, zone0_.COUNTRY_ID as COUNTRY3_138_ from SALESMANAGER.ZONE zone0_
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
Hibernate: select customer0_.CUSTOMER_ID as CUSTOMER1_160_0_, merchantst1_.MERCHANT_ID as MERCHANT1_135_1_, language2_.LANGUAGE_ID as LANGUAGE1_140_2_, group4_.GROUP_ID as GROUP1_191_3_, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_161_4_, customerop6_.CUSTOMER_OPTION_ID as CUSTOMER1_162_5_, descriptio8_.DESCRIPTION_ID as DESCRIPT1_163_6_, customerop7_.CUSTOMER_OPTION_VALUE_ID as CUSTOMER1_164_7_, descriptio9_.DESCRIPTION_ID as DESCRIPT1_166_8_, customer0_.CUSTOMER_ANONYMOUS as CUSTOMER2_160_0_, customer0_.BILLING_STREET_ADDRESS as BILLING3_160_0_, customer0_.BILLING_CITY as BILLING4_160_0_, customer0_.BILLING_COMPANY as BILLING5_160_0_, customer0_.BILLING_COUNTRY_ID as BILLING25_160_0_, customer0_.BILLING_FIRST_NAME as BILLING6_160_0_, customer0_.BILLING_LAST_NAME as BILLING7_160_0_, customer0_.BILLING_POSTCODE as BILLING8_160_0_, customer0_.BILLING_STATE as BILLING9_160_0_, customer0_.BILLING_TELEPHONE as BILLING10_160_0_, customer0_.BILLING_ZONE_ID as BILLING26_160_0_, customer0_.CUSTOMER_COMPANY as CUSTOMER11_160_0_, customer0_.CUSTOMER_DOB as CUSTOMER12_160_0_, customer0_.LANGUAGE_ID as LANGUAGE27_160_0_, customer0_.DELIVERY_STREET_ADDRESS as DELIVERY13_160_0_, customer0_.DELIVERY_CITY as DELIVERY14_160_0_, customer0_.DELIVERY_COMPANY as DELIVERY15_160_0_, customer0_.DELIVERY_COUNTRY_ID as DELIVERY28_160_0_, customer0_.DELIVERY_FIRST_NAME as DELIVERY16_160_0_, customer0_.DELIVERY_LAST_NAME as DELIVERY17_160_0_, customer0_.DELIVERY_POSTCODE as DELIVERY18_160_0_, customer0_.DELIVERY_STATE as DELIVERY19_160_0_, customer0_.DELIVERY_TELEPHONE as DELIVERY20_160_0_, customer0_.DELIVERY_ZONE_ID as DELIVERY29_160_0_, customer0_.CUSTOMER_EMAIL_ADDRESS as CUSTOMER21_160_0_, customer0_.CUSTOMER_GENDER as CUSTOMER22_160_0_, customer0_.MERCHANT_ID as MERCHANT30_160_0_, customer0_.CUSTOMER_NICK as CUSTOMER23_160_0_, customer0_.CUSTOMER_PASSWORD as CUSTOMER24_160_0_, merchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENCY_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_135_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_, merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_135_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STORE_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_, language2_.DATE_CREATED as DATE2_140_2_, language2_.DATE_MODIFIED as DATE3_140_2_, language2_.UPDT_ID as UPDT4_140_2_, language2_.CODE as CODE140_2_, language2_.SORT_ORDER as SORT6_140_2_, group4_.DATE_CREATED as DATE2_191_3_, group4_.DATE_MODIFIED as DATE3_191_3_, group4_.UPDT_ID as UPDT4_191_3_, group4_.GROUP_NAME as GROUP5_191_3_, group4_.GROUP_TYPE as GROUP6_191_3_, groups3_.CUSTOMER_ID as CUSTOMER1_160_0__, groups3_.GROUP_ID as GROUP2_0__, attributes5_.CUSTOMER_ID as CUSTOMER3_161_4_, attributes5_.OPTION_ID as OPTION4_161_4_, attributes5_.OPTION_VALUE_ID as OPTION5_161_4_, attributes5_.CUSTOMER_ATTR_TXT_VAL as CUSTOMER2_161_4_, attributes5_.CUSTOMER_ID as CUSTOMER3_160_1__, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_1__, customerop6_.CUSTOMER_OPT_ACTIVE as CUSTOMER2_162_5_, customerop6_.CUSTOMER_OPT_CODE as CUSTOMER3_162_5_, customerop6_.CUSTOMER_OPTION_TYPE as CUSTOMER4_162_5_, customerop6_.MERCHANT_ID as MERCHANT7_162_5_, customerop6_.CUSTOMER_OPT_PUBLIC as CUSTOMER5_162_5_, customerop6_.SORT_ORDER as SORT6_162_5_, descriptio8_.DATE_CREATED as DATE2_163_6_, descriptio8_.DATE_MODIFIED as DATE3_163_6_, descriptio8_.UPDT_ID as UPDT4_163_6_, descriptio8_.DESCRIPTION as DESCRIPT5_163_6_, descriptio8_.LANGUAGE_ID as LANGUAGE9_163_6_, descriptio8_.NAME as NAME163_6_, descriptio8_.TITLE as TITLE163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_163_6_, descriptio8_.CUSTOMER_OPTION_COMMENT as CUSTOMER8_163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_162_2__, descriptio8_.DESCRIPTION_ID as DESCRIPT1_2__, customerop7_.CUSTOMER_OPT_VAL_CODE as CUSTOMER2_164_7_, customerop7_.CUSTOMER_OPT_VAL_IMAGE as CUSTOMER3_164_7_, customerop7_.MERCHANT_ID as MERCHANT5_164_7_, customerop7_.SORT_ORDER as SORT4_164_7_, descriptio9_.DATE_CREATED as DATE2_166_8_, descriptio9_.DATE_MODIFIED as DATE3_166_8_, descriptio9_.UPDT_ID as UPDT4_166_8_, descriptio9_.DESCRIPTION as DESCRIPT5_166_8_, descriptio9_.LANGUAGE_ID as LANGUAGE8_166_8_, descriptio9_.NAME as NAME166_8_, descriptio9_.TITLE as TITLE166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_164_3__, descriptio9_.DESCRIPTION_ID as DESCRIPT1_3__ from SALESMANAGER.CUSTOMER customer0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on customer0_.MERCHANT_ID=merchantst1_.MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language2_ on customer0_.LANGUAGE_ID=language2_.LANGUAGE_ID left outer join SALESMANAGER.CUSTOMER_GROUP groups3_ on customer0_.CUSTOMER_ID=groups3_.CUSTOMER_ID left outer join SALESMANAGER.SM_GROUP group4_ on groups3_.GROUP_ID=group4_.GROUP_ID left outer join SALESMANAGER.CUSTOMER_ATTRIBUTE attributes5_ on customer0_.CUSTOMER_ID=attributes5_.CUSTOMER_ID left outer join SALESMANAGER.CUSTOMER_OPTION customerop6_ on attributes5_.OPTION_ID=customerop6_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_DESC descriptio8_ on customerop6_.CUSTOMER_OPTION_ID=descriptio8_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_VALUE customerop7_ on attributes5_.OPTION_VALUE_ID=customerop7_.CUSTOMER_OPTION_VALUE_ID left outer join SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION descriptio9_ on customerop7_.CUSTOMER_OPTION_VALUE_ID=descriptio9_.CUSTOMER_OPT_VAL_ID where customer0_.CUSTOMER_NICK=? and merchantst1_.MERCHANT_ID=?
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - No customer found with userName test123 for store VIjaySales
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Starting customer registration process..
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Starting to populate customer model from customer data
Hibernate: select language0_.LANGUAGE_ID as LANGUAGE1_140_, language0_.DATE_CREATED as DATE2_140_, language0_.DATE_MODIFIED as DATE3_140_, language0_.UPDT_ID as UPDT4_140_, language0_.CODE as CODE140_, language0_.SORT_ORDER as SORT6_140_ from SALESMANAGER.LANGUAGE language0_ where language0_.CODE=? limit ?
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - About to persist customer to database.
DEBUG: com.salesmanager.core.business.customer.service.CustomerServiceImpl - Creating Customer
Hibernate: select SEQ_COUNT from SALESMANAGER.SM_SEQUENCER where SEQ_NAME = 'CUSTOMER_SEQ_NEXT_VAL' for update
Hibernate: insert into SALESMANAGER.SM_SEQUENCER(SEQ_NAME, SEQ_COUNT) values('CUSTOMER_SEQ_NEXT_VAL', ?)
Hibernate: update SALESMANAGER.SM_SEQUENCER set SEQ_COUNT = ? where SEQ_COUNT = ? and SEQ_NAME = 'CUSTOMER_SEQ_NEXT_VAL'
Hibernate: insert into SALESMANAGER.CUSTOMER (CUSTOMER_ANONYMOUS, BILLING_STREET_ADDRESS, BILLING_CITY, BILLING_COMPANY, BILLING_COUNTRY_ID, BILLING_FIRST_NAME, BILLING_LAST_NAME, BILLING_POSTCODE, BILLING_STATE, BILLING_TELEPHONE, BILLING_ZONE_ID, CUSTOMER_COMPANY, CUSTOMER_DOB, LANGUAGE_ID, DELIVERY_STREET_ADDRESS, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY_ID, DELIVERY_FIRST_NAME, DELIVERY_LAST_NAME, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_TELEPHONE, DELIVERY_ZONE_ID, CUSTOMER_EMAIL_ADDRESS, CUSTOMER_GENDER, MERCHANT_ID, CUSTOMER_NICK, CUSTOMER_PASSWORD, CUSTOMER_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Returning customer data to controller..
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Retunring populated instance of customer entity
WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
Hibernate: select customer0_.CUSTOMER_ID as CUSTOMER1_160_0_, merchantst1_.MERCHANT_ID as MERCHANT1_135_1_, language2_.LANGUAGE_ID as LANGUAGE1_140_2_, group4_.GROUP_ID as GROUP1_191_3_, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_161_4_, customerop6_.CUSTOMER_OPTION_ID as CUSTOMER1_162_5_, descriptio8_.DESCRIPTION_ID as DESCRIPT1_163_6_, customerop7_.CUSTOMER_OPTION_VALUE_ID as CUSTOMER1_164_7_, descriptio9_.DESCRIPTION_ID as DESCRIPT1_166_8_, customer0_.CUSTOMER_ANONYMOUS as CUSTOMER2_160_0_, customer0_.BILLING_STREET_ADDRESS as BILLING3_160_0_, customer0_.BILLING_CITY as BILLING4_160_0_, customer0_.BILLING_COMPANY as BILLING5_160_0_, customer0_.BILLING_COUNTRY_ID as BILLING25_160_0_, customer0_.BILLING_FIRST_NAME as BILLING6_160_0_, customer0_.BILLING_LAST_NAME as BILLING7_160_0_, customer0_.BILLING_POSTCODE as BILLING8_160_0_, customer0_.BILLING_STATE as BILLING9_160_0_, customer0_.BILLING_TELEPHONE as BILLING10_160_0_, customer0_.BILLING_ZONE_ID as BILLING26_160_0_, customer0_.CUSTOMER_COMPANY as CUSTOMER11_160_0_, customer0_.CUSTOMER_DOB as CUSTOMER12_160_0_, customer0_.LANGUAGE_ID as LANGUAGE27_160_0_, customer0_.DELIVERY_STREET_ADDRESS as DELIVERY13_160_0_, customer0_.DELIVERY_CITY as DELIVERY14_160_0_, customer0_.DELIVERY_COMPANY as DELIVERY15_160_0_, customer0_.DELIVERY_COUNTRY_ID as DELIVERY28_160_0_, customer0_.DELIVERY_FIRST_NAME as DELIVERY16_160_0_, customer0_.DELIVERY_LAST_NAME as DELIVERY17_160_0_, customer0_.DELIVERY_POSTCODE as DELIVERY18_160_0_, customer0_.DELIVERY_STATE as DELIVERY19_160_0_, customer0_.DELIVERY_TELEPHONE as DELIVERY20_160_0_, customer0_.DELIVERY_ZONE_ID as DELIVERY29_160_0_, customer0_.CUSTOMER_EMAIL_ADDRESS as CUSTOMER21_160_0_, customer0_.CUSTOMER_GENDER as CUSTOMER22_160_0_, customer0_.MERCHANT_ID as MERCHANT30_160_0_, customer0_.CUSTOMER_NICK as CUSTOMER23_160_0_, customer0_.CUSTOMER_PASSWORD as CUSTOMER24_160_0_, merchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENCY_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_135_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_, merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_135_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STORE_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_, language2_.DATE_CREATED as DATE2_140_2_, language2_.DATE_MODIFIED as DATE3_140_2_, language2_.UPDT_ID as UPDT4_140_2_, language2_.CODE as CODE140_2_, language2_.SORT_ORDER as SORT6_140_2_, group4_.DATE_CREATED as DATE2_191_3_, group4_.DATE_MODIFIED as DATE3_191_3_, group4_.UPDT_ID as UPDT4_191_3_, group4_.GROUP_NAME as GROUP5_191_3_, group4_.GROUP_TYPE as GROUP6_191_3_, groups3_.CUSTOMER_ID as CUSTOMER1_160_0__, groups3_.GROUP_ID as GROUP2_0__, attributes5_.CUSTOMER_ID as CUSTOMER3_161_4_, attributes5_.OPTION_ID as OPTION4_161_4_, attributes5_.OPTION_VALUE_ID as OPTION5_161_4_, attributes5_.CUSTOMER_ATTR_TXT_VAL as CUSTOMER2_161_4_, attributes5_.CUSTOMER_ID as CUSTOMER3_160_1__, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_1__, customerop6_.CUSTOMER_OPT_ACTIVE as CUSTOMER2_162_5_, customerop6_.CUSTOMER_OPT_CODE as CUSTOMER3_162_5_, customerop6_.CUSTOMER_OPTION_TYPE as CUSTOMER4_162_5_, customerop6_.MERCHANT_ID as MERCHANT7_162_5_, customerop6_.CUSTOMER_OPT_PUBLIC as CUSTOMER5_162_5_, customerop6_.SORT_ORDER as SORT6_162_5_, descriptio8_.DATE_CREATED as DATE2_163_6_, descriptio8_.DATE_MODIFIED as DATE3_163_6_, descriptio8_.UPDT_ID as UPDT4_163_6_, descriptio8_.DESCRIPTION as DESCRIPT5_163_6_, descriptio8_.LANGUAGE_ID as LANGUAGE9_163_6_, descriptio8_.NAME as NAME163_6_, descriptio8_.TITLE as TITLE163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_163_6_, descriptio8_.CUSTOMER_OPTION_COMMENT as CUSTOMER8_163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_162_2__, descriptio8_.DESCRIPTION_ID as DESCRIPT1_2__, customerop7_.CUSTOMER_OPT_VAL_CODE as CUSTOMER2_164_7_, customerop7_.CUSTOMER_OPT_VAL_IMAGE as CUSTOMER3_164_7_, customerop7_.MERCHANT_ID as MERCHANT5_164_7_, customerop7_.SORT_ORDER as SORT4_164_7_, descriptio9_.DATE_CREATED as DATE2_166_8_, descriptio9_.DATE_MODIFIED as DATE3_166_8_, descriptio9_.UPDT_ID as UPDT4_166_8_, descriptio9_.DESCRIPTION as DESCRIPT5_166_8_, descriptio9_.LANGUAGE_ID as LANGUAGE8_166_8_, descriptio9_.NAME as NAME166_8_, descriptio9_.TITLE as TITLE166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_164_3__, descriptio9_.DESCRIPTION_ID as DESCRIPT1_3__ from SALESMANAGER.CUSTOMER customer0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on customer0_.MERCHANT_ID=merchantst1_.MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language2_ on customer0_.LANGUAGE_ID=language2_.LANGUAGE_ID left outer join SALESMANAGER.CUSTOMER_GROUP groups3_ on customer0_.CUSTOMER_ID=groups3_.CUSTOMER_ID left outer join SALESMANAGER.SM_GROUP group4_ on groups3_.GROUP_ID=group4_.GROUP_ID left outer join SALESMANAGER.CUSTOMER_ATTRIBUTE attributes5_ on customer0_.CUSTOMER_ID=attributes5_.CUSTOMER_ID left outer join SALESMANAGER.CUSTOMER_OPTION customerop6_ on attributes5_.OPTION_ID=customerop6_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_DESC descriptio8_ on customerop6_.CUSTOMER_OPTION_ID=descriptio8_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_VALUE customerop7_ on attributes5_.OPTION_VALUE_ID=customerop7_.CUSTOMER_OPTION_VALUE_ID left outer join SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION descriptio9_ on customerop7_.CUSTOMER_OPTION_VALUE_ID=descriptio9_.CUSTOMER_OPT_VAL_ID where customer0_.CUSTOMER_NICK=? and merchantst1_.MERCHANT_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?
ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree
ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree
<AST>:0:0: unexpected end of subtree
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3164)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect(HqlSqlBaseWalker.java:4485)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.inRhs(HqlSqlBaseWalker.java:4390)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4065)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1935)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)
    at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:216)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1207)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256)
    at com.salesmanager.core.business.user.dao.PermissionDaoImpl.getPermissionsListByGroups(PermissionDaoImpl.java:63)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy134.getPermissionsListByGroups(Unknown Source)
    at com.salesmanager.core.business.user.service.PermissionServiceImpl.getPermissions(PermissionServiceImpl.java:81)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy136.getPermissions(Unknown Source)
    at com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl.authenticate(CustomerFacadeImpl.java:414)
    at com.salesmanager.web.shop.controller.customer.CustomerRegistrationController.registerCustomer(CustomerRegistrationController.java:229)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:207)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)
ERROR: com.salesmanager.web.shop.controller.customer.CustomerRegistrationController - Cannot authenticate user
org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]
    at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:301)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:106)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy134.getPermissionsListByGroups(Unknown Source)
    at com.salesmanager.core.business.user.service.PermissionServiceImpl.getPermissions(PermissionServiceImpl.java:81)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy136.getPermissions(Unknown Source)
    at com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl.authenticate(CustomerFacadeImpl.java:414)
    at com.salesmanager.web.shop.controller.customer.CustomerRegistrationController.registerCustomer(CustomerRegistrationController.java:229)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
    at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
    at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
    at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
    at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:207)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1805)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1352)
    at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1293)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:265)
    at com.salesmanager.core.business.user.dao.PermissionDaoImpl.getPermissionsListByGroups(PermissionDaoImpl.java:63)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)
    ... 83 more
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select distinct p from com.salesmanager.core.business.user.model.Permission as p join fetch p.groups grous where grous.id in ()]
    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
    at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
    at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:255)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
    at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
    at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:216)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1207)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
    at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256)
    ... 92 more
DEBUG: org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.tiles2.TilesView: name 'register.bootstrap'; URL [register.bootstrap]] in DispatcherServlet with name 'appServlet'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'recapatcha_public_key' of type [java.lang.String] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'customer' of type [com.salesmanager.web.entity.customer.SecuredShopPersistableCustomer] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'countryList' of type [java.util.ArrayList] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'org.springframework.validation.BindingResult.customer' of type [org.springframework.validation.BeanPropertyBindingResult] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'zoneList' of type [java.util.ArrayList] to request in view with name 'register.bootstrap'
DEBUG: org.springframework.web.servlet.DispatcherServlet - Successfully completed request

[n4nd...@gmail.com]

hello sir,

           i have Register the customer in User Ui than its give error like Unable to complete registration, please try again later
and Tomcat Console have
 
INFO: DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/admin/reference/provinces.html]
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /admin/reference/provinces.html
DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public java.lang.String com.salesmanager.web.reference.ReferenceController.getProvinces(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)]
DEBUG: com.salesmanager.web.reference.ReferenceController - Province Country Code
ERROR: com.salesmanager.core.business.reference.zone.service.ZoneServiceImpl - getZones()
java.lang.NullPointerException
    at com.salesmanager.core.business.reference.zone.service.ZoneServiceImpl.getZones(ZoneServiceImpl.java:70)




its give goze error.  so plz give me replay

[n4nd...@gmail.com]

hi

       if i Reset Password in Admin Panel and its send me mail with new password but i use this password for Login but it cant me Login. and This New Password are store in Database.

[shopizer]

I suspect that reference data did not load correctly on initial startup

When you open the customer registration page do you see countries on the dropdown box, when you select a country for instance Australia are the provinces populated in the province dropdown field

If not then check any errors that might be printed during the first server startup. Look if Country and Zone tables are populated.

The best way to have the system populated correctly is to drop the schema, build with maven outside of eclipse and deploy directly to an application server. If the reference json file was imported in eclipse with unsupported characyter set it may have corrupted the file.

[n4nd...@gmail.com]

Hello sir,
             Error is still.  i have use our way. and error are not come when startup but when i click on register button then after it display and state drop box have value as per your suggesstion.


following error are still

DEBUG: com.salesmanager.core.business.customer.service.CustomerServiceImpl - Creating Customer
Hibernate: select SEQ_COUNT from SALESMANAGER.SM_SEQUENCER where SEQ_NAME = 'CUSTOMER_SEQ_NEXT_VAL' for update

Hibernate: update SALESMANAGER.SM_SEQUENCER set SEQ_COUNT = ? where SEQ_COUNT = ? and SEQ_NAME = 'CUSTOMER_SEQ_NEXT_VAL'
Hibernate: insert into SALESMANAGER.CUSTOMER (CUSTOMER_ANONYMOUS, BILLING_STREET_ADDRESS, BILLING_CITY, BILLING_COMPANY, BILLING_COUNTRY_ID, BILLING_FIRST_NAME, BILLING_LAST_NAME, BILLING_POSTCODE, BILLING_STATE, BILLING_TELEPHONE, BILLING_ZONE_ID, CUSTOMER_COMPANY, CUSTOMER_DOB, LANGUAGE_ID, DELIVERY_STREET_ADDRESS, DELIVERY_CITY, DELIVERY_COMPANY, DELIVERY_COUNTRY_ID, DELIVERY_FIRST_NAME, DELIVERY_LAST_NAME, DELIVERY_POSTCODE, DELIVERY_STATE, DELIVERY_TELEPHONE, DELIVERY_ZONE_ID, CUSTOMER_EMAIL_ADDRESS, CUSTOMER_GENDER, MERCHANT_ID, CUSTOMER_NICK, CUSTOMER_PASSWORD, CUSTOMER_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Returning customer data to controller..
INFO : com.salesmanager.web.shop.controller.customer.facade.CustomerFacadeImpl - Retunring populated instance of customer entity
WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
Hibernate: select customer0_.CUSTOMER_ID as CUSTOMER1_160_0_, merchantst1_.MERCHANT_ID as MERCHANT1_135_1_, language2_.LANGUAGE_ID as LANGUAGE1_140_2_, group4_.GROUP_ID as GROUP1_191_3_, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_161_4_, customerop6_.CUSTOMER_OPTION_ID as CUSTOMER1_162_5_, descriptio8_.DESCRIPTION_ID as DESCRIPT1_163_6_, customerop7_.CUSTOMER_OPTION_VALUE_ID as CUSTOMER1_164_7_, descriptio9_.DESCRIPTION_ID as DESCRIPT1_166_8_, customer0_.CUSTOMER_ANONYMOUS as CUSTOMER2_160_0_, customer0_.BILLING_STREET_ADDRESS as BILLING3_160_0_, customer0_.BILLING_CITY as BILLING4_160_0_, customer0_.BILLING_COMPANY as BILLING5_160_0_, customer0_.BILLING_COUNTRY_ID as BILLING25_160_0_, customer0_.BILLING_FIRST_NAME as BILLING6_160_0_, customer0_.BILLING_LAST_NAME as BILLING7_160_0_, customer0_.BILLING_POSTCODE as BILLING8_160_0_, customer0_.BILLING_STATE as BILLING9_160_0_, customer0_.BILLING_TELEPHONE as BILLING10_160_0_, customer0_.BILLING_ZONE_ID as BILLING26_160_0_, customer0_.CUSTOMER_COMPANY as CUSTOMER11_160_0_, customer0_.CUSTOMER_DOB as CUSTOMER12_160_0_, customer0_.LANGUAGE_ID as LANGUAGE27_160_0_, customer0_.DELIVERY_STREET_ADDRESS as DELIVERY13_160_0_, customer0_.DELIVERY_CITY as DELIVERY14_160_0_, customer0_.DELIVERY_COMPANY as DELIVERY15_160_0_, customer0_.DELIVERY_COUNTRY_ID as DELIVERY28_160_0_, customer0_.DELIVERY_FIRST_NAME as DELIVERY16_160_0_, customer0_.DELIVERY_LAST_NAME as DELIVERY17_160_0_, customer0_.DELIVERY_POSTCODE as DELIVERY18_160_0_, customer0_.DELIVERY_STATE as DELIVERY19_160_0_, customer0_.DELIVERY_TELEPHONE as DELIVERY20_160_0_, customer0_.DELIVERY_ZONE_ID as DELIVERY29_160_0_, customer0_.CUSTOMER_EMAIL_ADDRESS as CUSTOMER21_160_0_, customer0_.CUSTOMER_GENDER as CUSTOMER22_160_0_, customer0_.MERCHANT_ID as MERCHANT30_160_0_, customer0_.CUSTOMER_NICK as CUSTOMER23_160_0_, customer0_.CUSTOMER_PASSWORD as CUSTOMER24_160_0_, merchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENCY_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_135_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_, merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_135_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STORE_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_, language2_.DATE_CREATED as DATE2_140_2_, language2_.DATE_MODIFIED as DATE3_140_2_, language2_.UPDT_ID as UPDT4_140_2_, language2_.CODE as CODE140_2_, language2_.SORT_ORDER as SORT6_140_2_, group4_.DATE_CREATED as DATE2_191_3_, group4_.DATE_MODIFIED as DATE3_191_3_, group4_.UPDT_ID as UPDT4_191_3_, group4_.GROUP_NAME as GROUP5_191_3_, group4_.GROUP_TYPE as GROUP6_191_3_, groups3_.CUSTOMER_ID as CUSTOMER1_160_0__, groups3_.GROUP_ID as GROUP2_0__, attributes5_.CUSTOMER_ID as CUSTOMER3_161_4_, attributes5_.OPTION_ID as OPTION4_161_4_, attributes5_.OPTION_VALUE_ID as OPTION5_161_4_, attributes5_.CUSTOMER_ATTR_TXT_VAL as CUSTOMER2_161_4_, attributes5_.CUSTOMER_ID as CUSTOMER3_160_1__, attributes5_.CUSTOMER_ATTRIBUTE_ID as CUSTOMER1_1__, customerop6_.CUSTOMER_OPT_ACTIVE as CUSTOMER2_162_5_, customerop6_.CUSTOMER_OPT_CODE as CUSTOMER3_162_5_, customerop6_.CUSTOMER_OPTION_TYPE as CUSTOMER4_162_5_, customerop6_.MERCHANT_ID as MERCHANT7_162_5_, customerop6_.CUSTOMER_OPT_PUBLIC as CUSTOMER5_162_5_, customerop6_.SORT_ORDER as SORT6_162_5_, descriptio8_.DATE_CREATED as DATE2_163_6_, descriptio8_.DATE_MODIFIED as DATE3_163_6_, descriptio8_.UPDT_ID as UPDT4_163_6_, descriptio8_.DESCRIPTION as DESCRIPT5_163_6_, descriptio8_.LANGUAGE_ID as LANGUAGE9_163_6_, descriptio8_.NAME as NAME163_6_, descriptio8_.TITLE as TITLE163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_163_6_, descriptio8_.CUSTOMER_OPTION_COMMENT as CUSTOMER8_163_6_, descriptio8_.CUSTOMER_OPTION_ID as CUSTOMER10_162_2__, descriptio8_.DESCRIPTION_ID as DESCRIPT1_2__, customerop7_.CUSTOMER_OPT_VAL_CODE as CUSTOMER2_164_7_, customerop7_.CUSTOMER_OPT_VAL_IMAGE as CUSTOMER3_164_7_, customerop7_.MERCHANT_ID as MERCHANT5_164_7_, customerop7_.SORT_ORDER as SORT4_164_7_, descriptio9_.DATE_CREATED as DATE2_166_8_, descriptio9_.DATE_MODIFIED as DATE3_166_8_, descriptio9_.UPDT_ID as UPDT4_166_8_, descriptio9_.DESCRIPTION as DESCRIPT5_166_8_, descriptio9_.LANGUAGE_ID as LANGUAGE8_166_8_, descriptio9_.NAME as NAME166_8_, descriptio9_.TITLE as TITLE166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_166_8_, descriptio9_.CUSTOMER_OPT_VAL_ID as CUSTOMER9_164_3__, descriptio9_.DESCRIPTION_ID as DESCRIPT1_3__ from SALESMANAGER.CUSTOMER customer0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on customer0_.MERCHANT_ID=merchantst1_.MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language2_ on customer0_.LANGUAGE_ID=language2_.LANGUAGE_ID left outer join SALESMANAGER.CUSTOMER_GROUP groups3_ on customer0_.CUSTOMER_ID=groups3_.CUSTOMER_ID left outer join SALESMANAGER.SM_GROUP group4_ on groups3_.GROUP_ID=group4_.GROUP_ID left outer join SALESMANAGER.CUSTOMER_ATTRIBUTE attributes5_ on customer0_.CUSTOMER_ID=attributes5_.CUSTOMER_ID left outer join SALESMANAGER.CUSTOMER_OPTION customerop6_ on attributes5_.OPTION_ID=customerop6_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_DESC descriptio8_ on customerop6_.CUSTOMER_OPTION_ID=descriptio8_.CUSTOMER_OPTION_ID left outer join SALESMANAGER.CUSTOMER_OPTION_VALUE customerop7_ on attributes5_.OPTION_VALUE_ID=customerop7_.CUSTOMER_OPTION_VALUE_ID left outer join SALESMANAGER.CUSTOMER_OPT_VAL_DESCRIPTION descriptio9_ on customerop7_.CUSTOMER_OPTION_VALUE_ID=descriptio9_.CUSTOMER_OPT_VAL_ID where customer0_.CUSTOMER_NICK=? and merchantst1_.MERCHANT_ID=?
Hibernate: select country0_.COUNTRY_ID as COUNTRY1_136_1_, country0_.GEOZONE_ID as GEOZONE4_136_1_, country0_.COUNTRY_ISOCODE as COUNTRY2_136_1_, country0_.COUNTRY_SUPPORTED as COUNTRY3_136_1_, geozone1_.GEOZONE_ID as GEOZONE1_142_0_, geozone1_.GEOZONE_CODE as GEOZONE2_142_0_, geozone1_.GEOZONE_NAME as GEOZONE3_142_0_ from SALESMANAGER.COUNTRY country0_ left outer join SALESMANAGER.GEOZONE geozone1_ on country0_.GEOZONE_ID=geozone1_.GEOZONE_ID where country0_.COUNTRY_ID=?

Hibernate: select zone0_.ZONE_ID as ZONE1_138_2_, zone0_.ZONE_CODE as ZONE2_138_2_, zone0_.COUNTRY_ID as COUNTRY3_138_2_, country1_.COUNTRY_ID as COUNTRY1_136_0_, country1_.GEOZONE_ID as GEOZONE4_136_0_, country1_.COUNTRY_ISOCODE as COUNTRY2_136_0_, country1_.COUNTRY_SUPPORTED as COUNTRY3_136_0_, geozone2_.GEOZONE_ID as GEOZONE1_142_1_, geozone2_.GEOZONE_CODE as GEOZONE2_142_1_, geozone2_.GEOZONE_NAME as GEOZONE3_142_1_ from SALESMANAGER.ZONE zone0_ inner join SALESMANAGER.COUNTRY country1_ on zone0_.COUNTRY_ID=country1_.COUNTRY_ID left outer join SALESMANAGER.GEOZONE geozone2_ on country1_.GEOZONE_ID=geozone2_.GEOZONE_ID where zone0_.ZONE_ID=?

[n4nd...@gmail.com]

hello sir,

           its give me email for create customer. in email password are blank.  if i use admin panel to reset Password?
           ok i use the reset passwod for customer its also give me email with rendom password. i use this password for Login but still not loign.

Thanks
Ravi

[shopizer]

Do you see the customer you have created in the database ?

What are the value you select in the country drop down and what is the province you select or key in ?

On Thursday, July 31, 2014 2:50:01 PM UTC-4, Chaker Chaker wrote:

[shopizer]

From what i see you do not have the code from the master branch but the earlier version fixed in master (2.0.0)

https://github.com/shopizer-ecommerce/shopizer/tree/master

[n4nd...@gmail.com]

Hi,

  yes, customer are display in Database but password field are null.

   
       I have select in the country drop down : Australia
       i have select in the province  : Victoria.

Thanks,
Ravi

[n4nd...@gmail.com]

Hi,

             i show u my Tomcat console u any idea regrading This...

INFO : com.salesmanager.web.utils.EmailTemplatesUtils - Sending welcome email to
 customer

DEBUG: com.salesmanager.web.utils.EmailTemplatesUtils - Sending email to ramesh

on their  registered email id some...@gmail.com
Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_149_0_, merchants
t1_.MERCHANT_ID as MERCHANT1_135_1_, merchantco0_.DATE_CREATED as DATE2_149_0_,
merchantco0_.DATE_MODIFIED as DATE3_149_0_, merchantco0_.UPDT_ID as UPDT4_149_0_
, merchantco0_.CONFIG_KEY as CONFIG5_149_0_, merchantco0_.TYPE as TYPE149_0_, me
rchantco0_.MERCHANT_ID as MERCHANT8_149_0_, merchantco0_.VALUE as VALUE149_0_, m
erchantst1_.STORE_CODE as STORE2_135_1_, merchantst1_.CONTINUESHOPPINGURL as CON
TINUE3_135_1_, merchantst1_.COUNTRY_ID as COUNTRY20_135_1_, merchantst1_.CURRENC
Y_ID as CURRENCY21_135_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_13

5_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_135_1_, merchantst1_.DOMAIN_NAME as
 DOMAIN5_135_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_135_1_, merchantst1_.INVO
ICE_TEMPLATE as INVOICE7_135_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_135_1_,
 merchantst1_.STORE_EMAIL as STORE9_135_1_, merchantst1_.STORE_LOGO as STORE10_1
35_1_, merchantst1_.STORE_TEMPLATE as STORE11_135_1_, merchantst1_.STORE_ADDRESS
 as STORE12_135_1_, merchantst1_.STORE_CITY as STORE13_135_1_, merchantst1_.STOR

E_NAME as STORE14_135_1_, merchantst1_.STORE_PHONE as STORE15_135_1_, merchantst
1_.STORE_POSTAL_CODE as STORE16_135_1_, merchantst1_.STORE_STATE_PROV as STORE17

_135_1_, merchantst1_.USE_CACHE as USE18_135_1_, merchantst1_.WEIGHTUNITCODE as

WEIGHTU19_135_1_, merchantst1_.ZONE_ID as ZONE23_135_1_ from SALESMANAGER.MERCHA
NT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1
_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHA
NT_ID=? and merchantco0_.CONFIG_KEY=? limit ?

 

Thanks

[shopizer]

Please use master branch, a fix was applied around the issue of permissions and password problem when using H2 database