I use win8 64bit+anaconda(python 2.7),the nupic installation is ok,mysql installation is ok.
Running the /examples/swarm/test_db.py executes correctly. However, when I try to run examples/opf/clients/hotgym/prediction/one_gym/swarm.py I get the error listed below.
ProgrammingError: (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:\Users\USER’ at line 1")
Thanks for your reply. I have set the USER environment variable to my username. The following figure shows the configuration of my environment variables.
You should replace \\ in all nupic.cluster.database.nameSuffix with _ as \\ break SQL. In other words, insert suffix = suffix.replace("\\", "_") in def __getDBNameForVersion(cls, dbVersion) in \nupic\database\client_jobs_dao.py.