Michael04
Зарегистрирован: 30.11.2010 Сообщения: 7
|
Добавлено: Вт Ноя 30, 2010 2:03 pm Заголовок сообщения: Ошибка при регистрации нового участника |
|
|
Пытаюсь зарегистрироваться. После того, как заполнил все поля корректно, жму кнопку "Зарегитрировать" После вылазит "Ошибка работы с БД" и ниже некоторая информация. которая как мне кажется поможет в решении этой проблемы:
Ошибка доступа к БД: com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: Data truncation: Data too long for column 'schoolname' at row 1
Query being executed when exception was thrown:
INSERT INTO logins(is_anonymous, is_reserved, is_activated, is_confirmed, login, email, email_checked, name, role, pwdmethod, pwdsalt, password, capabilities, ro_mask, surname, firstname, middlename, gender, birthdate, country, region, district, city, schooltype, schoolname, schoolnum, acad_year, acad_group, teacher_disc_id, occupation, zip, street, phone, status, grade, field0, field1, field2, field3, field4, field5, field6, field7, field8, field9, guid, user_quota, group_quota, sid, is_secure, remote_addr, is_complete, last_disc, create_time) VALUES(0, 0, 0, 0, 'euler3-10516', 'michaelxnovoselov@gmail.com', 0, 'Михаил Новосёлов', 1, 0, 0, '2n65536m16g16384', null, 0, 'Новосёлов', 'Михаил', 'Геннадьевич', 1, '1996-12-04', 'Россия', 'Пермский край', null, 'Пермь', 0, 'Муниципальное Автономное Общеобразовательное Учреждение "Средняя общеобразовательная школа № 127 с углубленным изучением отдельных предметов"', 0, 0, null, 0, null, '614077', 'Бульвар Гагарина, 71а, кв.44', '3422632512', 0, 18, null, '89028070543', null, null, null, null, null, null, null, null, null, 0, 0, null, 0, null, 0, 0, NOW())
com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: Data truncation: Data too long for column 'schoolname' at row 1
Query being executed when exception was thrown:
INSERT INTO logins(is_anonymous, is_reserved, is_activated, is_confirmed, login, email, email_checked, name, role, pwdmethod, pwdsalt, password, capabilities, ro_mask, surname, firstname, middlename, gender, birthdate, country, region, district, city, schooltype, schoolname, schoolnum, acad_year, acad_group, teacher_disc_id, occupation, zip, street, phone, status, grade, field0, field1, field2, field3, field4, field5, field6, field7, field8, field9, guid, user_quota, group_quota, sid, is_secure, remote_addr, is_complete, last_disc, create_time) VALUES(0, 0, 0, 0, 'euler3-10516', 'michaelxnovoselov@gmail.com', 0, 'Михаил Новосёлов', 1, 0, 0, '2n65536m16g16384', null, 0, 'Новосёлов', 'Михаил', 'Геннадьевич', 1, '1996-12-04', 'Россия', 'Пермский край', null, 'Пермь', 0, 'Муниципальное Автономное Общеобразовательное Учреждение "Средняя общеобразовательная школа № 127 с углубленным изучением отдельных предметов"', 0, 0, null, 0, null, '614077', 'Бульвар Гагарина, 71а, кв.44', '3422632512', 0, 18, null, '89028070543', null, null, null, null, null, null, null, null, null, 0, 0, null, 0, null, 0, 0, NOW())
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3513)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1949)
at ru.mccme.sch911.cache.LoginCache.create(LoginCache.java:263)
at ru.mccme.sch911.model.euler.NewUser.execute(NewUser.java:96)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:9
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:6
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:9
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:9
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:9
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:9
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at ru.mccme.sch911.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:19)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:835)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
at java.lang.Thread.run(Thread.java:662) |
|