Ive just finished (i hope) an exceedingly problematic upgrade.
After completely removing everything at least 5 times, including tmp folder, Im still seeing problems in the user dbs where the names haven't been copied over, though the record exists. Further, when i go to cbtools to attempt automated CB DB corrections, those processes dry run ok, but fail when initiated.

CB fields data storage database adjustments dryrun is successful. See results below.
Click here to hide details
Table #__comprofiler successfully created
CREATE TABLE `#__comprofiler` ( `cb_test` text )ENGINE=InnoDB

1050 Table 'ca_comprofiler' already exists SQL=CREATE TABLE `CA_comprofiler` ( `cb_test` text )ENGINE=InnoDB

If it helps, it is a new site im in process of developing so there arent a lot of users or their sub records to be concerned with should more radical steps be needed


WAMP server 2003
J 3.3
CB 2.0.3

In _comprofiler_fields it appears to have the correct alias so the problem must be elsewhere.

fieldid name tablecolumns table title description
54 cb_test cb_test #__comprofiler test text

Im going to remove the whole thing yet again. Not sure why this install has been so tough- every other one that ive done has been problem free.

As you may have guessed from the title, it appears that CB 2.0 had a real issue with my naming the DB with a CA ( yes, capped) prefix. While it did not affect some portions of the install, the failures were indeed caused by a case sensitivity conflict. All db tools functioned properly and performed whatever necessary repairs successfully after i changed it in the Joomla prefs. I did not change that at any point previously, so other installs must have done a text filter string.lower() on all commands and perhaps that was missed in the re-write. God knows ive missed things like that plenty of times, so you'll get no criticism from me.

Im a little new to PHP etc so that begs the question of best practices. Is it an accepted standard to use lower case exclusively? I ask because I typically camelBack multi word param/var names for the sake of readability.

Thanks Kyle- Glad to know im not going crazy. It didn't seem like it would be a problem. However, if I can break it, I will. For the record, 1.9.1 seemed to have problems from the beginning on this install so it's possible it may have come from something else entirely: all I know is that when i changed the prefix, everything worked. There are other issues as well but ill do a different post. Apologies in advance.