<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">bumped into the same problem again. <br>Any tips to where in the code those statements are generated?<br><br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Stanislav Sinyagin <ssinyagin@yahoo.com><br>To: jifty-devel@lists.jifty.org<br>Sent: Thursday, January 17, 2008 9:30:04 AM<br>Subject: [jifty-devel] schema upgrade packet length limited<br><br>
(tested
with
Jifty
releasse
at
CPAN
and
current
SVN
too)<br><br>a
new
Model
package
has
been
created,
with
corresponding
since()
method:<br><br>==========================<br>use
strict;<br>use
warnings;<br><br>package
Toponet::Model::HardwareElement;<br><br><br>use
Jifty::DBI::Schema;<br><br>use
Toponet::Record
schema
{<br>
<br>
column
deviceID
=> <br>
refers_to
Toponet::Model::Device,<br>
is
indexed,<br>
is
mandatory,<br>
since
'0.0.6';<br><br>
column
parent
=> <br>
refers_to
Toponet::Model::HardwareElement,<br>
is
indexed,<br>
since
'0.0.6';<br><br>
column
elementDescription
=><br>
type
is
'varchar(255)',<br>
is
mandatory,<br>
since
'0.0.6';<br>
<br>
column
hardwareCategory
=><br>
type
is
'varchar(45)',<br>
is
indexed,<br>
is
mandatory,<br>
since
'0.0.6';<br><br>
column
usagePercent
=><br>
type
is
'int',<br>
is
mandatory,<br>
default
is
0,<br>
since
'0.0.6';<br>};<br><br><br>use
Toponet::Mixin::PropertyOwner;<br><br>sub
since
{'0.0.6'}<br>===============================<br><br>schema
upgrade
command
produces
an
error
below.
It
looks
like
MySQL
server<br>receives
only
a
part
of
the
upgrade
command:
the
command
is
cut
at
the
second <br>INDEX
statement:<br><br>[root@lab1
Toponet]#
jifty
schema
--setup<br>ERROR
-
Toponet::Dispatcher
did
not
return
a
true
value;
assuming
it
was
a
dispatcher
rule<br>WARN
-
Application
schema
version
in
database
(0.0.4)
doesn't
match
application
schema
version
(0.0.6)<br>WARN
-
Automatically
upgrading
your
database
to
match
the
current
application
schema
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/Handle.pm
line
174.<br>Jifty
version
0.71129
up
to
date.<br>Jifty::Plugin::CSSQuery
version
0.0.1
up
to
date.<br>Jifty::Plugin::CompressedCSSandJS
version
0.0.1
up
to
date.<br>Jifty::Plugin::Halo
version
0.0.1
up
to
date.<br>INFO
-
Generating
SQL
to
upgrade
Toponet
0.0.4
database
to
0.0.6<br>INFO
-
Upgrading
through
0.0.5<br>INFO
-
Running
upgrade
script<br>INFO
-
Upgrading
through
0.0.6<br>WARN
-
DBD::mysql::st
execute
failed:
You
have
an
error
in
your
SQL
syntax;
check
the
manual
that
corresponds
to
your
MySQL
server
version
for
the
right
syntax
to
use
near
';<br><br>CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;<br><br>CREATE
I'
at
line
10
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/DBI/Handle.pm
line
552.<br>WARN
-
Toponet::Handle=HASH(0xaa1174c)
couldn't
execute
the
query
'CREATE
TABLE
hardware_elements
(<br>
id
INTEGER
NOT
NULL
AUTO_INCREMENT,<br>
deviceID
integer
NOT
NULL
,<br>
parent
integer
NULL
,<br>
elementDescription
varchar(255)
NOT
NULL
,<br>
hardwareCategory
varchar(45)
NOT
NULL
,<br>
usagePercent
int
NOT
NULL
DEFAULT
0
,<br>
PRIMARY
KEY
(id)<br>)<br>
;<br><br>CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;<br><br>CREATE
INDEX
hardware_elements3
ON
hardware_elements
(
hardwareCategory
)
;<br><br>CREATE
INDEX
hardware_elements1
ON
hardware_elements
(
deviceID
)
;<br>'
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/DBI/Handle.pm
line
569.<br>error
updating
a
table:
Couldn't
execute
the
query
'CREATE
TABLE
hardware_elements
(<br>
id
INTEGER
NOT
NULL
AUTO_INCREMENT,<br>
deviceID
integer
NOT
NULL
,<br>
parent
integer
NULL
,<br>
elementDescription
varchar(255)
NOT
NULL
,<br>
hardwareCategory
varchar(45)
NOT
NULL
,<br>
usagePercent
int
NOT
NULL
DEFAULT
0
,<br>
PRIMARY
KEY
(id)<br>)<br>
;<br><br>CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;<br><br>CREATE
INDEX
hardware_elements3
ON
hardware_elements
(
hardwareCategory
)
;<br><br>CREATE
INDEX
hardware_elements1
ON
hardware_elements
(
deviceID
)
;<br>'You
have
an
error
in
your
SQL
syntax;
check
the
manual
that
corresponds
to
your
MySQL
server
version
for
the
right
syntax
to
use
near
';<br><br>CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;<br><br>CREATE
I'
at
line
10
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/Script/Schema.pm
line
623.<br>[root@lab1
Toponet]# <br><br><br><br><br><br>_______________________________________________<br>jifty-devel
mailing
list<br><a ymailto="mailto:jifty-devel@lists.jifty.org" href="mailto:jifty-devel@lists.jifty.org">jifty-devel@lists.jifty.org</a><br><a href="http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel" target="_blank">http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel</a><br></div><br></div></div></body></html>