Geeklog Forums

SQL Table doesn't exist
Table 'mydb.gl_blocks' doesn't exist. SQL in question:
SELECT is_enabled FROM gl_blocks WHERE name
= 'whosonline_block'

This error occured after I wrote an article and
attached a picture. Geeklog wrote the picture would be
too big (640x480 instead of 300x300).
I hit the browsers back button, reselected the picture
(which I resized to 300x300), and saved the
article again. GL responded with a blank page containing "An
SQL error has occured. Please see error.log for
details." I then took a look at error.log and it
contained the following:
Table 'mydb.gl_blocks' doesn't exist. SQL in question:
SELECT is_enabled FROM gl_blocks WHERE name
= 'whosonline_block'

Now I can't use GL any more, every page I try reports
the same SQL error message.

So does the table gl_blocks still exist in your database? And what about the other tables?

I see you also submitted this as a bug, but I very much doubt that it is one (Geeklog doesn't even contain code that could delete a table). To me, it sounds more like a problem on your end, i.e. with MySQL.

bye, Dirk

The problem is, I currently have no access to my webhosts phpmyadmin to check the tables (will be done in 3 days) and all the other scripts that use the same server and database, my forum, a newsscript etc. still do work.

Geeklog worked too, but suddenly it displayed that error. I did not change any files except the .css and the footer.thml.
But this seems not to be the problem, because everything did work before. Just from one second to another it didn't.

That's why I submitted this as a bug.

I hope we can find a solution.

Strange thing. I get an error, but a friend of mine can actually see the page. You can probably too. But I can't, so I deleted the cookies but the error still exists.
Meanwhile I restartet the install.php, but it reported an error, so I gave up.

btw: the error message in error.log is now:

The solution is near...

It works, well not really.

Deleting the cookies was not enough. I connected again to the internet to get another IP, the deleted the cookies again, and I could see the page.

Then I logged in and the error message was there again.

Your friend can see it but you can't? Have you tried different browsers? Also, try logging in as a different user.

That's right. But it has nothing to do with the browser I use, it depends on cookies an IP. That means when I delete the cookies and change my IP, I can see it too, but once I log in, the error returns.