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.


Site Crash on upgrade to 8.1.1

Login / Search

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

Community saint

Hi all,

I am looking for some advice. I started an upgrade to 8.1.1, took a backup, downloaded a backup of the db, cleared the cash, did a manual upload of the tar, and started a file compatibility when the site crashed, completely. The error logs show no errors. :( When I tried to log into the upgrader.php, the first time, I got a stack trace that indicated a db table was missing. I tried to login again, and the admin password from the info.php file is either not accepted, or I am still not able to access the db.

Right now, I am uploading the site backup, for the second time. The first did not work.

Here is my question. If this does not work the second time, what about clearing all files and doing a fresh install of 8.1.1? I have the database and backup of the themes. Could I just upload the backup db tables and restore all my site info? I guess I would also have to add the theme, too.

Does that sound like a viable option?

Any help is greatly appreciated.
Doc
Back to the top
 
Posted
Rating:
#87574
Avatar

Hi,

What were you upgrading from?

When I tried to log into the upgrader.php, the first time, I got a stack trace that indicated a db table was missing
Could you share the trace?


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:
#87575
Avatar

Community saint

I did not get the chance to copy the trace.  :$

I thought the version I was updating was 7.6.2, but that does not seem to be a choice. I barely paid attention long enough to have the tar created…my mind was not really in this, apparently.
Back to the top
 
Posted
Rating:
#87576
Avatar

Community saint

The backup is almost complete. I will see if that works.
Back to the top
 
Posted
Rating:
#87579
Avatar

Community saint

Chris, the upgrade was from 7.1.6 to 8.1.1.  :)
Back to the top
 
Posted
Rating:
#87581
Avatar

Can you get the stack trace now?


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:
#87588
Avatar

Community saint

No, sorry.

I guess I will just try what I suggested above.
Back to the top
 
Posted
Rating:
#87589
Avatar

I tried to login again, and the admin password from the info.php file is either not accepted, or I am still not able to access the db.

I'm a bit tired (past midnight) so I've been doing something of skim reading. Just noticed…

You uploaded the blank info.php from the manual installer.

That'd cause big problems.

If you must upgrade via the manual installer, it's critical not to upload that.

Ideally you would use the proper tailored upgrader generation system we have.

If you don't, you can get away with this (again, don't upload info.php) and the upgrader will help guide you what files belong to uninstalled addons so might need deleting again.


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:
#87591
Avatar

Community saint

Ideally, I would use the updater system. My ISP times me out every time I try that.

btw, you are right, I did upload the blank info.php. I told you my head was not in this.  :$

Thanks, Chris. Get some rest. It is about 12:30 AM your time. snooze… ;)
Back to the top
 
Posted
Rating:
#87761
Avatar

Community saint

Ok, here is an update.

I tried the updater system, and all seemed to be going well, until I got an "Access Denied" in large blue letters.  :(

Next, I downloaded the tar and extracted the files, made sure the info.php was not uploaded, and this is the result of the stack trace.

btw, there is some other problem cause I can not get back into the upgrader.php suing the password located in the info.php file.

Click the stack trace image to enlarge.



Any other ideas, Chris.  :)

Back to the top
 
Posted
Rating:
#87762
Avatar

Can you access /upgrader.php manually?


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:
#87763
Avatar

Community saint

No. I tried from the admin zone, and got that stack trace, then I tried using the direct url. I get the login screen displayed; however, no luck using the password.
Back to the top
 
Posted
Rating:
#87764
Avatar

Try editing info.php by hand and putting a new master password in. You don't need to encrypt it, plain is fine. You can change it again later :).


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:
#87765
Avatar

Community saint

I tried to access the upgrader.php, and now get a critical error. I tried to post the stack trace here, but it would not let me use the hide tags.

This is an error that has been elevated to critical error status because it occured 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 occured 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 l_setting FROM ocp4_notification_lockdown WHERE (l_notification_code='error_occurred') LIMIT 1] [Table 'trustser_ocf.ocp4_notification_lockdown' doesn't exist] (version: 8.1.1, PHP version: 5.3.13, URL: /upgrager.php)
This is the error message.
Back to the top
 
Posted
Rating:
#87766
Avatar

Community saint

Chris, the third try was a charm. I edited the info.php password, and used IE to access upgrader.php. I will try the process, again.
Back to the top
 
Posted
Rating:
#87767
Avatar

/upgrager.php

I think you did a typo and it redirected you to the 404 error page.

Essentially there are two things at play here:
  1. You can no longer login to the upgrader using the encrypted version of the password, due to added security. So the password must either be stored unencrypted (a temporary thing I hope), or you need to use the decrypted password.
  2. ocPortal itself is likely to crash and burn until the upgrader is done with database upgrades. The upgrader runs a stripped down version of ocPortal, basically.


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:
#87770
Avatar

Community saint

Thanks, Chris.

I did not receive a 404 error, so I don't think that was the problem.

Once I got access to the upgrader.php, I did a file integrity check and found a number of files that should not have been there, and that some files did not upload during the ftp transfer. I fixed that, updated the db, and all is now well, I think.  :lol:

How can I go about encrypting the upgrader.php admin password for the info.php file?
Back to the top
 
Posted
Rating:
#87772
Avatar

I did not receive a 404 error, so I don't think that was the problem.

No, ocPortal died before you did.

How can I go about encrypting the upgrader.php admin password for the info.php file?

/config_editor.php can change it. Log in, then change in there.


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:
#87773
Avatar

To be clear -- by default ocP handles 404 errors, due to the .htaccess settings.


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:
#87867
Avatar

Community saint

Thanks for all your help, Chris. It is greatly appreciated!  :thumbs:

One more question, that is  :offtopic: . I noticed that when you click the "view all emoticons" link, the iframe opens; however, when you click on an emoticon, it does not add it to the textarea dialog box. Is that a bug, or am I just doing something wrong?
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Expand