MivaSQL and MySQL

[Rick Wilson]

Re: MivaSQL and MySQL

Yeah go to www.mivamerchant.com and then if you click on Partners -> Hosting, the default list is the Premier list. You should recognize everyone on that list since they're the same who post here in the forums.

Many many years ago that was a marketing list anyone could get on by paying a fee, but today it's an invite only list.

[lesliekirk]

Re: MivaSQL and MySQL

Yeah go to www.mivamerchant.com and then if you click on Partners -> Hosting, the default list is the Premier list. You should recognize everyone on that list since they're the same who post here in the forums.

Many many years ago that was a marketing list anyone could get on by paying a fee, but today it's an invite only list.

And that's how is should be.

[Midrangeman14]

Re: MivaSQL and MySQL

Holy Cow! I guess I really stirred the pot with this one! Thank you for everyone's input, looks like I will be switches hosts very very soon...

[Midrangeman14]

Re: MivaSQL and MySQL

Status Update...
Switched to Hosting 4 Less and couldn't be happier thus far.
You guys were right..the hosting company really makes a difference. Thanks for all of the input!!
-Kevin

[aeaccessories]

Re: MivaSQL and MySQL

Hi,

Thanks for the steps listed in the conversion. I ran the diagnostic (diag6.mvc) and it only showed MivaSQL on the list. However, in my hosting admin, I can see the MySQL and create a database. Do I need something else installed on the server?

I contacted my host (OLM) and they told me where to create the database and that they could install libraries, but they would not be able to change the database API and to contact Miva for assistance with migrating the database from MivaSQL to MySQL. I have had good response from OLM in the past, but not sure what part of it I should expect them to do.

I appreciate any insight on this.

Thanks,

Pete

www.aeaccessories.com

[ILoveHostasaurus]

Re: MivaSQL and MySQL

Creating the database is of course required, but yes, they'll need to adjust your miva engine configuration so it's showing mysql as available before you'd be able to do the conversion.

[aeaccessories]

Re: MivaSQL and MySQL

Thanks David,

OLM has the MySQL showing up on the diag6 now.

I created the files described in this thread (MySQL database, script, compiled executable), but I get the following error:

mivasql2mysql running...

• Opening mivasql... OK.
• Opening mysql... OOPS, BAILING!: Cannot open mysql:[email protected]

From the conversion script, all I need to replace is the following:

<MvASSIGN NAME = "g.mysql_database" VALUE = "database_name@serverIP">
<MvASSIGN NAME = "g.mysql_username" VALUE = "database_user">
<MvASSIGN NAME = "g.mysql_password" VALUE = "user_password">

For the database user I put the admin account name and for the server IP, I tried both my domain IP address and the server address but no luck.

Does anyone have any ideas where I may be going wrong?

I did not zero out the MivaVM/Empresa timeout, but I am not aware that I have that need here.

Thanks,

Pete

www.aeaccessories.com

[ILoveHostasaurus]

Re: MivaSQL and MySQL

OLM will need to tell you if the server your database is on is the same one as your site (ideally) or if not, what the remote server IP is. If it is on the same server, typically only "localhost" will work for the server name, or 127.0.0.1 for IP, not the site IP or primary server IP. The user & pass will be ones you created specific to your new mysql database that you created.

[Siamese-Dream.Com]

Re: MivaSQL and MySQL

Does anyone have any ideas where I may be going wrong?

Ummm... you are using OLM as your host?

All I am saying is that I use hostasaurus and I'm ALWAYS having David, Jen, and the other good people there do crazy things for me, and they always seem to get it done quickly and smoothly.

I'm just saying.

[aeaccessories]

Re: MivaSQL and MySQL

Thanks!

"localhost" did not work, but 127.0.0.1 did.

This got me though 123 steps, but I got the following error:

1. Table: s01_Products = File: s01/products.dbf
   • Opening database... OK.
   • Fields... OK.
   • Generating SQL... OK.
   • Creating table... CREATE TABLE s01_Products (id INTEGER,catcount INTEGER,agrpcount INTEGER,pgrpcount INTEGER,disp_order INTEGER,code VARCHAR(50),name VARCHAR(100),thumbnail VARCHAR(254),image VARCHAR(254),price DECIMAL(16,2),cost DECIMAL(16,2),descrip MEDIUMTEXT,weight DECIMAL(16,2),taxable TINYINT(1),active TINYINT(1),sku VARCHAR(50)) OK.
   • Selecting and inserting... Runtime error in mivasql2mysql.mvc @ [00000000:00000d1a]: C:UsersAEAccessoriesDocumentsmivasql2mysqlmivasql2 mysql.mv: Line 257: MvQUERY: mysql_execute: Got a packet bigger than 'max_allowed_packet' bytes
   
   OOPS, BAILING!: :INSERT INTO s01_Products SET id= ?, catcount= ?, agrpcount= ?, pgrpcount= ?, disp_order= ?, code= ?, name= ?, thumbnail= ?, image= ?, price= ?, cost= ?, descrip= ?, weight= ?, taxable= ?, active= ?, sku= ?

Is it time for me to give up and pay OLM to do it? Or are they going to run into the same issue? Is this something I need to fix in one or more of my product listings?

Thanks,

Pete

[aeaccessories]

Re: MivaSQL and MySQL

A little extra information:

I did open up the database and see that it put in 280 products of the 600+ products in the database. I'm just not sure how to figure out which one it's failing on.

- Pete

[ILoveHostasaurus]

Re: MivaSQL and MySQL

That's going to be a difficult one to get around; the insert statement it's failing on requires a large amount of data to be allowed in one query than the mysql server allows; controlled by the max_allowed_packet variable. By default I think max_allowed_packet is set to a couple megabytes and I've seen the miva export file require it be as much as 50 MB to successfully complete some imports. Changing that is done on the mysql server and requires a mysql server restart.

[aeaccessories]

Re: MivaSQL and MySQL

David, thank you for the response. OLM changed the max packet size for me and it took me all the way to the end.

I was able to use the site on mysql, but I had to try a few merchdb.dat tries (mysql|[email protected]|username|password|, worked, the others forms I have seen would not allow miva to initialize the database).

I tried using the site and it looked fine at first, but when I went to add something to the basket, I got the following error (note about that I used @127.0.0.1, not @localhost, as that would not allow anything in miva to work, so I am not sure why it is looking for localhost here)




Error Code: MER-DBA-MYS-00002 Description: mysql_real_query: Access denied for user '***myusername***'@'localhost' to database '***database_name***'
I do know that it did get added to the basket, by backing up and going directly to the basket. The other very strange thing I noticed is that I could proceed to the checkout and log in (to an existing account), but when I went to get past the screen that asked for shipping/credit card type, it would take me to the address screen (which should be populated since I am logged into an account) and say that the session has timed out - I would re-enter address info, but it would take me back to shipping/credit card type and loop from there.

Does anyone have any ideas? (I am able to jump back to mivasql without apparant issue.)

Thanks,

Pete

[ILoveHostasaurus]

Re: MivaSQL and MySQL

That's very odd, it should definitely not say @localhost if your merchdb.dat contained 127.0.0.1 at the time. I can't think of any reason that would occur.