Recent Topics

6.10.2 Database Upgrade Failure. Blog Offline. Please Help.

Started by on Sep 12, 2018 – Contents updated: Oct 02, 2018

Sep 12, 2018 03:06    

I attempted an upgrade from v.6.9.4 to 6.10.2 on August 13th. The upgrade failed. So did my attempts to delete and reinstall the site back to v.6.9.4, or to complete the upgrade the database to v.6.10.2.

I continue to receive an error message that the database schema number is not the correct one, but my host control panel shows that it is.

I think the database may be corrupted.

Is there some way to recover my nearly-300 posts from it?

Sep 12, 2018 12:08

A new thread, which is great, still requires full detail,
a) a screenshot showing the URL and error of the point of failure and
b) one showing the database.table >settings > version from your cPanel

It is possible that your database is corrupt.

Starting from scratch

In my private message I asked you to try a new install, not either of the things you have stated, this would give you a basic site and we would know that you can at least install, as the original seems to have been a cPanel installation. The problem with knowing your first install was by cPanel is that it is unclear if you have the ability to make your own database and install from scratch. As mentioned in that post once you have a clean install we can then attempt to import your database.

You haven't or haven't clarified that you have done as I suggested.
To do so, please show screenshots of the items in a) and b) above. It can then be confirmed which database version you have and you can be directed to the appropriate version of b2evo to upload and install.

Do not leave the [/conf] folder in place for a new install, the only details you may want keep are the database name, user name and password which are in the [/conf/_basic_config.php] file which you can singularly copy to your desktop for reference,

A new install is not an upgrade and doesn't use your database so you will not get a database version error. However to successfully import your saved database you must install the associated version of b2evo, hence the importance of knowing the database version as asked in b)

Please try as instructed or explain why you have problems with doing so?

Sep 12, 2018 13:03

Amoun, I told you I believed that the database was corrupted on a previous thread. You disagreed, now you agree it might be corrupted after all.

Question: how will importing a corrupted database to a new install fix it?

Is there any way to reverse the blog to a date prior to the failed upgrade without the assistance of my host, which claims to no longer be able to do so?

Sep 12, 2018 13:17

I can only repeat

There is no indication the database is corrupt, you think it may be and so it may be. If the database is corrupt then getting the data from it could be laborious.

You won't know if it's corrupt until you do as suggested, install from scratch and import the database.

Without a good database and confirmation of the version from a screenshot as in b) in the first post there is now way of knowing which version you have and so no way of re-installing the associated version to reverse your predicament. Hence the starting from scratch

If your host claim to be unable to do so then you have to try yourself as has been suggested.

Sep 12, 2018 13:22

Okay, I'll try a new install, then import the database.

Should I install a new blog using the former version, 6.9.4, or the failed upgrade version, 6.10.2?

Sep 12, 2018 14:50

As has been said in my previous replies, if you are sure of the database version then the corresponding b2evo version would make sense.

Remember if you do not delete all files except the [/media] folder then the new install will try and connect to whatever database you have via the parameters in [/conf/_basic_config.php] so it is important to remove the [/conf[ folder if you want a fresh start.

If you manage a clean install that corresponds ti the data base version you can then import the database.

But note: You still haven't shown the forum by way of a screen shot, what database version you have so no-one can tell you which b2evo version is suitable.

However if you do upload and install any version that at least shows you have a good grasp of the skills needed.

Good Luck

Sep 12, 2018 15:21

Info on database management than may be of use.
Part 1 and 2 are critical Ignore the rest until you have a working site.

  1. Find out how many databases your host allows you to create. If it is only one then the one you have will have to deleted it via cPanel - make sure you have a copy on your desktop before if you do have to delete it.
  • If you can have multiple databases you can create e new one with a new installation. The advantage being that by modifying the parameters in [/conf/_basic_config.php] later you can connect to either or any database.
  • Make the database smaller
    via cPanel open the database and find the b2evo_sessions table and [Truncate] it.
    Do the same for the items_versions table, and the hits table.
    This could massively reduce the database size.

Check it's size now, save after each truncate and check size again

A smaller database means less likelyhood of timeouts when importing/exporting and upgrading.

You will see options to Optimse and Repair the database

Sep 12, 2018 16:01

Attached please find screenshots of the database schema error message and screenshots of my host's control panel MyPHP, which includes the site's database schema version and postcat. I cannot tell if the posts can be saved by what I see.


Attachments:

Sep 12, 2018 18:51

Ok Again please attach the image file not embedded in a word document.

1) So taking the first image it shows the normal notification, though usually the number are from lower to higher in an upgrade. You have database version 12735 and need 12360.
There is a link to install, which you haven't indicated you tried.

2) That you have this message means you did not have a clean database to start with as I suggested
During install you are asked for database details.
From the second image you have database called joyce_bla12360
If you had entered that database name, user and password you would not have the notification as there would have been no number version to adjust. It appears you may have just clicked on the data suggested as you had not deleted the [/conf] folder where you uploaded the 'new' 6.9.4 version

