DI
Asked
Hello,
Recently I change my server, host in shared hosting account. So after the server change, I can't login to my Simple Invoice Manager admin or any other account, when I try to login, it is automatically redirect to same login page, so
what is this issue ?
How to resolve this issue ?
App URL
http://clients.netcabin.com.au/auth/login
Get php info
http://clients.netcabin.com.au/phpinfo.php
Recently I change my server, host in shared hosting account. So after the server change, I can't login to my Simple Invoice Manager admin or any other account, when I try to login, it is automatically redirect to same login page, so
what is this issue ?
How to resolve this issue ?
App URL
http://clients.netcabin.com.au/auth/login
Get php info
http://clients.netcabin.com.au/phpinfo.php
- MSAnsweredHello,
I don't know what is the issue. You need to find it. Was it working before? Did you restore the database in new server? Did you update the config on new server?
The `base_url` in the `app/config/config.php` and database settings in `app/config/database.php`
Please check those along with your server error logs.
Thank you - DIAnsweredbase_url and database settings are OK, Now I update the system using update tool, now I can login but after the login everything going blank, what is this issue ? how to fix ?
- MSAnsweredPlease check the server error logs for 500 error details and let me know so that I can suggest. Thank you
- DIAnsweredIs this the error log ?
111.223.151.159 - - [19/May/2020:11:13:41 -0400] "GET /auth/login HTTP/1.1" 200 1257 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:13:42 -0400] "GET /themes/default/assets/style/bootstrap.min.css HTTP/1.1" 200 24745 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:13:43 -0400] "GET /themes/default/assets/fonts/MTP_ySUJH_bn48VBG8sNSnhCUOGz7vYGh680lGh-uXM.woff HTTP/1.1" 200 22604 "http://clients.netcabin.com.au/themes/default/assets/style/style.css" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:13:42 -0400] "GET /themes/default/assets/style/style.css HTTP/1.1" 200 8344 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:13:43 -0400] "GET /themes/default/assets/fonts/cJZKeOuBrn4kERxqtaUH3T8E0i7KZn-EPnyo3HZu7kw.woff HTTP/1.1" 200 21956 "http://clients.netcabin.com.au/themes/default/assets/style/style.css" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:13:45 -0400] "GET /auth/assets/img/favicon.png HTTP/1.1" 404 1370 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:20:58 -0400] "POST /auth/login HTTP/1.1" 303 0 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:20:59 -0400] "GET /auth/login HTTP/1.1" 200 1317 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:21:21 -0400] "POST /auth/login HTTP/1.1" 303 0 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:21:21 -0400] "GET /home HTTP/1.1" 500 0 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:21:21 -0400] "GET /favicon.ico HTTP/1.1" 404 1237 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:45:38 -0400] "GET /home HTTP/1.1" 500 0 "http://clients.netcabin.com.au/auth/login" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0"
111.223.151.159 - - [19/May/2020:11:45:39 -0400] "GET /favicon.ico HTTP/1.1" 404 1237 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:76.0) Gecko/20100101 Firefox/76.0" - MSAnsweredNo. These are access logs. If you are not sure, you can check with your server admin/host.
- DIAnsweredHey... if I give you a ftp can you fix this issue ?
- MSAnsweredHello,
I am sorry but the service to check installation/server is not free. You can [open ticket](/support/tickets/new) for `Check server/installation for me ($10)` and provide your server details. We can't fix any server issues but will update you what need to be changed.
Thank you - DIAnsweredOK, Can you please give me a link to download Simple Invoice Manager 3.4.5.1 ?
if you can do this help, I'm really appreciate. - MSAnsweredI am sorry as we can't save many versions only last 4 - 5 only. I checked the tag was started after 3.6.0 so I don't have version below.
I don't recommend you to use old versions, please always use the latest version.
Did you check the server error logs? I am not sure if app logs can help but you can enable app logs by changing the `log_threshold` to 1 in `app/config/config.php` and then visit the page again to produce error. Lastly check the latest error logs in `app/logs/` folder. This could be helpful to know if the app generating any errors.
Thank you - DIAnsweredHere is the error log,
log-2020-05-23.php ( PHP script, ASCII text )
<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
ERROR - 2020-05-23 14:02:17 --> 404 Page Not Found: Auth/assets
ERROR - 2020-05-23 14:04:20 --> Query error: Unknown column 'start' in 'where clause' - Invalid query: SELECT *
FROM `calendar`
WHERE `start` >= '2020-05-23'
ORDER BY `start`
LIMIT 5
ERROR - 2020-05-23 14:04:20 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /home/maxmindcp/public_html/clients-aus/app/models/Site.php 55 - Login to Reply