Welcome to Geeklog, Anonymous Saturday, April 20 2024 @ 04:37 pm EDT

Geeklog Forums

Yet Another SQL Error


Geeklog 1.3.10
php 4.1.2, register globals on, not running in safe mode
MySQL 3.23.43
When a new story is posted on the main page, logged in users can see it no problem. When an anonymous user views the front page, the following SQL error is generated.
Anonymous users that can go straight to the topic page bypassing the main page don't generate that error and can see the stories. It's only on the main page that this happens. Any ideas? It causes the server to restart the MySQL process. Smile

Text Formatted Code

 Lost connection to MySQL server during query. SQL in question: SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) as day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM hfh_stories as s, hfh_users as u, hfh_topics as t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1  AND (s.perm_anon >= 2) AND (s.tid IN ('General')) ORDER BY featured DESC, date DESC LIMIT 0, 10



Anyone? Bueller? Bueller? Question

Status: Banned


Forum User
Full Member
Registered: 03/22/04
Posts: 1512
try this


Nope, didn't do the trick. Any other ideas? it installed without a hitch and this is the only page that has any types of isses at all.
It's not timing out. The user gets the 'SQL error" message immediately, and the above error message is in the error.log.


Ah well, fixed it by updating to MySQL 4.1, which allso fixed a problem with backups and mysqldump at the same time.

All times are EDT. The time is now 04:37 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