Posts: 626
Threads: 76
Joined: Apr 2011
Reputation:
0
A couple days ago I look at my server tables for house and businesses. I noticed that most of the houses and businesses "owner" field was set to "NULL". No where in my script it says to do that, so I have reason to believe that a failed MySQL query has failed and caused this. But I have not added any new queries that interfere with houses/businesses lately.
So, what would a query that would make this happen insist of? Or perhaps too many queries executing at the same time?
Thanks.
Posts: 2,938
Threads: 162
Joined: May 2010
Posts: 977
Threads: 10
Joined: Apr 2011
Reputation:
0
NULL basically means nothing, or empty, so it makes sense to be there if there is no value for that field!
Anyway, you may have set up your table to default the values to NULL.
Posts: 2,938
Threads: 162
Joined: May 2010
Quote:
Originally Posted by lolumadd_
Thanks for your help smart ass but I already checked the logs.
|
nice, you didn't even
state that you checked the logs, so I gave a simple suggestion yet you burst out? cool.
Posts: 2,938
Threads: 162
Joined: May 2010
Quote:
Originally Posted by lolumadd_
I didn't burst out and you said "check the logs?" not "Try checking the logs." There is a difference between the two, the second one is much more polite.
|
Okay, it seemed like my response was a "command" and not a question, I guess..
anyway.. try debugging the loading, then gmx and print the loading. see what it outputs?
Maybe your ongamemodeexit is being called after ongamemodeinit? (I've seen this before when you gmx)
Posts: 2,938
Threads: 162
Joined: May 2010
can you show the query string, please change the field names if you feel insecure
Posts: 2,629
Threads: 40
Joined: Mar 2008
Reputation:
0
Make sure that the string name for mysql_query is the same string you formatted the SQL query with. Could you please show us the format line + the mysql_query line.