[opencms-dev] Errormessages during import of the Howto Mod_proxy?

[Jonathan Woods]

It might have something to do with the maximum packet size MySQL is
allowing.  For versions 3 and 4, and for all I know 5, the answer is to set
the MySQL system variable max_allowed_packet to a value of at least 16
megabytes.  You can do this in the my.cnf or my.ini file which controls your
MySQL installation, or from the MySQL command prompt.
 
Jon

  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jakob Lemler
Sent: 07 November 2006 17:23
To: opencms-dev at opencms.org
Subject: [opencms-dev] Errormessages during import of the Howto Mod_proxy?


hi,
 
when I try to import the

Alkacon OpenCms 6 Howto: Setting up httpd, Tomcat and mod_proxy Module
into OpenCms 6.2.2 with mysql 5.0.27, I get the following error-messages:
 
Fehler org.opencms.db.CmsDbSqlException: Error creating project "Import of
module com.alkacon.documentation.howto_httpd_tomcat_modproxy".
at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1027
)
at org.opencms.file.CmsObject.createProject(CmsObject.java:566)
at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:324)
at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:620)
at
org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportT
hread.java:91)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: com.mysql.jdbc.ServerPreparedStatement[27] -
INSERT INTO CMS_PROJECTS
(PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_NAME,PROJECT_DE
SCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
(161,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6-b188-3bac3da
54580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',161,'Import of module
com.alkacon.documentation.howto_httpd_tomcat_modproxy','System generated
project to import module
"com.alkacon.documentation.howto_httpd_tomcat_modproxy".',0,1162919707335,1)
. 
at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
179)
at org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:1404)
at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1024
)
... 4 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too
long for column 'PROJECT_NAME' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
....
 
Any Hints?
 
regards
    Jakob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20061107/ad008975/attachment.htm>