Страница 1 из 1

[not a bug] Баг с Настройкой!

Добавлено: 09 июн 2013, 19:05
akmaljonmusaev
Версия движка: V37a6.4
ОС: Windows 7
Браузер: Chrome 25
когда в настройках ставил птичку на Замерить разницу между локальным (клиентским) и серверным временем и нажал сохранит то такая ошибка !!!

User ID 97 raised error code 500 titled 'SQL Error' with text 'Unknown column \'user_time_diff\' in \'field list\'
UPDATE sn_users SET\n `username` = \'anonymous\',\n `password` = \'e84264732eb3f5ef4d150ea9f6b364c06\',\n `email` = \'nomail@gmail.com\',\n `lang` = \'ru\',\n `avatar` = \'0\',\n `dpath` = \'\',\n `design` = \'1\',\n `noipcheck` = \'0\',\n `planet_sort` = \'0\',\n `planet_sort_order` = \'0\',\n `spio_anz` = \'1\',\n `settings_tooltiptime` = \'5\',\n `settings_fleetactions` = \'0\',\n `settings_esp` = \'1\',\n `settings_wri` = \'1\',\n `settings_bud` = \'1\',\n `settings_mis` = \'1\',\n `settings_rep` = \'0\',\n `deltime` = \'0\',\n `vacation` = \'0\',\n `options` = \'opt_email_msg_admin^1|opt_email_mnl_joueur^1|opt_email_mnl_alliance^1|opt_mnl_spy^1|opt_email_mnl_spy^1|opt_mnl_attaque^1|opt_email_mnl_attaque^1|opt_mnl_transport^1|opt_email_mnl_transport^1|opt_mnl_exploit^1|opt_email_mnl_exploit^1|opt_mnl_expedition^1|opt_email_mnl_expedition^1|opt_mnl_buildlist^1|opt_email_mnl_buildlist^1|opt_uni_avatar_user^1|opt_uni_avatar_ally^1|opt_int_struc_vertical^1|opt_int_navbar_resource_force^1|opt_int_overview_planet_columns^0|opt_int_overview_planet_rows^5|\'\n , `user_time_diff` = NULL\n WHERE `id` = \'97\' LIMIT 1
' on page /index.php
backtrace = array(3)
2 => array(4)
file => string(41) /var/www/snova/includes/pages/options.php
line => integer 253
function => string(7) doquery
args => array(1)
0 => string(1174) UPDATE∴{{users}}∴SET¶;∴∴∴∴∴∴`username`∴=∴'anonymous',¶;∴∴∴∴∴∴`password`∴=∴'e8778f32eb3f5ef4d150ea9f6b364c06',¶;∴∴∴∴∴∴`email`∴=∴'nomail@gmail.com',¶;∴∴∴∴∴∴`lang`∴=∴'ru',¶;∴∴∴∴∴∴`avatar`∴=∴'0',¶;∴∴∴∴∴∴`dpath`∴=∴'',¶;∴∴∴∴∴∴`design`∴=∴'1',¶;∴∴∴∴∴∴`noipcheck`∴=∴'0',¶;∴∴∴∴∴∴`planet_sort`∴=∴'0',¶;∴∴∴∴∴∴`planet_sort_order`∴=∴'0',¶;∴∴∴∴∴∴`spio_anz`∴=∴'1',¶;∴∴∴∴∴∴`settings_tooltiptime`∴=∴'5',¶;∴∴∴∴∴∴`settings_fleetactions`∴=∴'0',¶;∴∴∴∴∴∴`settings_esp`∴=∴'1',¶;∴∴∴∴∴∴`settings_wri`∴=∴'1',¶;∴∴∴∴∴∴`settings_bud`∴=∴'1',¶;∴∴∴∴∴∴`settings_mis`∴=∴'1',¶;∴∴∴∴∴∴`settings_rep`∴=∴'0',¶;∴∴∴∴∴∴`deltime`∴=∴'0',¶;∴∴∴∴∴∴`vacation`∴=∴'0',¶;∴∴∴∴∴∴`options`∴=∴'opt_email_msg_admin^1|opt_email_mnl_joueur^1|opt_email_mnl_alliance^1|opt_mnl_spy^1|opt_email_mnl_spy^1|opt_mnl_attaque^1|opt_email_mnl_attaque^1|opt_mnl_transport^1|opt_email_mnl_transport^1|opt_mnl_exploit^1|opt_email_mnl_exploit^1|opt_mnl_expedition^1|opt_email_mnl_expedition^1|opt_mnl_buildlist^1|opt_email_mnl_buildlist^1|opt_uni_avatar_user^1|opt_uni_avatar_ally^1|opt_int_struc_vertical^1|opt_int_navbar_resource_force^1|opt_int_overview_planet_columns^0|opt_int_overview_planet_rows^5|'¶;∴∴∴∴∴∴,∴`user_time_diff`∴=∴NULL¶;∴∴∴∴WHERE∴`id`∴=∴'97'∴LIMIT∴1
3 => array(2)
function => string(16) sn_options_model
args => array(0)
4 => array(4)
file => string(24) /var/www/snova/index.php
line => integer 18
function => string(14) call_user_func
args => array(1)
0 => string(16) sn_options_model
query_log = string(110) ⇐¶;⇐¶;Query∴log⇐¶;<table><tr><th>Number</th><th>Query</th><th>Page</th><th>Table</th><th>Rows</th></tr></table>⇐¶;
user = array(117)
id => string(2) 97
username => string(9) anonymous
authlevel => string(1) 0
vacation => string(1) 0
banaday => string(1) 0
dark_matter => string(6) 105466
spy_tech => string(2) 17
computer_tech => string(2) 17
military_tech => string(2) 22
defence_tech => string(2) 22
shield_tech => string(2) 20
energy_tech => string(2) 17
hyperspace_tech => string(2) 12
combustion_tech => string(2) 20
impulse_motor_tech => string(2) 13
hyperspace_motor_tech => string(2) 12
laser_tech => string(2) 20
ionic_tech => string(2) 16
buster_tech => string(2) 12
intergalactic_tech => string(1) 7
expedition_tech => string(1) 0
colonisation_tech => string(2) 11
graviton_tech => string(1) 1
player_artifact_list => string(0)
ally_id => string(2) 23
ally_tag => string(5) Y-K-Y
ally_name => string(14) Yippie-Kai-Yay
ally_register_time => string(10) 1370259588
ally_rank_id => string(1) 0
player_que => NULL
lvl_minier => string(3) 202
xpminier => string(8) 35446731
player_rpg_tech_xp => string(8) 11772815
player_rpg_tech_level => string(3) 175
lvl_raid => string(1) 1
xpraid => string(1) 0
raids => string(1) 0
raidsloose => string(1) 0
raidswin => string(1) 0
new_message => string(1) 0
mnl_alliance => string(1) 0
mnl_joueur => string(1) 0
mnl_attaque => string(1) 0
mnl_spy => string(1) 0
mnl_exploit => string(1) 0
mnl_transport => string(1) 0
mnl_expedition => string(1) 0
mnl_buildlist => string(1) 0
msg_admin => string(1) 0
bana => NULL
deltime => integer 0
news_lastread => string(10) 1370796123
total_rank => string(2) 18
total_points => string(9) 120131436
password => string(32) e8778f32eb3f5ef4d150ea9f6b364c06
email => string(16) nomail@gmail.com
email_2 => string(16) nomail@gmail.com
lang => string(2) ru
sex => string(1) M
avatar => string(1) 0
sign => NULL
id_planet => string(4) 1347
galaxy => string(1) 5
system => string(3) 150
planet => string(1) 5
current_planet => string(4) 1018
user_agent => string(102) Mozilla/5.0∴(Windows∴NT∴6.1)∴AppleWebKit/537.22∴(KHTML,∴like∴Gecko)∴Chrome/25.0.1364.172∴Safari/537.22
user_lastip => string(14) 213.230.103.29
user_proxy => string(0)
register_time => string(10) 1365355389
onlinetime => string(10) 1370797635
dpath => string(0)
design => integer 1
noipcheck => integer 0
options => string(494) opt_email_msg_admin^1|opt_email_mnl_joueur^1|opt_email_mnl_alliance^1|opt_mnl_spy^1|opt_email_mnl_spy^1|opt_mnl_attaque^1|opt_email_mnl_attaque^1|opt_mnl_transport^1|opt_email_mnl_transport^1|opt_mnl_exploit^1|opt_email_mnl_exploit^1|opt_mnl_expedition^1|opt_email_mnl_expedition^1|opt_mnl_buildlist^1|opt_email_mnl_buildlist^1|opt_uni_avatar_user^1|opt_uni_avatar_ally^1|opt_int_struc_vertical^1|opt_int_navbar_resource_force^1|opt_int_overview_planet_columns^0|opt_int_overview_planet_rows^5|
planet_sort => integer 0
planet_sort_order => integer 0
spio_anz => integer 1
settings_tooltiptime => integer 5
settings_fleetactions => integer 0
settings_esp => integer 1
settings_wri => integer 1
settings_bud => integer 1
settings_mis => integer 1
settings_rep => integer 0
user_as_ally => NULL
metal => string(7) 0.00000
crystal => string(7) 0.00000
deuterium => string(7) 0.00000
que => string(0)
user_birthday => string(10) 1995-11-07
user_birthday_celebrated => string(10) 2012-11-07
player_race => string(1) 4
user_remember_me => string(1) 0
opt_email_msg_admin => string(1) 1
opt_email_mnl_joueur => string(1) 1
opt_email_mnl_alliance => string(1) 1
opt_mnl_spy => string(1) 1
opt_email_mnl_spy => string(1) 1
opt_mnl_attaque => string(1) 1
opt_email_mnl_attaque => string(1) 1
opt_mnl_transport => string(1) 1
opt_email_mnl_transport => string(1) 1
opt_mnl_exploit => string(1) 1
opt_email_mnl_exploit => string(1) 1
opt_mnl_expedition => string(1) 1
opt_email_mnl_expedition => string(1) 1
opt_mnl_buildlist => string(1) 1
opt_email_mnl_buildlist => string(1) 1
opt_uni_avatar_user => string(1) 1
opt_uni_avatar_ally => string(1) 1
opt_int_struc_vertical => string(1) 1
opt_int_navbar_resource_force => string(1) 1
opt_int_overview_planet_columns => string(1) 0
opt_int_overview_planet_rows => string(1) 5
option_list => array(3)
1 => array(15)
opt_email_msg_admin => string(1) 1
opt_email_mnl_joueur => string(1) 1
opt_email_mnl_alliance => string(1) 1
opt_mnl_spy => string(1) 1
opt_email_mnl_spy => string(1) 1
opt_mnl_attaque => string(1) 1
opt_email_mnl_attaque => string(1) 1
opt_mnl_transport => string(1) 1
opt_email_mnl_transport => string(1) 1
opt_mnl_exploit => string(1) 1
opt_email_mnl_exploit => string(1) 1
opt_mnl_expedition => string(1) 1
opt_email_mnl_expedition => string(1) 1
opt_mnl_buildlist => string(1) 1
opt_email_mnl_buildlist => string(1) 1
2 => array(2)
opt_uni_avatar_user => string(1) 1
opt_uni_avatar_ally => string(1) 1
3 => array(4)
opt_int_struc_vertical => string(1) 1
opt_int_navbar_resource_force => string(1) 1
opt_int_overview_planet_columns => string(1) 0
opt_int_overview_planet_rows => string(1) 5
ally => array(20)
id => string(2) 23
ally_name => string(14) Yippie-Kai-Yay
ally_tag => string(5) Y-K-Y
ally_owner => string(1) 6
ally_register_time => string(10) 1368812882
ally_description => string(46) Фан∴клуб∴Джона∴Макклейна.
ally_web => string(0)
ally_text => NULL
ally_image => string(1) 0
ally_request => NULL
ally_request_waiting => NULL
ally_request_notallow => string(1) 0
ally_owner_range => string(9) Rodriguez
ally_ranks => NULL
ally_members => string(1) 5
ranklist => string(95) Новичок,1,1,1,0,0,0,0;В∴самоволке,1,1,1,1,1,0,0;भाग्य,1,1,1,0,0,0,0;
total_rank => string(1) 5
total_points => string(9) 682840059
ally_user_id => string(3) 260
player => array(93)
id => string(3) 260
username => string(0)
authlevel => string(1) 0
vacation => string(1) 0
banaday => string(1) 0
dark_matter => string(1) 0
spy_tech => string(1) 0
computer_tech => string(1) 0
military_tech => string(1) 0
defence_tech => string(1) 0
shield_tech => string(1) 0
energy_tech => string(1) 0
hyperspace_tech => string(1) 0
combustion_tech => string(1) 0
impulse_motor_tech => string(1) 0
hyperspace_motor_tech => string(1) 0
laser_tech => string(1) 0
ionic_tech => string(1) 0
buster_tech => string(1) 0
intergalactic_tech => string(1) 0
expedition_tech => string(1) 0
colonisation_tech => string(1) 0
graviton_tech => string(1) 0
player_artifact_list => NULL
ally_id => NULL
ally_tag => NULL
ally_name => NULL
ally_register_time => string(1) 0
ally_rank_id => string(1) 0
player_que => NULL
lvl_minier => string(1) 1
xpminier => string(1) 0
player_rpg_tech_xp => string(1) 0
player_rpg_tech_level => string(1) 0
lvl_raid => string(1) 1
xpraid => string(1) 0
raids => string(1) 0
raidsloose => string(1) 0
raidswin => string(1) 0
new_message => string(2) 32
mnl_alliance => string(1) 0
mnl_joueur => string(1) 0
mnl_attaque => string(1) 0
mnl_spy => string(1) 0
mnl_exploit => string(1) 0
mnl_transport => string(1) 0
mnl_expedition => string(1) 0
mnl_buildlist => string(1) 0
msg_admin => string(2) 32
bana => NULL
deltime => string(1) 0
news_lastread => string(1) 0
total_rank => string(1) 0
total_points => string(1) 0
password => string(0)
email => string(0)
email_2 => string(0)
lang => string(2) ru
sex => string(1) M
avatar => string(1) 0
sign => NULL
id_planet => string(1) 0
galaxy => string(1) 0
system => string(1) 0
planet => string(1) 0
current_planet => string(1) 0
user_agent => string(0)
user_lastip => NULL
user_proxy => string(0)
register_time => string(10) 1368812882
onlinetime => string(10) 1370797635
dpath => string(0)
design => string(1) 1
noipcheck => string(1) 1
options => NULL
planet_sort => string(1) 0
planet_sort_order => string(1) 0
spio_anz => string(1) 1
settings_tooltiptime => string(1) 5
settings_fleetactions => string(1) 0
settings_esp => string(1) 1
settings_wri => string(1) 1
settings_bud => string(1) 1
settings_mis => string(1) 1
settings_rep => string(1) 0
user_as_ally => string(2) 23
metal => string(7) 0.00000
crystal => string(7) 0.00000
deuterium => string(7) 0.00000
que => string(0)
user_birthday => NULL
user_birthday_celebrated => NULL
player_race => string(1) 0
planetrow = array(103)
id => string(4) 1018
name => string(21) Chicken∴Грилл∴:)
id_owner => string(2) 97
galaxy => string(1) 1
system => string(3) 499
planet => string(1) 5
planet_type => string(1) 1
metal => double 1650302545.2205
crystal => double 201915954.95609
deuterium => double 7568698.09031
energy_max => double 41812533
energy_used => double 16614002
metal_mine => string(2) 42
crystal_mine => string(2) 39
deuterium_sintetizer => string(2) 40
solar_plant => string(2) 17
fusion_plant => string(2) 18
robot_factory => string(2) 15
nano_factory => string(2) 10
hangar => string(2) 15
metal_store => string(1) 7
crystal_store => string(1) 7
deuterium_store => string(1) 7
laboratory => string(2) 15
nano => string(2) 10
terraformer => string(1) 0
ally_deposit => string(1) 0
silo => string(1) 0
mondbasis => string(1) 0
phalanx => string(1) 0
sprungtor => string(1) 0
last_jump_time => string(1) 0
small_ship_cargo => string(1) 0
big_ship_cargo => string(1) 0
supercargo => string(1) 0
planet_cargo_hyper => string(1) 0
recycler => string(5) 85000
colonizer => string(1) 8
spy_sonde => string(1) 0
solar_satelit => string(3) 622
light_hunter => string(1) 0
heavy_hunter => string(1) 0
crusher => string(1) 0
battle_ship => string(1) 0
bomber_ship => string(1) 0
battleship => string(1) 0
destructor => string(3) 360
dearth_star => string(1) 3
supernova => string(3) 976
misil_launcher => string(1) 0
small_laser => string(1) 0
big_laser => string(1) 0
gauss_canyon => string(1) 0
ionic_canyon => string(1) 0
buster_canyon => string(1) 0
small_protection_shield => string(1) 0
big_protection_shield => string(1) 0
planet_protector => string(1) 0
interceptor_misil => string(1) 0
interplanetary_misil => string(1) 0
metal_perhour => double 49753381
crystal_perhour => double 27994945
deuterium_perhour => double 6689286
metal_mine_porcent => string(2) 10
crystal_mine_porcent => string(2) 10
deuterium_sintetizer_porcent => string(2) 10
solar_plant_porcent => string(2) 10
fusion_plant_porcent => string(2) 10
solar_satelit_porcent => string(2) 10
que => string(0)
b_hangar => integer 0
b_hangar_id => string(0)
last_update => integer 1370797642
image => string(14) wasserplanet02
points => string(1) 0
ranks => string(1) 0
id_level => string(1) 0
destruyed => string(1) 0
diameter => string(5) 14475
field_max => string(3) 500
field_current => integer 242
temp_min => string(3) 200
temp_max => string(3) 300
metal_max => double 38923901367
crystal_max => double 38923901367
deuterium_max => double 38923901367
parent_planet => string(1) 0
debris_metal => string(1) 0
debris_crystal => string(1) 0
PLANET_GOVERNOR_ID => string(3) 601
PLANET_GOVERNOR_LEVEL => string(2) 40
planet_teleport_next => string(10) 1370788024
ship_sattelite_sloth => string(1) 0
ship_bomber_envy => string(1) 0
ship_recycler_gluttony => string(1) 0
ship_fighter_wrath => string(1) 0
ship_battleship_pride => string(1) 0
ship_cargo_greed => string(1) 0
ship_sattelite_sloth_porcent => string(2) 10
governor => string(1) 0
governor_level => string(1) 0
prev_update => string(10) 1370797635
planet_caps => array(7)
planet => array(11)
metal => double 1650302545.2205
crystal => double 201915954.95609
deuterium => double 7568698.09031
metal_max => double 38923901367
crystal_max => double 38923901367
deuterium_max => double 38923901367
energy_max => double 41812533
energy_used => double 16614002
metal_perhour => double 49753381
crystal_perhour => double 27994945
deuterium_perhour => double 6689286
metal_perhour => array(5)
0 => integer 10000
1 => double 49743381
2 => double 0
3 => double 0
4 => double 0
crystal_perhour => array(5)
0 => integer 5000
1 => double 0
2 => double 27989945
3 => double 0
4 => double 0
deuterium_perhour => array(6)
0 => integer 0
1 => double 0
2 => double 0
3 => double 6691346
4 => double 0
12 => double -2060
energy => array(8)
0 => integer 0
1 => double -5388867
2 => double -4664991
3 => double -6560144
4 => double 4029435
12 => double 20056098
212 => double 17727000
221 => double 0
production => integer 1
real => array(4)
metal_perhour => double 49753381
crystal_perhour => double 27994945
deuterium_perhour => double 6689286
units => array(3)
metal_perhour => array(8)
0 => double 10000
1 => double 49743381
2 => double 0
3 => double 0
4 => double 0
12 => double 0
212 => double 0
221 => double 0
crystal_perhour => array(8)
0 => double 5000
1 => double 0
2 => double 27989945
3 => double 0
4 => double 0
12 => double 0
212 => double 0
221 => double 0
deuterium_perhour => array(8)
0 => double 0
1 => double 0
2 => double 0
3 => double 6691346
4 => double 0
12 => double -2060
212 => double 0
221 => double 0
$_GET = array(2)
page => string(7) options
mode => string(6) change
$_POST = array(39)
db_password => string(0)
newpass1 => string(0)
newpass2 => string(0)
db_email => string(16) nomail@gmail.com
langer => string(2) ru
opt_time_diff_clear => string(2) on
settings_order => string(1) 0
settings_sort => string(1) 0
design => string(2) on
dpath => string(0)
dpaths => string(0)
opt_int_struc_vertical => string(1) 1
opt_int_navbar_resource_force => string(1) 1
opt_int_overview_planet_columns => string(1) 0
opt_int_overview_planet_rows => string(1) 5
opt_uni_avatar_user => string(1) 1
opt_uni_avatar_ally => string(1) 1
spio_anz => string(1) 1
settings_tooltiptime => string(1) 5
settings_fleetactions => string(1) 0
settings_esp => string(2) on
settings_wri => string(2) on
settings_mis => string(2) on
settings_bud => string(2) on
opt_email_msg_admin => string(1) 1
opt_email_mnl_joueur => string(1) 1
opt_email_mnl_alliance => string(1) 1
opt_mnl_spy => string(1) 1
opt_email_mnl_spy => string(1) 1
opt_mnl_attaque => string(1) 1
opt_email_mnl_attaque => string(1) 1
opt_mnl_transport => string(1) 1
opt_email_mnl_transport => string(1) 1
opt_mnl_exploit => string(1) 1
opt_email_mnl_exploit => string(1) 1
opt_mnl_expedition => string(1) 1
opt_email_mnl_expedition => string(1) 1
opt_mnl_buildlist => string(1) 1
opt_email_mnl_buildlist => string(1) 1
$_COOKIES = NULL
$_SESSION = NULL
$_SERVER = array(33)
HTTP_HOST => string(13) snova.free.uz
HTTP_CONNECTION => string(10) keep-alive
CONTENT_LENGTH => string(4) 4271
HTTP_CACHE_CONTROL => string(9) max-age=0
HTTP_ACCEPT => string(63) text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ORIGIN => string(20) http://snova.free.uz
HTTP_USER_AGENT => string(102) Mozilla/5.0∴(Windows∴NT∴6.1)∴AppleWebKit/537.22∴(KHTML,∴like∴Gecko)∴Chrome/25.0.1364.172∴Safari/537.22
CONTENT_TYPE => string(68) multipart/form-data;∴boundary=----WebKitFormBoundaryTlBBfWpOw5OvIMoU
HTTP_REFERER => string(43) http://snova.free.uz/index.php?page=options
HTTP_ACCEPT_ENCODING => string(17) gzip,deflate,sdch
HTTP_ACCEPT_LANGUAGE => string(35) ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4
HTTP_ACCEPT_CHARSET => string(32) windows-1251,utf-8;q=0.7,*;q=0.3
HTTP_COOKIE => string(81) SuperNova=97%2F%25%2Fanonymous%2F%25%2Fb2c72da83fdf336ba42d2e75e9b27e2d%2F%25%2F0
PATH => string(28) /usr/local/bin:/usr/bin:/bin
SERVER_SIGNATURE => string(74) <address>Apache/2.2.22∴(Ubuntu)∴Server∴at∴snova.free.uz∴Port∴80</address>¶;
SERVER_SOFTWARE => string(22) Apache/2.2.22∴(Ubuntu)
SERVER_NAME => string(13) snova.free.uz
SERVER_ADDR => string(13) 83.69.129.232
SERVER_PORT => string(2) 80
REMOTE_ADDR => string(14) 213.230.103.29
DOCUMENT_ROOT => string(14) /var/www/snova
SERVER_ADMIN => string(17) webmaster@free.uz
SCRIPT_FILENAME => string(24) /var/www/snova/index.php
REMOTE_PORT => string(5) 38911
GATEWAY_INTERFACE => string(7) CGI/1.1
SERVER_PROTOCOL => string(8) HTTP/1.1
REQUEST_METHOD => string(4) POST
QUERY_STRING => string(24) page=options&mode=change
REQUEST_URI => string(35) /index.php?page=options&mode=change
SCRIPT_NAME => string(10) /index.php
PHP_SELF => string(10) /index.php
REQUEST_TIME_FLOAT => double 1370797640.428
REQUEST_TIME => integer 1370797640

Re: Баг с Настройкой!

Добавлено: 09 июн 2013, 22:05
igorrnc
шайтан, такие портянки текста можно и под спойлер прятать :twisted: :lol: