We can't really help you with migration issues. Any number of problems can happen. It also highly depends on what migration extension you used, etc..

When you migrate from J1.5 to J3.2 for example literally all of your Usergroups and View Access Levels will no longer match. This means you must edit everything in CB and correct all Usergroup and View Access Level usages. If you have not done this then it could be the cause of your problem.

Does this same issue happen when you attempt to register a user through backend CB > User Management? Please enable debug mode and maximum error reporting then re-test and see if the error exposes any further information as it's not saying what's wrong with the query (it looks ok to me as well).

Please one issue at a time. Once we've resolved the registration problem we can discuss your CBSubs issue.

You can't export and import directly. As stated in my previous reply none of your Usergroups and View Access Levels will match up. In addition to that _comprofiler is linked to _users and if you only copied _comprofiler then your users only exist in CB and not Joomla and _users won't have the correct auto increment value. To migrate users you should use something like CB Juice. You need to go through all of your CB backend (tabs, fields, plugins, lists, etc..) and ensure all your Usergroups and View Access Levels are re-saved with Joomla 3.x supported values. There is no easy solution to all of this; it just takes a ton of time going through everything manually.

Could you possibly show me a specific example of what I have to manually fix?

You need to go through your entire CB installation. None of the Usergroup and View Access Level parameters will match up. For View Access Levels they will all be 1 less than what Joomla expects. J1.5 View Access Levels were 0, 1, 2 and J3.x View Access Levels are 1, 2, 3. This means if you set something to Public it'd be 0 and in J3.x that doesn't exist so the view access level check will fail. If you set something in CB to 2 then that'd be Special in J1.5, but in J3.x it's Registered so you have a major access issue now. The only exception to this is Plugin Management which forces J1.5 usage (for now). For usergroups it just flat out won't match at all as the IDs are completely different.

I don't mind the time it takes as I just need to fix it or would it be better just to start over and do another migration?

That's entirely up to you. Migration is not a simple task. Moving users can be made relatively trivial using CB Juice, but that doesn't migrate your plugins, tabs, etc.. Using a Joomla migration extension can migrate other Joomla tables, but it doesn't know what to do with individual database columns in CB. Starting over then importing your users is also a good option to have a fresh install.

How much do you charge to migrate a joomla 1.5 site to include the CB and CB Subs?

We don't offer migration assistance. The time it takes to do a migration is just not economical and there are too many variables involved that could affect time/cost significantly. The creators of jUpgrade offer a paid migration service, but I've no idea if they can help with CB migration.