Sep 12, 2018 20:52

The images you see in the screenshot are of the blog after I restored the backup files upon failure of the reinstall.

The blog's database schema is the correct one for an upgrade.

Assuming the database is corrupted, how do I recover the posts from it? Is that possible?

Sep 12, 2018 21:37

@njjoyce wrote earlier:

The images you see in the screenshot are of the blog after I restored the backup files upon failure of the reinstall.

The blog's database schema is the correct one for an upgrade.

Assuming the database is corrupted, how do I recover the posts from it? Is that possible?

None of the images are of the blog ???

  1. The first image shows you are in the process of installing the blog and have stopped (See Point 1 of my last post
  2. The second image is a view via cPanel > myPhpAdmin of the multiple databases you have on your host and is irrelevant here
  3. The third shows you looking at a specific database which has no tables, this is a good one to use on a new install of any version. See my previous post Point 2
  4. The fourth is another view via cPanel showing a partial view of tables in [joycebla_freedom]

None are of the blog.

However if you follow previous guides you could see what version database [joycebla_freedom] and then you could install the appropriate version, but you must have the correct user name and password to access it, something I told you before that you have failed to acknowledge.

The blog's database schema is the correct one for an upgrade.
I don't think you are correct. You can tell that from the info you have provided in the first image shows you need to backdate not upgrade the database, although upgrade is the term used as you cannot downgrade the database hence the need to install the correct version of b2evo matching the database or start from scratch.

We have been through this since the first time you asked for help see *****

As you are not getting the picture so to speak you may be better starting from scratch, so no use in The blog's database schema is the correct one for an upgrade sort of idea.

Regarding your last sentence laboriously as mentioned but yes.

Not much use to recover if you can't install a working b2evo.

Sep 12, 2018 23:33

If there are no tables, does that mean all my posts were deleted by the failed upgrade?

Sep 13, 2018 01:46

I have no idea what you are doing as you don't detail the steps you are taking.
You do a lot of unseen changes and post mostly irrelevant and hard to read screen shots

  1. I have no idea when you made any of the databases.
    You should have dates you made each and you should know what they are for
  2. I have no idea what they relate to
  3. Specifically I have no idea when you made the database that is empty,
  4. No idea if you made an empty database
  5. No idea if you emptied it

You keep referring to a failed upgrade which is of no use. You have to do one of the option suggested.
Please either start a new install as suggested many times
or read all the databases via cPanel > myAdminPhp to see what they are for
No one else has access to them you have to do this or employ someone to do it.

But you are missing the point.
The databases are irrelevant if you don't install a working b2evo as said many times.
Do you have a problem deleting the old files, making a database, uploading and installing in that order.???

Sep 13, 2018 08:37

I followed your previous instructions to reinstall v.6.9.4 or to overwrite the failed upgrade to v.6.10.2 by first backing up all files. Next, I deleted all files except the media and conf files, then attempted to reinstall v.6.9.4. My attempt failed, so I extracted the compressed backup zip file. That's what you see in screenshots of my control panel.

How can I recover the posts on my blog if the database is corrupted, as it appears to be? You still have not provided any instructions to do so. Is it possible to recover them?

Sep 13, 2018 08:37

I followed your previous instructions to reinstall v.6.9.4 or to overwrite the failed upgrade to v.6.10.2 by first backing up all files. Next, I deleted all files except the media and conf files, then attempted to reinstall v.6.9.4. My attempt failed, so I extracted the compressed backup zip file. That's what you see in screenshots of my control panel.

How can I recover the posts on my blog if the database is corrupted, as it appears to be? You still have not provided any instructions to do so. Is it possible to recover them?

Sep 13, 2018 10:48

@njjoyce wrote earlier:

I followed your previous instructions to reinstall v.6.9.4 or to overwrite the failed upgrade to v.6.10.2 by first backing up all files. Next, I deleted all files except the media and conf files, then attempted to reinstall v.6.9.4. My attempt failed, so I extracted the compressed backup zip file. That's what you see in screenshots of my control panel.

How can I recover the posts on my blog if the database is corrupted, as it appears to be? You still have not provided any instructions to do so. Is it possible to recover them?

I followed your previous instructions to reinstall v.6.9.4 or to overwrite the failed upgrade to v.6.10.2 by first backing up all files.

I did not ask you to back up all the files, there is no point. I asked you to upload a new version from this site that a) either suits your database version or any version if you make a new database

