Advertisement:
« previous next »
Pages: [1]   Go Down

Author Topic: Database value  (Read 3055 times)

Offline RWhite

  • Newbie
  • *
  • Posts: 4
Database value
« on: May 02, 2012, 01:40:50 PM »
Whenever I try to log in to my forum, njbottles (dot) com I get an error message:

"The database value you are trying to insert does not exist: latitude"

Logging in from any other computer is not problem, it does right to my home page.  Why is this happening?  I've tried clering the caches and dumping history, etc. but no difference.

RWhite
Logged

Offline Doctor Deejay

  • Localizer
  • SMF Hero
  • *
  • Posts: 3,513
  • Gender: Male
Re: Database value
« Reply #1 on: May 02, 2012, 01:42:31 PM »
Hello, welcome to SMF! :) Do you have any mods installed? I haven't seen this problem before and as far as I know SMF doesn't have a column named "latitude". ;) Also, did you changed anything before the problem occurred?
Logged
Dr. Deejay
Localizer
Quote
[23:55] <@drdeejay> Just wondering, is Runic away?
[23:56] <@CoreISP> Yes
[23:56] <@CoreISP> he's sick
[23:56] <@Yoshi2889> Runic won't be attending
[23:56] <@CoreISP> I mean as in physically sick
[23:56] <@CoreISP> not the mental part that is obvious

Offline RWhite

  • Newbie
  • *
  • Posts: 4
Re: Database value
« Reply #2 on: May 02, 2012, 08:21:50 PM »
It isn't my board, I'm just a user, but I can't get there with my home computer.  Nothing changed I know about, though.
Logged

Offline MrPhil

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,801
Re: Database value
« Reply #3 on: May 02, 2012, 08:40:27 PM »
You'd probably be best off talking with your forum's administrator. Simple Machines and this forum here does not install or operate anyone else's forums, so we're kind of limited in what advice we can give to users of random SMF installations. Their system has apparently been modified in some way ("latitude" in the database, possibly something to do with a geo-referenced advertising mod?) and only the administrator will know for sure.
Logged
Please do not PM me with support questions, unless I ask you to. Unsolicited PMs for support will be ignored. It's best to have questions and answers in public, so others can research a problem and learn about it without having to ask the question yet again. Thank you!
FAQs | SMF 1.1 fixes | Project ideas
-= From the ashes shall rise a sooty tern =-

Offline RWhite

  • Newbie
  • *
  • Posts: 4
Re: Database value
« Reply #4 on: May 02, 2012, 10:50:25 PM »
That's easy for you to say, but I have no way to contact the admin, since I can't sign on to the Forum.

Thanks for the non-help.
Logged

Offline Colin

  • Customizer
  • SMF Hero
  • *
  • Posts: 5,143
  • Gender: Male
  • SMF Customizer
Re: Database value
« Reply #5 on: May 02, 2012, 10:55:16 PM »
Not to be harsh, but what do you want us to do? We don't own the forum. We are volunteers helping to make the software better.
« Last Edit: May 02, 2012, 11:11:27 PM by Colin »
Logged

Offline Kill Em All

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,089
  • Gender: Male
  • Something has to go wrong. Just has to.
    • KEAGaming
Re: Database value
« Reply #6 on: May 02, 2012, 11:08:59 PM »
Maybe possibly enter the website address here:
http://www.whois.sc/

So for example "simplemachines.org" without the quotes.

The owners information will pop up unless they have privacy enabled. You can possibly find an email address there.

I think that is the best help that we can give you unfortunately. I'm sorry.
Logged
My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

Offline NJbottles

  • Semi-Newbie
  • *
  • Posts: 22
  • Gender: Male
  • Charlie Jonsen
    • njbottles.com
Re: Database value
« Reply #7 on: May 03, 2012, 09:08:39 AM »
Hi gang, I am the admin of the forum in question.. www.njbottles.com [nofollow] and Labradoodle360 is my host..  all day yesterday, the same thing was happening to me, but as of this morning it has cleared up.. I haven't made any changes to the forum in a few months and never saw this error message before.. I do have MaxMind's Geo IP installed.. for a few months now.. could Geo IP be the cause? I have it set to block non-USA IP's.. 
Logged
Antique bottle collector and amateur forum admin

Offline Colin

  • Customizer
  • SMF Hero
  • *
  • Posts: 5,143
  • Gender: Male
  • SMF Customizer
