Welcome to Geeklog, Anonymous Wednesday, April 17 2024 @ 11:17 pm 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.
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
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.
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
6
5
Quote
Skinner
Anonymous
Anyone? Bueller? Bueller? 
6
3
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.
It's not timing out. The user gets the 'SQL error" message immediately, and the above error message is in the error.log.
6
3
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.
7
4
Quote
All times are EDT. The time is now 11:17 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