[Koha] On how to create a report

[catarinafrc]

Hey guys,

My question is how can I create a report to know how many books were
cataloged from Jan till now (or any other time period)? 
I have tried, but I find that the manual is not clear enough on this. all
the reports I created were not able to give me this info Thanks

[I still have 3.10 version, and NO I can't changed it now, so any help will
be much appreciated]


Thank you,




--
View this message in context: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] On how to create a report

[Chitralekha Chitale]

Hello 


Paste the following program in reports. 

SELECT CONCAT('',biblio.title,'')
 
AS Title, biblio.author AS Author, 
items.barcode AS Barcode 
FROM items 
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) 
WHERE 
DATE(items.dateaccessioned) BETWEEN <> 
AND <> 



I hope this will give the results you expect. 

For more reports visit 
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliographic_Reports
 

Mrs. Chitralekha Mahesh Chitale 
Librarian, LTCE, Navi Mumbai. 

- Original Message -

From: "catarinafrc [via Koha]"  
To: "Chitralekha Chitale"  
Sent: Friday, October 30, 2015 1:44:43 PM 
Subject: On how to create a report 

Hey guys, 

My question is how can I create a report to know how many books were cataloged 
from Jan till now (or any other time period)? 
I have tried, but I find that the manual is not clear enough on this. all the 
reports I created were not able to give me this info Thanks 

[I still have 3.10 version, and NO I can't changed it now, so any help will be 
much appreciated] 


Thank you, 



If you reply to this email, your message will be added to the discussion below: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html 
To start a new topic under Koha-general, email 
ml-node+s1045719n3047918...@n5.nabble.com 
To unsubscribe from Koha-general, click here . 
NAML 





--
View this message in context: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859364.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table

[Jonathan Druart]

Pedro,

Please answer to the list.
Yes it's the easy and lazy solution.
If you want to use MySQL 5.6, you must disable STRICT_TRANS_TABLES,
otherwise you will encounter some errors.
But we should take care of these errors and fix them.

Regards,
Jonathan

2015-10-29 16:51 GMT+00:00 Pedro Amorim :
> Hello Jonathan,
>
> Thank you for your reply.
>
> I have removed STRICT_TRANS_TABLES in both usr/my.cnf and etc/mysql/my.cnf
> and solved the following detected bugs:
> 1) Z39.50 import_records table insertion;
> 2) Z30.50 server creation with empty values on timeout and order;
> 3) Creating new category for patron -> Category already exists.
>
> And ( I imagine ) countless others.
>
> Let me know what you think about this, please.
>
> Thank you,
>
> Pedro Amorim
>
>
>
> 2015-10-29 7:20 GMT-01:00 Jonathan Druart
> :
>>
>> See all bug 13526 and the discussion on bug 5366
>> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523
>> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5366
>>
>> 2015-10-29 8:16 GMT+00:00 Jonathan Druart
>> :
>> > Hello Pedro,
>> >
>> > You should not use MySQL 5.6, some bugs are known: bug 13669 and bug
>> > 14637, and certainly some others.
>> > Until now nobody has shown a special interest for these issues.
>> >
>> > Regards,
>> > Jonathan
>> >
>> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
>> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637
>> >
>> > 2015-10-28 16:17 GMT+00:00 Pedro Amorim :
>> >> Also, some other thing to note:
>> >>
>> >> The mysql I'm running is 5.6.25.
>> >>
>> >> 2015-10-28 15:14 GMT-01:00 Pedro Amorim :
>> >>
>> >>> Hello,
>> >>>
>> >>> Version: Koha 3.2002000
>> >>>
>> >>> My name is Pedro Amorim and I've been implementing Koha for the first
>> >>> time
>> >>> for the past couple of days now.
>> >>>
>> >>> This is a fresh package install.
>> >>>
>> >>> This is a bug (I think) I stumbled upon and this is how I solved it:
>> >>> When performing a Z39.50 search I kept getting no records found
>> >>> despite
>> >>> the fact that I knew there were records (doing a yaz-client search and
>> >>> using the online demo returned results, so why didn't it return in my
>> >>> installation?).
>> >>>
>> >>> So I found out that the records should've been inserted in the
>> >>> import_records table but they weren't. Because marcxml_old wasn't
>> >>> being
>> >>> defined and it expected some value (NULL = NO), so I went in and
>> >>> changed
>> >>> the database structure to NULL = YES and everything is now working as
>> >>> expected.
>> >>>
>> >>> I think this also has something to do with mysql STRICT_TRANS_TABLES
>> >>> but I
>> >>> would like some confirmation on that.
>> >>>
>> >>> I'm new in the whole Koha scene and don't yet know how to submit bugs.
>> >>> I'm sending this mail in the hopes that someone confirms that this is
>> >>> indeed a bug and document the given solution.
>> >>>
>> >>> Cheers
>> >>>
>> >> ___
>> >> Koha mailing list  http://koha-community.org
>> >> Koha@lists.katipo.co.nz
>> >> https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] On how to create a report

[catarinafrc]

Thank you it worked!! You saved me!!

p.s. is there anything I can add so it gives me the information of how many
books each librarian cataloged?



Thank you so much





--
View this message in context: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859367.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Display question

[schnydszch]

How about for authorities? Are deleted authorities saved elsewhere? Or we can
do the same with authorities by setting matching rules. Will the new import
get the authid and controlfield '001' of the currently imported record? I'm
interested with this. Thanks!



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Display-question-tp5859291p5859352.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] On how to create a report

[catarinafrc]

Thank you!



--
View this message in context: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859377.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] On how to create a report

[Chitralekha Chitale]

You are most welcome Catarina. 

Please visit the link I sent. It gives many reports that we normally require. 
If you check the list item 6.86 and 6.87 are the reports you required. 

I hope either one will help you provided CataloguingLog to be on (setting in 
global system preferences, under log tab) 

Mrs. Chitralekha Mahesh Chitale 
Librarian, LTCE, Navi Mumbai. 

- Original Message -

From: "catarinafrc [via Koha]"  
To: "Chitralekha Chitale"  
Sent: Friday, October 30, 2015 2:23:42 PM 
Subject: Re: On how to create a report 

Thank you it worked!! You saved me!! 

p.s. is there anything I can add so it gives me the information of how many 
books each librarian cataloged? 



Thank you so much 




If you reply to this email, your message will be added to the discussion below: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859367.html
 
To start a new topic under Koha-general, email 
ml-node+s1045719n3047918...@n5.nabble.com 
To unsubscribe from Koha-general, click here . 
NAML 





--
View this message in context: 
http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859370.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Create a report that lists biblio number for a specific item type

[Charlotte Stock]

I've searched the forum but cannot find an SQL report that will allow me to
generate a list of biblio numbers for a specific item type (for example,
list all DVDs or list all Set Texts). Should I be creating a report for this
type of listing or should I be using another tool to create the information
I need?

Thanks in advance for your time
Charlotte



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Create-a-report-that-lists-biblio-number-for-a-specific-item-type-tp5859385.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difficulty filling out accounting info

[Jonathan Druart]

Hi Ann,

I confirm that it seems to work for me using 3.20.4 so it certainly
comes from your data.
Could you please make a screenshot of the form when you get the NaN
and give us the rate for the currency you use?

Regards,
Jonathan

2015-10-29 22:27 GMT+00:00 library :
> Good morning
>
> Ever since we were upgraded to 3.20.4 I have had difficulty filling out the
> accounting information for each item. I have found a work around for the
> books as I can can fill them out using the Uncertain Prices page then edit
> each item later, but I cannot do this for the subscriptions.
>
> Basically as soon as I enter the vendor price the rest of the price fields
> change to NaN (have no idea what this means) but the Budgeted cost and
> total cost fields are not editable. Then I cannot save because I get the
> error message -Total must be a number.
>
> Could anyone give me a hint as to what is wrong so I can tell our tech
> support where to look.
>
> Gratefully
>
> Ann Murphy
> Katikati College
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] On how to create a report

[Karam Qubsi]

Hi,
You may visit this wiki page :
http://wiki.koha-community.org/wiki/SQL_Reports_Library

and you can see all reports related to what you want  ,

we use the following 2 reports in our library :
they will give you the name of the cataloger as well but you must active
action log in your syspref  first :

Statistic for daily catalogers achievement in date range for bib records

   - *Developer:* Karam Qubsi
   - *Module:* Cataloging
   - *Purpose:* Statistic for daily catalogers achievement in date range
   for bib records (you can change the date range I make it for the whole 2014
   year in this example )
   - *Status:* Complete

SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date,
B.userid AS Staff,
count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON
I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD'
AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31'
 AND I.info='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC

change dates to the correct  range you want .

for items added you may try this report :
Statistic for daily catalogers achievement in date range for Item records

   - *Developer:* Karam Qubsi
   - *Module:* Cataloging
   - *Purpose:* Statistic for daily catalogers achievement in date range
   for item records (you can change the date range I make it for the whole
   2014 year in this example )
   - *Status:* Complete

SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date,
B.userid AS Staff,
count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON
I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD'
AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31'
 AND I.info='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC




*Best regards . *


On Fri, Oct 30, 2015 at 5:15 PM, catarinafrc 
wrote:

> Thank you!
>
>
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859377.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
*Karam Qubsi *

*Shah Alam , Malaysia . *
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Configuring smtp mail server to work with Koha

[Pedro Amorim]

Hello,

I want to configure an smtp server so that Koha can use it to send e-mail
notifications.
I was expecting some sort of configuration file where I would configure the
server, username, password and some other parameters but that is not the
case.

From my research I found 2 possible ways:
1) Editting /usr/share/perl5/Mail/Sendmail.pm file and inserting the smtp
server at the top of the file, but where do I insert the smtp credentials
(user/pass) in that same file? or
2) Through some postfix configuration which I really would like to avoid.

Would anyone shed some light on the matter or provide some sort of
guidelines on how to do this?

Thank you very much,

Pedro Amorim
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha Offline Circulation 1.3 Released!

[Kyle Hall]

Hello All,

I've updated the original desktop Koha Offline Circulation app for the
first time in 5 years!

Coeur d'Alene Public Library has sponsored the addition of a new feature.
The "Database" menu has now been renamed "Settings" and has a new option to
pre-set a default directory to save your .koc files in. When you set this
directory, by default the program will now save your files in that
directory with timestamp as the file name!

You can download the installer here:
https://github.com/bywatersolutions/koha-offline-circulation/releases

If you are upgrading from a previous version, you will want to uninstall
the old version first, as I had to create a new installer from scratch.
You'll also need to reselect your borrowers.db file if you had previously
selected one.

Kyle

