This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
don't try DO, ALWAYS list the column names, the error message is saying you haven't provided enough values in your insert statement.
There is another thread on here from a guy who found the columns were in diffenent order depending on how he ran his select statement.
Column order IS NOT RELIABLE.
subject: Error 500 in root causes saying not enough value error