-
Posts
26 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by hturner1
-
-
Greetings. I've been working to run a manual upgrade as the one through my AdminCP kept failing but not providing any sort of rationale as to why (the AdminCP would simply go back to the main dashboard or I'd get a random string of what looked like JSON on the screen). That said, the manual install isn't working either. I get all the way to the 'Upgrade' stage and it almost immediately fails with the following error information.
QuoteSpecified key was too long; max key length is 1000 bytes
/path/to/files/redacted/forum/system/Db/Db.php::2187ALTER TABLE `core_attachments_map` ADD KEY `map_lookup` (`location_key`(250),`id1`,`id2`)
Up in the top right of the above error message is the 4 digit value '1071' if that helps any as well. Below the error are a 'Retry?' and a 'Continue' button. I've tried both but the error keeps popping up. Any help/suggestions/troubleshooting steps would be appreciated. I did check the MySQL database through Cpanel and it said the DB was ok, FWIW. Thanks in advance!
-
Thats close but that is the marker for I65 not the location of those coordinates.
The green arrow here is what I am trying to show. -
Hey stoo,
I am using 39.916339,-86.325837 I tried switching them around but that didn't work.
Thanks for the update on the second issue. I am looking forward to updates on this module! -
Hey stoo, I swapped the lat and long instead of getting an address I get "Null" now.
Also if users put the same city as another user (without an actual street address) is there a way to have it show all users? For instance I have two users who put Fort Wayne as there address, problem is only one of the users displays when that happens. Any ideas? -
Hey stoo, when I do that it tries to find the nearest address and replaces the lat and long i put in the address bar. Any idea?
-
Great tool stoo!
Is there a way to manually set a marker though? I have some locations I would like to plot for my community but the plots do not have addresses.
Upgrade issue
in Classic self-hosted technical help
Posted · Edited by hturner1
Syntax highlighting
Thank you!!! This was it. Sure enough virtually all the tables were MyISAM. Converted them to InnoDB and the installation completed.
Just in case anyone else comes across this issue, here's what I did.
I'm sure there is probably a WAY more efficient SQL way to do all the above but I'm not a SQL wizard by any means. Hope this can help others though.