MV4a4 some problems

[Holm Tiffe <holm@freibergnet.de>]

Hi,

I have up and running (so far) the simple demo from MV4a4 with postgresql 6.5.3
on FreeBSD.

There are some problems with the DBI/DBD I think,

The first one is the construct in leftside:

<TD WIDTH="150" BGCOLOR="#c6a563" VALIGN="top" ALIGN="left"><FONT SIZE="1" FACE=
"Tahoma, Arial, Helvetica"><BR>
&nbsp;&nbsp;<A HREF="[if-cat-data cat url][cat-data cat url][else][area href=sca
n
        arg=|
        se=[cat-data cat selector]
        sf=category
        ml=3
        |][/else][/if-cat-data]" ALT="[cat-data cat name]"><B>[cat-data cat name
]</B></A><BR>
</FONT></TD>

even if I try to set the cat url manually to NULL's, the [area scan] is
never called.

I haven't had the time to look deeper on this problem jet...


The 2nd one is the automatic generation of indexes in the lib/Vend/Table/DBI.pm
in sub create around the line 166, Vend wishes to create an index ${key}_idx
for each table. Since the key for the most tables are called code, postgres
refuses to create more then one index named code_idx.

Changing the line

$db->do("create index ${key}_idx on $tablename ($key)")
        or ::logError("table %s index failed: %s" , $tablename, $DBI::errstr);

to something like

$db->do("create index ${tablename}_${key}_idx on $tablename ($key)")
        or ::logError("table %s index failed: %s" , $tablename, $DBI::errstr);

solves this problem since the indexes are now called like products_code_idx.

Sincerely,
Holm
-- 
FreibergNet Systemhaus GbR      Holm Tiffe  * Administration, Development
Systemhaus für Daten- und Netzwerktechnik           phone +49 3731 781279
Unternehmensgruppe Liebscher & Partner                fax +49 3731 781377
D-09599 Freiberg * Am St. Niclas Schacht 13    http://www.freibergnet.de/