Next, I deleted all files except the media and conf files,

See #6 above :: second sentence :: where it says "Remember if you do not delete all files except the [/media] folder then the new install will try and connect to whatever database you have via the parameters in [/conf/_basic_config.php] so it is important to remove the [/conf[ folder if you want a fresh start."
I asked you to save the [/config/_basic_config.php] to your desktop for reference if you need the login parameters once you have successfully imported the old database.

You still have not provided any instructions to do so. Is it possible to recover them?

See #11 :: last two sentences :: "Regarding your last sentence laboriously as mentioned but yes. Not much use to recover if you can't install a working b2evo."

I am not going to provide instructions on recovering data from your database as so far you have ben unable to follow instructions to the letter from all the previous posts, and recovery would add more effort.

Read the posts again

  1. Backup the media files and the config file to your desktop.
  2. Clear the space on your host for an new install and leave only the [/media] folder
  3. Make a new empty database, ensure you have the name, user and password
  4. Download anew 6.9.4
    5 Upload 6.9.4 to the clean space, no left over folder, DO NOT use a backup
  5. Install and when asked for database details enter those from your new database

You should now have a clean version of b2evo

The above instructions have been provided and are the basics of the on-line help. You should have been able to do this. Why you continually do other things brings to and you are not understanding the replies you get, which is implied by your off topic comments and overall lack of response to the specific instructions you are supplied with.

Sep 13, 2018 12:18

Ok Let's try yet again
( See previous posts to find out which database you have and then you can install the appropriate version) The problem here is you have been told you can do this but have not done so or responded to the detailed steps. If you can't find the version, say so!!

All below you should have read by now, but just in case you have avoided it, or have problems with it.

Try the install below with 6.9.4, the worst is that a) it works or b) another story

Download http://b2evolution.net/downloads/6-9-4?download=7407

1) Read https://b2evolution.net/man/installation-guide for a new installation Start at section 5

Pay special attention to steps 5.3 and 5.4

When you get to step 5.4 you should enter as has been explained before and shown on the screenshot, the details of the new database.

2) Once you have managed that ask about importing your old database

Leave only the [/media] folder where you upload the clean version of 6.9.4

If you want the old database details copy [/conf/_basic_config.php] it to your desktop do not leave them on the webspace.

Once you have a working copy start a new thread 'Importing backup database' so we can see you have made progress Step by Step.

And please sort out this attachment issue I do not like to open documents that need scanning for viruses etc.

Sep 13, 2018 13:34

