Bulk edit page 'broken' #45

Closed
lizdodd opened this Issue Jan 4, 2014 · 7 comments

Projects

None yet

2 participants

@lizdodd
lizdodd commented Jan 4, 2014

If I try to edit photos in bulk
eg http://billiau.net/zoph/edit_photos.php?album_id=267
I get blank under 'edit photos 1 to 24 of 35'

@jeroenrnl
Owner

I get 'insufficient permissions to edit photo', which is logical because I don't have edit rights on your photos. I'll check on my system.

@jeroenrnl jeroenrnl was assigned Jan 4, 2014
@jeroenrnl
Owner

On my system, in both Firefox and Chromium, the screen is not blank, but there is an error in the HTML, in edit_photos.php, the < at the end of line 314 is supposed to be at the beginning of line 315, this may confuse your browser...

@lizdodd
lizdodd commented Jan 6, 2014

Still no result (iceweasel, debian jessie/sid)
http://www.billiau.net/html/Screenshot1.png

@jeroenrnl
Owner

Could you turn on debugging and try again? Probably best is to go to the page, then edit config.inc.ph to set define('LOG_ALWAYS', log::DEBUG); and then reload the page, as navigating can be tough with a lot of debug messages.

@lizdodd
lizdodd commented Jan 8, 2014

Error: Incorrect language header in lang/zoph_strings.txt
Debug:

to create a new language file, translate these string and rename

this file

