During exploration of Developers Demo (Version available since V4.2 is almost being published) there is a problem with PHPMyAdmin.
I can NOT export or import any kind of file in PHPMyAdmin.
I tried with IE7 and Firefox latest Version. The following message is produced as soon as I click IMPORT or EXPORT -> Browse for file on local computer:
MySQLi is not installed also Error 500… etc or sort-like message, but at this moment I get even more confusing messages so I could not confirm. Possible I tried during reset of the Dev Demo.
I tried both Browsers on two different IP addresses but no solution for import or export. Strange behaviour since others like USER: fsgl, can do import and Export of SQL-file without problems.
Please Advise, TNX (don’t know if it is the right forum but in Developers Forum I did not find/get a solution)
The MySQLi extension is not installed by default on older PHP 5.2.x based servers. It seems that the new version of PhpMyAdmin (which is already out of date BTW) that is part of the 4.1.2 package requires it. PHP 5.3 and newer have mysqli enabled by default, but since the demo servers are running 5.2 they will require additional configuration to enable those features in PHPMyAdmin.
I just exported entire database on the 4.1.2 devel demo. The “The mysqli extension is missing. Please check your PHP configuration.” is just a message (ie. I see it at bottom of the screen, but export/import is still working).
Guessing this is the issue in phpmyadmin in script libraries/plugins/import/ImportOds.class.php :
/**
We need way to disable external XML entities processing.
*/
if (!function_exists(‘libxml_disable_entity_loader’)) {
return;
}
The libxml_disable_entity_loader() function only exists in php 5.2.11 and greater. Note the development demos are on what is almost considered legacy php versions (5.2.4), so they do not have that function which will cause it to return without ever initializing the ImportOds class below it. I am only guessing here, though.
Just another reminder how outdated the development demos are which are barely hanging on by a thread; note they are using Mandriva 2008 and only a matter of time before they completely flatline.
Tnx for the answers. Now what can I do to test OpenEMR Dev. Demo version online? Only test what is available or is there any body who can make a change so Import and Export will be available in due time?
Now I understand that I could make a Local working copy of Dev. Demo, but that is beyond my scope of expertise. Even if it is easy to implement I don’t like to use my computer as such.
Export is working indeed (Sorry for the work I might have caused.)
Import just give the error message and nothing can be done to do an Import like fsgl did with the Comprehensive Eye form.
Please heed this advisory and don’t import into your machine’s copy of OpenEMR:
“WARNING: This will overwrite configuration information with data from the uploaded file! Use this feature only with newly installed sites, otherwise you will destroy references to/from existing data.”
Are you able to install a copy on backup media and try importing there? It’s slower on a flash drive but it’s better than wiping out all your Lists and Layouts on C-drive.
If the problem is out of date versions of Php, why is it possible to import and export in the 4.1.1 Demo, albeit erratically, which I would guess; is even older and without the MySqli extension? I could not find the version of Php in 4.1.1.
The demos actually all use the same PHP version, as they are all based on the same virtual appliance. (Brady, correct me if I’m wrong, this statement is mostly conjecture.)
The difference is that 4.1.2 has a newer version of PhpMyAdmin than 4.1.1, and that newer version of PhpMyAdmin is what is complaining about MySQLi not being installed.
In otherwords, the 2.x version of PHPMyAdmin that’s part of 4.1.1 works fine without MySQLi, but the 4.x version of PHPMyAdmin that’s part of 4.1.2 and 4.1.3 would prefer to have it.
phpMyAdmin on “local”-version 4.1.2 (…localhost/…) works smooth with all kind of new tricks. For DELETE, Upload etc.
Since the new install on “Demo”-Version (OpenEMR-org) phpMyAdmin it is not possible to upload files through import. Changes can be made only within the OpenEMR program Server-Administration. During an earlier discussion on this topic it was decided that php needs some fine tuning for the Demo versions and this can only be done by the SUPER-Gurus, with the correct permissions for higher level corrections.
If you are still hankering to import those files, I would suggest that you download a second copy of 4.1.2, which comes with Php 5.4.16. You should be able to import to your heart’s content. This is the Über-Geek work-around for us mere mortals.
I used a second copy of XAMPP-OpenEMR on my desktop to work out the bugs in the .sql files before Henry Alvarez was able to import.
Using a second copy will prevent messing up the working one.
Now you can find out if NationNotes would permit commentaries in addition to image embedding. I don’t think so. Two NationNotes are paired in 2 of the Eye forms and one can be used for commentary. You can decide for yourself.
I hope the sun will shine more brightly in Curaçao after you have dispatched this little task.
That’s the reason why I knew the phpMyAdmin with version 4.1.2 does work on my Local-V4.1.2-patch1. Tnx anyway for your efforts to make the sun shine even more. With 28 to 32 degrees average, few clouds, I/We are supposed to stay out of the sun for prevention of our cataracts and melanomas… Doctors have to find other ways to secure an income ;-))
Here’s the fix. Could always make those changes to the OpenEMR codebase and see what happens (I am wondering if the import just gets skipped though rather than showing the error; ie. It may not work anyways):
)