 |
|
manual user confirmation
|
|
Date: 2005/12/14 21:51
|
By: alexvpp
|
Status: User
|
|
|
Karma: 1
|
|
Fresh Joomlapolitan
| Posts: 7 |   |
|
|
Hello,
I am having an issue when trying to manually confirm users in the CB User managment. When I confirm, I've got the following message:
DB function failed with error number 1054
Unknown column 'sbviewtype' in 'field list' SQL=UPDATE jos_comprofiler SET `sbviewtype`='',`sbordering`='',`sbsignature`='',`user_id`='75',`firstname`='Nick',`middlename`=''
,`lastname`='A.',`approved`='1',`confirmed`='1' WHERE id='75'
SQL =
UPDATE jos_comprofiler SET `sbviewtype`='',`sbordering`='',`sbsignature`='',`user_id`='75',`firstname`='Nick',`middlename`=''
,`lastname`='A.',`approved`='1',`confirmed`='1' WHERE id='75'
Some clues?
Thanks
Alex
|
|
The topic has been locked. |
|
 |
|
Re:manual user confirmation
|
|
Date: 2005/12/19 00:29
|
By: JoomlaJoe
|
Status: Admin
|
|
|
Karma: 14
|
|
Admin
| Posts: 38 | |
|
|
Looks like some how the field "sbviewtype" no longer exists in your database. Check out the jos_comprofiler table via phpmyadmin or something similar. If that is the case you will need to delete the field in CB and recreate it again.
JoomlaJoe *The developer formally known as MamboJoe*
CB Core Team
|
|
|
The topic has been locked. |
|
 |
|
Re:manual user confirmation
|
|
Date: 2006/01/10 22:15
|
By: alistaircochrane
|
Status: User
|
|
|
Karma: 3
|
|
Junior Joomlapolitan
| Posts: 42 | |
|
|
I had a similar error message... I deleted the fields and I'm trying to recreate them... but when i try to create a field it insists on putting cb_ before the field name.
so i can't recreate the fields that I need to
sbviewtype
sbordering
sbsignature
Is there a way round this. It can be done cos I managed somehow to create the sbviewtype field but I don't know how.
I'm not sure why these fields were missing, I installed the latest version of CB onto joomla 1.0.4 stable. Other than that it seems to be working ok.
Help!
|
|
|
The topic has been locked. |
|
|
|
|
Re:manual user confirmation
|
|
Date: 2006/01/10 22:32
|
By: alistaircochrane
|
Status: User
|
|
|
Karma: 3
|
|
Junior Joomlapolitan
| Posts: 42 | |
|
|
It's ok.. I still don't know how I did it but I managed to create the fields
Maybe something to do with not publishing the field the first time you save it.
|
|
|
The topic has been locked. |
|
|
|
|
Re:manual user confirmation
|
|
Date: 2006/01/14 07:32
|
By: alistaircochrane
|
Status: User
|
|
|
Karma: 3
|
|
Junior Joomlapolitan
| Posts: 42 | |
|
|
I had to recreate these fields again
and this time I worked out how to stop it prefixing sbordering with cb_
So in case anyone else finds this thread and has the same problem... here the way to do it...
You need to type the field name i.e. sbordering
Then click the curser so it's flashing before the s
Then hit return.
Then you should be able to move away from the field name without it adding the cb- prefix... you may need to try it once or twice.. I know there should be a logic to it somewhere!!
|
|
|
The topic has been locked. |
|
 |
|
Re:manual user confirmation
|
|
Date: 2006/03/02 13:03
|
By: Aly
|
Status: 
|
|
|
Karma: 4
|
|
Senior Joomlapolitan
| Posts: 58 | |
|
|
ran into this same issue today, and deleting the fields resolved it. But now how do you recreate the fields? I mean, what type, settings etc?
Or do I need to do it from joomlaboard?
|
|
|
The topic has been locked. |
|
|
