Re-install of XAMPP, followed by 1.000s of error messages!

Lars.Lemming
(@larslemming)

3 months, 1 week ago
I do not know how special my situation is, I presume that may people has experienced something similar, but to me this is a first!

For reasons I will not dive in to, I had to uninstall XAMPP and make a “fresh” installation, but before I did this, I copied the files in “data” and “backup” in the MySQL folder and the “htdocs” folder from the XAMPP installation.

After having uninstalled the old instance of XAMPP and installed the latest new version, I located the new “data” and “backup” folders in the MySQL folder and the “htdocs” folder in new XAMPP installation, replacing them with the old copies and started the servers.

I then checked the phpMyAdmin site and found that all the databases was established, so I proceeded to the first (of 9) website I am working on by entering “localhost/website name/wp-admin”, only to be presented with the installation menu for WordPress.

After having selected the language and filled in the name of the website, my email address and selecting pressing “Install WordPress” (I had no other options), a page called ” localhost/website name/wp-admin/install.php?step=2” appeared with several 1.000 of error messages (please see the attached for the first browser window of error messages – in total it was in excess of 90 browser windows long!

I wanted to attached a screen dump of the first page for your information, but the people who knows the answer probably know what it looks like in full – any way, at the bottom I will cut and paste the first browser page or so.

Now the first and most important question is, how do I solve this issue so that I can access the websites on my localhost installation and work on them – without having to rebuild the sites all over?

The second question – which is not that important if I get the first issue solved, but still important for my own curiosity and to prevent that something like this happens again and so we all can learn – is what has gone wrong?

Your assistance in solving this issue is naturally very much appreciated.

———-First browser window error message start———-

WordPress database error: [Table ‘wp_users’ already exists]
CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default '', user_pass varchar(255) NOT NULL default '', user_nicename varchar(50) NOT NULL default '', user_email varchar(100) NOT NULL default '', user_url varchar(100) NOT NULL default '', user_registered datetime NOT NULL default '0000-00-00 00:00:00', user_activation_key varchar(255) NOT NULL default '', user_status int(11) NOT NULL default '0', display_name varchar(250) NOT NULL default '', PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename), KEY user_email (user_email) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

WordPress database error: [Table ‘wp_usermeta’ already exists]
CREATE TABLE wp_usermeta ( umeta_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

WordPress database error: [Table ‘wp_termmeta’ already exists]
CREATE TABLE wp_termmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, term_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY term_id (term_id), KEY meta_key (meta_key(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

WordPress database error: [Table ‘wp_terms’ already exists]
CREATE TABLE wp_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) NOT NULL default '', slug varchar(200) NOT NULL default '', term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), KEY slug (slug(191)), KEY name (name(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

———-First browser window error message end———-
- This topic was modified 3 months, 1 week ago by James Huff. Reason: moved to Localhost Installs since this is a localhost install

Viewing 4 replies - 1 through 4 (of 4 total)

fahimmurshed
(@fahimmurshed)

3 months, 1 week ago

Would you please use LocalWP instead of the XAMP/MAMP development tools?

You can check this article: https://wpengine.com/resources/local-wordpress-development-environment-how-to/.

Let me know if you are still facing the problem.

Thread Starter Lars.Lemming
(@larslemming)

3 months, 1 week ago

Hi fahimmurshed, and thank you for your reply – unfortunately switching to LocalWP did not seem to help a lot.

I have tried to use LocalWP in the past, and also been working on the website that I have huge issues with in that environment, but where the site that I am working on in XAMPP (and I have been spending 4 days on it since I changed back from LocalWP to XAMPP) comes up as: “http://localhost/crowdtracking/wp-admin/”,

The “old” site In LocalWP comes up as: “http://localhost:10004/wp-admin/?localwp_auto_login=4”

What I ideally would want is to retrieve the “http://localhost/crowdtracking/wp-admin/” site, and whether this is then worked on in XAMPP or LocalWP does not really matter that much until after I have uploaded it, and once I have done so, I will naturally be making a back-up which I can load in either LocalWP or XAMPP (or any other environment)!

However, even finding out where LocalWP is storing my site (presumably called “10004”) is a challange – I have tried to go through all folders under “C:\Users\LarsLemming\AppData\Local\Programs\Local”, but there is no folder called “10004”, and that is the same when I look in “C:\xampp\”!

If I could find the folder which stores the 10004 folder and I could copy the content of the content of “C:\xampp\htdocs\CrowdTracking” to this folder, at the same time running an export of the MySQL database for CrowdTracking and then delete the tables of the 10004 database and import all the tables of the CrowdTracking database to the 10004 database, then I would presume that I would get my latest version of the website back – but then again, I am not a developer or a coder, I am just a person who build websites as a hobby!

Your advice – including any other things that may work – will be very much appreciated, I even invite you to contact me direct on lars_lemming followed by the sign for “to” and my email host (which is hotmail.com).

If you do that and if you believe that you have a solution to my issues, perhaps we could set up a TeamViewer session, where you could show me what to do on my computer (in spite of being 62 years old, one of the main reasons I have for getting up in the morning is to learn something new)!

Thanking you in advance, I remain,

Yours sincerely

Lars Lemming

Thread Starter Lars.Lemming
(@larslemming)

3 months, 1 week ago

I have now found the folder containing the LocalWP version of the website, on my computer it is located in C:\Users\LarsLemming\Local Sites\crowdtracking.

So now the question is, what happens if I “dunp” a copy of my latest version of WP-Content?

I think I will zip the “C:\Users\LarsLemming\Local Sites\crowdtracking\app\public\wp-content” file and try to replace it the XAMPP equivalent to see what happens (as the LocalWP instance presumably also use the CrowdTracking MySQL database in my PhPMyAdmin!

I will let you know what happens once I have done so, but right now something which is way more important just came in the door – my grandchildren 😉 – so it may take a couple of hours before I have tried that!

/Lars

fahimmurshed
(@fahimmurshed)

3 months, 1 week ago

For updating the WordPress core files, please read this https://wordpress.org/documentation/article/updating-wordpress/#manual-update

Viewing 4 replies - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

Views