Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.

If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping

Answers may be delayed for posts that do not include sufficient information.

Fatal Error when Installing

After much troubleshooting, I'm finally at the stage of the Collective Access installation, but getting the below error message:

Fatal error: Uncaught DatabaseException: 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 'rank int unsigned not null default 0, ' at line 11 in /Users/housefoundation/Sites/providence/app/lib/Db/mysqli.php:316 Stack trace: #0 /Users/housefoundation/Sites/providence/app/lib/Db/DbStatement.php(151): Db_mysqli->execute(Object(DbStatement), Object(DbStatement), '\n\n\n/==========...', Array, NULL) #1 /Users/housefoundation/Sites/providence/app/lib/Db.php(261): DbStatement->executeWithParamsAsArray(Array) #2 /Users/housefoundation/Sites/providence/install/inc/Installer.php(479): Db->query('\n\n\n/==========...') #3 /Users/housefoundation/Sites/providence/install/inc/page2.php(69): Installer->loadSchema('caGetTableToBeL...') #4 /Users/housefoundation/Sites/providence/install/index.php(151): require_once('/Users/housefou...') #5 {main} thrown in /Users/housefoundation/Sites/providence/app/lib/Db/mysqli.php on line 316

Any suggestions? I'm not sure where to find the correct syntax to clear these errors.


  • Nevermind - this was related to us having the wrong version of MYSQL downloaded. I downloaded an earlier version and that fixed the issues!

  • Unfortunately I'm still stuck! I'm getting this error message:
    It looks like the CA_URL_ROOT variable in your setup.php is not set correctly. Please try to set it to "/~housefoundation/providence". We came up with this suggestion because you accessed this script via "/~housefoundation/providence/index.php". Note that paths are case sensitive.

    but there is no CA_URL_ROOT in my setup.php, which was coped as instructed from the setup.pho-dist, which also (via github) doesn't have that line.

    Any suggestions for where I can make this edit?

  • Nevermind! I solved : )

Sign In or Register to comment.