piwik has a mysql table piwik_site
it has a field name which is a reserved word ‘group’ which stops me from adding my sites using a mysql script to insert lots of sites from GA to piwik_site table. this is driving me a bit nuts. :S
I don’t personally use the group field but it is set as NOT NULL so I can’t miss it from my mysql inserts statement.
anyone know how to get around this.
why did piwik use a field name which is a reserved word?
thanks for any advice.