ошибки

[wazz]

устанавливаю смарт на новый хостинг. словил букет ошибок. привожу ниже. так же вылезла проблема с кодировкой. русские буквы на морде отображаюсят красозяброй. как лечить? где копать?

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Helsinki' for 'EET/2.0/no DST' instead in /var/www/wazz168/data/www/domen.com/scj/tube/index.php on line 0

Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Helsinki' for 'EET/2.0/no DST' instead in /var/www/wazz168/data/www/domen.com/scj/includes/libs/rot_functions.php on line 0

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/wazz168/data/www/domen.com/scj/tube/index.php:0) in /var/www/wazz168/data/www/domen.com/scj/tube/index.php on line 0

[admin]

Действуя по принципу "лучше дать удочку, чем рыбу" поясняю что делать в таких случаях.

Чуть выше есть ссылка "поиск", идете туда и вставляете в поиск что-то что вам кажется более менее относящимся к тебе или уникальным например я скопипастил кусок текста ошибки "It is not safe to rely on the system" - и сразу выдает ответ )

[wazz]

апнулся... теперь вообще весело..

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'd' (1) in /var/www/wazz168/data/www/domen.com/scj/includes/db_modules/mysql.php on line 11
Can not connect to database server.

[magicum]

У меня тоже внезапно появляются ошибки mysql, вот так, из ниоткуда. Это видимо не баг, а фича.

[admin]

Откройте страницу без кеша и будет все ок.

Какие конкретно ошибки появляются из ниоткуда ?

[magicum]

Например вот так:

Code: Select all

2014-01-07 07:05:11 : Mysql error: 1054 (Unknown column '1362gallery' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 1362gallery THEN current_clicks + 1  WHEN thumb_id = 12757 THEN current_clicks + 2  END,  current_points = CASE  WHEN thumb_id = 1362gallery THEN current_points + 1018 WHEN thumb_id = 12757 THEN current_points + 2054 END WHERE thumb_id IN (1362gallery,12757) and group_id = '0'  
2014-01-07 07:05:11 : Mysql error: 1054 (Unknown column '1362gallery' in 'where clause') in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats
			    WHERE current_shows > '2000' 
			    AND thumb_id IN (5735,5746,13601,13708,13521,13585,13845,7212,13872,13497,13526,13643,7312,13640,7319,13829,7223,7418,7291,7265,656,1464,801,837,889,778,715,825,886,736,13286,860,774,696,760,13337,13357,677,709,832,1433,12221,1528,1559,1571,1547,11537,1543,1565,1533,11542,1554,1552,1538,722,1362,12757,9726,8351,9058,11528,7890,7949,1242,7927,1563,1309,8780,12056,2095,13564,1209,1237,5345,1308,155,2164,13016,1248,283,147,2151,7923,7908,7963,362,6961,1353,222,2135,13639,6335,1417,7911,151,15054,14076,130,8754,337,11486,354,1054,11221,5399,9491,298,1227,2064,9471,451,14691,175,9203,12173,390,7895,14605,233,125,12309,11230,342,139,262,9043,9327,959,12131,6416,15148,300,1425,6324,7902,134,11142,1229,2107,194,210,15257,273,1217,15134,8005,163,9246,8912,1234,9448,159,6352,9404,15696,1255,12107,9718,9007,1500,8336,15222,7131,256,8379,12197,9169,14011,2113,1298,440,9380,0,4910,5704,5632,5620,5495,5607,5639,12723,5687,5452,5678,5575,5540,5515,12816,5571,5561,5521,5559,5470,124,5692,444,413,371,535,2192,5705,5359,5187,5179,5299,12557,5173,12619,5117,5350,5395,5283,5302,12631,5321,5082,8387,8232,8251,8343,8220,8301,12945,8236,8266,8213,8307,8337,8261,8224,8270,8374,6064,6065,7880,7977,7944,1012,1020,1348,1084,1075,1343,1044,1356,1064,1394,1339,1367,1034,1391,1079,1058,1050,2006,9301,900,940,1402,1386,1409,1262,1270,961,971,1378,1295,1275,953,15362,985,1372,8400,8405,9124,9099,9705,9200,9516,9247,9113,9468,14127,14137,15216,14998,15202,15026,1362gallery)   
2014-01-07 07:05:11 : Mysql error: 1054 (Unknown column '1362gallery' in 'where clause') in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN (5735,5746,13601,13708,13521,13585,13845,7212,13872,13497,13526,13643,7312,13640,7319,13829,7223,7418,7291,7265,656,1464,801,837,889,778,715,825,886,736,13286,860,774,696,760,13337,13357,677,709,832,1433,12221,1528,1559,1571,1547,11537,1543,1565,1533,11542,1554,1552,1538,722,1362,12757,9726,8351,9058,11528,7890,7949,1242,7927,1563,1309,8780,12056,2095,13564,1209,1237,5345,1308,155,2164,13016,1248,283,147,2151,7923,7908,7963,362,6961,1353,222,2135,13639,6335,1417,7911,151,15054,14076,130,8754,337,11486,354,1054,11221,5399,9491,298,1227,2064,9471,451,14691,175,9203,12173,390,7895,14605,233,125,12309,11230,342,139,262,9043,9327,959,12131,6416,15148,300,1425,6324,7902,134,11142,1229,2107,194,210,15257,273,1217,15134,8005,163,9246,8912,1234,9448,159,6352,9404,15696,1255,12107,9718,9007,1500,8336,15222,7131,256,8379,12197,9169,14011,2113,1298,440,9380,0,4910,5704,5632,5620,5495,5607,5639,12723,5687,5452,5678,5575,5540,5515,12816,5571,5561,5521,5559,5470,124,5692,444,413,371,535,2192,5705,5359,5187,5179,5299,12557,5173,12619,5117,5350,5395,5283,5302,12631,5321,5082,8387,8232,8251,8343,8220,8301,12945,8236,8266,8213,8307,8337,8261,8224,8270,8374,6064,6065,7880,7977,7944,1012,1020,1348,1084,1075,1343,1044,1356,1064,1394,1339,1367,1034,1391,1079,1058,1050,2006,9301,900,940,1402,1386,1409,1262,1270,961,971,1378,1295,1275,953,15362,985,1372,8400,8405,9124,9099,9705,9200,9516,9247,9113,9468,14127,14137,15216,14998,15202,15026,1362gallery) 

[admin]

Ок, добавлена проверка в этом месте.

[magicum]

Проверка чего добавлена, при появлении такой ошибки не выводить ее в лог?

[admin]

Проверка на ид.

[magicum]

А откуда взялся в моей случае левый ID? Не тут ли надо искать причину?