[SOLVED] Will CB 1.2.2 Upgrade Affect CBSubs?

13 years 10 months ago #133153 by SusanC
Replied by SusanC on topic Re:Will CB 1.2.2 Upgrade Affect CBSubs?
Thanks, Beat, They're all different kinds of fields, which did not seem to provide a clue. So, I looked at the jos_comprofiler database fields using phpmyadmin, and sure enough, some of them are indeed listed as jos_ instead of #_. It is a mystery, why only certain fields were affected. For instance, some of the fields I had added, like "cb_mtnacertification," are listed as using jos, and others, like "cb_mywebsite," are listed as #. (see screenshots attached) Please forgive that I have very minimal knowledge of php - how is it possible to change these prefixes to what they should be, that is, from jos_ to #_? Or would it be easier to simply delete the fields and add them back in again, using the cb field manager in the site's back end?

Post edited by: SusanC, at: 2010/05/16 01:00

Post edited by: SusanC, at: 2010/05/16 01:01
(The editor interface would not allow the attachment of screenshots after I resized them and tried again.)

Post edited by: SusanC, at: 2010/05/16 01:06

These are all the fields I had added, showing the ones for which errors had shown up after checking the fields database storage, and whose prefixes had been changed to jos_comprofiler (not all the fields I had custom added were affected):

expiration date jos_comprofiler
chartermember jos_comprofiler
membershiptype jos_comprofiler
favoritecomposers jos_comprofiler
streetaddress-still used #
recordingsilove jos_comprofiler
geographicalarea jos_comprofiler
mystyles jos_comprofiler
state jos_comprofiler
myinstrument jos_comprofiler
country jos_comprofiler
technologyiuse jos_comprofiler
postalcode-still used #
contactphone-still used #
mywebsite-still used #
twitter-still used #
professionalaffiations jos_comprofiler
mtnacertification jos_comprofiler
mybiography jos_comprofiler

Post edited by: SusanC, at: 2010/05/16 01:15
Attachments:

Please Log in to join the conversation.

13 years 10 months ago #133154 by beat
Replied by beat on topic Re:Will CB 1.2.2 Upgrade Affect CBSubs?
Hi Susan,
No PHP needed here :)

Just use a MySQL editor, like PhpMyAdmin and edit and save those rows.

Replace jos_ by #__ (2 underscores) in each of the rows of jos_comprofiler_fields "table" column.

Joomla does the replacement of #__ by whatever you have (jos_ , mos_ or your own prefix).

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

13 years 10 months ago #133185 by SusanC
Replied by SusanC on topic Re:Will CB 1.2.2 Upgrade Affect CBSubs?
Thank you very much. That was very easy and everything seems to be in order now!

Please Log in to join the conversation.

13 years 7 months ago #139555 by ZeusMM
Something similar friends...

I used Akeeba to back up my system and restore it to a live web environment from a local test situation. The table jos_comprofiler_fields has a large number of entries that have been converted to jos_<...> when they should be #_<...>. The CB database checker gives errors to the effect that this is not working.

Error message is:

________________
Table #__comprofiler_fields Column table DEFAULT is 'jos_comprofiler' instead of #__comprofiler
Table #__comprofiler_fields Rows fieldid = 41 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 26 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 25 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 27 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 28 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 29 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 42 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 45 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 46 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 47 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 48 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 49 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 50 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 51 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 52 : Field table = jos_users instead of '#__users'
Table #__comprofiler_fields Rows fieldid = 24 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 23 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 22 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 21 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 20 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 19 : Field table = jos_comprofiler instead of '#__comprofiler'
Table #__comprofiler_fields Rows fieldid = 18 : Field table = jos_comprofiler instead of '#__comprofiler'

_____________

The solution is to take a copy of the working loca system and replace the table with the correct one by deleting the old one using PHPmyAdmin...

Checking everything seems to give a positive result with all of the errors having been fixed.

The reason that I created a local test system was because of this precise problem and I wanted to make a step by step clean install with no errors. The errors came back and luckily I have now tracked them down to Akeeba not functioning correctly.

Hope this helps...

Andi

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.274 seconds

Facebook Twitter LinkedIn