Recent Topics

I can't login to the back office after update to 6.10.7 stable

Started by on Mar 26, 2019 – Contents updated: Apr 03, 2019

Mar 26, 2019 06:52    

I can't login to the back office after update to 6.10.7 stable

When I finally was successful in getting the upgrade (at first I was missing some files and had an outdated plugin), I went to the blog homepage. Everything is messed up (no background, header etc), which I expected, but I did not expect to be unable to fix it.

I have no way to edit posts -- no button at the end of the post.
When I click the "Log in" I get:

Note: You are already logged in as airycat! Continue »
You are already logged in

With no option to log into the back office. Comments are also disabled. Essentially my blog has become a read only site--even for me. the Form is loading... at the bottom of the page is ???? maybe to post a comment, but it only jumps down to 'no feedback yet.'

I'd say I was missing another file, but I have no clue what to look for or if that is even the cause.

You're my last hope, Oh, B2.

Mar 26, 2019 10:46

Hi
I'm attaching a file that has a copy of the source code from your 'front page'

There are a few anomalies and would suggest you reinstall.
The first line [1] is not what you would expect from a 6.10.7 install so I imagine your skin overrides the default set up. So please try and install without the skin in line [6]

The code for HTML would be, for example

<!DOCTYPE html>
<html lang="en-US"><head>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta http-equiv="X-UA-Compatible" content="IE=edge" />
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<base href="/skins/b2evo_bootstrap_forums_skin/" />

There are other things of note but without the above showing in the common sense I'm not sure I can help at this point.

Line [73] has an incomplete div tag [/div] rather than [</div] this will screw up the layout and more. So you may be able to find that and edit the tag, that could sort it?

it looks like a bad install for a few reasons, not least the skin problem.
How old is the previous version and do you have a backup of the database before the 'upgrade'?


Attachments:

Mar 26, 2019 18:34

My previous version was old. I had ftp problems for two years (with only intermittent effort to fix it) and it was old then. I don't remember the version.

I knew about the incomplete div tag. It was the first thing I wanted to fix. Fortunately I do have a complete backup. I'll clean up the page first and then reinstall and let you know if that worked.

Thank you!

Mar 28, 2019 02:06

I'm out of my element here. Before all I had to do was follow directions and everything upgraded fine. This time I was interrupted several times and I suspect I may have accidentally deleted/overwritten something I shouldn't have.

I think my old version was 5.9

amounI, got rid of the crap at the top of the page, got rid of the incomplete div tab, and changed my skin to basic, (although I know so little that I may have missed something) and the only thing that shows is the /div> is gone.

fplanque, I found the admin.php where it should be, but as far as I could tell it's the same one I've had with only a little filled in by me back in about 2010. Am I supposed to change something?

What I do find odd is that there is no folder or file named "anblog" or "blog 13". Maybe, since it's the main blog, the index.txt and index.php are all it needs.

I'm at the point where I'm ready simply to do a new install, rather than an upgrade, and start over, unless you see something simple that I can fix myself. I think it would be easier.

Mar 28, 2019 10:20

Hi @airycat

The 'anblog' or 'blog 13' are part of the database so if you can't see them, the question is are they still there. Also where are you looking for the folder.

if you created a slug folder in the root it shouldn't be overriden by and upgrade or new install
if are thinking about such a folder in the /media/blogs it would only change if you change the name of the blog via the back office.

Have you tried
Are you happy using phpMyAdim from the cpanel if you have such.

As you may have a few problems take one idea at a time.

Just been checking your site. Look at http://airynothing.net/Blogs/install/

Section 2
You will see it cannot connect to the database.
So forget all the above for now.
a) the install folder should have been deleted so anyone can't install over your database.
b) The implication is that your /conf/_basic.config.php fiel doesn't have the correct database name or user or password
c) The host/server is usually Localhost. It's unusual to have a fixed IP address as most people have a dynamic one that changes, so Localhost in that case is essential.

So if http://airynothing.net/Blogs/install/ isn't connecting to the new and proper database then it could be an old one.

If that is the case then a new install won't be any good if you use the same database.

OK that's a lot I know.
Back to a question - do you have access to cpanel and phpMyAdmin as you can check the databases there

