I just installed it.
Â
This might be a stupid a question:
Â
Is it necessary to drop the entire database, to upgrade?
Â
se,
the installer complains with:
Â
Error loading database. The database error was
ERROR 1050 (42S01) at line 35: Table 'at_type' already exists
     Error loading database. The database error was
     ERROR 1050 (42S01) at line 35: Table 'at_type' already exists Â
and the "make install" process appears to be interrupted.
Â
Same with this newest version.
Â
I am able to start the newest version server anyway, but when I log in via the
front end, I get the error below.
Â
Is flushing the database the only way to fix this?
Â
tia
Â
============== quote bricolage error ====================
Â
An error occurred while processing your request:
Â
Unable to execute SQL statement
Â
DBD::mysql::st execute failed: Unknown column 'f.name' in 'field list' [for
Statement "
    SELECT f.id, f.name, f.priority, f.description, f.usr__id,
f.output_channel__id, f.tplate_type, f.element_type__id, f.category__id,
f.file_name, f.current_version, f.published_version, f.deploy_status,
f.deploy_date, f.expire_date, f.workflow__id, f.desk__id, f.active, f.site__id,
i.id, i.template__id, i.version, i.usr__id, i.data, i.file_name, i.note,
i.checked_out, COALESCE(group_concat(DISTINCT CASE WHEN m.grp__id <> 0 THEN
m.grp__id END SEPARATOR ' ')), COALESCE(group_concat(DISTINCT CASE WHEN
c.asset_grp_id <> 0 THEN c.asset_grp_id END SEPARATOR ' ')),
COALESCE(group_concat(DISTINCT CASE WHEN w.asset_grp_id <> 0 THEN w.asset_grp_id
END SEPARATOR ' '))
    FROM  template_instance i, template_member fm, member m, category c,
workflow w, template fÂ
    WHERE  f.id = i.template__id AND fm.object_id = f.id AND m.id =
fm.member__id AND m.active = '1' AND c.id = f.category__id AND f.workflow__id =
w.id AND f.current_version = i.version AND f.active = ? AND i.checked_out = ?
AND i.usr__id = ?
    GROUP  BY f.id, f.name, f.priority, f.description, f.usr__id,
f.output_channel__id, f.tplate_type, f.element_type__id, f.category__id,
f.file_name, f.current_version, f.published_version, f.deploy_status,
f.deploy_date, f.expire_date, f.workflow__id, f.desk__id, f.active, f.site__id,
i.id, i.template__id, i.version, i.usr__id, i.data, i.file_name, i.note,
i.checked_out
    ORDER BY f.deploy_date, f.id
" with ParamValues: 0=1, 1=1, 2='0'] at
/usr/local/bricolage6/lib/Bric/Util/DBI.pm line 1138, <GEN1> line 24.
Â
Stack:
  [/usr/local/bricolage6/lib/Bric/Util/DBI.pm:1138]
  [/usr/local/bricolage6/lib/Bric/Util/DBI.pm:758]
  [/usr/local/bricolage6/lib/Bric/Biz/Asset.pm:306]
  [/usr/local/bricolage6/comp/widgets/desk/desk.mc:51]
  [/usr/local/bricolage6/comp/workflow/profile/workspace/dhandler:10]
  [/usr/local/bricolage6/comp/dhandler:10]
  [/usr/local/bricolage6/comp/autohandler:7]
Â
============ end quote ==========================
Â
Â
Â
On February 10, 2011 at 12:37 AM Bret Dawson <bret@pectopah.com> wrote:
> Hi everybody,
>
> The Bricolage development team is pleased to announce that Bricolage
> 2.0.1 is available for download. This maintenance release contains a
> wealth of bugfixes and some exciting new features, and it slightly (but
> elegantly) tweaks the user interface. It's the best Bricolage yet.
>
> Download it now, right here: http://bricolagecms.org/downloads/
>
>
> (Extra thanks to David for his patience while I learned how to package a
> release. Next time, no training wheels!)
>
>
> Cheers,
>
> Bret
>
>
>
> --
> Bret Dawson
> Producer
> Pectopah Productions Inc.
> (416) 895-7635
> bret@pectopah.com
> www.pectopah.com
>