1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
Server Crash
jamesb93
Huge Clucker
***
Posts: 216
Threads: 45
Joined: May 2009
Reputation: 0
#1

11.01.2010, 09:38
Hey,

Well my server runs on mysql and my own gamemde.

When you login the server crashes, Theres nothing in the logs to show for it either:

Code:
[10:32:58] 

[10:32:58] ---------------------------

[10:32:58] MySQL Debugging activated (01/11/10)

[10:32:58] ---------------------------

[10:32:58] 

[10:32:58] mysql_connect("*****","****","*******","*******");

[10:32:58] MySQL connection has been established

[10:32:58] mysql_stat(); Return "Uptime: 421 Threads: 1 Questions: 50 Slow queries: 0 Opens: 22 Flush tables: 1 Open tables: 15 Queries per second avg: 0.118"

[10:32:58] mysql_ping(); Return: 1

[10:32:58] mysql_query("SELECT * FROM `vehicles`"); Return: 1

[10:32:58] mysql_store_result();

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "1|451|1362.14|-1635.07|13.0848|178.166|7|7|3|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "2|451|1367.1|-1634.9|13.0895|180.653|7|7|3|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "3|451|1371.4|-1635.33|13.0901|180.04|7|7|3|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "4|424|1375.37|-1655.9|13.3828|255.379|7|0|3|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "5|424|1365.97|-1654.61|13.3828|184.051|7|0|3|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "6|467|1964.61|-1758.05|13.1229|101.471|7|7|2|40000|361"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "7|404|2134.28|-1136.4|25.3887|95.0681|2|0|2|35000|1222"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "8|496|2134.66|-1140.65|24.9736|92.6567|126|126|2|75000|1311"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "9|571|829.786|-851.947|69.2104|200.963|6|6|1|250000|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "10|468|2135.3|-1146.15|24.3377|101.511|126|1|2|175000|1284"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "37|541|-1533.85|-212.469|13.7854|35.0762|9|0|2|0|59"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "12|574|1427.07|-1649.75|13.3741|19.2456|86|86|2|150000|1222"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "17|494|-2596.24|710.769|27.8125|264.808|6|0|2|150000|1286"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "18|494|-2586.75|709.359|27.8125|276.425|6|0|1|150000|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "28|562|1377.2|-1633.69|13.1184|179.367|7|7|2|150000|358"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "20|457|1419.17|2773.74|10.4471|91.0003|4|4|1|1|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "38|411|833.062|-889.552|68.4995|66.4743|0|0|2|900000|1"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "23|432|1247.01|-2055.24|59.8039|269.463|15|10|2|1|65"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "134|447|392.511|-2054.52|13.8463|49.3836|0|0|2|0|1008"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "129|522|1244.66|-2013.27|59.4017|272.708|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "29|494|-1657.29|-447.55|20.5939|306.861|6|6|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "31|522|-1582.33|1089.7|7.03906|248.576|6|6|2|0|87"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "32|448|-1600.09|1102.68|7.03906|78.8054|6|3|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "33|541|-1521.47|899.067|7.1875|20.6317|0|0|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "34|451|-1991.57|542.002|35.0098|48.4189|0|0|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "35|541|-2636.06|1372.07|7.12682|247.992|6|6|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "126|451|1245.69|-2023.28|59.5504|269.953|3|3|6|800000|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "39|593|1866.96|-1410.21|14.0353|349.105|86|0|2|1000000|95"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "40|429|899.588|-922.611|42.2813|181.347|3|0|4|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "43|560|894.81|-922.1|42.0226|180.815|3|0|4|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "103|415|378.617|-2039.12|7.60381|55.9589|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "46|487|364.389|-2062.27|15.5743|313.005|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "47|494|1855.22|-2389.73|13.5547|89.6026|1|1|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "48|494|1854.98|-2396.4|13.5547|90.4173|0|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "49|494|1856.35|-2402.31|13.5547|90.2318|3|126|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "50|457|1844.53|-2389.71|13.5547|270.99|0|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "51|457|1845.46|-2392.28|13.5547|99.9086|3|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "52|457|1844.04|-2395.37|13.5547|279.68|7|7|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "53|522|1844.13|-2406.59|13.5547|344.241|1|1|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "54|522|1841.64|-2404.77|13.5547|11.9403|0|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "55|522|1838.51|-2405.36|13.5547|355.647|3|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "56|522|1832.63|-2405.32|13.5547|23.1886|126|126|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "57|522|1827.59|-2404.01|13.5547|347.343|0|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "58|411|-1172.16|17.542|13.8754|314.43|3|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "59|411|-1201.17|68.5556|14.1358|212.966|0|0|2|0|1313"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "60|411|-1190.78|-1.80803|13.8755|319.137|126|1|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "65|411|-1180.93|7.73509|13.8755|318.092|126|1|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "66|451|-1238.08|32.4919|13.8537|224.122|1|1|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "67|451|-1224.44|48.4113|13.8403|318.903|3|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "68|444|-1242.48|19.827|14.5197|135.882|3|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "70|444|-1199.82|-10.5252|14.52|136.039|3|1|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "71|429|-1221.92|46.4793|13.8167|319.551|3|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "72|415|-1159.04|30.2306|13.9187|309.843|0|3|2|0|1222"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "73|415|-1215.43|75.2306|13.9005|224.5|44|55|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "74|415|-1221.36|63.8888|13.9039|133.071|66|66|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "75|411|-1165.81|23.8069|13.8754|314.002|66|77|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "76|522|-1177.6|11.2112|13.7032|158.639|2|2|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "77|522|-1209.82|26.3925|13.7136|225.787|9|9|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "78|522|-1175.77|12.811|13.727|126.655|66|77|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "79|522|-1168.93|20.5874|13.7038|214.295|126|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "80|494|-1220.82|58.5215|14.0283|42.8779|4|4|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "81|494|-1187.06|46.8821|14.0435|44.3706|3|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "82|494|-1183.07|50.7428|14.0437|45.9903|0|1|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "83|494|-1191.73|42.5463|14.0438|46.3626|126|3|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "84|494|-1195.92|37.7563|14.0437|41.9754|145|6|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "86|579|362.963|-2033.97|7.75517|308.667|6|1|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "136|522|361.741|-2043.2|7.41|303.04|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "88|522|2932.42|-1670.54|872.486|336.47|3|0|0|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "89|522|2939.54|-1669.76|872.379|252.944|3|126|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "90|522|2947.91|-1672.81|872.253|10.0288|3|126|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "91|522|2945|-1673.12|872.296|100.029|0|3|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "92|522|2942.44|-1674.16|872.334|100.029|3|3|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "135|522|361.824|-2044.86|7.40053|305.518|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "94|579|1380.98|-1988.02|47.1348|172.245|1|1|2|1|21"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "96|506|1244.97|-2044.06|59.5588|268.383|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "97|415|1245.05|-2038.81|59.6286|267.56|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "98|522|1244.51|-2011.18|59.4021|272.963|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "99|579|362.835|-2029.59|7.75969|303.78|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "100|579|362.367|-2025.7|7.76749|300.025|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "104|508|2938.81|-1677.85|872.559|280.101|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "105|508|2695.92|-1661.84|320.468|279.27|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "106|422|2955.52|-1676.43|872.138|142.924|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "107|455|2927.64|-1675.73|872.556|252.4|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "108|481|2935.54|-1677.53|872.609|76.4745|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "109|481|2931.73|-1675.45|872.495|287.072|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "110|481|2930.72|-1678.95|872.509|277.072|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "128|522|1244.57|-2009.25|59.4|269.623|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "127|451|1245.29|-2033.17|59.5718|266.47|3|3|6|1|21"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "121|545|389.911|-2044.36|7.64702|130.445|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "120|482|380.863|-2028.08|7.948|44.424|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "115|520|2044.5|-2354.99|13.5469|84.039|5|5|NULL|NULL|NULL"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "125|511|1743.26|-2628.06|14.9285|21.716|6|6|5|50000|1008"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "119|415|379.905|-2034.92|7.60507|42.5204|6|6|5|1|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "122|545|384.803|-2043.72|7.64697|131.768|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "130|415|1245.12|-2028.86|59.6095|269.947|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "131|415|1245.31|-2018.11|59.6025|267.909|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "133|519|1138.23|-2019.55|69.9252|267.716|3|3|6|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "137|522|361.454|-2041.62|7.40685|303.28|6|6|5|0|0"

