Forum Subject: table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/01/03 01:19am
By: Anonymous (barrmulio)

I feel like this is a dumb mistake, but I\'m getting the error: 1146: Table \'db.gl_blocks\' doesn\'t exist Error log reads: 08/01/03 00:46:53 - 1146: Table \'db.gl_blocks\' doesn\'t exist SQL in question: SELECT is_enabled FROM gl_blocks WHERE name = \'whosonline_block\' Everything else seems to run fine. I\'ve tried avariety of different databases j.i.c. but I get the same mistake. Any clues? Thanks!

Re:table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/01/03 04:16am
By: Dirk

Something must have gone wrong during the installation. You should have 39 tables in your database (40, if you\'re using 1.3.7). I\'d suggest you drop the database and run the install script again, paying close attention on any error or warning messages that may flash up during the process. bye, Dirk

Re:table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/01/03 12:09pm
By: Anonymous (Barrmulio)

Thanks for the prompt reply!! I just dropped the table, and recreated another one. Didn\'t work (same exact error). I went to check and no tables were created at all. I dropped this one, and tried again, same error. At least it\'s consistent... Checking another tread, I also made sure the permissions on mysql were set right, but this didn\'t make a difference...

Re:table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/01/03 04:41pm
By: Dirk

[QUOTE BY= Barrmulio]I went to check and no tables were created at all.[/QUOTE] Did you get to the success page after the install? I would assume you get an error during the install script, but don\'t see it. Can you try switching error_reporting on in PHP (if you have access to the php.ini)? If not, you may need to add some debug output in the install script to find out what\'s going on ... bye, Dirk

Re:table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/01/03 05:35pm
By: Anonymous (Barrmulio)

Hi again, I don\'t get anything during the install except for a white page with the txt: \"1146: Table \'geek.gl_blocks\' doesn\'t exist\" Error reporting was on: (nothing changed from default php install) \"error_reporting = E_ALL; display all errors, warnings and notices\" I have access to everything since the site is being run on my IIS 5 server before I go live. Maybe this will make troubleshooting easier. Any clue to maybe where I should be looking in the install script? Since noone seems to have had this problem, it may just be my machine thanks for the continued support

Re:table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/01/03 06:09pm
By: Dirk

[QUOTE BY= Barrmulio]Any clue to maybe where I should be looking in the install script?[/QUOTE] The tables are created in function INST_createDatabaseStructures(), so it would be interesting to know if it even gets there. [QUOTE BY= Barrmulio]Since noone seems to have had this problem, it may just be my machine [/QUOTE] There are at least two bugs in the install script (as I just learned today), but in those cases, it at least creates the tables ... bye, Dirk

Re:table \'db.gl_blocks\' doesn\'t exist error

Posted on: 08/03/03 04:24am
By: Dazzy

Out of curiosity are you using a masked URL in the $_CONF[\'site_url\'] setting? Also make sure you are not editing your files with a WYSIWYG editor such as Dreamweavor,(I had the same problem and it was a combination of these two setup errors) if you have been start with a fresh version of the file and use soemthing like notepad or wordpad.