Comment submitted, but doesn't go anywhere ... ?

scrappy · Post by **scrappy** » Sun Jan 08, 2006 6:42 am

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 errors there ...

Before I run through and try to debug this, is this a known problem that has already been fixed?

Thanks ...

Post by **Thorsten** » Sun Jan 08, 2006 1:59 pm

Hi,

can you enable the debug mode in inc/ini.php and post the queries here?

Thanks!

bye
Thorsten

scrappy · Post by **scrappy** » Mon Jan 09, 2006 6:15 am

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.parent_id AS parent_id, faqcategories.name AS name, faqcategories.description AS description FROM faqcategoryrelations, faqcategories WHERE faqcategories.id=faqcategoryrelations.category_id AND faqcategoryrelations.record_id = 6 AND faqcategoryrelations.category_lang = 'en'
SELECT count(sid) FROM faqsessions WHERE time > 1136783381 GROUP BY ip
SELECT DISTINCT faqdata.id AS id, faqdata.lang AS lang, faqdata.thema AS thema, faqcategoryrelations.category_id AS category_id, faqvisits.visits AS visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'en' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqvisits.visits DESC
SELECT DISTINCT faqdata.id AS id, faqdata.lang AS lang, faqcategoryrelations.category_id AS category_id, faqdata.thema AS thema, faqdata.datum AS datum, faqvisits.visits AS visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'en' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqdata.datum DESC

Post by **Thorsten** » Mon Jan 09, 2006 12:18 pm

Hi,

are these queries the ones after a comment post?

bye
Thorsten

scrappy · Post by **scrappy** » Mon Jan 09, 2006 6:59 pm

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

Post by **Thorsten** » Mon Jan 09, 2006 8:10 pm

Hi,

okay, I'll test it the next days with a local PostgreSQL installation.

bye
Thorsten

Post by **Thorsten** » Mon Jan 09, 2006 9:00 pm

Hi,

can you please replace line 38 in savecomment.php with the following line:

Code: Select all

$result = $db->query("INSERT INTO ".SQLPREFIX."faqcomments (id_comment, id, usr, email, comment, datum, helped) VALUES (".$db->nextID(SQLPREFIX."faqcomments", "id_comment").", ".$id.", '".$comment_by_user."', '".$comment_by_mail."', '".$comment."', ".$datum.", '".$helped."')");

bye
Thorsten

scrappy · Post by **scrappy** » Mon Jan 09, 2006 10:45 pm

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, description FROM faqcategories WHERE lang = 'en' ORDER BY id
SELECT faqcategories.id AS id, faqcategories.lang AS lang, faqcategories.parent_id AS parent_id, faqcategories.name AS name, faqcategories.description AS description FROM faqcategoryrelations, faqcategories WHERE faqcategories.id=faqcategoryrelations.category_id AND faqcategoryrelations.record_id = 6 AND faqcategoryrelations.category_lang = 'en'
SELECT count(sid) FROM faqsessions WHERE time > 1136842629 GROUP BY ip
SELECT DISTINCT faqdata.id AS id, faqdata.lang AS lang, faqdata.thema AS thema, faqcategoryrelations.category_id AS category_id, faqvisits.visits AS visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'en' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqvisits.visits DESC
SELECT DISTINCT faqdata.id AS id, faqdata.lang AS lang, faqcategoryrelations.category_id AS category_id, faqdata.thema AS thema, faqdata.datum AS datum, faqvisits.visits AS visits FROM faqvisits, faqdata LEFT JOIN faqcategoryrelations ON faqdata.id = faqcategoryrelations.record_id AND faqdata.lang = faqcategoryrelations.record_lang WHERE faqdata.lang = 'en' AND faqdata.id = faqvisits.id AND faqdata.lang = faqvisits.lang AND faqdata.active = 'yes' ORDER BY faqdata.datum DESC

Post by **Thorsten** » Tue Jan 10, 2006 7:28 am

Hi,

can you try to insert the INSERT query from savecomment.php in your PostgreSQL console? Just to test this.

bye
Thorsten

scrappy · Post by **scrappy** » Tue Jan 10, 2006 6:23 pm

/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 ...

Post by **Thorsten** » Tue Jan 10, 2006 7:57 pm

Hi,

I fixed it in the install scripts. Does a ALTER TABLE work in PostgreSQL?

bye
Thorsten

scrappy · Post by **scrappy** » Tue Jan 10, 2006 9:00 pm

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

Post by **Thorsten** » Tue Jan 10, 2006 9:17 pm

Hi,

great, I'll add that on the update script for 1.5.6.

Thanks for your help.

bye
Thorsten