[10:32:58] mysql_fetch_row_format(Delimiter: |); Return: "138|432|384.931|-2076.51|7.85159|357.872|1|1|5|0|0"

[10:32:58] mysql_free_result();

[10:33:35] mysql_ping(); Return: 1

[10:33:35] mysql_real_escape_string([RG]James); Escaped 9 characters

[10:33:35] mysql_query("SELECT playerid FROM `players` WHERE name='[RG]James' LIMIT 1"); Return: 1

[10:33:35] mysql_store_result();

[10:33:35] mysql_num_rows(); Return: 1

[10:33:35] mysql_fetch_int(); Return: 1

[10:33:35] mysql_free_result();

[10:33:42] mysql_ping(); Return: 1

[10:33:42] mysql_real_escape_string([*******]); Escaped 10 characters

[10:33:42] mysql_query("SELECT * FROM `players` WHERE playerid=1 AND pass=MD5('[*******]') LIMIT 1"); Return: 1

[10:33:42] mysql_store_result();

[10:33:42] mysql_fetch_row_format(Delimiter: |); Return: "1|[RG]James|560560895e1600612bb85d56da4c67d0|150|0|180000|0|0|0|0|0|0|0|0|0|0|0|4|0|0|0|5|NULL"
and the server log shows nothing either.

P.S it works off serverffs fine but on my VPS it dosent.

Find
Reply
Calon
Big Clucker
***
Posts: 117
Threads: 2
Joined: Nov 2009
Reputation: 0
#2

11.01.2010, 10:15
Verify you have the latest MySQL plugin / MySQL software.
Find
Reply
jamesb93
Huge Clucker
***
Posts: 216
Threads: 45
Joined: May 2009
Reputation: 0
#3

11.01.2010, 10:16
yep I have the latest plugin and downloaded XAMPP fresh
Find
Reply
Calon
Big Clucker
***
Posts: 117
Threads: 2
Joined: Nov 2009
Reputation: 0
#4

11.01.2010, 10:21
If I recall, XAMPP had an update feature because you have to update as soon as you download it (not sure if that's 100% accurate), but try run any packed update wizard.
Find
Reply
jamesb93
Huge Clucker
***
Posts: 216
Threads: 45
Joined: May 2009
Reputation: 0
#5

11.01.2010, 14:22
I have 1.7.3 (latest)

Anyone else got ideas why it does this?
Find
Reply
Calon
Big Clucker
***
Posts: 117
Threads: 2
Joined: Nov 2009
Reputation: 0
#6

11.01.2010, 16:02
Are you sure you're running the latest plugin? Sorry again, but there's two separate releases, one is now deprecated.
Find
Reply
jamesb93
Huge Clucker
***
Posts: 216
Threads: 45
Joined: May 2009
Reputation: 0
#7

11.01.2010, 17:15
yea im using R2 for G-sTyLeZzZ.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support