I'm getting a strange error message when I try to run a JOIN query on this one site. The really puzzling part is that this same query worked fine yesterday, and still works fine here on my machine. Anyway, here's the query:
SELECT success_stories.story_id, story_title, story_thumbnail_image, story_short_desc, COUNT(success_stories_slideshows.photo_id) AS photo_count FROM success_stories LEFT JOIN success_stories_slideshows ON success_stories.story_id=success_stories_slideshows.story_id WHERE story_status > 0 GROUP BY success_stories.story_id ORDER BY story_rank ASC, story_date ASC
I get this message back from mysql_error:
Error: Got error 28 from table handler
We are running MySQL 4.0.25 on the server, and I have MySQL 4.0.20a-nt here on my machine. I'm staring at the query and I don't see what's wrong w/ it. The only other change on the site from yesterday today is that some of the success stories have quotes in the title, and I added an .htaccess file to the server w/ these variables:
php_value safe_mode On
php_value register_globals Off
php_value magic_quotes_gpc On
php_value display_startup_errors On
Any ideas??
