upgrade 2.8.x to 2.9.2, all is blank

Please report bugs here!

Moderator: Thorsten

Post Reply
romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Fri Jul 08, 2016 10:57 pm

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
Posts: 14793
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by Thorsten » Sat Jul 09, 2016 7:38 pm

Hi,

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

Thanks!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Sun Jul 10, 2016 6:47 pm

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
Posts: 14793
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by Thorsten » Sun Jul 10, 2016 8:26 pm

Hi,

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

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Sun Jul 10, 2016 11:26 pm

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

romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Sun Jul 10, 2016 11:29 pm

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
Posts: 14793
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by Thorsten » Mon Jul 11, 2016 9:17 am

Hi,

which host field?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Mon Jul 11, 2016 1:58 pm

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

Thorsten
Posts: 14793
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by Thorsten » Mon Jul 11, 2016 7:41 pm

Hi,

Code: Select all

UPDATE faqconfig SET config_value = 'your_url' WHERE config_key = 'main.referenceURL';
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Wed Jul 13, 2016 8:53 pm

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
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Wed Jul 13, 2016 9:01 pm

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
Posts: 14793
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by Thorsten » Thu Jul 14, 2016 8:39 am

Hi,

do you see the HTML source code?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

romainp
Posts: 21
Joined: Mon May 09, 2016 4:14 pm

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by romainp » Thu Jul 14, 2016 4:31 pm

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.
Last edited by romainp on Thu Jul 14, 2016 4:40 pm, edited 2 times in total.

Thorsten
Posts: 14793
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.2, all is blank

Post by Thorsten » Thu Jul 14, 2016 4:37 pm

Hi,

great to hear! :)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply