Thread: [Slashcode-development] bugs in postgresql version.

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

hey,

with the CVS'ed 3 hours ago version of slash, i get the following errors wh=
en
attempting to install-slashsite with postgresql 7.0.2:
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "default": can't parse "de=
fault"=0D
Failed on :INSERT INTO templates VALUES ('','previewSlashbox','users','defa=
ult','eng','[% INCLUDE titlebar %]\r\n\r\nWhat you see on the right hand si=
de is a preview of the block thingee\r\nlabeled \"[% FILTER strip_literal; =
block.title; END %]\".  If you select it from the\r\n<A HREF=3D\"[% constan=
ts.rootdir %]/users.pl?op=3Dpreferences\">Preferences Page</A>,\r\nyou will=
 have that little block added to the right hand side of your\r\n<A HREF=3D\=
"[% constants.rootdir %]/index.pl\">Custom [% constants.sitename %]</A> pag=
e.\r\nExciting?  Not really, but its a great way to waste time.\r\n\r\n[% I=
F is_editable %]\r\n <P>Edit <A HREF=3D\"[% constants.rootdir %]/admin.pl?o=
p=3Dblocked&bid=3D[% form.bid %]\">[% form.bid %]</A>\r\n[% END %]\r\n\r\n =
     </TD><TD WIDTH=3D\"180\" VALIGN=3D\"TOP\">\r\n',10000,'Preview a slash=
box\r\n\r\n* title =3D passed to titlebar\r\n* width =3D passed to titlebar=
\r\n* block =3D hashref of some block info (bid, title, block)\r\n* is_edit=
able =3D current user may edit box',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "default": can't parse "de=
fault"=0D
=0D
Failed on :INSERT INTO templates VALUES ('','footer','misc','light','eng','=
[% USE Slash %]\r\n<P>[% Slash.horizmenu() %]\r\n\r\n<FORM METHOD=3D\"GET\"=
 ACTION=3D\"[% constants.rootdir %]/search.pl\">\r\n  <INPUT TYPE=3D\"name\=
" NAME=3D\"query\" VALUE=3D\"\" WIDTH=3D\"20\" SIZE=3D\"20\" LENGTH=3D\"20\=
">\r\n  <INPUT TYPE=3D\"submit\" VALUE=3D\"Search [% constants.sitename %]\=
">\r\n</FORM>\r\n\r\n[% INCLUDE motd %]\r\n\r\n<P> All trademarks and copyr=
ights on this\r\n  page are owned by their respective companies.  Comments\=
r\n  are owned by the Poster.\r\n \r\n</BODY>\r\n</HTML>\r\n',10000,'Footer=
 for light mode.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','header','misc','light','eng','=
[% USE Slash %]\r\n</HEAD>\r\n<BODY>\r\n\r\n<H1>[% constants.sitename %]</H=
1>\r\n\r\n<H2>[% constants.slogan %]</H2>\r\n\r\n<A HREF=3D\"[% constants.r=
ootdir %]/\"><IMG SRC=3D\"[% constants.rdfimg %]\" BORDER=3D\"0\"></A>\r\n\=
r\n<P>[% Slash.horizmenu() %]</P>\r\n',10000,'Header for light mode.',NULL)=
;:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','index','index','light','eng','=
[% stories %]\r\n\r\n<P>\r\n\r\n[% UNLESS user.noboxes; boxes; END %]\r\n',=
10000,'Index for light mode.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','storylink','index','light','en=
g','<P><B>(</B> [% links.join(\' | \') %] <B>)</B></P>\r\n',10000,'Story li=
nk for light mode.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','dispStory','misc','light','eng=
','[% INCLUDE titlebar %]\r\n\r\n<A HREF=3D\"[% constants.rootdir %]/search=
.pl?topic=3D[% topic.tid %]\">[% topic.tid %]</A> | \r\n<B>Posted by [% aut=
hor.nickname %] [% user.aton %] [% story.storytime %]</B><BR>\r\n\r\n<FONT =
SIZE=3D\"2\"><B>from the [% story.dept %] dept.</B></FONT><BR>\r\n\r\n[% st=
ory.introtext %]\r\n',10000,'Display story for light mode.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','titlebar','misc','light','eng'=
,'<H2>[% title %]</H2>',10000,'Titlebar for light mode.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','fancybox','misc','light','eng'=
,'<H3>[% title %]</H3><P>[% contents %]</P>',10000,'Fancybox for light mode=
.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  pg_atoi: error in "light": can't parse "ligh=
t"=0D
Failed on :INSERT INTO templates VALUES ('','dispComment','misc','light','e=
ng','        <TR>\r\n                <TD>\r\n         <A NAME=3D\"[% cid %]=
\"><H4>[% subject %]</H4></A>\r\n  by [% nickname %] on [% time %]\r\n     =
      [% UNLESS user.noscores %] (Score:[% points %][% IF reason %], [% con=
stants.reasons.$reason %][% END %])[% END %]\r\n  <BR>\r\n  [% UNLESS is_an=
on %](<A HREF=3D\"[% constants.rootdir %]/users.pl?op=3Duserinfo&nick=3D[% =
FILTER fixparam; nickname; END %]\">User #[% uid %] Info</A>)[% END %]\r\n =
             [% IF homepage && homepage.length > 8 %]<A HREF=3D\"[% homepag=
e %]\">[% homepage %]</A>[% END %]\r\n  <P>[% comment %]\r\n             </=
TD>\r\n       </TR>\r\n',10000,'Display comment for light mode.',NULL);:=0D
DBD::Pg::db do failed: ERROR:  Relation 'users' does not have attribute 'au=
thor'=0D

a couple screenfulls of this, i guess that it's the fault of postgresql sch=
ema
not being up to date.  when is it going to be fixed?

i've mailed a larger bug report (the whole log + some other bugs) to brian,
but didn't get any response.

greetings,
Wojtek

Thread: [Slashcode-development] bugs in postgresql version.

slashcode-development