Welcome to Geeklog Monday, September 21 2020 @ 06:29 am EDT

Geeklog Forums

Yet Another SQL Error


Skinner

Anonymous
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


PHP 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

 
 Quote

Skinner

Anonymous
unfocused
Anyone? Bueller? Bueller? Question
 Quote

Status: Banned

machinari

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

Skinner

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

Skinner

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

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