PS that server/host ip doesn't seem to go anywhere so you couldn't connect to a database even if the name/user/pass where correct.

Mar 28, 2019 19:55

I had a pdf backup of posts, so I clicked on an "edit link there and got this:

An unexpected error has occurred!
If this error persists, please report it to the administrator.


Go back to home page


Additional information about this error:
MySQL error!


Error establishing a database connection!


(mysqli::real_connect(): (HY000/2002): Connection refused)


Are you sure you have typed the correct user/password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

I went into cPanel and did a check of MySQL® Database (which was ok) and a repair (just in case). No change.

Are you sure you have typed the correct user/password?--yes, it says I'm logged in and they're the same ones I've had forever
Are you sure that you have typed the correct hostname?--yes
Are you sure that the database server is running?--since it checked ok, I assume yes

I went to my pdf backup and used the "edit" link on a post, but got the same message. I have no other way, that I know of, to get to the back office.

It looks to me like the blog and sql are not talking to each other.
If I re-set-up the blog (as if I'd never had one), I know I'd lose everything I had (and is the "just in case" I saved pdf pages for), should that straighten things out, or should I talk to my web host? I have no problems accessing any other part of my website--only the biogs.

Mar 28, 2019 20:58

I went into cPanel and did a check of MySQL® Database (which was ok) and a repair (just in case). No change.
Saying that the database is ok via cpanel isn't much use. What is needed is to see a) what version it is set at to ensure it is compatible with b2evo 6.10.7 b) that it contains the posts you want.

Are you sure you have typed the correct user/password?--yes, it says I'm logged in and they're the same ones I've had forever
As the database isn't connecting it doesn't seem you do have the correct login details despite your assertions. When you say "it says I'm logged in" what says you are logged in ??

Are you sure that you have typed the correct hostname?--yes
On the host part of your login details, the number shown on the install is not the same as your ip.
If your database is on the same host crosswinds as part of your package then it will have the same ip as crosswinds which is crosswinds.net [8.21.33.10] you have it set to 69.28.227.132 so I'm not sure why you think that is correct.

I'll stop there as this is a problem I can't get past.

Are you sure that the database server is running?--since it checked ok, I assume yes

I went to my pdf backup and used the "edit" link on a post, but got the same message. I have no other way, that I know of, to get to the back office.

No idea what a pdf backup is as pdf usually refers to a Portable Document Format so this statement leaves me at a loss :(

It looks to me like the blog and sql are not talking to each other.
Very true given the ip number as mentioned

If I re-set-up the blog (as if I'd never had one), I know I'd lose everything I had (and is the "just in case" I saved pdf pages for), should that straighten things out, or should I talk to my web host? I have no problems accessing any other part of my website--only the biogs.

You seem to have a few strange words. You say "If I re-set-up the blog (as if I'd never had one)" but you are upgrading so yoiu have had one.

If you export the database via cpanel you will not loose anything.

The issue is still a) ensure you have a copy of the database, either prior to this attempt to upgrade or now.
b) ensure you can connect to a suitable data base whether you do a fresh install or do an upgrade i.e. back to the main issue of connecting to a/the database with proper name/user/pass/host.

c) do you have a copy of the database?

d) please inspect the database to see it's version and it's content, that is not a pdf of some of the content but either live via phpMyAdmin or via text editor once you have exported it to an sql file.

Mar 29, 2019 01:13

Briefly.
1) Ensure you have a copy of the database Use phpMyAdmin and export.
2) Check the version either by using phpMyAdmin and you will find the version in the setting table or you can find it in the exported file.
3) recheck the database is connectable.

Make a file testmydatabase.php for example with the following content

<?php
$link = mysqli_connect("localhost", "user_name_here", "password")or die("cannot connect to server "); 
mysqli_connect("localhost", "user_name_here", "password") or die(mysqli_error($link));
mysqli_select_db($link, "database_name_nere") or die(mysqli_error($link));
echo 'connected';
?>

replacing the user_name_here database_name_here and password

Try it like that, you can change the localhost to your IP if you like but try with localhost first, please :)