I cannot copy and paste into this forum, that is why I am copying and pasting them into attached documents.

I will follow your instructions and hope there is a different result this time.

Sep 13, 2018 15:02

When you take a screen shot paste it to Paint not a Word doc and save it as a jpg, gif or png, then you can attach it here and it will be viewable in the post once you have saved the post.

Good luck. At this point only a clean install will let you know if you have the procedure sorted.

Sep 14, 2018 23:46

I don't think there's anything to recover in the media file, Amoun. The main blog appears to have been wiped clean, which would explain the filehacker/upgrade files in the blog's trash bin.

Fortunately, I found backup files from late last year that I can use on a fresh reinstall.

In order to do that, should I back up what's left of my site or just delete everything on it and start all over again with the backup file?

Sep 15, 2018 18:37

I don't think there's anything to recover in the media file, Amoun.

The main blog appears to have been wiped clean, which would explain the filehacker/upgrade files in the blog's trash bin.

Fortunately, I found backup files from late last year that I can use on a fresh reinstall.
Told you not to install a back up

In order to do that, should I back up what's left of my site or just delete everything on it and start all over again with the backup file?

Told you not to install a backup. You can clearly read English, so why ignore the content.

Go back and read it all again.

Start a new thread when you have something different to say and don't carry on with this as it is irrelevant to the topic title again

Sep 15, 2018 18:52

When I opened the media file, I saw items from one of the four blogs on my site, but none of the nearly 300 posts on the main blog.

If I can't install a backup file, what am I supposed to do to recover my posts?

Sep 15, 2018 19:06

If you have read the previous responses you would know the answers.
Read #16 and #17 again

Sep 15, 2018 19:20

Amoun, it's very difficult to read your posts because they're so long and you're copying and pasting mine into them.

I'm not proposing that I install a backup copy of the media file from the control panel; I'm proposing I install a backup copy of the media file downloaded to my laptop late last year, when I successfully upgraded to version 6.9.4.

I also have a backup copy of 6.10.2 stored on my laptop, but I didn't check to see if it was hacked or not. Probably was since I was experiencing problems with the blog just before the failed upgrade.

Sep 15, 2018 20:34

I deleted all the files you told me to remove and now I'm getting the following error message:

Warning: require_once(/home6/joycebla/public_html/freedomofthepress/inc/_main.inc.php): failed to open stream: No such file or directory in /home6/joycebla/public_html/freedomofthepress/index.php on line 26

Fatal error: require_once(): Failed opening required '/home6/joycebla/public_html/freedomofthepress/inc/_main.inc.php' (include_path='.:/opt/php70/lib/php') in /home6/joycebla/public_html/freedomofthepress/index.php on line 26

Sep 15, 2018 21:33

If you have a clean host space as in [/home6/joycebla/public_html/freedomofthepress] and have created a new database, as instructed then a clean install should work fine.

You have not made it clear after many posts than you have done the above.

The error you mention '/opt/php70/lib/php' is not a b2evo error, but a hosting one either a mismatch of php versions or lack of provision.

If you start with an empty space and make a new install you will not get proper help if you don't explain exactly what you have done with a proper screen shot.

I repeat
A new topic each time you try a new install.
Do not use a backup version of b2evo.

Clean your webspace.
Ask your host what php version you are using
Download a fresh version of b2evo any version for now, 6.10.2 will do if you like
Upload the unzipped files

The new topic title must reflect a simple query and then stick to it.
At the start of the topic mention the version
List the exact steps you took from clearing the space, downloading, unzipping, uploading, installing and then the error.

Do not miss a step or mention anything else as it a) unclear if you are proceeding properly and you keep referring to past actions.
Install via http://joycebla/freedomofthepress/install.index.php if that is where the install file is.

If all goes well fine, if not start a new topic with exact details and post a single image as mentioned via Paint

Sep 15, 2018 21:50

My host's tech is restoring the files I deleted. In the meantime, he also installed the db.sql backup file from v.6.10.2 into the MyPHP joycebla_12360, which had empty tables. Now they are filled, but I'm still getting the same error message (attached).

My host's tech said he believes there is a coding communication error between the database and the Web site configuration files, but that the b2evolution developers would know better than he if that is the case.

If it is, then I need your benefit of your expertise to fix the coding problem since I am not a coder or programmer. This is not a user issue; it is a coding issue.

Please help me.


Attachments:

Sep 16, 2018 02:11

You ask for suggestions yet you ignore them.
I suggest you install from scratch and you say you will but then don't.
As you continue to restore old files etc, you keep repeating the same mistake, so you cannot be helped until you stop.

You say your hosts believes there is a coding problem. You then up the anti to say it IS a coding problem, how you worked that out I don't know as you are not a or the coder.

As you were told by FPlanque in your first loads of posts, get your host to post on this site if they think there is a problem, if they can't be bothered then, there no point in you passing on what they say again.

My continued experience with you is that you do not give out the information asked for and I will not open another one of your word documents, so at least learn to copy to Paint and attach that. At least then I will have some confidence that you can both understand what you are being told and can act on it.

If you can't learn to make a simple image file by copy and paste , then I have no confidence that you can carry out the operation of installing from scratch, as you clearly show.

Stop messing about and start from scratch.

Sep 16, 2018 09:53

You are making assumptions that are not correct.

I did try to install a new version of b2evolution - multiple times - but none of the attempts worked because there is already an existing version.

I tried to delete the files you said I did not need in order to reinstall the new version, but got a different error code. That is why I asked my host's tech to put back all the files I deleted.

The issue with my blog is a programming problem, not a user problem. My host used to be able to fix similar upgrade coding problems with b2evolution, but no more. They no longer support b2evolution or even offer it for download.

Please correct this coding communication problem, then you can share the resolution with others through a post that can include screenshots that are not attachments.

I cannot fix the problem myself as I am not a developer, programmer or coder. The cost of hiring a developer that can fix a coding upgrade problem with my b2evolution blog could cost hundreds of dollars that I cannot afford.

Please help.

Sep 16, 2018 11:58

I did try to install a new version of b2evolution - multiple times - but none of the attempts worked because there is already an existing version.

  1. Your posts have never indicated a clean install
  2. An existing version implies you didn't remove the old one which has been suggested multiples times is the route to take.

I tried to delete the files you said I did not need in order to reinstall the new version, but got a different error code. That is why I asked my host's tech to put back all the files I deleted.

You have never reported the steps you have taken to make a new install so I can't really help you until you follow instructions to the letter and post back exactly what you do.

You still have the same problem by reinstalling and connecting to an old database and not a new one as directed

The issue with my blog is a programming problem, not a user problem. My host used to be able to fix similar upgrade coding problems with b2evolution, but no more. They no longer support b2evolution or even offer it for download.

It is not a coding problem and as I've said why bother with your host.

Please correct this coding communication problem, then you can share the resolution with others through a post that can include screenshots that are not attachments.

You are becoming increasingly out of step and demanding

I cannot fix the problem myself as I am not a developer, programmer or coder. The cost of hiring a developer that can fix a coding upgrade problem with my b2evolution blog could cost hundreds of dollars that I cannot afford.

If is not a developer, programmer or coder problem, after over 100 posts you show little integrity on following simple instructions, and until you do you cannot be helped.
Please help.

Sep 16, 2018 16:54

I cannot fix the problem myself as I am not a developer, programmer or coder. The cost of hiring a developer that can fix a coding upgrade problem with my b2evolution blog could cost hundreds of dollars that I cannot afford.

If you cannot afford hiring a competent sysadmin (which is what you really need), then you cannot NOT afford to follow the instructions that @amoun is giving you for free.

Let me rephrase that to be extra clear: you MUST follow @amoun's instructions STEP BY STEP and you MUST report on what you do STEP BY STEP.

Your repeated failure to do so has gotten you nowhere and likely won't get you anywhere in the future either.


Form is loading...

free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.