Geeklog Forums

Please help me out here before I go totally insane. I followed the guidelines in the install text file and ignored the docs/install.html file as instructed. I have created the "geeklog" database in mysql as required. However, when I attempt to execute the ... "public_html/admin/install/install.php" script I get the following error. 1146: Table 'geeklog.gl_blocks' doesn't exist Um, of course 'geeklog.gl_blocks' doesn't exist yet. After all, is the install script not supposed to set up the tables in the dbase for me? Please advise. Thx.

That's strange. It sounds like you did everything correctly.

Is this the only error message you get? Can you check your error.log file to see if that contains other errors or more details?

bye, Dirk

Props to Dirk for the prompt reply. The error.log contains the following message repeated numerous times . . . 1146: Table 'geeklog.gl_blocks' doesn't exist SQL in question: SELECT is_enabled FROM gl_blocks WHERE name = 'whosonline_block' Thx again Dirk.

The error message seems to be caused by lib-common.php. Since the install script does not use lib-common.php, but success.php does, I would assume that the install script went through, and the error occurs when it tries to execute success.php.

Can you check if it actually created any tables in your database? You should have 40 tables.

At the moment it looks like a database issue to me. Please check you database settings in config.php again and that the database user has the proper rights (e.g. to create tables).

bye, Dirk

Hi Dirk, i've searched the site about this error #1146. My problem is, after adding the simple code to check for security of my site (in the 'Are you secure?' link), uploading it (lib-custom.php) and then creating the PHP block as per instruction, when i click 'Home' i get this error msg: 1146: Table 'geeklog.users' doesn't exist. Obviously it doesn't exist bec i've prefixed my tables with 'GL_'. When i delete the PHP block, the error's gone. So i presume that's the one causing it. So why do i receive this error? Thanks, Luigi MD

The PHP block from the "Are you secure?" page has this SQL statement in it: select count(*) as count from users where ... So when you are using a gl_ prefix on your tables you need to change this to select count(*) as count from gl_users where ... That should get rid of the error. bye, Dirk

I have the same problem. The install is writing only 13 tables then it quits.