Your message dated Sun, 13 Apr 2008 10:27:42 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Re: Bug#475734: zoph: Multiple SQL errors (with latest mysql)
has caused the Debian Bug report #475734,
regarding zoph: Multiple SQL errors (with latest mysql)
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [EMAIL PROTECTED]
immediately.)
--
475734: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=475734
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
adding some info to clarify the (currently somewhat confusing) numbering
scheme:
On Sat, Apr 12, 2008 at 06:02:24PM +0200, Edelhard Becker wrote:
> [..] this looks like you did not yet update update your database. Do as root
> first backup your current version (see README.Debian step B1) and then
>
> # mysql -u zoph_admin --password=zoph_admin zoph <
> /usr/share/doc/zoph/zoph_update-0.8.sql
On Sat, Apr 12, 2008 at 06:20:57PM +0200, Matija Grabnar wrote:
> [..]
> mysql -u zoph_admin --password=zoph_admin zoph <
> /usr/share/doc/zoph/zoph_update-0.7.sql
> ERROR 1060 (42S21) at line 19: Duplicate column name 'allexif'
>
> Manually trying to apply the alter statements listed in that file I
> get an error for every line, which means those changes were already
> in effect.
On Sat, Apr 12, 2008 at 06:32:12PM +0200, Edelhard Becker wrote:
> [..] yes, have a look at upgrading.html: Zoph 0.7.1 is a preview
> release for 0.8, so you *really* have to uprade with zoph_update-0.8.sql!
On Sat, Apr 12, 2008 at 10:02:16PM +0200, Matija Grabnar wrote:
> [..] Ok, that worked. Thank you.
I'll try to add a note to NEWS.Debian on future database upgrades.
Greetings,
Edelhard
--
~
~
:wq
signature.asc
Description: Digital signature
--- End Message ---
