Welcome to Geeklog, Anonymous Wednesday, March 26 2025 @ 10:56 pm 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.
The following was in the error.log file
Any ideas on what's wrong?
Thanks,
Chris
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
11
17
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
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
13
17
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
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
14
14
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
i.e. a checkbox, followed by a hidden field named blkChange. Something there is probably messed up.
bye, Dirk
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
14
10
Quote
Status: offline
ChrisF
Forum User
Junior
Registered: 10/07/04
Posts: 17
Mine pretty much looks the same.
<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?
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?
16
11
Quote
All times are EDT. The time is now 10:56 pm.
- 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