HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


[resolved] 9.0.5 MSN install critical error

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#96082 (In Topic #19097)
Avatar

Community saint

I guess this is a good time to stop for the night.  :thumbs:

Critical error - bailing out

This is an error that has been elevated to critical error status because it occurred during the primary error mechanism reporting system itself (possibly due to it occuring within the standard output framework). It may be masking a secondary error that occurred before this, but was never output - if so, it is likely strongly related to this one, thus fixing this will fix the other.
Unfortunately a query has failed [SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM oc_f_member_custom_fields main LEFT JOIN oc_translate t0 ON t0.id=main.field_1 AND t0.language='EN' LEFT JOIN oc_translate t1 ON t1.id=main.field_6 AND t1.language='EN' LEFT JOIN oc_translate t2 ON t2.id=main.field_9 AND t2.language='EN' WHERE (main.mf_member_id=2) LIMIT 1] [Unknown column 'main.field_6' in 'on clause'] (version: 9.0.5, PHP version: 5.3.3, URL: /adminzone/index.php?page=admin_setupwizard&type=misc)

Expand: Stack trace... Stack trace...


Steve
Back to the top
 
Posted
Rating:
#96084
Avatar

Community saint

The above install took out 3 other MSN sites. All 3 have the same error…

Critical error - bailing out

This is an error that has been elevated to critical error status because it occurred during the primary error mechanism reporting system itself (possibly due to it occuring within the standard output framework). It may be masking a secondary error that occurred before this, but was never output - if so, it is likely strongly related to this one, thus fixing this will fix the other.
Unfortunately a query has failed [SELECT main.*,t0.text_original AS t0__text_original,t0.text_parsed AS t0__text_parsed,t1.text_original AS t1__text_original,t1.text_parsed AS t1__text_parsed,t2.text_original AS t2__text_original,t2.text_parsed AS t2__text_parsed FROM oc_f_member_custom_fields main LEFT JOIN oc_translate t0 ON t0.id=main.field_1 AND t0.language='EN' LEFT JOIN oc_translate t1 ON t1.id=main.field_6 AND t1.language='EN' LEFT JOIN oc_translate t2 ON t2.id=main.field_9 AND t2.language='EN' WHERE (main.mf_member_id=354) LIMIT 1] [Unknown column 'main.field_6' in 'on clause'] (version: 9.0.5, PHP version: 5.3.3, URL: /index.php?page=login&type=login)

Expand: Stack trace... Stack trace...




Steve
Back to the top
 
Posted
Rating:
#96087
Avatar

Could you open a bug report ticket?


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#96094
Avatar

Community saint

Chris Graham said

Could you open a bug report ticket?

Opened.

Steve
Back to the top
 
Posted
Rating:
#96098
Avatar

This should now be fixed on the gambos.org site. Could you copy sources/database.php from that site, to the others please.

What happened here is thus…

The Setup Wizard was filled in to delete some default CPF(s). This deleted them from the central site, but the language field registries (a term I just made up to avoid confusion) are taken from the individual satellite sites and it caused a mismatch.
I have coded it to no longer use language field registries for the CPF table, as this is dynamic.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#96101
Avatar

Community saint

Chris Graham said

This should now be fixed on the gambos.org site. Could you copy sources/database.php from that site, to the others please.
Thanks, Chris. I'll make the changes shortly to the other sites and report back.


What happened here is thus…

The Setup Wizard was filled in to delete some default CPF(s). This deleted them from the central site, but the language field registries (a term I just made up to avoid confusion) are taken from the individual satellite sites and it caused a mismatch.
I have coded it to no longer use language field registries for the CPF table, as this is dynamic.

That makes sense because all my other satellite installs were as close to carbon copies as I could make them, but with this one I decided to do something a little different.

Should satellite installs be carbon copies (set up) of the main site to avoid things like this happening?

Is there a way to pull a config/addon profile from a site to help in cloning another site? Something like this would be very useful for setting up default installs. A tracker feature request?



Steve
Back to the top
 
Posted
Rating:
#96102
Avatar

