[Koha] Problem with Notices & Slips

[अभिषेक नागर Abhishek Nãgar]

Hi,

Thanks i was able to import and its working now

Thanks Again



On Wed, 13 Feb 2019 at 12:35, Katrin Fischer <katrin.fischer.83 at web.de>
wrote:

> Hi,
>
> sorry, the table is: message_transports
>
> You will need to add the configuration data missed while installing. The
> SQL files for this are part of your installation in
> installer/data/mysql/en/mandatory/
>
> They rarely change, so these are the links to the current versions in git:
>
>
> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/message_transport_types.sql;h=ed3c4ad13aa2c33e380eccc1f12674b11de9fb99;hb=66f3a72a01ba5238a9bba39a3b9cb659dbb47a42
>
>
> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql;h=a7a6032cc74117ef67cd79270245a77539593dcb;hb=66f3a72a01ba5238a9bba39a3b9cb659dbb47a42
>
>
> http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/en/mandatory/sample_notices_message_transports.sql;h=5954bafc7b35dce64374f7a1f5c97f2ad2b91755;hb=66f3a72a01ba5238a9bba39a3b9cb659dbb47a42
>
> Katrin
> On 13.02.19 07:54, अभिषेक नागर Abhishek Nãgar wrote:
>
> Hi Katrin,
>
> My Database contains Tables message_attributes and message_transport_types
> but are empty Table message_transport does not exist how can i get the
> Default SQL for creating the tables
>
> mysql> select * from message_transport_types;
> Empty set (0.00 sec)
>
> mysql> select * from message_transport;
> ERROR 1146 (42S02): Table 'koha_library.message_transport' doesn't exist
>
> mysql> select * from message_attributes;
> Empty set (0.00 sec)
>
>
>
>
> On Wed, 13 Feb 2019 at 12:19, Katrin Fischer <katrin.fischer.83 at web.de>
> wrote:
>
>> Hi Abhishek,
>>
>> I think you might not be missing the sample notices, but some of the
>> mandatory data.
>>
>> Check your database tables: message_attributes, message_transport and
>> message_transport_types. Especially the last one should have 4 entries:
>> email, phone, print, sms. But the others need to have data as well.
>>
>> Katrin
>> On 12.02.19 09:12, अभिषेक नागर Abhishek Nãgar wrote:
>>
>> I am Using Koha 18.11.02.000, Installed it via apt-get
>>
>> When i try to Add a Notice and click on save i get an alert Please fill
>> at least one template. (attached)
>> _________________________________________
>> Abhishek Nagar
>>
>>
>>
>>
>> On Mon, 11 Feb 2019 at 11:45, Katrin Fischer <katrin.fischer.83 at web.de>
>> wrote:
>>
>>> Hi,
>>>
>>> you can find examples for a lot of the notices in the wiki:
>>> https://wiki.koha-community.org/wiki/Notices_and_Slips_Library
>>>
>>> If you have access to your database you could also load the sample
>>> notices using SQL. The SQL file is part of your Koha installation.
>>>
>>> But not having the sample notices should not create any problems when
>>> using the notices and slips tool. What you describe sounds like there
>>> might be another problem.
>>>
>>> How did you install Koha and which version are you using? What is the
>>> error displaying?
>>>
>>> Katrin
>>>
>>>
>>> On 04.02.19 14:56, अभिषेक नागर Abhishek Nãgar wrote:
>>> > Dear All,
>>> >
>>> > I am relatively new to Koha, installed my first instance was able to
>>> import
>>> > 40000+ titles from LibSys ane approx 3000 Users.
>>> >
>>> > Koha installation is working quite well on a 8 Gb RAM VPS Cataloguing,
>>> > Circulation and everything thing is working just file. But No default
>>> > templates are available under Notices & Slips I would like to enable
>>> few
>>> > email alerts.
>>> >
>>> > When I try to add new notice it won't allow me to do and displays
>>> error to
>>> > select a template while email phone body fields are not visible while
>>> > creating Notice.
>>> >
>>> > Kindly suggest how to import default notices now so that it may work.
>>> >
>>> > IMO I deselected sample notices while creating instance can I now get
>>> > default Notices & Slips
>>> >
>>> >
>>> > Abhishek Nagar
>>> > _______________________________________________
>>> > Koha mailing list  http://koha-community.org
>>> > Koha at lists.katipo.co.nz
>>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>