Крон за*вает письмами (в день по 5к писем)

[Semen_ssr]

Mysql error:: 1292 (Truncated incorrect DOUBLE value: ' Trade start limit reached, activating trader.') (db_link) in query update traders set ta = '1', tcomment = tcomment + ' Trade start limit reached, activating trader.' where td = 'example.com1'. (example.com2)

Build 201312121641

[admin]

Fixed

но просто интересно что сейчас в поле comment у этого трейдера ?

[Semen_ssr]

Я это поле никогда не заполнял, думаю ничего или "new trade" дефолтное.

[Semen_ssr]

Mysql error:: 0 () (db_link) in query UPDATE rot_pages set shows = CASE WHEN id = '19' THEN shows + 2 WHEN id = '4' THEN shows + 1 WHEN id = '15' THEN shows + 3 END WHERE id IN (19,4,15). (example.com)

Mysql error:: 0 () (db_link) in query insert into traders (td, tpassword, tn, tdesc, tu, ti, tni, te, signup_ip, trat, keep_ratio, tp, ta, thf, tforce_minute, tff, sforce_amount, sforce_hours, boost_force, personal_boost_force, normal_boost_force, tt, taf, tafa, tafh, tafd, tafl, tafu, taft, ttin, tgroup, signuptime, tnew, tcomment, ext_info, tmax, tsupport, tsupport_line, tzeroin, tattempt, tsupportcount, ttop, tuselimit, tlimit, max_prod_limit, tget_exout, tsend_cheat, tcheat_url, tsend_proxy, tproxy_url, tstart_limit, texout_stop, texout_start, tforcedown_hours, tforcedown_amount, tsuspend_hours, tsuspend_amount, tsuspend_prod_percent, tsuspend_prod_hours, system_trade, tsmart_info, thout_limit, tuse_scheme, tskimming, tscheme, tfirst_click, tantiblock, top_position, script_warnings, trow_color, ext_stats_next_check, thumb_create_next_run, personal_page, traffic_quality_in, traffic_quality_out, traffic_quality_to_trade, traffic_sell_trade, traffic_sell_url, create_trader_!
thumb, trader_thumb_start, top_thumb_x, top_thumb_y, hold_top_place, site_type, top_reset_data, top_reset_next_check, ext_script_type, ext_script_login, ext_script_password, ext_script_results, change_requests, blocked_countries, blocked_traders, toplist_comment) values ('example.com', 'password', 'Site name', 'Site Description', 'http://www.example.com/', 'ICQ', 'Nickname', '[email protected]', '0', '120', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '_main_', '', '1', 'new trade', 'new trade', '0', '0', '0', '0', '0', '0', '1', '0', '300', '0', '1', '0', 'http://cheat_url', '0', 'http://proxy_url', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', 'uttuut', '0', '0', '0', '', '', '0', '0', '', '', '', '', '101', '101', '1', '0', '0', '0', '0', 'cj', '', '0', '0', '', '', '', '', '', '', ''). (example.com)

SmartCJ Pro V 1.51 Build 201312121641

[admin]

ок, убрали что б это не писало.

[xawm]

ок, продолжаем марафон:

Code: Select all

Mysql error:: 1366 (Incorrect integer value: '' for column 'signuptime' at row 1) (db_link) in query insert into traders (td, tpassword, tn, tdesc, tu, ti, tni, te, signup_ip, trat, keep_ratio, tp, ta, thf, tforce_minute, tff, sforce_amount, sforce_hours, boost_force, personal_boost_force, normal_boost_force, tt, taf, tafa, tafh, tafd, tafl, tafu, taft, ttin, tgroup, signuptime, tnew, tcomment, ext_info, tmax, tsupport, tsupport_line, tzeroin, tattempt, tsupportcount, ttop, tuselimit, tlimit, max_prod_limit, tget_exout, tsend_cheat, tcheat_url, tsend_proxy, tproxy_url, tstart_limit, texout_stop, texout_start, tforcedown_hours, tforcedown_amount, tsuspend_hours, tsuspend_amount, tsuspend_prod_percent, tsuspend_prod_hours, system_trade, tsmart_info, thout_limit, tuse_scheme, tskimming, tscheme, tfirst_click, tantiblock, top_position, script_warnings, trow_color, ext_stats_next_check, thumb_create_next_run, personal_page, traffic_quality_in, traffic_quality_out, traffic_quality!
 _to_trade, traffic_sell_trade, traffic_sell_url, create_trader_thumb, trader_thumb_start, top_thumb_x, top_thumb_y, hold_top_place, site_type, top_reset_data, top_reset_next_check, ext_script_type, ext_script_login, ext_script_password, ext_script_results, change_requests, blocked_countries, blocked_traders, toplist_comment) values ('imperia31.ru', 'password', 'Site name', 'Site Description', 'http://imperia31.ru/', 'ICQ', 'Nickname', '[email protected]', '0', '120', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '_main_', '', '1', 'new trade', 'new trade', '0', '0', '0', '0', '0', '0', '1', '0', '300', '0', '1', '0', 'http://cheat_url', '0', 'http://proxy_url', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', 'uttuut', '0', '0', '0', '', '', '0', '0', '', '', '', '', '101', '101', '1', '0', '0', '0', '0', 'cj', '', '0', '0', '', '', '', '', '', '', ''). 

[xawm]

вторым финиширует:

Code: Select all

Mysql error:: 1406 (Data too long for column 'language' at row 1) (db_link) in query INSERT into language (trader, hour, language, num) VALUES  ('blocked_ref', '385412', 'de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4', '1'),  ('noref', '385412', 'de-DE', '1'),  ('noref', '385412', 'it-IT', '1'),  ('spiders', '385412', 'no_lng', '1') ON DUPLICATE KEY UPDATE num=num + VALUES(num) 

[xawm]

третьим пришёл:

Code: Select all

Mysql error:: 1690 (BIGINT UNSIGNED value is out of range in '(`db_scj`.`rot_tags`.`used_counter` - 1)') (db_link) in query DELETE FROM rot_gal2tag where gallery_md5 NOT IN (select gallery_md5 from rot_galleries)

[admin]

Fixed