No, copy & paste won't work with this one because it calls in fields that it creates in other tables.
I had modify the script myself. The problem(s) were:
1. Field names weren't encased in `these`
2. Field values weren't encased in 'these' -- namely 'NULL' and the values for "Order"
The first part of the script ran fine where it added a field to the configuration_group, so I went and got the ID for the new field and in subsequent code I replaced:
@configuration_group_id
with..
'ID#' (the actual #)
...I also had to add the prefix to "configuration"
I have no idea why only a couple of us had this problem! I got it from the same download screen everyone else did. I don't know much about SQL versions, but maybe that had something to do with it.
Bookmarks