Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 03:22 am EST
Geeklog Forums
Cannot access block
random dood
Anonymous
Wed Mar 17 03:19:40 2004 - 1064: You have an error in your SQL syntax near '`gl_blocks` SET `blockorder` = ' 10' WHERE `bid` = '3'' at line 1. SQL in question: UPDATE `gl_blocks` SET `blockorder` = ' 10' WHERE `bid` = '3'
9
10
Quote
random dood
Anonymous
This error is on 1.3.9 btw sorry for not mentioning, and I have mysql 3.22.32 installed.
11
7
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by random dood: I have mysql 3.22.32 installed.
Any chance you can get this updated? MySQL 3.22 is so old, it's not even supported by the makers any more (not to mention possible security issues).
bye, Dirk
7
11
Quote
Random dood
Anonymous
yeah I know, but its out of my control. The site admins were gonna update it during last summer but I guess they're too busy.
How about any chance of telling me where are these SQL commands so I can edit it to make it compatible
How about any chance of telling me where are these SQL commands so I can edit it to make it compatible
11
8
Quote
Random dood
Anonymous
most of the site works perfectly sweet, like a candy 
its just the blocks.
its just the blocks.
8
7
Quote
Random dood
Anonymous
Hi there, I got this sorted, in Blocks.php
find
$q = "UPDATE `" . $_TABLES['blocks'] . "` SET `blockorder` = ' " .
$blockOrd . "' WHERE `bid` = '" . $A['bid'] ."'";
DB_query($q);
}
it should be on line 533 and edit it to
$q = "UPDATE " . $_TABLES['blocks'] . " SET blockorder = ' " .
$blockOrd . "' WHERE bid = '" . $A['bid'] ."'";
DB_query($q);
}
I basically took out the ' ' on the field names and table names, they were causing the SQL syntax error, The new version works fine with these but older ones cannot allow such ' ' (quotes)
find
Text Formatted Code
if ($A['blockorder'] != $blockOrd) {$q = "UPDATE `" . $_TABLES['blocks'] . "` SET `blockorder` = ' " .
$blockOrd . "' WHERE `bid` = '" . $A['bid'] ."'";
DB_query($q);
}
it should be on line 533 and edit it to
Text Formatted Code
if ($A['blockorder'] != $blockOrd) {$q = "UPDATE " . $_TABLES['blocks'] . " SET blockorder = ' " .
$blockOrd . "' WHERE bid = '" . $A['bid'] ."'";
DB_query($q);
}
I basically took out the ' ' on the field names and table names, they were causing the SQL syntax error, The new version works fine with these but older ones cannot allow such ' ' (quotes)
9
10
Quote
Random dood
Anonymous
Quote by Dirk:
Any chance you can get this updated? MySQL 3.22 is so old, it's not even supported by the makers any more (not to mention possible security issues).
bye, Dirk
Quote by random dood: I have mysql 3.22.32 installed.
Any chance you can get this updated? MySQL 3.22 is so old, it's not even supported by the makers any more (not to mention possible security issues).
bye, Dirk
no need to upgrade anything now
MySQL 3.22.32 and PHP 4.0.3pl1 lol. I don't think any other portal systems support these without a huge tinkering job, but yours is sweet man, just a little tinkle and it works so nice 
good job, now you can advertise that it works even for such old systems
9
9
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Random dood: good job, now you can advertise that it works even for such old systems
We did actually make sure that 1.3.8 worked on MySQL 3.22, but I completely forgot to check for 3.22 compatibility this time around.
Thanks for the patches, we'll probably add them to CVS (for future releases).
bye, Dirk
7
7
Quote
All times are EST. The time is now 03:22 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