The secure CMS.

Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 05:32 am EST

Geeklog Forums

New error just came up

 New Topic  Post Reply
 05/10/08 02:24pm (Read 3,326 times)  
Status: offline

kilerb

Forum User
Regular Poster
Registered: 03/19/08
Posts: 119
Hi, a user just emailed me on myspace saying that he was trying to email me through my geeklog powered site. He said the message came up "this user prefers not to be emailed." So I went to my settings and saw that under privacy "email from users" was not checked. So, I checked it... When I hit save information, this error came up... An SQL error has occurred. Please see error.log for details.

Why would this happen? I'm not too savvy on error logs, but I could find it if necessary. The site has worked perfectly up til now, so I'm not sure what is wrong. Any suggestions?

Thanks!
B

By the way, I just went in to my panel and tried to find my logs... This is the last bit of it. Hopefully this will help figure out what's up...

Text Formatted Code
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/style.css HTTP/1.1" 304 148 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /javascript/common.js HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:45 -0700] "GET /usersettings.php?mode=edit HTTP/1.1" 200 28911 "http://www.socalstandup.com/profiles.php?uid=2" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/images/logo.gif HTTP/1.1" 304 148 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /javascript/profile_editor.js HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/images/header-bg.png HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/navbar/images/tableftJ.gif HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/navbar/images/tabrightJ.gif HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/navbar/images/tableftI.gif HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/navbar/images/tabrightI.gif HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:12:46 -0700] "GET /layout/professional/images/icon_info.png HTTP/1.1" 304 147 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:13:17 -0700] "POST /usersettings.php HTTP/1.1" 200 541 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
66.249.70.117 - - [10/May/2008:11:13:50 -0700] "GET /calendar/index.php?mode=&view=day&month=11&day=24&year=2023 HTTP/1.1" 200 17376 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
67.49.2.127 - - [10/May/2008:11:14:58 -0700] "GET /forum/memberlist.php HTTP/1.1" 200 27177 "http://www.socalstandup.com/usersettings.php?mode=edit" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:14:58 -0700] "GET /layout/professional/forum/image_set/email.gif HTTP/1.1" 304 146 "http://www.socalstandup.com/forum/memberlist.php" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:14:58 -0700] "GET /layout/professional/forum/image_set/latestposts.gif HTTP/1.1" 304 146 "http://www.socalstandup.com/forum/memberlist.php" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:14:58 -0700] "GET /layout/professional/forum/image_set/home.gif HTTP/1.1" 304 146 "http://www.socalstandup.com/forum/memberlist.php" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
67.49.2.127 - - [10/May/2008:11:15:02 -0700] "GET /profiles.php?uid=2 HTTP/1.1" 200 11508 "http://www.socalstandup.com/forum/memberlist.php" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)"
 Quote
 05/10/08 02:47pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by: kilerb

When I hit save information, this error came up... An SQL error has occurred. Please see error.log for details.[/code]


This refers to Geeklog's error.log file (in the logs directory), not your webserver's logfile (from which you quoted).

Please quote the entry or entries from Geeklog's error.log for the time when you ran into the problem.

bye, Dirk
 Quote
 05/10/08 03:12pm  
Status: offline

kilerb

Forum User
Regular Poster
Registered: 03/19/08
Posts: 119
Hi Dirk.. I'm looking everywhere... Well obviously not everywhere since I can't find it... But where is the logs directory exactly?

Thanks
 Quote
 05/10/08 03:17pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Usuall /path/to/geeklog/logs, i.e. in the same directory as your config.php. Unless you've been using Fantastico to install the site, then it's in the same directory as your lib-common.php (where it shouldn't be, but that's another story).

bye, Dirk
 Quote
 05/10/08 03:20pm  
Status: offline

kilerb

Forum User
Regular Poster
Registered: 03/19/08
Posts: 119
Thanks..... I believe this is it...

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 = 77' at line 1. SQL in question: UPDATE gl_users SET phonenumber =  WHERE uid = 77
Sat 10 May 2008 11:09:56 PDT - 1064: 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 = 2' at line 1. SQL in question: UPDATE gl_users SET phonenumber =  WHERE uid = 2
Sat 10 May 2008 11:10:07 PDT - 1064: 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 = 2' at line 1. SQL in question: UPDATE gl_users SET phonenumber =  WHERE uid = 2
Sat 10 May 2008 11:13:17 PDT - 1064: 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 = 2' at line 1. SQL in question: UPDATE gl_users SET phonenumber =  WHERE uid = 2
 
 Quote
 05/10/08 03:27pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Okay, "phonenumer" is not something that Geeklog would ask for. Did you install any add-ons recently that would use a phone number entry? Or played around with the custom registration?

Looks like that add-on is either not properly installed or not properly uninstalled.

bye, Dirk
 Quote
 05/10/08 03:59pm  
Status: offline

kilerb

Forum User
Regular Poster
Registered: 03/19/08
Posts: 119
I think "properly uninstalled" is the key. Blaine added a phone number field to the registration process. I found out later that I didn't have access to the phone numbers of the users, so I removed it. DIdn't see the point of having them enter it if I couldn't access it. So I took it out. I remember doing it and took it out in two places. I must've missed something. Where else would I have to edit out this info?

Thanks a lot...
 Quote
 05/10/08 04:09pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Not knowing what Blaine added there, I'll have to guess. It's either a plugin, in which case it would show up in the list under the Admin's Plugin panel. Or (more likely) it's using the custom registration API, in which case there's some code in your lib-custom.php that's still being called.

Most likely candidate: CUSTOM_userSave. See if you have such a function in your lib-custom.php and if you do, comment it out.

bye, Dirk
 Quote
 05/10/08 04:20pm  
Status: offline

kilerb

Forum User
Regular Poster
Registered: 03/19/08
Posts: 119
Thanks Dirk, seems to be working now. I appreciate your fast replies!

 Quote
 New Topic  Post Reply
All times are EST. The time is now 05:32 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