put the file in the root/Blogs of your site and then go http://airynothing.net/Blogs/testmydatabase.php

If it connects you will just get the word 'connected'

Mar 29, 2019 23:08

As I said, I am out of my element. I know 0 about databases. Before I updated I went into cPanel and did an account backup and a MySql backup. I also made my pdf backup, which is simply saving each page of the blog as a pdf file, because I understand this. And then I downloaded the whole Blogs folder to my computer. Then I did the upgrade.

I've never used phpMyAdmin before. Did the test my database and it takes me to the same non-working blog page as anblog does.

Looking at everything, I'd say either I didn't use the right place to save the database or that was one of the interrupted times and I thought I did it, but didn't, so I don't have one, apparently. I strongly suspect the former.

re-set-up the blog (as if I'd never had one)

means "fresh install' I think. Delete everything (except my media which I'll reincorporate later, maybe) to do with the blogs and start over at the very beginning. Looks like this is what I have to do. (I'm glad I do the pdf backup or I'd have lost it all. Dummy insurance. :D )

All I know about ips is that every computer has them and mine is not static. My website is hosted by Crosswinds, so I guess it should have the same ip as Crosswinds.

What besides css, php and databases do I need to learn to be a more informed user? I sure hope thy have " ___ for Dummies" for all these things. I'm not really a dummy, but it's not really what I want to spend my time doing.

Thank you for taking so much time for me. I really appreciate it, and I have learned a few new (to me) things, already.

Mar 30, 2019 09:22

OK Without going into more detail or all the things in your last post : one thing at a time

Going back to my post #9 did you make the file, upload it and run it?

Mar 31, 2019 07:11

@airycat wrote earlier:

... Did the test my database and it takes me to the same non-working blog page as anblog does.

No "connected." Just the non-working index page.

Nothing anywhere that looks like blog data (dates,post titles).

Mar 31, 2019 10:48

@airycat wrote earlier:

@airycat wrote earlier:

... Did the test my database and it takes me to the same non-working blog page as anblog does.


No &quot;connected.&quot; Just the non-working index page.


Nothing anywhere that looks like blog data (dates,post titles).

I'm not sure you are following the instructions as the file I asked you to make will not take you to your site.
For example you can connect to my database via http://calstock.org.uk/testmydatabase.php and you will see a simple page with the word connect. If any of the connection details were incorrect you would get an error message.

The process only connects to the database and will do so without any website content if the connection parameters are correct otherwise you will get an error message.

Your site responds with

Warning: mysqli_connect(): (****): Can't connect to MySQL server on '' (115) in on line 2
cannot connect to server

BUT FIRST Please change the name of the /Blogs/install folder, to some random /Blogs/n000way1n for example, from your host as it shows some of your login details, I will send you a private message after that.

Apr 01, 2019 22:06

I just removed the install folder.

Hmmm...as far as I know, I did the test php exactly the same way before, but this time I got "connected."
I have only one database. I tried to look at it, but it's in code I can't read. It should be current. I did the backup on 19/3/17

Apr 02, 2019 12:38

Ok Thanks for removing the install folder, one less worry.

If you did create the file as I suggested and then browsed to the file and got connected then it would seem you have all the correct connection data as you said more or less from the beginning :(

Here's my problem
a) Using the install URL, before you removed the folder there was a clear warning that you could not connect.

I'm attaching an image of the ERROR to a private message, so as not to divulge your database/user name etc.

If the details on that image are the same as you put in the testmydatabase file then there should be no error.
In b2evo the place where that info is available in /Blogs/conf/_basic.config.php

Will you open that file and ensure the connection details are the same as that in the testmydatabase file.
Basically if I put the details you used in the 'test' file in to my /conf/_basic.config.php I could run my site with all your data, it's that easy.

Apr 02, 2019 12:50

OK have sent private message.

So apart from, and before, a fresh install I'd like to know you have a good copy of the database. So when you are ready I will walk you through a database check.

Speak later after you have confirmed, here, whether config file data is either as you have in the 'test' file and/or as I have shiwn in the private message.

This post has 2 feedbacks awaiting moderation...


Form is loading...

Run your own website! – This forum is powered by b2evolution CMS, a complete engine for your website.