<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Nachricht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=477050519-07112006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=477050519-07112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=477050519-07112006><FONT face=Arial
color=#0000ff size=2>Jon</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Jakob
Lemler<BR><B>Sent:</B> 07 November 2006 17:23<BR><B>To:</B>
opencms-dev@opencms.org<BR><B>Subject:</B> [opencms-dev] Errormessages during
import of the Howto Mod_proxy?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=616531517-07112006><FONT size=2><FONT face=Arial>h<SPAN
class=616531517-07112006>i,</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=616531517-07112006><SPAN class=616531517-07112006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN></SPAN> </DIV>
<DIV><SPAN class=616531517-07112006><FONT color=#0000ff><SPAN
class=616531517-07112006><FONT face=Arial color=#000000 size=2>when I try to
import the</FONT></DIV>
<DIV>
<TABLE class=references border=0>
<TBODY>
<TR>
<TD class=references-title align=left colSpan=2>
<DIV><FONT face=Arial><FONT size=2>Alkacon OpenCms 6 Howto<SPAN
class=616531517-07112006>:</SPAN> Setting up httpd, Tomcat and
mod_proxy<SPAN class=616531517-07112006> </SPAN><SPAN
class=616531517-07112006>Module</SPAN></FONT></FONT></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV></SPAN></FONT></SPAN><SPAN class=616531517-07112006><FONT face=Arial
size=2><SPAN class=616531517-07112006>into OpenCms 6.2.2 with mysql 5.0.27, I
get the following error-messages:</SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=616531517-07112006><FONT face=Arial color=#0000ff size=2><SPAN
class=616531517-07112006></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=616531517-07112006><FONT size=+0><SPAN
class=616531517-07112006><SPAN class=throw><FONT face=Arial size=2>Fehler
org.opencms.db.CmsDbSqlException: Error creating project "Import of module
com.alkacon.documentation.howto_httpd_tomcat_modproxy".<BR>at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)<BR>at
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)<BR>at
org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)<BR>at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1027)<BR>at
org.opencms.file.CmsObject.createProject(CmsObject.java:566)<BR>at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:324)<BR>at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:620)<BR>at
org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java:91)<BR>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_DESCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
(161,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6-b188-3bac3da54580','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).
<BR>at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:179)<BR>at
org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:1404)<BR>at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1024)<BR>...
4 more<BR>Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data
too long for column 'PROJECT_NAME' at row 1<BR>at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)<BR>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)<BR>....</FONT></SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=616531517-07112006><FONT face=Arial size=2><SPAN
class=616531517-07112006><SPAN
class=throw></SPAN></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=616531517-07112006><FONT face=Arial size=2><SPAN
class=616531517-07112006><SPAN class=throw>Any
Hints?</SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=616531517-07112006><FONT face=Arial size=2><SPAN
class=616531517-07112006><SPAN
class=throw></SPAN></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=616531517-07112006><FONT face=Arial size=2><SPAN
class=616531517-07112006><SPAN
class=throw>regards</SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=616531517-07112006><FONT face=Arial size=2><SPAN
class=616531517-07112006><SPAN class=throw>
Jakob</SPAN></SPAN></FONT></SPAN></DIV></BODY></HTML>