|
|
Re:Problem using CB adapter - 2008/04/09 22:30
Getting the exact same error as lanxcape:
ADAPTER ERROR: Unknown column 'cb_address' in 'field list' SQL=select user_id, u.name, cb_address, cb_city, cb_state, cb_zipcode, cb_country, avatar, cb_latitude, cb_longitude, avatarapproved from jos_comprofiler a, jos_users u where a.user_id = u.id
And it was all going so well
The administrator has disabled public write access.
|
|
|
Re:Problem using CB adapter - 2008/04/10 04:15
I am assuming you updated your install. Doing so, will overwrite the adapter class file ... which I have told many ... I do not support. Doing a standard Joomla install and reinstall will remove your directory and then any changes you may have applied -- even in the adapter. I hope to remove the adapters out from underneath that folder, but until there is time....
You issue is in the field names. It is IMPOSSIBLE for me to develop any class file to match everyones CB field names. This adapter is supposed to be an example only. Change the field names to match your environment ... specifically cb_address, and that will fix your immediate problem.
As this becomes more and more of an issue, I may remove it moving forward.
You may wish to talk to your hosting company to see when the last backup of the adapter file was made and get a copy that way. For me, I've written my own script on a local server in my house to backup the filesystem on the hosting companies server twice a week just in case.
The administrator has disabled public write access.
|
|
|
Re:Problem using CB adapter - 2008/04/10 11:11
I fixed it 
You were right it was my fields.
I went back to the Community Board field management
and deleted all the fields and started fresh.
The problem I found out was that G-Maps is looking for the fields listed. But some of the default fields are
_UE_Company, _UE_Address etc. So I just deleted them and created new ones with cb_address etc. Also I found out that even though you don't want cb_zipcode or some other fields create them but don't publish them and the errors disappeared.
Thanks.
The administrator has disabled public write access.
|
|
|
Re:Problem using CB adapter - 2008/04/10 16:54
Yikes!!!! For those who read this thread ... I don't advocating deleting fields as there may be data in there and as such, you will lose it by doing so. Please .. please ... change the field name in the adapter as it is a lower risk change and I don't want people deleting data unnecessarily.
Chris
The administrator has disabled public write access.
|
|
|
Re:Problem using CB adapter - 2008/07/31 06:16
Have you been able to get this working by any chance? I am getting the same error. Any guidance is appreciated. Thx
The administrator has disabled public write access.
|
|
|
Re:Problem using CB adapter - 2008/07/31 06:54
I read the previous post a little more closely and fixed the problem myself by changing the filed names. No reply needed.
The administrator has disabled public write access.
|
|
|
Re:Problem using CB adapter - 2008/08/01 08:09
here is a link that provides more info on how to customize that adapter. it is located at the bottom of the list.
Adapter docs
Chris
Post edited by: support, at: 2008/08/01 08:11
The administrator has disabled public write access.
|
|
