App went offline by itself

[rritz]

My mw app went offline today .. in the logs I see:

"
2017/11/04 08:36:01 [error] [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_added' in 'where clause'. The SQL statement executed was: SELECT *
FROM `mw_email_blacklist`
WHERE is_added=:is_added.
2017/11/04 08:36:01 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_added' in 'where clause'' in /var/www/mw/apps/common/framework/db/CDbCommand.php:543
Stack trace:
#0 /var/www/mw/apps/common/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /var/www/mw/apps/console/commands/BlacklistEmail.php(46): CDbCommand->queryAll()
#2 /var/www/mw/apps/console/commands/BlacklistEmail.php(28): BlacklistEmail->process()
#3 [internal function]: BlacklistEmail->actionIndex()
#4 /var/www/mw/apps/common/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs(Object(BlacklistEmail), Array)
#5 /var/www/mw/apps/common/framework/console/CConsoleCommandRunner.php(71): CConsoleCommand->run(Array)
#6 /var/www/mw/apps/common/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#7 /var/www/mw/apps/common/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#8 /var/www/mw/apps/init.php(228): CApplication->run()
#9 /var/www/mw/apps/console/console.php(28): require_once('/var/www/mw/app...')
#10 {main}
---
"
first log is 00:36:01 h
and one log every minute

Would this be the cause? What's happening here?

 

[twisted1919]

The SQL statement executed was: SELECT *
FROM `mw_email_blacklist`
WHERE is_added=:is_added.

Mailwizz's blacklist database does not have a is_added column.
According to the error, it is caused by /var/www/mw/apps/console/commands/BlacklistEmail.php which is not a mailwizz command.

 

[Samuels]

Hello,

I guess im having this issue as well:

Error 503!
Application currently offline. Try again later!

See my log

2017/11/10 13:19:28 [error] [exception.CHttpException.503] [169.255.124.55] CHttpException: Application currently offline. Try again later! in /home/globalviewng/public_html/mserver/apps/frontend/controllers/SiteController.php:27
Stack trace:
#0 /home/globalviewng/public_html/mserver/apps/common/framework/web/actions/CInlineAction.php(49): SiteController->actionOffline()
#1 /home/globalviewng/public_html/mserver/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#2 /home/globalviewng/public_html/mserver/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#3 /home/globalviewng/public_html/mserver/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#4 /home/globalviewng/public_html/mserver/apps/common/framework/web/CWebApplication.php(282): CController->run('offline')
#5 /home/globalviewng/public_html/mserver/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('site/offline')
#6 /home/globalviewng/public_html/mserver/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#7 /home/globalviewng/public_html/mserver/apps/init.php(233): CApplication->run()
#8 /home/globalviewng/public_html/mserver/index.php(18): require_once('/home/globalvie...')
#9 {main}
REQUEST_URI=/index.php/site/offline
HTTP_REFERER=http://mserver.globalviewng.com/index.php/site/offline
---
2017/11/10 13:22:10 [error] [exception.CHttpException.503] [169.255.124.55] CHttpException: Application currently offline. Try again later! in /home/globalviewng/public_html/mserver/apps/frontend/controllers/SiteController.php:27
Stack trace:
#0 /home/globalviewng/public_html/mserver/apps/common/framework/web/actions/CInlineAction.php(49): SiteController->actionOffline()
#1 /home/globalviewng/public_html/mserver/apps/common/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#2 /home/globalviewng/public_html/mserver/apps/common/framework/web/CController.php(286): CController->runAction(Object(CInlineAction))
#3 /home/globalviewng/public_html/mserver/apps/common/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#4 /home/globalviewng/public_html/mserver/apps/common/framework/web/CWebApplication.php(282): CController->run('offline')
#5 /home/globalviewng/public_html/mserver/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('site/offline')
#6 /home/globalviewng/public_html/mserver/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()

 

[twisted1919]

You can still login from http://mserver.globalviewng.com/index.php/backend and put it online.

 

[Samuels]

Where do I do that from please..??

which menu ??

 

[Samuels]

Any reason why it went offline by itself.

 

[twisted1919]

Where do I do that from please..??

which menu ??

Backend > Settings > Common

Any reason why it went offline by itself.

Yes, if the app cannot communicate with our servers, it will go offline. So most likely your hosting internet connection was offline at that time.