heiseltc
Joined: 07 Oct 2003
Posts: 1
|
 Posted: Tue Oct 07, 2003 5:35 pm Post subject: found solution to some mysql_fetch_object() errors! |
 |
|
First of all, it seems that this error "corrects itself" sometimes depending on what's getting updated on your host. However, it may not.
If you are getting errors along the lines of:
| Code: | | Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource |
and everything works fine when you get to b2edit.php then this may help you. After looking all over and dissecting everything I could think of. I stumbled across this solution:
It seems that after some hosts upgrade MySQL that the "DISTINCT" flag of SELECT statements gives an error 28 ("Got error 28 from table handler"). If you look at blog.header.php, any page besides b2edit.php uses "DISTINCT", so change this line:
| Code: | | $distinct = 'DISTINCT'; |
to this:
| Code: | //$distinct = 'DISTINCT';
$distinct = ''; |
The down side is that if you have any duplicate entries, they will probably show up. Small price, I think, to have it work.
Hope this helps someone. |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
