phpMyAdmin is down after a bios update of my laptop

Wappler General
1

Hey guys,

Probably this is not a Wappler related problem but I am new to web apps in general if anybody has an idea of where to start so I can recover my databases and my projects…

win 10,
php 7.4.33

I forgot my DELL laptop open last night and when i woke up this morning I saw a bios update was running…
So, when it finished and my laptop restarted I saw that phpMyAdmin error:

Screenshot_1
Screenshot_1997×132 7.76 KB

Translation:
phpmyadmin - Error
The mysqli extension is missing

The project (a sample for manipulating array fields inside data store component) that I was working last night it was open in my browser and working as it should:
addressed at: http://localhost/datastore_test/index

Now at this address there are no data from database:

Screenshot_2
Screenshot_21147×784 21.6 KB

But When I fire up the page from within wappler

Screenshot_3
Screenshot_3755×445 32.3 KB

I get my data but and a warning at the top of the page:

Screenshot_4
Screenshot_41911×1044 373 KB

Warning : Undefined array key “query” in C:\Users\gtrez\AppData\Local\Wappler\resources\app\Shared\DMXzone\dmxAppCreator\UI\lib\htaccess_router.php on line 34

Deprecated : parse_str(): Passing null to parameter #1 ($string) of type string is deprecated in C:\Users\gtrez\AppData\Local\Wappler\resources\app\Shared\DMXzone\dmxAppCreator\UI\lib\htaccess_router.php on line 34

Then I took a look on my main project that was working on 1 week ago (and it is not finished…) and on every page I go I get this output:

Screenshot_5
Screenshot_51140×374 27.2 KB

{
"code": 0,
"file": "C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\lib\\db\\Connection.php",
"line": 87,
"message": "Undefined class constant 'MYSQL_ATTR_INIT_COMMAND'",
"trace": "#0 C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\modules\\dbconnector.php(12): lib\\db\\Connection->__construct()\n#1 C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\lib\\App.php(206): modules\\dbconnector->connect()\n#2 C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\lib\\App.php(146): lib\\App->execSteps()\n#3 C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\lib\\App.php(172): lib\\App->exec()\n#4 C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\lib\\App.php(178): lib\\App->execSteps()\n#5 C:\\xampp\\htdocs\\stock\\stock\\dmxConnectLib\\lib\\App.php(146): lib\\App->execSteps()\n#6 C:\\xampp\\htdocs\\stock\\stock\\adm_products.php(19): lib\\App->exec()\n#7 {main}"
}

If anybody has an idea on how to resolve my situation it will be much appreciated.
:disappointed:

2

If it is the mysqli extension, then create a php page with the following code, no HTML code.

<?php
phpinfo();
?>

Look for the Loaded Configuration File to find the location of your php.ini file.

Open the php.ini file and find the line that reads ;extension=mysqli. Remove the semicolon (;) at he the beginning of the line. Save the file and restart the server.

1 Like
3

Let me check @ben…
Thanks for your quick reply brother

4

image
image1446×1043 45.1 KB

The second one must be the one I am interested in… But there is no semicolon in front of it

5

Temporarily rename .htaccess to ._htaccess and see what happens.

6

I am sorry but where is that file located?

7

Not sure what server are you using, bust most probably PHP PDO is missing/not isntalled/not enabled.

8

I am talking about LOCAL dev only… No server

9

Well, locally you are running some server, obviously. What server are you using?

10

image
image834×537 133 KB

11

Are you sure your XAMPP server is running at all?

12

I suppose it is, at least until yesterday night it was working fine . Now I stopped in case I change something…

13

The issue is with your XAMPP either something is not running correctly or it got corrupted. Maybe just reinstall your XAMPP.

14

OK I will try it later brother. Thanks for your help.

Should I care about the databases? They will be lost?

15

databases will be lost probably on reinstall. Maybe backup them.

16

As a matter of fact I just remembered that I have forgotten XAMPP open & running yesterday night while my laptop bios updated…
THIS MUST BE THE PROBLEM, THANK YOU

  • By the way, how can I back up my local databases? And after the XAMPP reinstall and database s restore will wappler identify them normally?

I apologize to you and all the community for asking this kind of questions. I am just new to this area but willing to learn

17

There’s a mysql folder inside the xampp directory with the sql files.
Xampp also has a log button wich points you to a txt file.
Maybe you can see wich errors you may have that attempts to stop apache

1 Like
18

Thanks Francisco, yes i clicked the log button and there is a list but I don’t understand…
I will have to search in google for this and see what I can do.
Thanks again

19

I finally resolved it… It was a nightmare for me!

Following are some useful links that I followed just in case that somebody has the same problem:

https://community.apachefriends.org/viewtopic.php?p=175337

How to Restore Old MySQL Database to New XAMPP Installation [Tutorial] - YouTube

Apache Friends Support Forum • View topic - MySQL Error

Thank you all guys

1 Like