Copy and paste the above SQL code. Save the report follow error, *The following error was encountered:* The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details.
On Tue, 20 Jun 2023, 1:09 pm libr...@ssst.edu.ba, <libr...@ssst.edu.ba> wrote: > Hi Alvaro, > > What do you mean by discard items with no covers? I don’t want to discard > them; I want them to use the cover I upload for those records that don’t > have Amazon covers (mostly because they are titles published in my country > and are not available via big distributors). Or is that not what “discard” > means in this context? > > Best regards > > Aida Đikić > > > From: Alvaro Cornejo <cornejo.alv...@gmail.com> > Sent: Monday, June 19, 2023 4:34 PM > To: libr...@ssst.edu.ba > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Local covers and the Coverflow plugin > > Hi > > You need to "discard" items with no covers from your query. > > We use this: > > SELECT DISTINCT biblio.title, biblio.biblionumber, c.imagenumber AS > localcover > FROM items i > LEFT JOIN biblioitems USING (biblioitemnumber) > LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber) > LEFT JOIN biblioimages c ON (i.biblionumber=c.biblionumber) > WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND > biblioitems.isbn IS NOT NULL AND c.imagenumber != '' > ORDER BY rand() > LIMIT 50 > > Hope helps > > Regards > > Alvaro > > > > |----------------------------------------------------------------------------------------| > [ > https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQbsF7Zq7ukeIuapEB3QMlgOXKzxbFPpUQzsex8cwRRihwVw] > Stay safe / Cuídate/ Reste sécurisé > 7 Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > q Recycle always / Recicla siempre / Recyclez toujours > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le lun. 19 juin 2023 à 02:16, libr...@ssst.edu.ba<mailto: > libr...@ssst.edu.ba> <libr...@ssst.edu.ba<mailto:libr...@ssst.edu.ba>> a > écrit : > Hello Alvaro, > > I don't know how to do that, since I never even touched SQL before. I can > copy and paste code from the SQL list, but don’t really understand what it > does and how to change it to do what I need. > > I just checked the report, it is public. The code I'm using is from the > plugin configuration: > > SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title > FROM items i > LEFT JOIN biblioitems m USING (biblioitemnumber) > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND > m.isbn IS NOT NULL AND m.isbn != '' > GROUP BY biblionumber > HAVING isbn != "" > ORDER BY rand() > LIMIT 30 > > The instructions then go on to say: > > Note: You can add an additional column 'localcover' - this should be blank > if the biblio doesn't have a localcover and can contain any other data if > it does. If this column is populated a local cover will be used. Example > below: > > SELECT DISTINCT biblio.title, biblio.biblionumber, > SUBSTRING_INDEX(biblioitems.isbn, ' ', 1) AS isbn, c.imagenumber AS > localcover > FROM items > LEFT JOIN biblioitems USING (biblioitemnumber) > LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) > LEFT JOIN cover_images c ON (items.biblionumber=c.biblionumber) > WHERE biblioitems.isbn IS NOT NULL AND biblioitems.isbn !='' > ORDER BY RAND() > LIMIT 15; > > > But when I tried replacing the first code with the second, I didn't get > any results. Right now I'm back to the original code, and have turned the > local covers option off, so I have several "No image available" images. > Where do I change what to get local covers? > > Best regards > > Aida Đikić > > > From: Alvaro Cornejo <cornejo.alv...@gmail.com<mailto: > cornejo.alv...@gmail.com>> > Sent: Friday, June 16, 2023 4:27 PM > To: libr...@ssst.edu.ba<mailto:libr...@ssst.edu.ba> > Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > Subject: Re: [Koha] Local covers and the Coverflow plugin > > Hi Aida > > You only need to change/edit the report that pulls information for > coverflow. Also remember to define the report as public. > > Regards > > Alvaro > > > |----------------------------------------------------------------------------------------| > Stay safe / Cuídate/ Reste sécurisé > • Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > • Recycle always / Recicla siempre / Recyclez toujours > • Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le ven. 16 juin 2023 à 03:41, mailto:libr...@ssst.edu.ba<mailto: > libr...@ssst.edu.ba> <mailto:libr...@ssst.edu.ba<mailto: > libr...@ssst.edu.ba>> a écrit : > Hello again, > > I'm trying to find a way to have local covers show in the Coverflow plugin > on the OPAC page for titles not added via Z39.50. > > I had originally set it up using the first example in the configuration > (items added in the last 30 days), but going back I see there's another > example for adding additional columns. Since it said, "you can add an > additional column" I thought I was supposed to paste it below the already > existing code. That... ended up with an error yeah :) So I replaced it and > ran the report but could not get a local cover. > > What am I doing wrong this time? I uploaded the cover in the holdings > area. Is there another location I should do it instead? I checked old posts > on the mailing list, but could not find any solutions for this. I would > also like to work out a way to show covers of our collections (e.g. CS > textbooks, ECON textbooks, donated books etc.) but for that I need to > figure out lists?? > > I'm on Koha 23.05.00 and Ubuntu 22.04.2 LTS. > > Best regards > > Aida Đikić > _______________________________________________ > > Koha mailing list http://koha-community.org > mailto:Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha