Geeklog Forums

Hello,

I've searched the forums and have seen people mention issues like this one....but I havent found the real solution.

I am using PHP Version 5.1.6 and Geeklog 1.4.1

At times (could be related to my sessions being cached I assume) I get the error 'An SQL error.....please see error.log

In the error log I get:

1146: Table 'mydatabasename.gl_stories' doesn't exist.
SQL in question: SELECT COUNT(*) FROM gl_stories WHERE featured = '1'

If I refresh the page.....everything seems to be ok.....and eventually after a few click through's it happens again.

I only have one story in the table....and the table is there.

The only other thing I have added is MediaGallery 1.5.0

Any ideas on how to fix this issue?

Thanks

So you are sure this refers to your actual table, i.e. the table is named "gl_stories" and it is located in the database "mydatabasename"?

If so, I'd suggest you contact your hosting service and ask them if there's a problem with their MySQL install. A database table can't just hop in and out of existence. It's either there or it isn't - permanently, in either case. Geeklog can only report what MySQL (via PHP) told it. And if the MySQL server for your site sometimes claims that the table isn't there, I'd say that's a problem on the server side.

bye, Dirk