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
 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
 Quote

MS

Anonymous
That did it. Thanks!
 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