I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 14, 2019 11:13PM

Hi,
I updated Wampserver and all the programs. The icon is green and I changed the versions of the databases - I should see the log in page for wordpress when I type localhost on the search engine, but I get this message instead:

Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the mysite database.

Are you sure it exists?
Does the user root have permission to use the mysite database?
On some systems the name of your database is prefixed with your username, so it would be like username_mysite. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

Please, could anybody explain me what thing I did wrong and how to fix it?

Thanks for your time.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: RiggsFolly (Moderator)
Date: July 14, 2019 11:24PM

Hint.
Updated all the programs.
Therefore you updated mysql.... Right

What does that tell you.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 14, 2019 11:29PM

Not sure,

I updated mysql too.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 14, 2019 11:39PM

Last time, I did it in the same way and everything worked perfect. In fact, I followed the advise from this forum. I also try to log in to another site and I get this other message:

Not Found
The requested URL /wp-login.php was not found on this server.

Apache/2.4.39 (Win64) PHP/7.3.7 Server at festivals.test Port 80

I have no clue what's happening.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: RiggsFolly (Moderator)
Date: July 15, 2019 12:29AM

Hi,

Ok, lets start by you telling us what version of WAMPServer you originally had, and then tell us what version of WAMPServer you upgraded to.

Then tell us how you did the upgrade.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 12:46AM

I don't remember the last version I had of Wampserver. Is there any way to find out that?
I have now the last one, 3.1.9. 64bit.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 12:55AM

I went to [wampserver.aviatechno.net] and under wampserver updates, I clicked the only version available. The other options are under xdebug (no idea what is that). Once downloaded, I run it and it changed to the new version. After that, I just carried on with the rest of programs and before change the version I backed up the database using the export option.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: RiggsFolly (Moderator)
Date: July 15, 2019 01:02AM

Ok,

BUT WHICH VERSION DID YOU HAVE BEFORE?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: David Danelski (124.156.162.---)
Date: July 15, 2019 03:17AM

The problem is still actual. I've found a similar request here. I did it in the same way and everything worked perfect.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 10:33AM

I don't know. I imagine it's the last one before the 3.1.9. 64bit. Why?

Is there a download history on Wampserver to find out which version was the last, before updating it?

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Otomatic (Moderator)
Date: July 15, 2019 11:14AM

Hi,

Before change Mysql version, you must export your database then import it with the new MySQL version.

Your database is in the MySQL version you use. If you change MySQL version without export/import your database does not exist with the new version.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27 - MariaDB 10.3.16
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27/8.0.17 - MariaDB 10.3.16
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 06:20PM

Hi,
So, are you suggesting me to import my database, I have never done that so, I am not sure how I have to do it. Please, tell me if I am wrong: Left click to the wampserver Icon, then click to PHPmyAdmin and click to the import button. Is that right?
Do I have to do anything else?

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 07:39PM

Hi,
I tried what I said in my last post and it worked. I don't understand yet why others were asking me what version of Wampserver I had, as the problem it was with the database.

Last time, which was the first time I ever updated Wampserver and the rest of programs, I hadn't this problem. I updated MySQL without then importing the backup database. Probably way lucky or, who knows?

Anyway, thanks a lot for your help.

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 07:51PM

It worked well with one of my sites but the other it didn't. why?

I thought when I backed up the database it updates all the databases. The other site was empty, I meant, I only downloaded Wordpress and that's it, but I can't access to it. I still get this message:
Not Found
The requested URL /wp-login.php was not found on this server.

Apache/2.4.39 (Win64) PHP/7.3.7 Server at festivals.test Port 80

Any suggestion/piece of advice for the future to avoid situations like that. If I lost the site, should I delete Wordpress for that site and restart again?

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Otomatic (Moderator)
Date: July 15, 2019 09:47PM

Hi

Are you sure that the WordPress version you use supports PHP 7.3.7 ?

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27 - MariaDB 10.3.16
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27/8.0.17 - MariaDB 10.3.16
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 15, 2019 10:14PM

I think so, but not sure. If not what should I do? How can I check that?

The version I had for my second virtual host is newer than the first one, which now, after importing the database is working

Options: ReplyQuote
Re: I can't access to my site after updating wampserver
Posted by: Pisco (---.dynamic.dsl.as9105.com)
Date: July 16, 2019 11:01PM

Any piece of advice or suggestion?

Options: ReplyQuote


Sorry, only registered users may post in this forum.