# Can not login to my libretime

**URL:** <https://discourse.libretime.org/t/can-not-login-to-my-libretime/440>\
**Category:** Uncategorized\
**Created:** [January 2, 2020, 5:51am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440 "2020-01-02T05:51:04Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![bheatproductions](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/bheatproductions/32/246_2.png) [@bheatproductions](https://discourse.libretime.org/u/bheatproductions)\
**Post date:** [January 2, 2020, 5:51am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/1 "2020-01-02T05:51:04Z")

</div>

![image](https://canada1.discourse-cdn.com/flex036/uploads/libretime/original/1X/b841bc55b27946fe775f0d657b70736db0d4ea4d.jpeg)

At login it reads oops! Something went wrong

---

<div class="post-metadata">

**Author:** ![paddatrapper](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/paddatrapper/32/675_2.png) [@paddatrapper](https://discourse.libretime.org/u/paddatrapper)\
**Post date:** [January 2, 2020, 7:53am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/2 "2020-01-02T07:53:35Z")

</div>

How did you install LibreTime?

What are the contents of `/var/log/airtime/zend.log`?

---

<div class="post-metadata">

**Author:** ![robbt](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/robbt/32/15_2.png) [@robbt](https://discourse.libretime.org/u/robbt)\
**Post date:** [January 2, 2020, 1:20pm UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/4 "2020-01-02T13:20:13Z")

</div>

if you go to the command line and type

> tail -n 200 /var/log/airtime/zendphp.log

it should show an error.

Other info that would help troubleshooting. Did you ever have it working, how did you install it, what distro are you using etc.

---

<div class="post-metadata">

**Author:** ![rayuela](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@rayuela](https://discourse.libretime.org/u/rayuela)\
**Post date:** [March 8, 2020, 5:40pm UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/5 "2020-03-08T17:40:40Z")

</div>

It seems that you are using a domain, did you add it into the general settings in CORL Urls?

goodlook

---

<div class="post-metadata">

**Author:** ![itcrowdsource](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/itcrowdsource/32/286_2.png) [@itcrowdsource](https://discourse.libretime.org/u/itcrowdsource)\
**Post date:** [March 28, 2020, 10:40pm UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/6 "2020-03-28T22:40:32Z")

</div>

Help! My Libretime server has crashed with the same error at the login screen…what might be the cause? This is my zendphp.log

2020-03-28T22:38:33+00:00 ERR (3): [live2.fnoobtechno.com](http://live2.fnoobtechno.com) [ErrorController.php:54 - errorAction()] - An internal application error has occurred.: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation “cc\_track\_types” does not exist  
LINE 1: SELECT id, code, type\_name, description FROM cc\_track\_types …  
^ in /usr/share/airtime/php/airtime\_mvc/application/common/Database.php:24  
Stack trace:  
#0 /usr/share/airtime/php/airtime\_mvc/application/common/Database.php(24): PDOStatement-\>execute()  
#1 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(124): Application\_Common\_Database::prepareAndExecute(‘SELECT id, code…’, Array, ‘all’)  
#2 /usr/share/airtime/php/airtime\_mvc/application/models/Tracktype.php(98): Application\_Model\_Tracktype::getTracktypesData(Array, NULL)  
#3 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(146): Application\_Model\_Tracktype::getTracktypes()  
#4 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(85): PageLayoutInitPlugin-\>\_initTranslationGlobals(Object(Zend\_View))  
#5 /usr/share/airtime/php/airtime\_mvc/application/controllers/plugins/PageLayoutInitPlugin.php(47): PageLayoutInitPlugin-\>\_initGlobals()  
#6 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Plugin/Broker.php(260): PageLayoutInitPlugin-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#7 /usr/share/airtime/php/vendor/zf1s/zend-controller/library/Zend/Controller/Front.php(923): Zend\_Controller\_Plugin\_Broker-\>routeShutdown(Object(Zend\_Controller\_Request\_Http))  
#8 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend\_Controller\_Front-\>dispatch()  
#9 /usr/share/airtime/php/vendor/zf1s/zend-application/library/Zend/Application.php(384): Zend\_Application\_Bootstrap\_Bootstrap-\>run()  
#10 /usr/share/airtime/php/airtime\_mvc/application/airtime-boot.php(84): Zend\_Application-\>run()  
#11 /usr/share/airtime/php/airtime\_mvc/public/index.php(68): require\_once(’/usr/share/airt…’)

---

<div class="post-metadata">

**Author:** ![itcrowdsource](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/itcrowdsource/32/286_2.png) [@itcrowdsource](https://discourse.libretime.org/u/itcrowdsource)\
**Post date:** [March 28, 2020, 11:38pm UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/7 "2020-03-28T23:38:16Z")

</div>

![image](https://canada1.discourse-cdn.com/flex036/uploads/libretime/original/1X/10ee80592aed3ec9153ebc990a908d282ad53644.png)

---

<div class="post-metadata">

**Author:** ![itcrowdsource](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/itcrowdsource/32/286_2.png) [@itcrowdsource](https://discourse.libretime.org/u/itcrowdsource)\
**Post date:** [March 28, 2020, 11:39pm UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/8 "2020-03-28T23:39:08Z")

</div>

@robbt do you know what might be the cause of this?

---

<div class="post-metadata">

**Author:** ![robbt](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/robbt/32/15_2.png) [@robbt](https://discourse.libretime.org/u/robbt)\
**Post date:** [March 29, 2020, 1:30am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/9 "2020-03-29T01:30:44Z")

</div>

It looks like the database didn’t update properly after you did the latest git pull.

---

<div class="post-metadata">

**Author:** ![robbt](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/robbt/32/15_2.png) [@robbt](https://discourse.libretime.org/u/robbt)\
**Post date:** [March 29, 2020, 1:31am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/10 "2020-03-29T01:31:21Z")

</div>

See [Can't login to airtime](https://discourse.libretime.org/t/cant-login-to-airtime/498/10)

---

<div class="post-metadata">

**Author:** ![itcrowdsource](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/itcrowdsource/32/286_2.png) [@itcrowdsource](https://discourse.libretime.org/u/itcrowdsource)\
**Post date:** [March 29, 2020, 2:05am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/13 "2020-03-29T02:05:15Z")

</div>

@robbt I’m getting these errors when I run the script on the database

airtime=# INSERT INTO cc\_track\_types VALUES (1, ‘MUS’, ‘Music’, ‘This is used for tracks containing music.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (1, ‘MUS’, ‘Music’, 'This …  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (2, ‘SID’, ‘Station ID’, ‘This is used for Station IDs’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (2, ‘SID’, ‘Station ID’, '…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (3, ‘INT’, ‘Show Intro’, ‘This can be used for organizing all the show introductions.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (3, ‘INT’, ‘Show Intro’, '…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (4, ‘OUT’, ‘Show Outro’, ‘This can be used for organizing all the show outroductions.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (4, ‘OUT’, ‘Show Outro’, '…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (5, ‘SWP’, ‘Sweeper’, ‘This is used for segues between songs.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (5, ‘SWP’, ‘Sweeper’, 'Thi…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (6, ‘JIN’, ‘Jingle’, ‘A short song or tune, normally played during commercial breaks. Contains one or more hooks.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (6, ‘JIN’, ‘Jingle’, 'A sh…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (7, ‘PRO’, ‘Promo’, ‘For promotional use.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (7, ‘PRO’, ‘Promo’, 'For p…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (8, ‘SHO’, ‘Shout Out’, 'A message of congratulation, greeting. support, or appreciation. ', true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (8, ‘SHO’, ‘Shout Out’, 'A…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (9, ‘NWS’, ‘News’, ‘This is used for noteworthy information, announcements.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (9, ‘NWS’, ‘News’, 'This i…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (10, ‘COM’, ‘Commercial’, ‘This is used for commerical advertising.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (10, ‘COM’, ‘Commercial’, …  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (11, ‘ITV’, ‘Interview’, ‘This is used for radio interviews’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (11, ‘ITV’, ‘Interview’, '…  
^  
airtime=# INSERT INTO cc\_track\_types VALUES (12, ‘VTR’, ‘Voice Tracking’, ‘Also referred as robojock or taped. Make announcements without actually being in the station.’, true);  
ERROR: relation “cc\_track\_types” does not exist  
LINE 1: INSERT INTO cc\_track\_types VALUES (12, ‘VTR’, 'Voice Trackin…

---

<div class="post-metadata">

**Author:** ![robbt](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/robbt/32/15_2.png) [@robbt](https://discourse.libretime.org/u/robbt)\
**Post date:** [March 29, 2020, 3:05am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/14 "2020-03-29T03:05:10Z")

</div>

You need to create that table. I think the code is in the other post.Can you let me know how you did the upgrade ? I want to see if there is a issue in the code we can reproduce as this should be automatic. Like what version where you running prior to this and then I assume you just updated to the master recently and this happened.

---

<div class="post-metadata">

**Author:** ![itcrowdsource](https://yyz2.discourse-cdn.com/flex036/user_avatar/discourse.libretime.org/itcrowdsource/32/286_2.png) [@itcrowdsource](https://discourse.libretime.org/u/itcrowdsource)\
**Post date:** [March 29, 2020, 8:20am UTC](https://discourse.libretime.org/t/can-not-login-to-my-libretime/440/15 "2020-03-29T08:20:05Z")

</div>

I managed to create the table. It started working again!  
I installed the new version with the ./install command from the latest revision of the git source.

Unfortunately I didn’t register the previous version number. I installed a clean version of Libretime back in January. Imported the databases from the previous Libretime server. Yesterday the server started producing problems and users couldn’t upload mixes anymore (see attachment). After resetting the services the problem still persisted. After that I decided to update the code on the server from the git source.

 ![LibreTimeError](https://canada1.discourse-cdn.com/flex036/uploads/libretime/original/1X/516db17128a32f9258197d92a195d03ed71bad97.jpeg)