You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@vcl.apache.org by Natalia Watanabe <na...@gmail.com> on 2009/09/15 02:43:50 UTC

vcl.sql fails inserting dumping data for table variable

Hello,


I want to report a bug on revision 813875 of vcl.sql. the script fails when
trying to execute this insert:

INSERT INTO `variable` (`id`, `name`, `serialization`, `value`) VALUES
(1, 'schema-version', 'none', '1');

The reason is column 'serialization' doesn't exists. Commenting this the
script works perfectly.


Kind regards,
Natalia Watanabe

Re: vcl.sql fails inserting dumping data for table variable

Posted by Natalia Watanabe <na...@gmail.com>.
Hi Josh,


Thank you for the update. At the moment it's easy to add the column, like
this:

ALTER TABLE `variable`
ADD COLUMN `serialization` enum('none','yaml','phpserialize') NOT NULL
default 'none';

but the INSERT sentence is still failing, due to `timestamp` column which is
not null. I've modified the insert to fill this column:

INSERT INTO `variable` (`id`, `name`, `serialization`, `value`, `timestamp`)
VALUES (1, 'schema-version', 'none', '1', now());

I don't know if this is correct, but at least works. I hope this information
is useful.

2009/9/15 Josh Thompson <jo...@ncsu.edu>

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Natalia,
>
> Thanks for the bug report.  I've updated the definition of the variable
> table
> to include the serialization field (I missed it when I checked it in a few
> days ago).  You should go ahead and modify your schema to include this
> field.
>
> Josh
>
> On Monday September 14, 2009, Natalia Watanabe wrote:
> > Hello,
> >
> >
> > I want to report a bug on revision 813875 of vcl.sql. the script fails
> when
> > trying to execute this insert:
> >
> > INSERT INTO `variable` (`id`, `name`, `serialization`, `value`) VALUES
> > (1, 'schema-version', 'none', '1');
> >
> > The reason is column 'serialization' doesn't exists. Commenting this the
> > script works perfectly.
> >
> >
> > Kind regards,
> > Natalia Watanabe
> - --
> - -------------------------------
> Josh Thompson
> Systems Programmer
> Advanced Computing | VCL Developer
> North Carolina State University
>
> Josh_Thompson@ncsu.edu
> 919-515-5323
>
> my GPG/PGP key can be found at pgp.mit.edu
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFKr40AV/LQcNdtPQMRAvprAJ9TTROFmP50Tb1V1P2jw9c77b0jMwCfcXHt
> QbKlde1K3u3dZv1vjS0iSfA=
> =AT3v
> -----END PGP SIGNATURE-----
>



-- 
Kind regards,
Natalia Watanabe

Re: vcl.sql fails inserting dumping data for table variable

Posted by Josh Thompson <jo...@ncsu.edu>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Natalia,

Thanks for the bug report.  I've updated the definition of the variable table 
to include the serialization field (I missed it when I checked it in a few 
days ago).  You should go ahead and modify your schema to include this field.

Josh

On Monday September 14, 2009, Natalia Watanabe wrote:
> Hello,
>
>
> I want to report a bug on revision 813875 of vcl.sql. the script fails when
> trying to execute this insert:
>
> INSERT INTO `variable` (`id`, `name`, `serialization`, `value`) VALUES
> (1, 'schema-version', 'none', '1');
>
> The reason is column 'serialization' doesn't exists. Commenting this the
> script works perfectly.
>
>
> Kind regards,
> Natalia Watanabe
- -- 
- -------------------------------
Josh Thompson
Systems Programmer
Advanced Computing | VCL Developer
North Carolina State University

Josh_Thompson@ncsu.edu
919-515-5323

my GPG/PGP key can be found at pgp.mit.edu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFKr40AV/LQcNdtPQMRAvprAJ9TTROFmP50Tb1V1P2jw9c77b0jMwCfcXHt
QbKlde1K3u3dZv1vjS0iSfA=
=AT3v
-----END PGP SIGNATURE-----