http://www.kylehall.info
ByWater Solutions ( http://bywatersolutions.com )
Meadville Public Library ( http://www.meadvillelibrary.org )
Crawford County Federated Library System ( http://www.ccfls.org )
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Configuring smtp mail server to work with Koha

[Michael Kuhn]

Hi Pedro


However, Koha still doesn't send any e-mail when I manually add a new
patron.
NOTE:
1) AutoEmailOpacUser is set to "send" in administration -> patrons;
2) All cronjobs were left as default. I also know they are running because
my new records get indexed every 5 minutes.


You might try the following command (where xyxx is the name of your Koha 
instance).


# koha-email-enable xxx

Hope this helps, Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Configuring smtp mail server to work with Koha

[Pedro Amorim]

Hello Galen,

Thank you for your reply.
I have changed the Sendmail.pm file to point to smtp.gmail.com instead of
localhost and am now receiving these errors:

# koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/
process_message_queue.pl -v
koha: sending email message to patron: Admin at
/usr/share/koha/lib/C4/Letters.pm line 937.
koha: MAIL FROM: error (530 5.7.0 Must issue a STARTTLS command first.
uj4sm7521289wjc.34 - gsmtp
koha: )
koha: Server said: 530 5.7.0 Must issue a STARTTLS command first.
uj4sm7521289wjc.34 - gsmtp
koha:  at /usr/share/koha/bin/cronjobs/process_message_queue.pl line 66

I do not know much about configuring mail servers, should I keep the
Sendmail.pm file pointing to localhost and postfix takes care of the
redirecting?

Thanks again,

Pedro Amorim




2015-10-30 13:57 GMT-01:00 Galen Charlton :

> Hi,
>
> On Fri, Oct 30, 2015 at 10:40 AM, Pedro Amorim 
> wrote:
> > connect to localhost failed (Connection refused)
> > connect to localhost failed
> > connect to localhost failed (Connection refused) no (more) retries!
>
> Koha expects there to be an MTA listening on port 25 on localhost.
> Since you've got postfix already running, I suggest checking its
> configuration for that -- specifically, inet_interfaces (to ensure
> that it's listening on that interface) and mynetworks (to verify that
> it will accept connects from with your Koha server).
>
> Alternatively, if the only thing you need is for email to get
> forwarded to your mail smarthost, you could try nullmailer instead of
> postfix.
>
> Regards,
>
> Galen
> --
> Galen Charlton
> Infrastructure and Added Services Manager
> Equinox Software, Inc. / The Open Source Experts
> email:  g...@esilibrary.com
> direct: +1 770-709-5581
> cell:   +1 404-984-4366
> skype:  gmcharlt
> web:http://www.esilibrary.com/
> Supporting Koha and Evergreen: http://koha-community.org &
> http://evergreen-ils.org
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Zebra (Koha 3.20.05) - Run it as a cron job or use default daemon?

[Craig Butosi]

Hi all,

Koha 3.20.05 on Ubuntu 14.04 LTS x64 VPS (package install)

Was just wondering if it is still recommended to run zebra as a cron job 
(/usr/share/koha/bin/migration_tools/rebuild_zebra.pl) rather than using the 
zebraqueue. I've read older posts saying that this was case (ca. 2008-2013).

If it is recommended to run it as a cron job (as koha user of course), I read 
also that it is necessary to disable the zebraqueue to avoid conflicts. How 
would I do that? With <$ service koha-stop-zebra instancename>?

Thanks all!

C

Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
the royal conservatory
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca



Note: This email message and any attachments are intended only for the use of 
the individual to which it is addressed, and may contain information that is 
privileged, confidential and exempt from disclosure under applicable law. If 
the recipient of this email is not the intended recipient (or the employee or 
agent responsible for delivering the email to the intended recipient), you are 
hereby notified that any review, dissemination, distribution or copying or 
other use of this message is strictly prohibited. If you have received this 
communication in error, please notify the sender immediately by return email 
and delete this message and attachments from your system, thank you.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Configuring smtp mail server to work with Koha

[Pedro Amorim]

Hello Michael and Mark,

Thank you for your replies.
Silly me, I forgot to mention I had already run the command
koha-email-enable so that is not the reason.

UPDATE:
I had the following entry on the logs:

Use of uninitialized value $OPACBaseURL in substitution

$OPACBaseURL is a variable being used in the mail template so I'm guessing
this was part of the reason. But I configured the OPACBaseURL parameter in
the administration panel and still no e-mail is being sent. Although it
doesn't log the message anymore. Instead of waiting for the cronjob to
trigger, I ran:

/usr/share/koha/bin/cronjobs/process_message_queue.pl

Because I knew there was a record in message_queue with the status =
"pending", but after running the above command I got the following
message(s):

connect to localhost failed (Connection refused)
connect to localhost failed
connect to localhost failed (Connection refused) no (more) retries!

Cheers,

Pedro Amorim


2015-10-30 13:21 GMT-01:00 Mark Tompsett :

> Greetings,
>
> Assuming you installed using packages:
>
> http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-email-enable
>
> GPML,
> Mark Tompsett
>
> -Original Message- From: Pedro Amorim
> Sent: Friday, October 30, 2015 10:10 AM
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Configuring smtp mail server to work with Koha
>
>
> Update:
>
> I have installed and configured postfix on my machine and tested it using:
>
> echo "This is the body of the email" | mail -s "This is the subject line"
> u...@example.com
>
> So I know it's well configured and my server is able to send mails.
>
> However, Koha still doesn't send any e-mail when I manually add a new
> patron.
> NOTE:
> 1) AutoEmailOpacUser is set to "send" in administration -> patrons;
> 2) All cronjobs were left as default. I also know they are running because
> my new records get indexed every 5 minutes.
>
> 2015-10-30 12:28 GMT-01:00 Pedro Amorim :
>
> Hello,
>>
>> I want to configure an smtp server so that Koha can use it to send e-mail
>> notifications.
>> I was expecting some sort of configuration file where I would configure
>> the server, username, password and some other parameters but that is not
>> the case.
>>
>> From my research I found 2 possible ways:
>> 1) Editting /usr/share/perl5/Mail/Sendmail.pm file and inserting the smtp
>> server at the top of the file, but where do I insert the smtp credentials
>> (user/pass) in that same file? or
>> 2) Through some postfix configuration which I really would like to avoid.
>>
>> Would anyone shed some light on the matter or provide some sort of
>> guidelines on how to do this?
>>
>> Thank you very much,
>>
>> Pedro Amorim
>>
>> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.20.03 - koha-opac-error_log

