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
upgrade 2.8.x to 2.9.1 issue
Moderator: Thorsten
Re: upgrade 2.8.x to 2.9.1 issue
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
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
amazon.de Wishlist