phpMyFAQ

Warning: pg_query(): Query failed: ERROR: syntax error at or near "AFTER" at character 54 in /usr/local/www/phpmyfaq.1.6.0/inc/pgsql.php on line 108

ALTER TABLE faqdata ADD solution_id INTEGER NOT NULL AFTER lang

AFTER is not support with PostgreSQL ... not sure how the backend is/was written ...

Perfect, that was what I was looking for ... only suggestion, for readability, add a column to the front that shows # of comments, instead of the (2 Comments) at the end of the 'entry subject' ... would make it easier to read, and, at least for me, negate teh requirement to have a seperate admin ...

personally, just do 'VACUUM ANALYZE;' and it will do all tables within that database ... the other option is a loop that goes through and issues a seperate VACUUM ANALYZE for each table ...

basically, you can't do a VACUUM ANALYZE with tables seperated by commas:

# vacuum analyze faqadminlog, faqadminsessions;
ERROR: syntax error at or near "," at character 27
LINE 1: vacuum analyze faqadminlog, faqadminsessions;

in my acse, I just removed the tables and let it vacuum analyze the ...

Is there some way of listing comments in the system *without* having to go to the database itself and doing a SELECT to find out which topics have comments added to them?

more an annoyance then a bug, but ... if I leave myself logged in and come back after a period of time, and click anything (even logout), it will come back with 'Error', and taht's it... hit Logout a second time and I get the login screen...

If my session has timed out, jus bring me back to the ...

ALTER TABLE faqcomments ALTER COLUMN datum TYPE bigint;

I'm not sure how far back in releases, though, that it works on columns ... I'm using 8.1 ...

/tmp/psql.edit.50431: 1 lines, 163 characters.
ERROR: integer out of range

the faqcomments.datum value needs to be changed to a bigint instead of an int ...

Looks like the same result ... ? how come the INSERT isn't listed in the DEBUG? even if it failed, shouldn't it be listed?

DEBUG INFORMATION:
SELECT thema FROM faqdata WHERE id = 6 AND lang = 'en'
SELECT keywords FROM faqdata WHERE id = 6 AND lang = 'en'
SELECT id, lang, parent_id, name ...

d'oh, I did try $this->pg_fetch_row(), figuring there was something special abotu the $this-> part didn'tthink to get rid of the $this-> ...

that does it ... thanks ...

Yes, cut-n-paste'd directly ...

DEBUG INFORMATION:
SELECT thema FROM faqdata WHERE id = 6 AND lang = 'en'
SELECT keywords FROM faqdata WHERE id = 6 AND lang = 'en'
SELECT id, lang, parent_id, name, description FROM faqcategories WHERE lang = 'en' ORDER BY id
SELECT faqcategories.id AS id, faqcategories.lang AS lang, faqcategories ...

Fatal error: Call to undefined function: fetch_array() in /usr/local/www/phpmyfaq.1.5.5/inc/pgsql.php on line 253

Added a few FAQ items to our new phpMyFAQ 1.5.5 system ... postgresql 8.1 backend ... everything seems to work well, except when I submit a comment to an item ... nothing seems to go anywhere ... checked "SELECT * FROM faqcomments;", and its empty ... and checked the error log for postgresql, and no ...

Just installed phpMyFAQ 1.5.5, and everything installed beautifully, and is up and running ... but, when I login as admin, the Startpage generates the following error:

Fatal error: Call to undefined function: pg_fetch_row() in /usr/local/www/phpmyfaq.1.5.5/inc/pgsql.php on line 253

the code in ...