when i tried to delete it through "edit comments" got this:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/.../.../.../databases/mysqli.php on line 20 Non-numeric id value given in creating object.
Well, the issue is how it came to lose its auto_increment. I've seen that happen before on sites that originated in really old versions, I believe it's because the original field type which the old setup created isn't compatible with auto_increment in newer mysql versions (what was allowed in mysql 3 may not be allowed in mysql 5). I'll see if I can add a column sanity check on upgrade.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on reject comments does not work
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/.../.../.../databases/mysqli.php on line 23
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/.../.../.../databases/mysqli.php on line 23
Comment does not get rejected/deleted - gives above error
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Works for me. Post the debug info. scripts.webmastersite.net/w...icles/mysql-errors-66.html
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
it's weird but I can make it show queries..
It shows all queries accept when I go to validate page - it does not show queries...
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
when i tried to delete it through "edit comments" got this:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/.../.../.../databases/mysqli.php on line 20
Non-numeric id value given in creating object.
WSN Links 4.1.55
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
I found the problem - the field "id" for comments table was not set to "auto_increment" ...
this is not a bug, please delete the post
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
Well, the issue is how it came to lose its auto_increment. I've seen that happen before on sites that originated in really old versions, I believe it's because the original field type which the old setup created isn't compatible with auto_increment in newer mysql versions (what was allowed in mysql 3 may not be allowed in mysql 5). I'll see if I can add a column sanity check on upgrade.