The secure CMS.

Welcome to Geeklog, Anonymous Tuesday, December 24 2024 @ 11:59 pm EST

Geeklog Forums

SQL error when checking profile

 New Topic  Post Reply
 06/25/06 09:22pm (Read 1,559 times)  
Status: offline

scroff

Forum User
Regular Poster
Registered: 02/19/03
Posts: 111
Sorry to be so brain dead, but I'm drawing a blank to know where to start looking to fix this problem when I click on a users name to view their profile...

Text Formatted Code
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (uid = 10) ORDER BY date desc LIMIT 10' at line 1. SQL in question: SELECT date,subject,comment,replies,views,id FROM  WHERE (uid = 10) ORDER BY date desc LIMIT 10
 


I have been adding users from an old gl to the database through phpmyadmin, but I've made the necessary changes to the old tables before adding them.
 Quote
 06/30/06 01:50pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That request looks like it could be from the forum plugin. Do you have the forum plugin installed? If not, that is probably some custom code you've added somewhere to display a user's forum posting stats that won't work when the forum isn't there.

bye, Dirk
 Quote
 06/30/06 05:36pm  
Status: offline

scroff

Forum User
Regular Poster
Registered: 02/19/03
Posts: 111
Thanks, Dirk...

I don't know what happened... but I replaced public_html/users.php and the error disappeared.

I'm living proof that a little knowledge can be a dangerous thing...
 Quote
 New Topic  Post Reply
All times are EST. The time is now 11:59 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