I updated today to the latest version and during the database upgrade and received the following error message:

The following updates returned messages

atjs module

Update #7101
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'DEFAULT NULL' at line 1: ALTER TABLE {atjs_listener} ADD `lookup_on_click` DEFAULT NULL; Array ( ) in db_add_field() (line 2844 of /home/user/Code/git/drupal/includes/database/database.inc).

Comments

ehj-52n created an issue. See original summary.

david.hughes’s picture

david.hughes
he/him
Primary language English
CreditAttribution: david.hughes at Cancer Research UK commented

Thanks again ehj-52n, I'll take a look into this. Been doing a bunch of work behind the scenes, specifically in making the listener usage data available to Views so haven't had a chance to catch up with looking into the library requirement issues. Will be dedicating today to checking over the module (with the views stuff) on a completely fresh site.

david.hughes’s picture

david.hughes
he/him
Primary language English
CreditAttribution: david.hughes at Cancer Research UK commented

Just pushed some changes including changes to the install file - is this still an issue? Tried deleting all new columns and re-running 7101, seems to function as expected on my install.

ehj-52n’s picture

ehj-52n CreditAttribution: ehj-52n as a volunteer commented

The error did not occur during the latest updates, hence I think that you fixed it.

david.hughes’s picture

david.hughes
he/him
Primary language English
CreditAttribution: david.hughes at Cancer Research UK commented
Status: Active » Fixed

Thanks!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.