Notification: SELECT * FROM zoph_users ORDER BY user_name
Debug: user_id = 1
Debug: person_id = 1
Debug: user_class = 0
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 1
Debug: detailed_places = 1
Debug: import = 1
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id = 0
Debug: lastnotify = 0000-00-00 00:00:00
Debug: lastlogin = 2010-11-01 08:34:32
Debug: lastip = xxx
Debug: user_id = 7
Debug: person_id = 6
Debug: user_class = 0
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 1
Debug: detailed_places = 1
Debug: import = 1
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 1
Debug: allow_share = 1
Debug: lightbox_id = 240
Debug: lastnotify = 2009-12-04 20:10:57
Debug: lastlogin = 2013-08-05 14:36:48
Debug: lastip = xxx
Debug: user_id = 6
Debug: person_id = 5
Debug: user_class = 1
Debug: user_name = graham
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 1
Debug: detailed_places = 1
Debug: import = 1
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 1
Debug: allow_share = 1
Debug: lightbox_id =
Debug: lastnotify = 2009-11-28 18:58:50
Debug: lastlogin = 2013-01-01 15:40:32
Debug: lastip = xxx
Debug: user_id = 4
Debug: person_id = 28
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 0
Debug: browse_places = 0
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 0
Debug: import = 0
Debug: download = 0
Debug: leave_comments = 0
Debug: allow_rating = 0
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2009-11-01 21:33:39
Debug: lastlogin = 2014-01-08 20:04:16
Debug: lastip = xxx
Debug: user_id = 15
Debug: person_id = 44
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 0
Debug: import = 0
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2011-03-29 13:32:29
Debug: lastlogin =
Debug: lastip =
Debug: user_id = 16
Debug: person_id = 47
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 0
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 0
Debug: import = 0
Debug: download = 0
Debug: leave_comments = 1
Debug: allow_rating = 0
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2011-10-30 13:16:16
Debug: lastlogin = 2011-10-30 13:17:49
Debug: lastip = 192.168.79.133
Debug: user_id = 8
Debug: person_id = 0
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 0
Debug: browse_places = 0
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 0
Debug: import = 0
Debug: download = 0
Debug: leave_comments = 0
Debug: allow_rating = 0
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2009-12-06 20:28:02
Debug: lastlogin = 2011-12-05 14:47:57
Debug: lastip = xxx
Debug: user_id = 2
Debug: person_id = 3
Debug: user_class = 0
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 1
Debug: detailed_people = 1
Debug: detailed_places = 1
Debug: import = 1
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 1
Debug: allow_share = 1
Debug: lightbox_id = 239
Debug: lastnotify = 2009-11-01 18:40:19
Debug: lastlogin = 2014-01-08 20:07:15
Debug: lastip = 192.168.79.206
Debug: user_id = 10
Debug: person_id = 13
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 1
Debug: detailed_places = 1
Debug: import = 0
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2010-11-21 17:24:07
Debug: lastlogin = 2013-02-22 07:17:57
Debug: lastip = xxx
Debug: user_id = 12
Debug: person_id = 57
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 1
Debug: import = 0
Debug: download = 0
Debug: leave_comments = 0
Debug: allow_rating = 1
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2011-02-12 21:02:29
Debug: lastlogin = 2011-10-13 21:24:51
Debug: lastip = xxx
Debug: user_id = 9
Debug: person_id = 76
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 1
Debug: import = 0
Debug: download = 0
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 0
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2010-06-15 11:18:37
Debug: lastlogin = 2011-08-29 20:40:37
Debug: lastip = 59.167.223.93
Debug: user_id = 3
Debug: person_id = 4
Debug: user_class = 0
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 1
Debug: browse_places = 1
Debug: browse_tracks = 1
Debug: detailed_people = 1
Debug: detailed_places = 1
Debug: import = 1
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 1
Debug: allow_share = 1
Debug: lightbox_id = 241
Debug: lastnotify = 2009-11-01 18:41:10
Debug: lastlogin = 2013-06-25 20:19:03
Debug: lastip = xxx
Debug: user_id = 14
Debug: person_id = 53
Debug: user_class = 1
Debug: user_name = xxx
Debug: password = xxx
Debug: browse_people = 0
Debug: browse_places = 1
Debug: browse_tracks = 0
Debug: detailed_people = 0
Debug: detailed_places = 0
Debug: import = 0
Debug: download = 1
Debug: leave_comments = 1
Debug: allow_rating = 1
Debug: allow_multirating = 1
Debug: allow_share = 0
Debug: lightbox_id =
Debug: lastnotify = 2011-03-08 08:32:49
Debug: lastlogin = 2011-03-09 19:19:22
Debug: lastip = 192.168.79.133
Notification: SELECT * FROM zoph_users WHERE user_id = '1'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '7'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '6'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '4'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '15'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '16'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '8'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '10'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '12'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '9'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '3'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '14'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '1'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '7'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '6'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '4'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '15'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '16'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '8'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '10'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '12'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '9'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '3'
Debug: GET user_class
Debug: GET user_id
Debug: GET user_name
Notification: SELECT * FROM zoph_users WHERE user_id = '14'
Debug: GET user_class
Notification: SELECT conf_id, value FROM zoph_conf
Debug: GET color_scheme_id
Debug: GET color_scheme_id
Notification: SELECT * FROM zoph_color_schemes WHERE color_scheme_id =
'5' Debug: GET name
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_id
Notification: SELECT * FROM zoph_prefs WHERE user_id = '2'
Debug: GET person_id
Notification: SELECT * FROM zoph_people WHERE person_id = '3'
Debug: GET home_id
Debug: GET work_id
Debug: GET num_cols
Debug: GET num_rows
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Notification: select count(distinct ph.photo_id) from zoph_photos as ph
JOIN zoph_photo_albums as pa on pa.photo_id = ph.photo_id where
(pa.album_id in (15)) Notification: select distinct ph.photo_id,
ph.name, ph.path, ph.width, ph.height from zoph_photos as ph JOIN
zoph_photo_albums as pa on pa.photo_id = ph.photo_id where (pa.album_id
in (15)) order by ph.date asc, ph.time asc, ph.photo_id asc limit 0, 24
Debug: photo_id = 27105 Debug: name = out3271.jpeg Debug: path =
2011/05/17 Debug: width = 6962 Debug: height = 4616 Debug: photo_id =
27106 Debug: name = out3272.jpeg
Debug: path = 2011/05/17
Debug: width = 4680
Debug: height = 6912
Debug: photo_id = 27107
Debug: name = out3273.jpeg
Debug: path = 2011/05/17
Debug: width = 6846
Debug: height = 4664
Debug: photo_id = 27108
Debug: name = out3274.jpeg
Debug: path = 2011/05/17
Debug: width = 6846
Debug: height = 4680

Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Debug: GET lightbox_id
Debug: GET lightbox_id
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Notification: SELECT * FROM zoph_users WHERE user_id = '2'
Debug: GET user_class
Debug: GET user_id
home
albums
categories
people
places
photos
lightbox
search
import
admin
reports
prefs
about
logout

Debug: GET show_breadcrumbs
Debug: GET num_breadcrumbs
x

Home
Albums
SES
Photos (Page 1/1)
Edit Photos (Page 1/1) 

return edit photos 1 to 4 of 4

Debug: GET autocomp_categories

@lizdodd
lizdodd commented Jan 8, 2014

looks like an old version of zoph_strings.txt hanging around
I'm not sure why the file was copied to the wrong place on the update, but it has been.
Correct file copied over, but still no change in the DEBUG message

@jeroenrnl
Owner

I have the issue reproduced on my system. Working on a fix, as a workaround, if you turn on autocomplete in the configuration screen, it works.

@jeroenrnl jeroenrnl added a commit that closed this issue Jan 9, 2014
@jeroenrnl Added selectArray cache to zophTable
The SA cache was missing from zophTable and the call to build it
referred to a wrong function name, causing an error when autocomplete is
switched off.

Also added a simple testcase to test this in the future

fixes #45
8eec6a5
@jeroenrnl jeroenrnl closed this in 8eec6a5 Jan 9, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment