Jump to content

hturner1

Clients
  • Posts

    26
  • Joined

  • Last visited

Recent Profile Visitors

2,613 profile views

hturner1's Achievements

  1. 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. Logged into the MySQL instance (I was able to do this in phpMyAdmin). Switched to the database for the forum: use <Your_DB_Name_Here>; Check the engine being used on the tables: show table status; Since all of my tables showed an engine of myISAM, I obtained a list of all the table names with: show tables; From here those table names were put into a txt file, one table name per line, called "tables" and with the sed tool, I created alter statements for each table name: sed -i 's/\(.*\)/ALTER TABLE `\1` ENGINE=InnoDB\;/' tables; From here, the tables file would have a bunch of ALTER statements that were run. It took a minute but once it was done, I double checked with `show table status;` again to see that the engine was changed to InnoDB. Continued the installation process and things were successful! 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.
  2. 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. 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!
  3. 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.
  4. 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!
  5. 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?
  6. 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?
  7. 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.
×
×
  • Create New...