[Mengu Yazicioglu]

Hi Ozkan,

This should be related with that you didn't choose a Library in Opac 
interface.

/
/
On 29-10-2015 14:15, Ozkan OZMEN wrote:

Hi all,

I have 2 errors at koha-opac-error_log at below:

[Thu Oct 29 13:41:00 2015] opac-search.pl: C4::Context->userenv not defined! at 
/usr/share/koha/lib/C4/Items.pm line 1355.

[Thu Oct 29 13:53:31 2015] opac-detail.pl: C4::Context->userenv not defined! at 
/usr/share/koha/lib/C4/Items.pm line 1355., referer: https://www.google.com.tr/

I searched these errors but I didn't found about it. What does these means? How 
can I solve these errors?

Thanks to all helps...


Regards,
Özkan ÖZMEN
CENTER OF LIBRARY
BALIKESİR UNIVERSITY - TURKEY





___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.20.03 - koha-opac-error_log

[Mark Tompsett]

Greetings,

The file name is a partial misnomer. Warnings and errors go into this file.

[Thu Oct 29 13:41:00 2015] opac-search.pl: C4::Context->userenv not 
defined! at /usr/share/koha/lib/C4/Items.pm line 1355.
[Thu Oct 29 13:53:31 2015] opac-detail.pl: C4::Context->userenv not 
defined! at /usr/share/koha/lib/C4/Items.pm line 1355., referer: 
https://www.google.com.tr/
I searched these errors but I didn't found about it. What does these 
means? How can I solve these errors?


These two messages are WARNINGS. If you had opac logins enabled, and you 
logged in, you would find that these messages would not be triggered.
Yes, these will fill the logs, but that is the real problem to solve, not 
the messages themselves.


Also, you didn't state what version of Koha you are using, because it is 
likely line 1363 in master.


GPML,
Mark Tompsett 


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Changing IP on Koha Server

[Doug Dearden]

Hi Greg,

You don't say which distro you are using.  On my Debian install, I have the IP 
addresses I use statically defined in /etc/network/interfaces .  I would check 
there first.

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of G P Ashe
Sent: Friday, October 30, 2015 9:07 AM
To: koha-user 
Subject: [Koha] Changing IP on Koha Server

I need to change the fixed IP on Koha server.

What files need to be updated manually in order that everything will work as 
before but with new IP (different subnet).

Thanks

