Setting up an instance of TM's DB and web front end

[yakra]

Sure, TravelMappingTest works. Thanks!

[michih]

I've got a mirror running at http://205.209.84.174, so we won't have to go without our fix for a day.

Cool I don't wanna complain - I'm very happy that it's working - but does your PC have a clock so that you can show the timestamp of "the most recent site update completed"?

[yakra]

 I haven't paid any attention to that feature. I'll have to give it a look.

[yakra]

Code: [Select]

// get the timestamp of most recent DB update
function tm_update_time() {
    global $tmdb;
    global $tmdbname;
    $sql_command = "SELECT create_time FROM information_schema.tables WHERE TABLE_SCHEMA = '".$tmdbname."' ORDER BY create_time DESC;";
    global $tmsqldebug;
    if ($tmsqldebug) {
        echo "<!-- SQL: ".$sql_command." -->\n";
    }
    $res = tmdb_query($sql_command);
    $row = $res->fetch_assoc();
    $ans = $row['create_time'];
    $res->free();
    return $ans;
}


Code: [Select]

mysql> SELECT create_time FROM information_schema.tables WHERE TABLE_SCHEMA = 'TravelMapping' ORDER BY create_time DESC;
+---------------------+
| CREATE_TIME         |
+---------------------+
| 2019-07-09 10:52:07 |
| 2019-07-09 10:52:07 |
| 2019-07-09 10:52:06 |
| 2019-07-09 10:52:06 |
| 2019-07-09 10:52:05 |
| 2019-07-09 10:51:57 |
| 2019-07-09 10:51:51 |
| 2019-07-09 10:51:49 |
| 2019-07-09 10:51:48 |
| 2019-07-09 10:51:48 |
| 2019-07-09 10:51:48 |
| 2019-07-09 10:50:42 |
| 2019-07-09 10:50:16 |
| 2019-07-09 10:50:14 |
| 2019-07-09 10:49:51 |
| 2019-07-09 10:49:49 |
| 2019-07-09 10:49:46 |
| 2019-07-09 10:49:46 |
| 2019-07-09 10:49:46 |
| 2019-07-09 10:49:46 |
| 2019-07-09 10:49:46 |
+---------------------+
21 rows in set (0.00 sec)
I'm not sure what's happening.

[yakra]

Fixed. Apparently my CentOS setup was treating 'create_time' as case-sensitive, while Jim's FreeBSD setup was not.
https://github.com/TravelMapping/Web/pull/317

[yakra]

Attempting to update lab2 with (almost) the latest Web commits...
https://github.com/yakra/Web/tree/lab2redo
https://github.com/yakra/Web/tree/517ebc0898d11985bfaac5fdec2d5f0c8749dbf2

HB is broken:
• No waypoints listed in table
• Map stays centered at Siena,  and Processing Route Waypoint Data... message doesn't go away.

Mapview broken too; same basic symptoms as the 2nd bullet point.

For now, reverting to the previous head I'd been using...
https://github.com/yakra/Web/tree/lab2
https://github.com/yakra/Web/tree/4c7f5d9c607a0bc32c6478830214f9f83ce50000
It will take some detective work to find just where things broke.