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 <[email protected]> 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 <[email protected]> > 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 >> > [email protected] >> > https://lists.katipo.co.nz/mailman/listinfo/koha >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
