Hi,
I got this error running the upgrade:
DB error: ERROR: syntax error at or near "(" LINE 1: ALTER TABLE faquser ADD success INT(1) NULL DEFAULT 1 ^
Can you help?
Thanks!
R.
Upgrad from 2.8 to 2.9 issue
Moderator: Thorsten
Re: Upgrad from 2.8 to 2.9 issue
Hi,
I was able to run the sql command by habd without any issue and the setup finished ok but now I have a blank page when I access my phpmyfaq site.
The logs show this:
[Sat May 14 10:56:24.971410 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_query(): Query failed: ERROR: column fc.group_id does not exist\nLINE 9: fc.group_id AS group_id,\n ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112
[Sat May 14 10:56:25.003291 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_query(): Query failed: ERROR: column fd.updated does not exist\nLINE 5: fd.updated AS updated,\n ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112
[Sat May 14 10:56:25.003371 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 142
[Sat May 14 10:56:25.005605 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_query(): Query failed: ERROR: column fd.updated does not exist\nLINE 7: fd.updated AS updated,\n ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112
[Sat May 14 10:56:25.005659 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 142
I was able to run the sql command by habd without any issue and the setup finished ok but now I have a blank page when I access my phpmyfaq site.
The logs show this:
[Sat May 14 10:56:24.971410 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_query(): Query failed: ERROR: column fc.group_id does not exist\nLINE 9: fc.group_id AS group_id,\n ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112
[Sat May 14 10:56:25.003291 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_query(): Query failed: ERROR: column fd.updated does not exist\nLINE 5: fd.updated AS updated,\n ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112
[Sat May 14 10:56:25.003371 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 142
[Sat May 14 10:56:25.005605 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_query(): Query failed: ERROR: column fd.updated does not exist\nLINE 7: fd.updated AS updated,\n ^ in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 112
[Sat May 14 10:56:25.005659 2016] [:error] [pid 27589] [client 192.168.1.61:60246] phpMyFAQ warning: pg_fetch_object() expects parameter 1 to be resource, boolean given in /var/www/html/phpmyfaq/inc/PMF/DB/Pgsql.php on line 142
Re: Upgrad from 2.8 to 2.9 issue
Hi,
well, other update queries are now missing. I fixed the query for 2.9.1.
bye
Thorsten
well, other update queries are now missing. I fixed the query for 2.9.1.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Upgrad from 2.8 to 2.9 issue
No problem, I will wait for the 2.9.1 Thanks!
R.
R.