Error messages on LIVE Play servers

General
21

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px Monaco; color: #f4f4f4; background-color: #000000; background-color: rgba(0, 0, 0, 0.85)}
span.s1 {font-variant-ligatures: no-common-ligatures}

mysql> show create view DefaultUser;

ERROR 1347 (HY000): ‘BC15C3B1-2D4C-C9F2-FFA0-12C7235B7B00.DefaultUser’ is not VIEW

mysql>

22

You need to make sure that view exists in the database. If that view is missing, it will result in the behavior you’re observing right now.

23

Can you tell me how to create this view?

24

Here’s the command to create the view:

CREATE VIEW `DefaultUser` AS
    SELECT 
        `u`.`id` AS `id`,
        `u`.`loggedIn` AS `loggedIn`,
        `u`.`failedLoginCount` AS `failedLoginCount`,
        `u`.`logsCount` AS `logsCount`,
        `u`.`default` AS `default`,
        `u`.`activationKey` AS `activationKey`,
        `u`.`userTypeId` AS `userTypeId`,
        `u`.`userStatusId` AS `userStatusId`,
        `u`.`lastLogin` AS `lastLogin`,
        `u`.`lastTimeReturningCount` AS `lastTimeReturningCount`
    FROM
       `User` `u`
    WHERE
        (`u`.`default` = 1)
25

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px Monaco; color: #f4f4f4; background-color: #000000; background-color: rgba(0, 0, 0, 0.85)}
p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px Monaco; color: #f4f4f4; background-color: #000000; background-color: rgba(0, 0, 0, 0.85); min-height: 19.0px}
span.s1 {font-variant-ligatures: no-common-ligatures}

mysql> CREATE ALGORITHM=UNDEFINED DEFINER=<removed>@% SQL SECURITY DEFINER VIEW DefaultUser AS select u.id AS id,u.loggedIn AS loggedIn,u.failedLoginCount AS failedLoginCount,u.logsCount AS logsCount,u.default AS default,u.activationKey AS activationKey,u.userTypeId AS userTypeId,u.userStatusId AS userStatusId,u.lastLogin AS lastLogin,u.lastTimeReturningCount AS lastTimeReturningCount from User u where (u.default = 1)

-> ;

ERROR 1050 (42S01): Table ‘DefaultUser’ already exists

mysql> select * from DefaultUser;

Empty set (0.00 sec)

mysql> drop view DefaultUser;

ERROR 1347 (HY000): ‘BC15C3B1-2D4C-C9F2-FFA0-12C7235B7B00.DefaultUser’ is not VIEW

mysql>

26

I am not sure how you got there, it appears “DefaultUser” is created as a table. There is no such table in Backendless, it must be a view with the contents I shared earlier.

27

Ok i dropped the table using

drop table DefaultUser;
ran the command you sent above and recreated the view
ran the command
select * from DefaultUser;
It returned the DefaultUser
Now logins are working and im able to browse the deployed API Services in the console

THANK YOU THANK YOU THANK YOU!!! YOU GUYS ARE AWESOME!!!

28

Ok, glad it got resolved. I caution you from doing the restore from the RDS backups. Make sure to inspect the SQL script they create. It appears they mix up views and tables.

29

Please re-open this. Found that when attempting to login using rest console getting this error message

Cannot read property ‘email’ of null

30

is there a test account we could use?

31

sending to you in private chat

32

sent in private message in slack

33

are there any exceptions in the log when a login fails?

34

Sorry i was mistaken about the password, I tried with the correct password and i am able to login to the REST console

35

ok lets close this one out and i will re-open a new one for the other issue we are experiancing