Hi list, recently I had to make some modifications to the chart subscriber of my openser to be able to use the CDRTool, now when I make an user with the serMyAdmin-BETA-1.0.war it shows me an error :
please they can help me with this problem?
best regards
rickygm
Grails Runtime Exception Error Details [leonardo]Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [User]; uncategorized SQLException for SQL [insert into subscriber (version, password_hash, auth_username, rpid, datetime_created, domain_id, domain, email_address, first_name, ha1, ha1b, last_name, username, password, role_id, class) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'User')]; SQL state [HY000]; error code [1364]; Field 'quota' doesn't have a default value; nested exception is java.sql.SQLException: Field 'quota' doesn't have a default value Class: UserController
Hi Ricky, SerMyAdmin seems not ready to use the "quota" field. You can try to add a default value to the quota field in the mysql table definition. We are going to check the interaction of serMyAdmin with CDRTool. Flavio
--- Em ter, 25/11/08, Ricky Gutierrez xserverlinux@yahoo.com escreveu:
De: Ricky Gutierrez xserverlinux@yahoo.com Assunto: serMyAdmin 1.0 Beta error Para: users@lists.kamailio.org Cc: glwgoes@gmail.com, "Flavio Goncalves" flavio@asteriskguide.com Data: Terça-feira, 25 de Novembro de 2008, 4:00
Hi list, recently I had to make some modifications to the chart subscriber of my openser to be able to use the CDRTool, now when I make an user with the serMyAdmin-BETA-1.0.war it shows me an error :
please they can help me with this problem?
best regards
rickygm
Grails Runtime Exception Error Details [leonardo]Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [User]; uncategorized SQLException for SQL [insert into subscriber (version, password_hash, auth_username, rpid, datetime_created, domain_id, domain, email_address, first_name, ha1, ha1b, last_name, username, password, role_id, class) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'User')]; SQL state [HY000]; error code [1364]; Field 'quota' doesn't have a default value; nested exception is java.sql.SQLException: Field 'quota' doesn't have a default value Class: UserController
ok thanks flavio, but really already I made the change in the table quota, but serMyAdmin still does not work to me, I hope that soon they solve the problem ...
best regards
rickygm
________________________________ From: Flavio Goncalves flavio@asteriskguide.com To: users@lists.kamailio.org; Ricky Gutierrez xserverlinux@yahoo.com Cc: glwgoes@gmail.com; leonardoborges@voffice.com.br Sent: Tuesday, November 25, 2008 3:48:35 AM Subject: Re: serMyAdmin 1.0 Beta error
Hi Ricky,
SerMyAdmin seems not ready to use the "quota" field. You can try to add a default value to the quota field in the mysql table definition. We are going to check the interaction of serMyAdmin with CDRTool.
Flavio
-
-
Flavio Goncalves -
Ricky Gutierrez