Everytime I run Cron.
There is an error on Comment
-
Notice: Undefined variable: key in comment_prepare_thread() (line 901 of /home/domain/public_html/beta/modules/comment/comment.module).
-
Warning: Creating default object from empty value in comment_prepare_thread() (line 901 of /home/domain/public_html/beta/modules/comment/comment.module).
I tried deleting all sample comments and updating core. The error is still there. Please help how to fix it. Thanks.
Best Regards,
Andre
Hi,
We will check and reply ASAP :)
Could you send uss your site url, admin account and FTP account? We would like to have a check on your site.
Please remember to check "Private message" for security reason.
In your database:
SELECT * FROM `comment` WHERE uid NOT IN (SELECT uid FROM users)
"If you are having this error because it cant find the user accounts in the UID column then you can (a) delete the comment(s) or (b) keep them and just update them to point at a valid User Profile."
UPDATE `comment` SET uid = 0 WHERE uid NOT IN (SELECT uid FROM users)