[Koha] Problem with Notices & Slips

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

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
>>
>