Greg

-- 


*Disclaimer Important*: ​
Information in this email (including attachments) is confidential. It is 
intended for receipt and consideration only by the intended recipient. If you 
are not an addressee or intended recipient, any use, dissemination, 
distribution, disclosure, publication or copying of information contained in 
this email is strictly prohibited. Opinions expressed in this email may be 
personal to the author and are not necessarily the opinions of *Glenstal Abbey 
School Ltd*. If this email has been received by you in error we would be 
grateful if you could immediately notify the sender, and thereafter delete this 
e-mail from your system.  You are requested to carry out your own virus check 
before opening any attachment. The author and *Glenstal Abbey School Ltd* 
accept no liability for any loss or damage which may be caused by viruses, 
malware or malicious software.
​ Please consider the environment before printing this email.​ 
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.20.03 - koha-opac-error_log

[Ozkan OZMEN]

Hi Mengu,

Thanks for your interest. So these errors doesn't important for us.
Good works.

Regards,
Özkan ÖZMEN
CENTER OF LIBRARY
BALIKESIR UNIVERSITY - TURKEY
YASAL UYARI:
Bu elektronik posta ve onunla iletilen butun dosyalar kisiye ozeldir ve sadece 
gondericisi tarafindan almasi amaclanan yetkili gercek ya da tuzel kisinin 
kullanimi icindir. Eger soz konusu yetkili alici siz degilseniz bu elektronik 
postanin icerigini aciklamaniz, kopyalamaniz, yonlendirmeniz ve kullanmaniz 
kesinlikle yasaktir. Bu mesajin gonderilmek istendigi kisi degilseniz (ya da bu 
e-posta'yi yanlislikla aldiysaniz), lutfen yollayan kisiyi haberdar ediniz ve 
mesaji sisteminizden derhal siliniz. Kurumumuz, bu mesajin icerdigi bilgilerin 
dogrulugu veya eksiksiz oldugu konusunda herhangi bir garanti vermemektedir. Bu 
nedenle bu epostanin ne sekilde olursa olsun iceriginden, iletilmesinden, 
alinmasindan ve saklanmasindan kurumumuz sorumlu degildir. Bu mesajdaki 
gorusler yalnizca gonderen kisiye ait olup, her zaman kurumumuzun goruslerini 
yansitmayabilir. 
Bu e-posta, bilinen butun bilgisayar viruslerine karsi anti-virus sistemimiz 
tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin virus 
icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hukuki ve 
mali hic bir sorumlulugu kabul etmez.

DISCLAIMER:
This e-mail and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you are not the intended recipient you are hereby notified that any 
dissemination, forwarding, copying or use of any of the information is strictly 
prohibited. If you are not the intended recipient (or have received this e-mail 
by mistake), please notify the sender and delete it from your system 
immediately. Our university makes no warranty as to the accuracy or 
completeness of any information contained in this message and hereby excludes 
any liability of any kind for the information contained therein or for the 
information transmission, reception, storage or use of such in any way 
whatsoever. The opinions expressed in this message may belong to sender alone 
and may not necessarily reflect the opinions of our university. 
This e-mail has been scanned by our anti-virus system for all known computer 
viruses. In doing so, however, sender cannot guarantee that virus or other 
forms of data corruption may not be present and do not take any legal or 
financial responsibility in any occurrance.

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Configuring smtp mail server to work with Koha

[Pedro Amorim]

Hello,

I have solved the problem:
Sendmail.pm needs to have smtp => 'localhost' and port => 25 and the e-mail
notifications are now working.

Thank you,

Pedro Amorim

2015-10-30 14:23 GMT-01:00 Pedro Amorim :

> Hello Galen,
>
> Thank you for your reply.
> I have changed the Sendmail.pm file to point to smtp.gmail.com instead of
> localhost and am now receiving these errors:
>
> # koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/
> process_message_queue.pl -v
> koha: sending email message to patron: Admin at
> /usr/share/koha/lib/C4/Letters.pm line 937.
> koha: MAIL FROM: error (530 5.7.0 Must issue a STARTTLS command first.
> uj4sm7521289wjc.34 - gsmtp
> koha: )
> koha: Server said: 530 5.7.0 Must issue a STARTTLS command first.
> uj4sm7521289wjc.34 - gsmtp
> koha:  at /usr/share/koha/bin/cronjobs/process_message_queue.pl line 66
>
> I do not know much about configuring mail servers, should I keep the
> Sendmail.pm file pointing to localhost and postfix takes care of the
> redirecting?
>
> Thanks again,
>
> Pedro Amorim
>
>
>
>
> 2015-10-30 13:57 GMT-01:00 Galen Charlton :
>
>> Hi,
>>
>> On Fri, Oct 30, 2015 at 10:40 AM, Pedro Amorim 
>> wrote:
>> > connect to localhost failed (Connection refused)
>> > connect to localhost failed
>> > connect to localhost failed (Connection refused) no (more) retries!
>>
>> Koha expects there to be an MTA listening on port 25 on localhost.
>> Since you've got postfix already running, I suggest checking its
>> configuration for that -- specifically, inet_interfaces (to ensure
>> that it's listening on that interface) and mynetworks (to verify that
>> it will accept connects from with your Koha server).
>>
>> Alternatively, if the only thing you need is for email to get
>> forwarded to your mail smarthost, you could try nullmailer instead of
>> postfix.
>>
>> Regards,
>>
>> Galen
>> --
>> Galen Charlton
>> Infrastructure and Added Services Manager
>> Equinox Software, Inc. / The Open Source Experts
>> email:  g...@esilibrary.com
>> direct: +1 770-709-5581
>> cell:   +1 404-984-4366
>> skype:  gmcharlt
>> web:http://www.esilibrary.com/
>> Supporting Koha and Evergreen: http://koha-community.org &
>> http://evergreen-ils.org
>>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] 3.20 circulation email to staff

