mysql_connect() deprecated Change-Id: I3f98bf077a231791fc12ceb701f5abcfe15065c0
diff --git a/classes/export/syncup.php b/classes/export/syncup.php index 8aba72d..400cc22 100644 --- a/classes/export/syncup.php +++ b/classes/export/syncup.php
@@ -34,10 +34,6 @@ $User = getSyncupUser(); -// $dbc = new DBConnection(); -// global $dbh; -// $dbh = $dbc->connect(); - echo "Connection established. Ready to begin. The syncup user id is: $User->userid\n"; /** @@ -84,8 +80,14 @@ $language_iso = $language_row['iso_code']; $language_id = $language_row['language_id']; echo "\nInvestigating $language_name ($language_iso) (language_id=$language_id)\n"; - #In performance purpose, the SQL sorts a temporary table, TEMP. - $untranslated_strings = mysqli_query($dbh, "SELECT * FROM (SELECT string_id, value from strings where is_active and non_translatable = 0 and value <> '' and string_id not in(select string_id from translations where language_id=$language_id) ) AS TEMP order by value" ); + #For performance purpose, the SQL sorts a temporary table, TEMP. + $sql = "SELECT * FROM (SELECT string_id, value from strings where is_active and non_translatable = 0 and value <> '' and string_id not in(select string_id from translations where language_id=$language_id) ) AS TEMP order by value"; + $untranslated_strings = mysqli_query($dbh, $sql); + if($untranslated_strings === FALSE) { + # We may have lost the database connection with our shell-outs, reconnect + $dbh = $dbc->connect(); + $untranslated_strings = mysqli_query($dbh, $sql); + } $count = 0; $prev_value = ''; while ( ($string_row = mysqli_fetch_assoc($untranslated_strings)) != null) {