[jifty-devel] schema upgrade packet length limited
Stanislav Sinyagin
ssinyagin at yahoo.com
Fri Feb 15 05:43:42 EST 2008
bumped into the same problem again.
Any tips to where in the code those statements are generated?
----- Original Message ----
From: Stanislav Sinyagin <ssinyagin at yahoo.com>
To: jifty-devel at lists.jifty.org
Sent: Thursday, January 17, 2008 9:30:04 AM
Subject: [jifty-devel] schema upgrade packet length limited
(tested
with
Jifty
releasse
at
CPAN
and
current
SVN
too)
a
new
Model
package
has
been
created,
with
corresponding
since()
method:
==========================
use
strict;
use
warnings;
package
Toponet::Model::HardwareElement;
use
Jifty::DBI::Schema;
use
Toponet::Record
schema
{
column
deviceID
=>
refers_to
Toponet::Model::Device,
is
indexed,
is
mandatory,
since
'0.0.6';
column
parent
=>
refers_to
Toponet::Model::HardwareElement,
is
indexed,
since
'0.0.6';
column
elementDescription
=>
type
is
'varchar(255)',
is
mandatory,
since
'0.0.6';
column
hardwareCategory
=>
type
is
'varchar(45)',
is
indexed,
is
mandatory,
since
'0.0.6';
column
usagePercent
=>
type
is
'int',
is
mandatory,
default
is
0,
since
'0.0.6';
};
use
Toponet::Mixin::PropertyOwner;
sub
since
{'0.0.6'}
===============================
schema
upgrade
command
produces
an
error
below.
It
looks
like
MySQL
server
receives
only
a
part
of
the
upgrade
command:
the
command
is
cut
at
the
second
INDEX
statement:
[root at lab1
Toponet]#
jifty
schema
--setup
ERROR
-
Toponet::Dispatcher
did
not
return
a
true
value;
assuming
it
was
a
dispatcher
rule
WARN
-
Application
schema
version
in
database
(0.0.4)
doesn't
match
application
schema
version
(0.0.6)
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.
Jifty
version
0.71129
up
to
date.
Jifty::Plugin::CSSQuery
version
0.0.1
up
to
date.
Jifty::Plugin::CompressedCSSandJS
version
0.0.1
up
to
date.
Jifty::Plugin::Halo
version
0.0.1
up
to
date.
INFO
-
Generating
SQL
to
upgrade
Toponet
0.0.4
database
to
0.0.6
INFO
-
Upgrading
through
0.0.5
INFO
-
Running
upgrade
script
INFO
-
Upgrading
through
0.0.6
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
';
CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;
CREATE
I'
at
line
10
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/DBI/Handle.pm
line
552.
WARN
-
Toponet::Handle=HASH(0xaa1174c)
couldn't
execute
the
query
'CREATE
TABLE
hardware_elements
(
id
INTEGER
NOT
NULL
AUTO_INCREMENT,
deviceID
integer
NOT
NULL
,
parent
integer
NULL
,
elementDescription
varchar(255)
NOT
NULL
,
hardwareCategory
varchar(45)
NOT
NULL
,
usagePercent
int
NOT
NULL
DEFAULT
0
,
PRIMARY
KEY
(id)
)
;
CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;
CREATE
INDEX
hardware_elements3
ON
hardware_elements
(
hardwareCategory
)
;
CREATE
INDEX
hardware_elements1
ON
hardware_elements
(
deviceID
)
;
'
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/DBI/Handle.pm
line
569.
error
updating
a
table:
Couldn't
execute
the
query
'CREATE
TABLE
hardware_elements
(
id
INTEGER
NOT
NULL
AUTO_INCREMENT,
deviceID
integer
NOT
NULL
,
parent
integer
NULL
,
elementDescription
varchar(255)
NOT
NULL
,
hardwareCategory
varchar(45)
NOT
NULL
,
usagePercent
int
NOT
NULL
DEFAULT
0
,
PRIMARY
KEY
(id)
)
;
CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;
CREATE
INDEX
hardware_elements3
ON
hardware_elements
(
hardwareCategory
)
;
CREATE
INDEX
hardware_elements1
ON
hardware_elements
(
deviceID
)
;
'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
';
CREATE
INDEX
hardware_elements2
ON
hardware_elements
(
parent
)
;
CREATE
I'
at
line
10
at
/usr/lib/perl5/site_perl/5.8.8/Jifty/Script/Schema.pm
line
623.
[root at lab1
Toponet]#
_______________________________________________
jifty-devel
mailing
list
jifty-devel at lists.jifty.org
http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jifty.org/pipermail/jifty-devel/attachments/20080215/1b2a6ee4/attachment-0001.htm
More information about the jifty-devel
mailing list