upgrade 2.8.x to 2.9.2, all is blank

[romainp]

Hi,
I have tried to update from 2.8.4 to the latest and all seems to be fine during the process but, when I try to access the faq, everything is blank! I have activate the debug but can't seen anything on the screen or in the logs.
If anybody have an idea
Thanks!
Romain

[Thorsten]

Hi,

please open your config/database.php and tell me which database type you're using.

Thanks!

bye
Thorsten

[romainp]

Here it is:

$DB['type'] = 'pgsql';

the db server is on another server. I have tested a connexion with a cli (psql) and it works fine, I can access the db with the user name and password.

Thanks!
R.

[Thorsten]

Hi,

please enable the debug mode in inc/Bootstrap.php and try it again. Thanks!

bye
Thorsten

[romainp]

Hi,
It's already enable but I do not see anything in the logs on on the screen..

[romainp]

Oh I think I know why I have some issue but.. can you tell me the sql syntax to update the host field in the db please?
Thanks!
R.

[Thorsten]

Hi,

which host field?

bye
Thorsten

[romainp]

Oh sorry!
The "main.referenceurl" field please. I can't find a way to update the value in postgres...
Thanks!
R.

[Thorsten]

Hi,

Code: Select all

UPDATE faqconfig SET config_value = 'your_url' WHERE config_key = 'main.referenceURL';

bye
Thorsten

[romainp]

Hi,
I have used

Code: Select all

update faqconfig set config_value = 'http://192.168.4.4/phpmyfaq' where config_name = 'main.referenceURL';

to update the db to reflect the fact that I access the phpmyfaq app using this ip but I still have a blank page and the logs only show this:

Code: Select all

192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:09:20:17 -0400] "OPTIONS * HTTP/1.0" 200 -
192.168.4.5 - - [12/Jul/2016:13:16:21 -0400] "GET /phpmyfaq/ HTTP/1.1" 200 11904
192.168.4.5 - - [12/Jul/2016:13:16:23 -0400] "GET /phpmyfaq/assets/template/default/css/style.min.css?v=1 HTTP/1.1" 304 -
192.168.4.5 - - [12/Jul/2016:13:16:23 -0400] "GET /phpmyfaq/assets/js/libs/modernizr.min.js HTTP/1.1" 404 238
192.168.4.5 - - [12/Jul/2016:13:16:23 -0400] "GET /phpmyfaq/assets/template/default/favicon.ico HTTP/1.1" 304 -
192.168.4.5 - - [12/Jul/2016:13:17:22 -0400] "GET /phpmyfaq/ HTTP/1.1" 200 11513
192.168.4.5 - - [12/Jul/2016:13:17:23 -0400] "GET /phpmyfaq/assets/js/libs/modernizr.min.js HTTP/1.1" 404 238

Still investigating..

[romainp]

Hmm.. the 404 error code suggest that the path is wrong, so I have updated the db to use only http://192.168.4.4 and I will test to access the app using http://192.168.4.4/phpmyfaq in my browser. I will let you know about the result as soon as I am back to my home.
Thks.
R.

[Thorsten]

Hi,

do you see the HTML source code?

bye
Thorsten

[romainp]

Hi!
Ok found the issue! I feel bad because I made some terrible errors during this upgrade and troubleshoot steps... but well, that's how we learn!
So, first I don't know why but I was unable to understand how to update the postgres db with the right information for the url. It's just like my brain think it's a strange db format and I never notice the 2 columns.. maybe it's because it's different than the way mysql show the databases/columns but I was completely lost with this update! I soon as you tell me the right string I have understand my error.
So, the refereceURL was fixed. I have also modified my vhost config to have the ip goes directly to the phpmyfaq folder.
But it was still not working and have a blank page...
What the logs says at that point?

Code: Select all

192.168.4.5 - - [12/Jul/2016:13:17:22 -0400] "GET /phpmyfaq/ HTTP/1.1" 200 11513
192.168.4.5 - - [12/Jul/2016:13:17:23 -0400] "GET /phpmyfaq/assets/js/libs/modernizr.min.js HTTP/1.1" 404 238

Ok then, accessing the root of the site is working but it seems that it can't find the file /phpmyfaq/assets/js/libs/modernizr.min.js.
I have try to locate that file and see that in fact it was not where it supposed to be! Strange...
So at the end I decided to backup my current installation, unzip the 2.9.2 archive version, copy the files according to the documentation, fix the perms and.. TADA!!! It works!
So I guess that I have done a bad migration earlier.
Now everything is working fine and I am so happy!
Thanks again!
R.

[Thorsten]

Hi,

great to hear!

bye
Thorsten