GRACO
Posts: 488
Joined: Mon Sep 01, 2008 8:19 am

After patch cannot acces server

Tue Oct 05, 2010 10:48 pm

Hello.
Users cannot access server after latest patch...
any idea?

was working perfect before that.

2010-10-05 12:36:07.5100 | Error | 3 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1054 |
2010-10-05 12:36:07.5256 | Warn | 3 | DAOBase.Fill | System.Data.Odbc.OdbcException | ERROR [42S22] [MySQL][ODBC 5.1 Driver][mysqld-5.1.35-community]Unknown column 'a.deleted' in 'where clause'
2010-10-05 12:36:07.5256 | Warn | 3 | LoggerImpl.Write | SQL: SELECT DISTINCT a.* from applications a JOIN groups g ON a.application_id = g.application_id JOIN user_groups ug ON ug.group_id = g.group_id WHERE a.deleted <> 1 AND ug.user_id = 12 |
2010-10-05 12:36:07.5256 | Error | 3 | AppGateway.Page_Load | Exception in Page_Load | Database error - could not fill data
2010-10-05 12:36:25.1536 | Info | 6 | LoggerImpl.Write | Registered Users: 13, Max Users: 13 |
2010-10-05 12:36:25.1536 | Info | 6 | LoggerImpl.Write | Logging in User = control From Source = xxx |
2010-10-05 12:36:25.1848 | Info | 6 | LoggerImpl.Write | Authentication OK: Username = control |
2010-10-05 12:36:26.4796 | Error | 6 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1054 |
2010-10-05 12:36:26.4796 | Warn | 6 | DAOBase.Fill | System.Data.Odbc.OdbcException | ERROR [42S22] [MySQL][ODBC 5.1 Driver][mysqld-5.1.35-community]Unknown column 'a.deleted' in 'where clause'
2010-10-05 12:36:26.4796 | Warn | 6 | LoggerImpl.Write | SQL: SELECT DISTINCT a.* from applications a JOIN groups g ON a.application_id = g.application_id JOIN user_groups ug ON ug.group_id = g.group_id WHERE a.deleted <> 1 AND ug.user_id = 12 |
2010-10-05 12:36:26.4796 | Error | 6 | AppGateway.Page_Load | Exception in Page_Load | Database error - could not fill data
2010-10-05 12:36:48.0076 | Info | 3 | LoggerImpl.Write | Registered Users: 13, Max Users: 13 |
2010-10-05 12:36:48.0076 | Info | 3 | LoggerImpl.Write | Logging in User = control From Source = xxx|
2010-10-05 12:36:48.0700 | Info | 3 | LoggerImpl.Write | Authentication OK: Username = control |
2010-10-05 12:36:49.0684 | Error | 3 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1054 |

peetee
Posts: 365
Joined: Wed Jul 09, 2008 1:37 am

RE: After patch cannot acces server

Tue Oct 05, 2010 11:22 pm

Try to recycle AppPool and restart web server.

Regards,
Piotr

User avatar
johan
GpsGate
Posts: 15350
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: After patch cannot acces server

Tue Oct 05, 2010 11:28 pm

What has happend is that the database updates are not installed. You must login to SiteAdmin after installing the core patch.

To correct this:
1. Login to SiteAdmin
2. Install the database updates.
3. Stop and Start NMEA Service.

Regards,
Johan

GpsGate Support

GRACO
Posts: 488
Joined: Mon Sep 01, 2008 8:19 am

RE: After patch cannot acces server

Tue Oct 05, 2010 11:32 pm

Thx Johan! and petee ..
It worked after log in to admin site.

Regards!

grigor
Posts: 90
Joined: Mon May 14, 2012 6:41 pm
Location: Albania
Contact: Facebook Twitter Skype

RE: After patch cannot acces server

Wed Apr 20, 2016 12:46 pm

Originally posted by GRACO

Hello.
Users cannot access server after latest patch...
any idea?

was working perfect before that.

2010-10-05 12:36:07.5100 | Error | 3 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1054 |
2010-10-05 12:36:07.5256 | Warn | 3 | DAOBase.Fill | System.Data.Odbc.OdbcException | ERROR [42S22] [MySQL][ODBC 5.1 Driver][mysqld-5.1.35-community]Unknown column 'a.deleted' in 'where clause'
2010-10-05 12:36:07.5256 | Warn | 3 | LoggerImpl.Write | SQL: SELECT DISTINCT a.* from applications a JOIN groups g ON a.application_id = g.application_id JOIN user_groups ug ON ug.group_id = g.group_id WHERE a.deleted <> 1 AND ug.user_id = 12 |
2010-10-05 12:36:07.5256 | Error | 3 | AppGateway.Page_Load | Exception in Page_Load | Database error - could not fill data
2010-10-05 12:36:25.1536 | Info | 6 | LoggerImpl.Write | Registered Users: 13, Max Users: 13 |
2010-10-05 12:36:25.1536 | Info | 6 | LoggerImpl.Write | Logging in User = control From Source = xxx |
2010-10-05 12:36:25.1848 | Info | 6 | LoggerImpl.Write | Authentication OK: Username = control |
2010-10-05 12:36:26.4796 | Error | 6 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1054 |
2010-10-05 12:36:26.4796 | Warn | 6 | DAOBase.Fill | System.Data.Odbc.OdbcException | ERROR [42S22] [MySQL][ODBC 5.1 Driver][mysqld-5.1.35-community]Unknown column 'a.deleted' in 'where clause'
2010-10-05 12:36:26.4796 | Warn | 6 | LoggerImpl.Write | SQL: SELECT DISTINCT a.* from applications a JOIN groups g ON a.application_id = g.application_id JOIN user_groups ug ON ug.group_id = g.group_id WHERE a.deleted <> 1 AND ug.user_id = 12 |
2010-10-05 12:36:26.4796 | Error | 6 | AppGateway.Page_Load | Exception in Page_Load | Database error - could not fill data
2010-10-05 12:36:48.0076 | Info | 3 | LoggerImpl.Write | Registered Users: 13, Max Users: 13 |
2010-10-05 12:36:48.0076 | Info | 3 | LoggerImpl.Write | Logging in User = control From Source = xxx|
2010-10-05 12:36:48.0700 | Info | 3 | LoggerImpl.Write | Authentication OK: Username = control |
2010-10-05 12:36:49.0684 | Error | 3 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 1054 |


Thanks and regards,
Grigor

Return to “GpsGate Server - How to setup and use”