upgrade 2.8.x to 2.9.1 issue

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.1 issue

Post by romainp »

Hi,
Got this error when trying to upgrade to 2.9.1:

DB error: ERROR: syntax error at or near "(" LINE 1: ALTER TABLE faqcategories ADD active INT(1) NULL DEFAULT 1 ^
ALTER TABLE faqcategories ADD active INT(1) NULL DEFAULT 1

Any idea on what I can do to solve this?

Thanks!
R.
Update: I have to to re run the update and this time no error message (all seems green and fine) but now when I try to access the home page, all is blank...


phpMyFAQ warning [2]: pg_query(): Query failed: ERROR: column fc.group_id does not exist LINE 9: fc.group_id AS group_id, ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112

phpMyFAQ warning [2]: pg_query(): Query failed: ERROR: column fd.updated does not exist LINE 5: fd.updated AS updated, ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112

phpMyFAQ warning [2]: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 142

phpMyFAQ warning [2]: pg_query(): Query failed: ERROR: column fd.updated does not exist LINE 7: fd.updated AS updated, ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112

phpMyFAQ warning [2]: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 142
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: upgrade 2.8.x to 2.9.1 issue

Post by Thorsten »

Hi,

please revert the upgrade, this issue will be fixed in 2.9.2. Here's the ticket on Github: https://github.com/thorsten/phpMyFAQ/issues/1166

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.1 issue

Post by romainp »

Thanks!
:)
Post Reply