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

[CB_DESIGNER]

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

I created a database in MySQL to match the name of the db in the merchdb.dat file, and granted access to the user listed in that file as well.
I don't see MySQL.DLL in my C:\MIVAMia\DATABASES folder (or anywhere else in these files). Where can I download this driver? Do I only need to put it into that folder?
(The version number came from the Release Note. I see the 5.06 number referenced for Miva Empresa in that doc.)

[Jim McCormick]

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

I created a database in MySQL to match the name of the db in the merchdb.dat file, and granted access to the user listed in that file as well.
I don't see MySQL.DLL in my C:\MIVAMia\DATABASES folder (or anywhere else in these files). Where can I download this driver? Do I only need to put it into that folder?
(The version number came from the Release Note. I see the 5.06 number referenced for Miva Empresa in that doc.)

Make sure the password in the merchdb.dat matches the user's password as well. It should look like this:

mysql|[email protected]|database_user|user_p assword|

I just emailed you the latest MySQL connector library.

[CB_DESIGNER]

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

I have added the .dll file as directed (...open Mia, click on Libraries and then highlight the MySQL line ... Once it's highlighted click on Update and then browse to the .DLL.)

Checked that the merchdb.dat file has the [email protected] and that the password matches the MySQL password. Trying to access the admin using 127.0.0.1/Merchant2/admin.mvc still yields the 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. Not sure what to do next.

Also, I had Hostasaurus provide me with a dump file of the data from the MySQL db for use with the local version.

[Jim McCormick]

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

I have added the .dll file as directed (...open Mia, click on Libraries and then highlight the MySQL line ... Once it's highlighted click on Update and then browse to the .DLL.)

Checked that the merchdb.dat file has the [email protected] and that the password matches the MySQL password. Trying to access the admin using 127.0.0.1/Merchant2/admin.mvc still yields the 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. Not sure what to do next.

Also, I had Hostasaurus provide me with a dump file of the data from the MySQL db for use with the local version.

Miva Merchant is not connecting to the database. Double check the usernames/passwords and be sure that the database user you're using has ALL privileges granted to it.

[CB_DESIGNER]

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

After some effort to resolve the MySQL connection and password for Miva Mia, I managed to create the tables using the dump file. I connected to the admin without problems. The products and pages look correct in the Miva interface.
I tried to connect to the home page. Using 'Show Home Page' from the Miva Mia taskbar icon opened the 'Welcome to Miva Mia' home page. Using http://127.0.0.1/Merchant2/merchant.mvc?Screen=SFNT as the address I get the following error message, "
Runtime error in lib/db.mvc @ [0000009b:0000005c]: lib/dbprim/baskets.mv: Line 66: MvQUERY: mysql_execute: Incorrect integer value: '' for column 'cust_id' at row 1 " with the Fatal Error page showing Error Code "MER-DBP-BSK-00001".
I think we're close, but not quite there. Any help would be appreciated.

[Jim McCormick]

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

After some effort to resolve the MySQL connection and password for Miva Mia, I managed to create the tables using the dump file. I connected to the admin without problems. The products and pages look correct in the Miva interface.
I tried to connect to the home page. Using 'Show Home Page' from the Miva Mia taskbar icon opened the 'Welcome to Miva Mia' home page. Using http://127.0.0.1/Merchant2/merchant.mvc?Screen=SFNT as the address I get the following error message, "
Runtime error in lib/db.mvc @ [0000009b:0000005c]: lib/dbprim/baskets.mv: Line 66: MvQUERY: mysql_execute: Incorrect integer value: '' for column 'cust_id' at row 1 " with the Fatal Error page showing Error Code "MER-DBP-BSK-00001".
I think we're close, but not quite there. Any help would be appreciated.

Can you compare the local database and the live one? I'm not so sure it imported correctly.

[CB_DESIGNER]

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

I'm not sure that I can compare the two. I don't have ready access to the live db (using PHPMyAdmin, for example), which is why I had Hostasaurus prepare the dump file for me. And I have not installed PHPMyAdmin locally, so I have been using command line with MySQL. Is there anything I can look for in the dump file?

[Jim McCormick]

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

I'm not sure that I can compare the two. I don't have ready access to the live db (using PHPMyAdmin, for example), which is why I had Hostasaurus prepare the dump file for me. And I have not installed PHPMyAdmin locally, so I have been using command line with MySQL. Is there anything I can look for in the dump file?

You should look into using MySQL Administrator.

http://dev.mysql.com/downloads/gui-tools/5.0.html

I'm also wondering why you don't have access to the live database. I've never worked with a Hostasaurus client that didn't have access to it's database.

[CB_DESIGNER]

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

I ran a SHOW tables command and output to an external file to review the list of tables. There are 139 tables, many of which begin with 's01_'. (Does this help?)

[Jim McCormick]

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

I ran a SHOW tables command and output to an external file to review the list of tables. There are 139 tables, many of which begin with 's01_'. (Does this help?)

Well it tells me you have 139 tables in the local database. What about the user's privileges? Are you sure you're not missing any of the script (mm5) files?

[CB_DESIGNER]

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

I copied the directory of files and folders from the host. Everything in the 'httpdocs' folder was copied to the MivaMia/HTML folder; the files in the 'private' folder were copied to MivaMia/DATA. Where would the mm5 files be on the host server?
Also, I am currently trying to gain access to the database on the host server to compare.

[CB_DESIGNER]

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

I have reviewed the listing of tables on the server and the 139 tables seem to be the same. Any idea which table might have had the 'cust_id' field from the error message?

[CB_DESIGNER]

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

Still cannot get any pages beyond the Miva Mia admin to load on my local computer.
Noticed, however, that when I log in after using the url
http://127.0.0.1/Merchant2/admin.mvc
the url changes to
http://myWorkstation/Merchant2/admin.mvc?Session_ID=...
where myWorkstation is the computer name on which all my Miva Mia files are loaded.
Could this have anything to do with the problems I am having?

[Jim McCormick]

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

Still cannot get any pages beyond the Miva Mia admin to load on my local computer.
Noticed, however, that when I log in after using the url
http://127.0.0.1/Merchant2/admin.mvc
the url changes to
http://myWorkstation/Merchant2/admin.mvc?Session_ID=...
where myWorkstation is the computer name on which all my Miva Mia files are loaded.
Could this have anything to do with the problems I am having?

The URL change is fine as long as the Site Configuration matches. Expand Global Settings, click on Domain Settings and then on Site Configuration.

[CB_DESIGNER]

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

I reset all references in Domain Settings to match the workstation name. Using http://myWorkstation/Merchant2/merchant.mvc?Screen=SFNT still produces a Fatal Error page with "Runtime error in lib/db.mvc @ [0000009b:0000005c]: lib/dbprim/baskets.mv: Line 66: MvQUERY: mysql_execute: Incorrect integer value: '' for column 'cust_id' at row 1" at the top of the page and "Error Code: MER-DBP-BSK-00001" (along with the description) on the page.