[Elaine Bradtke]

We're testing 3.20 before installing it in production.  As part of the
test, I ran some items through checkout and check in. I was surprised to
receive emails about both these actions at the end of the day.  I have been
digging around in the system preferences, but haven't yet found where to
switch this off, or at least change the email address.  It wasn't happening
in earlier versions, so I assume this is a new feature?

-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] System Time

[Nas Yakubu]

Thank you.

I have sorted this out.

On Fri, Oct 30, 2015 at 12:52 PM, vinod kumar 
wrote:

> yes Date and time taking koha from system
>
> On Thu, Oct 15, 2015 at 4:51 AM, Nas Yakubu  wrote:
>
>> Hi
>>
>> Can anyone advise me on how to change the date and time in Koha?
>>
>> Or does Koha get these values from the Operating System?
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>


-- 
Regards

M Nasiru Yakubu
Instructional Technology Unit Manager
American University of Nigeria
Lamido Zubairu Way
Yola
Adamawa State
+234 805 703 2980
VOIP 1153
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Changing IP on Koha Server

[G P Ashe]

I need to change the fixed IP on Koha server.

What files need to be updated manually in order that everything will work
as before but with new IP (different subnet).

Thanks

Greg

-- 


*Disclaimer Important*: ​
Information in this email (including attachments) is confidential. It is 
intended for receipt and consideration only by the intended recipient. If 
you are not an addressee or intended recipient, any use, dissemination, 
distribution, disclosure, publication or copying of information contained 
in this email is strictly prohibited. Opinions expressed in this email may 
be personal to the author and are not necessarily the opinions of *Glenstal 
Abbey School Ltd*. If this email has been received by you in error we would 
be grateful if you could immediately notify the sender, and thereafter 
delete this e-mail from your system.  You are requested to carry out your 
own virus check before opening any attachment. The author and *Glenstal 
Abbey School Ltd* accept no liability for any loss or damage which may be 
caused by viruses, malware or malicious software.
​ Please consider the environment before printing this email.​
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha