Forum
Comments going live without pending
Just as it says in the title.
Debug Message
SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='ab864187ae1dc49c82b42fb46c2ef0f5' LIMIT 1
UPDATE perch2_users SET userHash='af7b8682aa105a081124eed9a6ef8cd5' WHERE userID=1
SELECT p.privKey FROM perch2_user_privileges p
INSERT INTO perch2_comments(parentID,commentDateTime,commentName,commentHTML,parentTitle,commentDynamicFields,commentSpamData,commentIP,commentStatus) VALUES('example1','2015-04-02 15:01:45','Ok','<p>This should start pending</p>','Comments Example','{\"submitComment\":\"Add\"}','{\"fields\":{\"body\":\"This should start pending\",\"name\":\"Ok\"},\"environment\":{\"PATH\":\"\\/bin:\\/usr\\/bin:\\/sbin:\\/usr\\/sbin\",\"RAILS_ENV\":\"production\",\"SCRIPT_NAME\":\"\\/comments\\/index.php\",\"REQUEST_URI\":\"\\/comments\\/\",\"QUERY_STRING\":\"\",\"REQUEST_METHOD\":\"POST\",\"SERVER_PROTOCOL\":\"HTTP\\/1.1\",\"GATEWAY_INTERFACE\":\"CGI\\/1.1\",\"REMOTE_PORT\":\"34949\",\"SCRIPT_FILENAME\":\"\\/home\\/artmal1\\/staging.wilkinsonyoga.co.uk\\/comments\\/index.php\",\"SERVER_ADMIN\":\"webmaster@staging.wilkinsonyoga.co.uk\",\"DOCUMENT_ROOT\":\"\\/home\\/artmal1\\/staging.wilkinsonyoga.co.uk\",\"REMOTE_ADDR\":\"82.132.236.222\",\"SERVER_PORT\":\"80\",\"SERVER_ADDR\":\"208.97.176.102\",\"SERVER_NAME\":\"staging.wilkinsonyoga.co.uk\",\"SERVER_SOFTWARE\":\"Apache\",\"SERVER_SIGNATURE\":\"\",\"HTTP_CONNECTION\":\"close\",\"HTTP_CACHE_CONTROL\":\"max-age=43200\",\"HTTP_HOST\":\"staging.wilkinsonyoga.co.uk\",\"HTTP_O2GW_ID\":\"07\",\"HTTP_X_FORWARDED_FOR\":\"10.145.186.25\",\"HTTP_X_GATEWAY\":\"wap.london.02.net\",\"HTTP_ACCEPT_ENCODING\":\"gzip, deflate\",\"HTTP_ACCEPT_LANGUAGE\":\"en-us\",\"HTTP_REFERER\":\"https:\\/\\/staging.wilkinsonyoga.co.uk\\/comments\\/\",\"HTTP_USER_AGENT\":\"Mozilla\\/5.0 (Macintosh; Intel Mac OS X 10_10) AppleWebKit\\/600.2.5 (KHTML, like Gecko) Version\\/8.0.2 Safari\\/600.2.5\",\"HTTP_ACCEPT\":\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,*\\/*;q=0.8\",\"CONTENT_LENGTH\":\"243\",\"HTTP_COOKIE\":\"cmsa=1; cmssb=1; PHPSESSID=iZzR6OvS2ir6GXLK-tErU0; __utma=127942666.1373933881.1412179740.1427968208.1427976377.33; __utmc=127942666; __utmz=127942666.1425312881.17.2.utmcsr=stidston.com|utmccn=(referral)|utmcmd=referral|utmcct=\\/post\\/preview\",\"HTTP_ORIGIN\":\"https:\\/\\/staging.wilkinsonyoga.co.uk\",\"CONTENT_TYPE\":\"application\\/x-www-form-urlencoded\",\"DH_USER\":\"artmal1\",\"ds_id_29025063\":\"\",\"dsid\":\"29025063\",\"SCRIPT_URI\":\"https:\\/\\/staging.wilkinsonyoga.co.uk\\/comments\\/\",\"SCRIPT_URL\":\"\\/comments\\/\",\"UNIQUE_ID\":\"VR1Z2dBx2VcAADr7dsIAAAAK\",\"FCGI_ROLE\":\"RESPONDER\",\"PHP_SELF\":\"\\/comments\\/index.php\",\"REQUEST_TIME_FLOAT\":1427986905.6939,\"REQUEST_TIME\":1427986905}}',1384443102,'LIVE')
SELECT * FROM perch2_comments WHERE commentID='10' LIMIT 1
No ids to log.
SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/comments/index.php' LIMIT 1
Using template: /templates/navigation/item.html
SELECT COUNT(*) FROM perch2_comments WHERE parentID='example1' AND commentStatus='LIVE'
SELECT * FROM perch2_comments WHERE 1=1 AND parentID='example1' AND commentStatus='LIVE' ORDER BY commentDateTime ASC
Using template: /addons/apps/perch_comments/templates/comments/comment.html
Using template: /addons/apps/perch_comments/templates/comments/comment_form.html
Are you logged in when posting these comments?
Yes. Add if I log out then pending works!
Thanks Rachel
Can I cause comments to go live without pending if that is now my desired behaviour?
No, as you would end up with a blog full of spam.