View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000761 | NNW API Service | Application | public | June 24, 2017, 10:53 pm | July 28, 2017, 12:43 pm |
Reporter | Scott Bradford | Assigned To | Scott Bradford | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 0.9.3 | ||||
Target Version | 0.9.3 | Fixed in Version | 0.9.3 | ||
Summary | 0000761: Errors When Updating Locations Table | ||||
Description | Figure out why this is happening and fix it: [24-Jun-2017 22:44:01 America/New_York] Can't get user table. [24-Jun-2017 22:44:01 America/New_York] PHP Warning: Invalid argument supplied for foreach() in /home/achmafooma/intersanity/nnw-test/admin/index.php on line 453 [24-Jun-2017 22:44:01 America/New_York] Can't get API key table. [24-Jun-2017 22:44:01 America/New_York] PHP Warning: Invalid argument supplied for foreach() in /home/achmafooma/intersanity/nnw-test/admin/index.php on line 476 | ||||
|
Turns out this was happening because the DB import for the location table failed. After much digging, it turns out that some locations have alternate names (from GeoNames) with funky characters that aren't always covered under standard MySQL UTF-8. So the DB will now be encoded as utf8mb4, which has a cost in storage space, but works. To compensate, the DB has been reworked a bit so it uses more varchar and less char, and doesn't use fixed tables (an earlier effort to improve performance)...so the net change is the DB tables actually got a lot smaller. Go figure. |
|
Deployed. |
Date Modified | Username | Field | Change |
---|---|---|---|
June 24, 2017, 10:53 pm | Scott Bradford | New Issue | |
June 24, 2017, 10:53 pm | Scott Bradford | Status | new => assigned |
June 24, 2017, 10:53 pm | Scott Bradford | Assigned To | => Scott Bradford |
June 27, 2017, 4:44 pm | Scott Bradford | Status | assigned => resolved |
June 27, 2017, 4:44 pm | Scott Bradford | Resolution | open => fixed |
June 27, 2017, 4:44 pm | Scott Bradford | Fixed in Version | => 0.9.3 |
June 27, 2017, 4:44 pm | Scott Bradford | Note Added: 0002021 | |
July 28, 2017, 12:43 pm | Scott Bradford | Note Added: 0002083 | |
July 28, 2017, 12:43 pm | Scott Bradford | Status | resolved => closed |