Message: Error DataBase::getInstance()->prepareStatement() [execute]: Deadlock found when trying to get lock; try restarting transaction - Query: UPDATE `geo_db`.`city2` SET `city2`.`country_code`=?, `city2`.`format_name`=?, `city2`.`name`=?, `city2`.`code_region`=?, `city2`.`population`=?, `city2`.`latitude`=?, `city2`.`longitude`=?, `city2`.`elevation`=?, `city2`.`capital`=?, `city2`.`name_en`=?, `city2`.`name_fr`=?, `city2`.`name_de`=?, `city2`.`name_it`=?, `city2`.`name_pl`=?, `city2`.`name_es`=?, `city2`.`name_pt`=?, `city2`.`name_ru`=?, `city2`.`name_hi`=?, `city2`.`name_cn`=?, `city2`.`name_jp`=?, `city2`.`name_ar`=?, `city2`.`postal_code`=?, `city2`.`link`=?, `city2`.`geonames_nb_cities_found`=?, `city2`.`is_geonames_data`=?, `city2`.`geonames_id`=?, `city2`.`geonames_date`=?, `city2`.`latitude_orig`=?, `city2`.`longitude_orig`=?, `city2`.`parent_city_code`=?, `city2`.`is_city_created_manually`=?, `city2`.`is_duplicate_url_detected`=?, `city2`.`is_histo_rate_migrate`=?, `city2`.`pic_json`=?, `city2`.`pic_json_date`=?, `city2`.`nb_news`=?, `city2`.`pic_json_validated`=?, `city2`.`pic_json_date_validated`=? WHERE `city2`.`city_code`=? [types: ssssidddissssssssssssssiiisddsiiississi] [values: SE, navragol, Nävragöl, 02, 229, 56.36667, 15.56667, 105, 0, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, Nävragöl, NULL, http://en.wikipedia.org/wiki/N%C3%A4vrag%C3%B6l, 10, 1, 2689983, 2015-09-27 21:49:26, 56.3666667, 15.5666667, NULL, 0, 1, 1, {\"id\":\"48987585886\",\"owner\":\"49014613@N05\",\"secret\":\"5b952a2309\",\"server\":\"65535\",\"farm\":66,\"title\":\"Blekinge_190806-5189.jpg\",\"ispublic\":1,\"isfriend\":0,\"isfamily\":0}, 2024-10-21 00:00:00, 0, NULL, NULL, 2176467]
File: /home/weather/www/wsp/class/database/DataBase.class.php
Line: 211
Class :
Method :

Trace:

file: 185 - /home/weather/www/wsp/class/database/DataRowIterator.class.php
call: DataBase->prepareStatement("UPDATE `geo_db`.`city2` SET `city2`.`country_code`=?, `city2`.`f...", Array(39))

file: 84 - /home/weather/www/wsp/class/database/DataRowIterator.class.php
call: DataRowIterator->updateRow(Object(DataRow), "`city2`.`city_code`=?", Array(39), Array(1))

file: 295 - /home/weather/www/wsp/class/database_model/wsp/City2WSPObject.class.php
call: DataRowIterator->save()

file: 32 - /home/weather/www/pages/includes/utils-picture.inc.php
call: City2WSPObject->save()

file: 344 - /home/weather/www/pages/pictures.php
call: saveFirstCityPicture(False, Object(stdClass), 2176467)

file: 111 - /home/weather/www/pages/pictures.php
call: Pictures->saveFirstCityPicture(False, Object(stdClass), 2176467)

file: 131 - /home/weather/www/index.php
call: Pictures->Load()