Package: sitebar Version: 3.2.6-7 Severity: important Tags: patch
If you use mysql version 4.1 with sitebar, it will not allow you to add folders or links. Instead an error is thrown "Expected field 'nid_acl' was not filled!" I checked the forums at sitebar.org and found a fix, which is as follows: $ more /usr/share/sitebar/inc/tree.inc.php.patch 521c521 < $from = 'sitebar_root t natural join sitebar_node n'; --- > $from = 'sitebar_node n natural join sitebar_root t'; Seems kind of strange that the order of this sql statement would matter, but it does. From the discussion on the sitebar.org forum it seems that upstream is aware of this and is contacting mysql. Just to be sure that this is indeed a problem related to mysql 4.1, I installed sitebar 3.2.6 again on another debian box running mysql 4.0. That installation preformed flawlessly. Kevin -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.8-2-k7 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages sitebar depends on: ii apache [httpd] 1.3.33-4 versatile, high-performance HTTP s ii debconf 1.4.30.11 Debian configuration management sy ii php4 4:4.3.10-8 server-side, HTML-embedded scripti ii php4-mysql 4:4.3.10-8 MySQL module for php4 ii wwwconfig-common 0.0.42 Debian web auto configuration -- debconf information excluded
521c521 < $from = 'sitebar_root t natural join sitebar_node n'; --- > $from = 'sitebar_node n natural join sitebar_root t';