Should satellite installs be carbon copies (set up) of the main site to avoid things like this happening?

There should be no problems like this – if there are, it's a bug.

Is there a way to pull a config/addon profile from a site to help in cloning another site? Something like this would be very useful for setting up default installs. A tracker feature request?

Is it desirable? I think personally I'd want each site to have a custom set of addons, because otherwise I'd be using zones.

Zones can have their own domain names, although in v9 that requires manual editing of info.php.

v10 is about to receive a function where you can basically clone out complex site structures into new zones, i.e. auto-set up various categories, menu items to link to them, etc.

It becomes thornier if you want to delegate permissions over a zone. But MSNs don't solve that either, as you need to give each site access to the central forum DB (inc members table).
One popular request that we haven't been able to prioritise yet is per-zone Comcode page editing permissions:
0000107: Comcode page editing permissions, per zone - ocPortal feature tracker


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#96104
Avatar

I thought some more, and actually it would be useful, outside the context of MSNs. It could be useful generally for running a web design business in a particular industry.
So:
0001080: Save site configuration as an install profile hook - ocPortal feature tracker


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#96109
Avatar

Community saint

Copied over the file to the other sites and everything is back up and running again. Thanks again, Chris!  :thumbs:

Chris Graham said

Should satellite installs be carbon copies (set up) of the main site to avoid things like this happening?

There should be no problems like this – if there are, it's a bug.

Is there a way to pull a config/addon profile from a site to help in cloning another site? Something like this would be very useful for setting up default installs. A tracker feature request?

Is it desirable? I think personally I'd want each site to have a custom set of addons, because otherwise I'd be using zones.
I was thinking more as using for a base install since a lot of the "extras" like ecommerce, shopping, quizzes, etc. aren't useful for what our community is about. Having a "base" config profile would help in getting a satellite site set up quickly without needing to spend a lot of time stepping through the config wizard or going through all the different configuration screens.


Zones can have their own domain names, although in v9 that requires manual editing of info.php.
I haven't looked yet, but is there any documentation on this?

v10 is about to receive a function where you can basically clone out complex site structures into new zones, i.e. auto-set up various categories, menu items to link to them, etc.

It becomes thornier if you want to delegate permissions over a zone. But MSNs don't solve that either, as you need to give each site access to the central forum DB (inc members table).
Nice tidbit of info. I'm looking forward to playing with this.

One popular request that we haven't been able to prioritise yet is per-zone Comcode page editing permissions:
0000107: Comcode page editing permissions, per zone - ocPortal feature tracker
Ah, yes. This is one I've marked last November for future sponsorship.  :thumbs:


Steve
Back to the top
 
Posted
Rating:
#96110
Avatar

I was thinking more as using for a base install since a lot of the "extras" like ecommerce, shopping, quizzes, etc. aren't useful for what our community is about. Having a "base" config profile would help in getting a satellite site set up quickly without needing to spend a lot of time stepping through the config wizard or going through all the different configuration screens.

Yeah, there's a tracker item for a minimalistic install profile.

I haven't looked yet, but is there any documentation on this?

Prob the advanced configuration tutorial.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#96111
Avatar

Community saint

Chris Graham said

I was thinking more as using for a base install since a lot of the "extras" like ecommerce, shopping, quizzes, etc. aren't useful for what our community is about. Having a "base" config profile would help in getting a satellite site set up quickly without needing to spend a lot of time stepping through the config wizard or going through all the different configuration screens.

Yeah, there's a tracker item for a minimalistic install profile.
Already found it!  :lol: (and started the ball rolling on it and a few others)

I haven't looked yet, but is there any documentation on this?

Prob the advanced configuration tutorial.
Thanks, I'll dig around in there.

Steve
Back to the top
 
Posted
Item has a rating of 5 (Liked by sholzy)  
Rating:
#96112
Avatar

Here's what we use on here:

Code

$SITE_INFO['ZONE_MAPPING_ocproducts']=array('ocproducts.com','');

It is saying the ocproducts zone is tied to the root ('') of the ocproducts.com domain.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: