<p>I changed the 'userSlug' field in 'shortlist_list' table to allow null and it seems to be working fine now. </p>

CC BY-SA 3.0
2017-04-25T09:36:10.523Z
2017-04-25T09:36:10.523Z
Mouse
<p>I think you're using an older version of the plugin.</p>

<p>That bug was definitely fixed in the current version - which is actually 1.0.4 - although oddly that is not available as a 'public release' it seems.</p>

<p>I'd contact Joel and get him to update his version page! <a href="http://squarebit.co.uk/contact" rel="nofollow noreferrer">http://squarebit.co.uk/contact</a></p>

CC BY-SA 3.0
2017-04-24T23:42:22.150Z
2017-04-24T23:42:22.150Z
Jeremy Daalder
<p>I'm getting this error when I try create a new list: </p>

<p><code>CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field 'userSlug' doesn't have a default value. The SQL statement executed was: INSERT INTO `craft_shortlist_list` (`default`, `public`, `type`, `ownerType`, `uid`, `ownerId`, `id`, `dateUpdated`, `dateCreated`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8). Bound with :yp0=0, :yp1=1, :yp2='manual', :yp3='member', :yp4='8fb7840a-a399-4eb3-bdf7-c59cb656bbff', :yp5='1', :yp6=1698, :yp7='2017-04-24 09:11:47', :yp8='2017-04-24 09:11:47'</code></p>

<p>Some help would be greatly appreciated!</p>

CC BY-SA 3.0
2017-04-24T23:13:36.253Z
My guess would this this is a bug with the plugin.  Have you tried contacting the developer?
Brad Bell
<plugin-shortlist>
Shortlist plugin error when creating a new list
# Shortlist plugin error when creating a new list

(Asked by: username_0 on 2017-04-24)

I'm getting this error when I try create a new list:

`CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1364 Field 'userSlug' doesn't have a default value. The SQL statement executed was: INSERT INTO `craft_shortlist_list` (`default`, `public`, `type`, `ownerType`, `uid`, `ownerId`, `id`, `dateUpdated`, `dateCreated`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8). Bound with :yp0=0, :yp1=1, :yp2='manual', :yp3='member', :yp4='8fb7840a-a399-4eb3-bdf7-c59cb656bbff', :yp5='1', :yp6=1698, :yp7='2017-04-24 09:11:47', :yp8='2017-04-24 09:11:47'`

Some help would be greatly appreciated!

**Tags:** plugin-shortlist

> **Comments:**
> **username_1**: My guess would this this is a bug with the plugin.  Have you tried contacting the developer?  

---

## 2 answers

### Answer by username_0 on 2017-04-25. Score: 1 | Accepted answer

I changed the 'userSlug' field in 'shortlist\_list' table to allow null and it seems to be working fine now.


---

### Answer by username_2 on 2017-04-24. Score: 1

I think you're using an older version of the plugin.

That bug was definitely fixed in the current version - which is actually 1.0.4 - although oddly that is not available as a 'public release' it seems.

I'd contact Joel and get him to update his version page! <http://squarebit.co.uk/contact>


---

