Setting up Miva Mia with Miva Merchant v4.14-v5.0

[mgobeil]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

Ok, have you installed MySQL on your windows pc? Have you installed the MySQL connector library for Mia? Have you modified your merchdb.dat to point to the local MySQL database if you've set one up?

yes i installed mysql

No i did not install connector libary or modified merchant.dat
but now that i know i will look into that can you provide some detail on that

[Jim McCormick]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

merchdb.dat.

It's inside your data directory and you can open it with notepad or any text editor.

You can get the connector library here:

https://support.smallbusiness.miva.com/supportsuite/index.php?_m=downloads&_a=viewdownload&downloaditemid=33&nav=0,3

Place the library inside of Mia's DATABASES directory. By default it's located in c:\Program Files\Miva\Miva Mia. You'll also have to open Mia and click on Libraries. You should already have an entry for MySQL so just edit that entry and browse to the DATABASES folder and select the proper library.

Let me know if you have any problems or questions about this.

[mgobeil]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

OK here is where i am now

Runtime error in lib/db.mvc @ [000000e1:0000002a]: lib/dbprim/domain.mv: Line 179: MvOPENVIEW: mysql_stmt_bind_results: Using unsupported buffer type: 253 (parameter: 1) Runtime error in lib/db.mvc @ [000000e1:00000058]: lib/dbprim/domain.mv: Line 183: MvDO: Unable to open '': The system cannot find the path specified.

[Jim McCormick]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

Runtime error in lib/db.mvc @ [000000e1:0000002a]: lib/dbprim/domain.mv: Line 179: MvOPENVIEW: mysql_stmt_bind_results: Using unsupported buffer type: 253 (parameter: 1)

I've only seen that error when there is a mismatch between the connector library and the MySQL version. What version of MySQL do you have installed and what version of the connector library did you install?

[Leanne]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

I get this same error message. I just gave up on running Mia with MySQL. Here's my info, if that helps:

Connector: MVDMYSQL5.DLL Version 5.0.0.1
MySQL 5.0.21

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

Hello Jim, I have been attempting to utilize MIA to update our MySQL 5.5 store. I have followed your thread and believe I have it set up correctly. I have WAMP server running my local MySQL DBs.

Mysql version 5.1.32
MIA Library version 5.0.0.1

URL and Error -

http://127.0.0.1:8000/mm5/admin.mvc

[IMG]file:///C:/DOCUME%7E1/JEREMY%7E1.AWN/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG]Fatal Error
Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error:

Error Code: MER-ADM-00003 Description: Miva Merchant has not been initialized. Please use the MIVA Merchant Setup script to initialize the required data files.

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

Here is the path to my DATA files - C:\MIVAMia\DATA\private\mivadata\Merchant5

[Jim McCormick]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

I'm not sure what connector library you're using but you should be using the v2.016 library located here:

https://support.smallbusiness.miva.com/supportsuite/index.php?_m=downloads&_a=downloadfile&downloaditemid=33

Have you modified your merchdb.dat to point to the local database?

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

Here is the information on those two items:

merchdb.dat - mysql|fabrics_mm5@localhost|UN|PS|

C:\MIVAMia\DATABASES\mysql-2.016\Win32\MVDMYSQL5.dll

[Jim McCormick]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

C:\MIVAMia\DATA\private\mivadata\Merchant5

That path looks wrong. You need to change that to C:\MIVAMia\DATA\private\mivadata\

You do not need to include the /Merchant5/ in the path.

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

I just changed path and still get the same error. I have been trying all different types of paths to get to my data files including that same one. Believe me I have tried a lot before contacting you for help.

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

What else could be keeping the data b locked or hidden?

[Jim McCormick]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

What else could be keeping the data b locked or hidden?

Make sure your configured IUSR in IIS has enough rights to access the VM files. I usually just give the IUSR 'Modify' rights to the entire
/Program Files/Miva/Miva Empresa folder.

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

Do you need any more information from me to trouble shoot my mia setup?

[Ecentral]

Re: Setting up Miva Mia with Miva Merchant v4.14-v5.0

maybe thats the problem I don't have - /Program Files/Miva/Miva Empresa folder.

Did MIA not install properly?