Re: Database value
« Reply #8 on: May 03, 2012, 10:56:03 AM »
That sure sounds like the issue.
Logged

Offline NJbottles

  • Semi-Newbie
  • *
  • Posts: 22
  • Gender: Male
  • Charlie Jonsen
    • njbottles.com
Re: Database value
« Reply #9 on: May 03, 2012, 05:28:18 PM »
Thank you for the response.. I hate to be a completely helpless idiot, but could you or someone please try to explain just why it might be the source of trouble? Also, if it indeed is, can a correction be made to get Mr. White up and running again, or will I have to turn off my Geo IP? I'd hate to resort to that since it is extremely effective in amiliorating the spammer situation..
Logged
Antique bottle collector and amateur forum admin

Offline Colin

  • Customizer
  • SMF Hero
  • *
  • Posts: 5,143
  • Gender: Male
  • SMF Customizer
Re: Database value
« Reply #10 on: May 03, 2012, 07:29:41 PM »
Well first of all where is Mr. White located? Secondly is he using a proxy? Third you should be able to white list his IP.
Logged

Offline NJbottles

  • Semi-Newbie
  • *
  • Posts: 22
  • Gender: Male
  • Charlie Jonsen
    • njbottles.com
Re: Database value
« Reply #11 on: May 03, 2012, 10:09:24 PM »
His IP is in Tuscon AZ.. don't know about proxies, and I will look for a 'white list option' ..thanks again..  :)
Logged
Antique bottle collector and amateur forum admin

Offline RWhite

  • Newbie
  • *
  • Posts: 4
Re: Database value
« Reply #12 on: May 14, 2012, 05:34:50 AM »
Here I am, two weeks later, same problem exists, from just this one computer.  Nothing that anyone has suggested makes the slightest bit of difference.  I even went so far as to dump all history, cookies, forms, etc, recover the computer to a point before all this happened, changed browsers to FireFox, and still, everythime I try to get into the Forum, the error comes up:

The database value you're trying to insert does not exist: latitude

I realize that you can't deal with the specifics of someones Forum just because they use Simple machine, but since this problem seems to be with MY computer, as a simple subscriber, it seems to me that the problem certainly must have occurred before.  All I want is to sign in to the damn Forum.

I'm in Arizona, not using a proxie, and have my IP from Cox.  This problem just started out of the clear blue sky two weeks ago - and happens from no other computer, nor does it happen when I access via iPAD.
Logged

Offline MrPhil

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,801
Re: Database value
« Reply #13 on: May 14, 2012, 10:38:59 AM »
If anyone thinks of anything that you can try, we'll be sure to post it here. Note that we prefer to deal with the forum owner/administrator rather than individual users, as the admin will have more information about the situation and can implement any changes needed on the server side.
Logged
Please do not PM me with support questions, unless I ask you to. Unsolicited PMs for support will be ignored. It's best to have questions and answers in public, so others can research a problem and learn about it without having to ask the question yet again. Thank you!
FAQs | SMF 1.1 fixes | Project ideas
-= From the ashes shall rise a sooty tern =-

Offline Colin

  • Customizer
  • SMF Hero
  • *
  • Posts: 5,143
  • Gender: Male
  • SMF Customizer
Re: Database value
« Reply #14 on: May 14, 2012, 10:40:54 AM »
Truthfully I would just ask the admin to add you to the whitelist. (I am sure there has to be one for the mod he is using).
Logged

Offline Kill Em All

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 8,089
  • Gender: Male
  • Something has to go wrong. Just has to.
    • KEAGaming
Re: Database value
« Reply #15 on: May 19, 2012, 02:33:28 PM »
I'm going to go ahead and mark this solved since the forum owner appeared. If you have any other issues, please feel free to let us know.
Logged
My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

Offline NJbottles

  • Semi-Newbie
  • *
  • Posts: 22
  • Gender: Male
  • Charlie Jonsen
    • njbottles.com
Re: Database value
« Reply #16 on: May 19, 2012, 05:04:27 PM »
Yes it's resolved.. the problem went away as soon as I manually updated the GeoIP database, just so everyone knows..  ;)
Logged
Antique bottle collector and amateur forum admin

Offline Colin

  • Customizer
  • SMF Hero
  • *
  • Posts: 5,143
  • Gender: Male
  • SMF Customizer
Re: Database value
« Reply #17 on: May 19, 2012, 05:55:13 PM »
Awesome, thanks for posting. Glad you got it all worked out.
Logged
Pages: [1]   Go Up
« previous next »