Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 02:41 am EST
Geeklog Forums
Error 1064 in block.php
MS
Anonymous
Hi,
After looking through the help and this forum I didn't find anything like this, so I thought I'd ask. After installing GeekLog it looked like all was well. Until I went into the Admin panel.
Clicking on the Block admin section always returns the following in the web browser:
"An SQL error has occured. Please see error.log for details."
Closer inspection of the error log shows the following:
"Sat May 29 23:50:21 2004 - 1064: You have an error in your SQL syntax near '`gl_blocks` SET `blockor
der` = ' 10' WHERE `bid` = '3'' at line 1. SQL in question: UPDATE `gl_blocks` SET `blockorder` = '
10' WHERE `bid` = '3'"
Needless to say, I'm puzzled. Any help on this would be great. I'm using an older PHP (4.0.x) and MySQL, if it matters.
Thanks,
MS
After looking through the help and this forum I didn't find anything like this, so I thought I'd ask. After installing GeekLog it looked like all was well. Until I went into the Admin panel.
Clicking on the Block admin section always returns the following in the web browser:
"An SQL error has occured. Please see error.log for details."
Closer inspection of the error log shows the following:
"Sat May 29 23:50:21 2004 - 1064: You have an error in your SQL syntax near '`gl_blocks` SET `blockor
der` = ' 10' WHERE `bid` = '3'' at line 1. SQL in question: UPDATE `gl_blocks` SET `blockorder` = '
10' WHERE `bid` = '3'"
Needless to say, I'm puzzled. Any help on this would be great. I'm using an older PHP (4.0.x) and MySQL, if it matters.
Thanks,
MS
8
14
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Yes, that's a problem with older versions of MySQL. Try downloading this version of block.php from CVS.
bye, Dirk
bye, Dirk
12
12
Quote
MS
Anonymous
That did it. Thanks!
9
8
Quote
All times are EST. The time is now 02:41 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