Welcome to Geeklog, Anonymous Thursday, December 26 2024 @ 02:11 pm EST
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
9
14
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
12
15
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
13
13
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
13
9
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?
14
9
Quote
All times are EST. The time is now 02:11 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