Package: zoph
Version: 0.7.1-1
Severity: grave
Justification: renders package unusable
For several operations, such as "albums, "categories", "search", "import"
an error message such as this
====
Unable to get records
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ' name' at line 1
SELECT a.*, album as name, min(p.date) as oldest, max(p.date) as newest,
min(p.timestamp) as first, max(p.timestamp) as last, min(rating) as lowest,
max(rating) as highest, avg(rating) as average,
rand() as random from zoph_albums as a LEFT JOIN zoph_photo_albums as pa ON
a.album_id=pa.album_id LEFT JOIN zoph_photos as p ON pa.photo_id=p.photo_id
WHERE parent_album_id=1 GROUP BY a.album_id
ORDER BY , name
====
is displayed, and the operation is terminated. Note that there is a comma
directly after "ORDER BY", which is against SQL syntax. Looks like there
is a column name missing.
In addition, if I try to edit a user, I get:
===
Update failed:
Unknown column 'download' in 'field list'
update zoph_users set user_name = 'matija', person_id = '1', password =
password('****'), user_class = '0', browse_people = '1', browse_places = '1',
detailed_people = '1', detailed_places = '1',
import = '1', download = '0', leave_comments = '1' where user_id = '2'
===
(no, I didn't leave my password in there)
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.24-1-686 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=UTF-8) (ignored: LC_ALL set to en_GB.utf8)
Shell: /bin/sh linked to /bin/bash
Versions of packages zoph depends on:
ii apache2 2.2.8-3 Next generation, scalable, extenda
ii apache2-mpm-prefork 2.2.8-3 Traditional model for Apache HTTPD
ii imagemagick 7:6.3.7.9.dfsg1-2+b1 image manipulation programs
ii jhead 2.80-1 manipulate the non-image part of E
ii libapache2-mod-php5 5.2.5-3 server-side, HTML-embedded scripti
ii libdbd-mysql-perl 4.006-1 A Perl5 database interface to the
ii libdbi-perl 1.604-1 Perl5 database interface by Tim Bu
ii libimage-size-perl 3.1.1-2 determine the size of images in se
ii perl 5.8.8-12 Larry Wall's Practical Extraction
ii php5-gd 5.2.5-3 GD module for php5
ii php5-mysql 5.2.5-3 MySQL module for php5
ii unzip 5.52-11 De-archiver for .zip files
ii wwwconfig-common 0.1.0 Debian web auto configuration
zoph recommends no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
