Author Topic: Development Setup Guide  (Read 6462 times)

0 Members and 1 Guest are viewing this topic.

Offline Thing342

  • Computer Guy
  • TM Collaborator
  • Newbie
  • *****
  • Posts: 13
  • Gender: Male
  • Last Login:June 08, 2017, 10:58:40 pm
  • V.T.C.S.
    • Personal Page
Development Setup Guide
« on: January 13, 2017, 05:51:16 pm »
Hey guys, I finally got around to writing this. I only have experience setting this up on Linux environments, so if you have set this up on Windows, please feel free to edit the page.

https://github.com/TravelMapping/Web/wiki/Development-Setup-Guide

Post any questions you may have here.

Offline rschen7754

  • Jr. Member
  • **
  • Posts: 51
  • Gender: Male
  • Last Login:Yesterday at 08:06:13 pm
    • Rschen7754
Re: Development Setup Guide
« Reply #1 on: August 20, 2017, 06:12:55 pm »
This statement fails with an error 1221:

GRANT SELECT, SHOW VIEW, PROCESS, REPLICATION CLIENT ON TravelMapping.* to '<New Username>'@'localhost' IDENTIFIED by '<New Password>';

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGE

I had to split each GRANT command into different parts, and change TravelMapping.* to *.* on the last two.

Also, it seems that php5-mysqlnd is no longer available on 16.04 - I had to use php7.0-mysqlnd.

In MySQL since I'm on the latest version, I had to use the following commands to emulate older behavior:

alter schema TravelMapping default character set utf8
SET @@global.sql_mode= '';

In the end I did get it to work though.
« Last Edit: August 21, 2017, 12:28:55 am by rschen7754 »