Welcome to Geeklog, Anonymous Saturday, July 13 2024 @ 11:24 am EDT

Geeklog Forums

Unknown column when turning of blocks


Status: offline

ChrisF

Forum User
Junior
Registered: 10/07/04
Posts: 17
I just installed 1.4.0sr5-1. The documentation was very clean and I had the site up in no time.

I ran across an issue though when trying to turn off any of the blocks on the side.

When turning off the block the following message appears on the site, without any geeklog formatting.

Text Formatted Code
An SQL error has occurred. Please see error.log for details.
 


The following was in the error.log file
Text Formatted Code
Unknown column '7blkChange' in 'where clause'. SQL in question: SELECT is_enabled FROM gl_blocks WHERE bid=7blkChange=7
 


Any ideas on what's wrong?


Thanks,
Chris
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That's very odd indeed - never seen that one before.

So I have to guess: A corrupted file, maybe? Try uploading admin/block.php again.

bye, Dirk
 Quote

Status: offline

ChrisF

Forum User
Junior
Registered: 10/07/04
Posts: 17
My webserver is in my basement, so I normally just copy any install files directly to it (the original download file) and extract them there.

I did extract the download to a different directory and copied over the /admin/block.php as you requested to try and I still get the same error.

In testing further, I am able to move the blocks up and down on the block menu.

Could this be a rights issue or possible a PHP or MySQL issue?

PHP is 4.2.2
MySQL is 3.23.54 (thought 3.23.2 was needed)

Thanks,
Chris
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
It doesn't have anything to do with permissions. "blkChange" is actually the name of that checkbox and neither that nor those "7"s should be showing up in the SQL.

As I said, I've never seen this before, so I'm a bit baffled ...

You should still be able to enable/disable blocks from the block editor (there's another checkbox in there).

bye, Dirk
 Quote

Status: offline

ChrisF

Forum User
Junior
Registered: 10/07/04
Posts: 17
This might help then, the 7 doesn't show for each block I'm trying to turn off. It changes depending upon the block. I have 3blkchange, or 6blkchange or 11blkchange ...
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Those are the block IDs.

Can you check the HTML source code of that page? For each checkbox, it should contain something like
Text Formatted Code
<input type="checkbox" name="blkenable" onclick="submit()" value="17" checked="checked"><input type="hidden" name="blkChange" value="17">
 

i.e. a checkbox, followed by a hidden field named blkChange. Something there is probably messed up.

bye, Dirk
 Quote

Status: offline

ChrisF

Forum User
Junior
Registered: 10/07/04
Posts: 17
Mine pretty much looks the same.

Text Formatted Code

<input type="checkbox" name="blkenable" onclick="submit()" value="8" checked="checked"><input type="hidden" name="blkChange" value="8">

 


Could it have to do with my version of MySQL?
 Quote

All times are EDT. The time is now 11:24 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content