MivaSQL to MySQL converter for MM5

[Nerd Boy Inc]

Re: MivaSQL to MySQL converter for MM5

Dear David,

As far as I can tell all is right other than not seeing this file. The site is up and running and was upgraded to the latest stream last night.

I just sent you a PM as well.

[MatMcN]

Re: MivaSQL to MySQL converter for MM5

I am getting the following error when trying to convert a mivaSQL to mySQL; I have completely removed the cbs shipping supermod, cleaned the store; packed the data and I am still seeing this error. Can anyone help me?

Opening mivasql... OK.
Opening mysql... OK.
Opening raw database OK.
Reading mivasql tables and converting...
Table: AdminSessions = File: adminsessions.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... OK.
Selecting and inserting... OK.
Creating indexes...
- Create Index: AdminSessions_1:adminsessions/1.mvx:session_id:remoteaddr:4 OK.
OK.
Table: cbs_cbslic = File: cbs/cbslic.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... Runtime error in mivasql2mysql.mvc @ [00000000:000009c2]: mivasql2mysql.mv: Line 221: MvQUERY: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').
OOPS, BAILING!: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').

[CybrHost]

Re: MivaSQL to MySQL converter for MM5

The script is "OOPS, BAILING!:" on the following datafile.

Table: EBusi_EBusilic = File: ebusi/ebusilic.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... Runtime error in mivasql2mysql.mvc @ [00000000:000009c2]: mivasql2mysql.mv: Line 221: MvQUERY: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').
OOPS, BAILING!: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').



Did anyone see this before?




--
Thank you,
Gary Hodder
Support
--
CybrHost Corp. - http://www.cybrhost.com/ - [email protected]
+1-866-300-MIVA - Professional Miva & E-Commerce web hosting services.

[Laura Schindler]

Re: MivaSQL to MySQL converter for MM5

I'm getting the same error, but referencing a different module:

Table: MivaCentral_ID_PCINET = File: mivacentral/id/pcinet.dbf
* Opening database... OK.
* Fields... OK.
* Generating SQL... OK.
* Creating table... Runtime error in mivasql2mysql.mvc @ [00000000:000009c2]: mivasql2mysql.mv: Line 221: MvQUERY: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').
OOPS, BAILING!: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').


I'm going to try to contact James offlist. I'll post here when I hear from him.

[swampthang]

Re: MivaSQL to MySQL converter for MM5

I have need to convert from mivaSQL to mySQL on my windows server 2003 box. I just off the phone with support and they're saying that their tool doesn't work on a windows server. I thought I had seen somewhere that someone had been succesful with this. If someone can help me with this today I'll pay for it today. I have direct access to the box and do have mySQL 4.1 installed and working on port 3316. mySQL 5 is default on the server and is on 3306. Please reply as soon as possible. Thanks.

[Jim McCormick]

Re: MivaSQL to MySQL converter for MM5

Hello,

I updated the mivasql2mysql converter back in April but neglected to post anything letting you guys know. The latest version should get you around the errors in this thread. Please post something if you run into problems. Thank you.

[chucklasker-BANNNED]

Re: MivaSQL to MySQL converter for MM5

Jim,

The link below to the "tool" is broken:

http://extranet.miva.com/forums/showthread.php?t=11078

Can you post here the instructions in full, please?

[Hostasaurus]

Re: MivaSQL to MySQL converter for MM5

The file download in the KB says it was updated April 2009, but the files within the zip are from August 2007 and the file size of the mivasql2mysql.mv file is the same as the original one?

https://support.mivamerchant.com/sup...nloaditemid=51


Jen

[Jim McCormick]

Re: MivaSQL to MySQL converter for MM5

Jen,

I'll fix the one on the support suite. I uploaded it on the first post in April.

http://extranet.mivamerchant.com/for...26&postcount=1

[Jim McCormick]

Re: MivaSQL to MySQL converter for MM5

Ok, just to be safe I updated the converter in both places.

[chucklasker-BANNNED]

Re: MivaSQL to MySQL converter for MM5

From the instructions, it looks like only a host can do it, or someone with back end server access, right?

[ILoveHostasaurus]

Re: MivaSQL to MySQL converter for MM5

It's a lot easier to have the host do it but it isn't required, you basically create a database, compile the script with the db info, run it on the site, if successful, adjust the merchdb.dat file to include the mysql settings instead of dbase settings.

[precision]

Re: MivaSQL to MySQL converter for MM5

Ok,
I'm stumped.... I'm trying to run the mivasql2mysql converter... I changed the configuration to use my local database, user, and password. compiled and executed the script and got the "OOPS BAILING cannot open mydatabase@localhost....

What I can't figure out is how I can log into mysql through the command line and connect to the database without any issues, but I cannot open the database when trying to run the conversion.

Any ideas?
Thanks

[Jim McCormick]

Re: MivaSQL to MySQL converter for MM5

As an FYI, the conversion tool has been updated in this thread's initial post. We also have it available in our downloads section of our support suite.

https://support.mivamerchant.com/sup...temid=51&nav=0

NO COMPILER NEEDED!

[Jim McCormick]

Re: MivaSQL to MySQL converter for MM5

Ok,
I'm stumped.... I'm trying to run the mivasql2mysql converter... I changed the configuration to use my local database, user, and password. compiled and executed the script and got the "OOPS BAILING cannot open mydatabase@localhost....

What I can't figure out is how I can log into mysql through the command line and connect to the database without any issues, but I cannot open the database when trying to run the conversion.

Any ideas?
Thanks

Does your MySQL user have ALL privileges granted to it? Have you tried using the latest conversion tool? What version of the MySQL connector do you have installed?