Howdy, Stranger!

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

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.

Lightbox Error

Were were able to use the Lightbox functionality until recently. Now when a object or set is attempted be saved to a Lightbox we get this error:

Field 'rank' doesn't have a default value in /var/www/pawtucket2-1.7.5/app/lib/core/Db/mysqli.php line 316:

The full error is attached, any help is appreciated.



  • You're probably using an old database with a newer version of MySQL, which is stricter about how fields were defined. Run this SQL on your database to set a default value on the field in question:

    ALTER TABLE ca_set_items MODIFY COLUMN rank int unsigned not null default 0;
  • That worked perfectly. Thanks
Sign In or Register to comment.