Oh the though of using the hammer puts a smile on my face... but you're right, I'll hold off; for now!!!
Okay let's start from the top... To uninstall, I'll use Mambo and CB uninstall. Do I leave the tables in place, because from past experience thay remain in the DB.
Okay... done!
Note: Had to manually remove the tables as the uninstall left them there.
________________________________
GOT THIS ERROR ON REINSTALL
________________________________
1.0 RC 1 to 1.0 RC 2 part 2 failed! SQL errorB function failed with error number 1064
You have an error in your SQL syntax near '; ' at line 2 SQL=ALTER TABLE `mos_comprofiler_fields` ADD `pluginid` INT( 11 ) , ADD `params` MEDIUMTEXT;
1. Did you install ONLY comprofiler.zip and mod_cblogin.zip ?
2.Could you send me your comprofiler.zip and mod_cblogin.zip
3. what is the version of your zip file cb_1_1_0-unzip1st
Date, and size.
In the meantime, use phpMyAdmin to alter the table
mos_comprofiler_fields to add 2 columns
pluginid INT( 11 ) null is yes
and
params MEDIUMTEXT null is yes
these are the 2 columns to be added in the table after the sys column.
Your problem occured during the installation of com_comprofiler.zip
Here is the medecine:
use my com_comprofiler.zip instead. I had put some vitamin to make it work for me.
remove all the 9 comprofiler tables.
re-install com_comprofiler.zip and mod_cblogin.zip
REMEMBER: in mambo installers universal make sure all directories are green (writable), AND grant all privileges to the user which is used to run the admin backend.