• Registered: 2014-02-14
  • Posts: 10,294

Topic: Alpha version 2.040b with support MySQL

Alpha version 2.040b with support MySQL


download:
http://myvisualdatabase.com/download/my … 2.040b.exe



download MySQL Community Server:
http://dev.mysql.com/downloads/mysql/



Video, how to install MySQL server:
http://myvisualdatabase.com/forum/viewt … p?pid=9770


how to enable MySQL
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=1339&download=0

Post's attachments

Attachment icon mvd_mysql.png 121.09 kb, 318 downloads since 2015-09-16 

Dmitry.
  • Registered: 2014-06-25
  • Posts: 863

Re: Alpha version 2.040b with support MySQL

Any other improvement with this version?   big_smile

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

Just MySQL.


All registered users with licenses 'Free Minor Updates" also can use this version without additional charge.

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: Alpha version 2.040b with support MySQL

I And My Student Thank You  Very Much ..
I Wait Long Time And Now : Happy Happy  And Happy
-------------------------------------------------------------------------

Happy

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-09-04
  • Posts: 98

Re: Alpha version 2.040b with support MySQL

Thanks so much!

  • Registered: 2014-02-17
  • Posts: 365

Re: Alpha version 2.040b with support MySQL

#(Auto Increment) not display in TableGrid
2015-09-17 Image 001

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2015-04-29
  • Posts: 43

Re: Alpha version 2.040b with support MySQL

thanks Mr.Dmitry.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

prahousefamily
Thank you for the help, found the bug and fixed.

Dmitry.
  • Registered: 2014-09-04
  • Posts: 98

Re: Alpha version 2.040b with support MySQL

I have a web server with mysql installed it is version 5.5.44 when I try to connect I get

2 errors

[Window Title]
Container fill log

[Content]
Exception raised with message: 
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 
'No, CONSTRAINT `Inspections_id_Locations` FOREIGN KEY(id_Locations) REFERENCES L' at line 1
[OK]

and

---------------------------
Application Error
---------------------------
Exception EMyError in module Container Fill Log.exe at 004F3C04.
#42S22Unknown column 'id' in 'field list'.
---------------------------
OK   
---------------------------

what version is mvd written for and is there a place to change it?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

timlitw

Minimum req. MySQL 5.0.3


Can you attach your project here?
And let me know steps for raise this error?



Thanks.

Dmitry.

11 Reply by timlitw (edited by timlitw 2015-09-17 15:52:23)

  • Registered: 2014-09-04
  • Posts: 98

Re: Alpha version 2.040b with support MySQL

here is the project, it is the project I've been working on for over a year.  I get the first error when I click to create the database if I make a new one or when I connect to the database if it is there already.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

timlitw
In your project not exists a file 'forms.xml', so I can't open the project.

Dmitry.

13 Reply by timlitw (edited by timlitw 2015-09-17 18:35:08)

  • Registered: 2014-09-04
  • Posts: 98

Re: Alpha version 2.040b with support MySQL

I'm sorry, I left out too many files.
Here it is again, with the forms.xml

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

timlitw wrote:

I'm sorry, I left out too many files.
Here it is again, with the forms.xml


It's bug, thank you for the help.


I just change default value for field: Inspections.printed from 'No' to 0
and made some changes in SQL query for 'Refresh' button.


fixed project attached:

Post's attachments

Attachment icon project_fixed.zip 1.99 mb, 618 downloads since 2015-09-17 

Dmitry.
  • Registered: 2014-02-17
  • Posts: 365

Re: Alpha version 2.040b with support MySQL

Format Date Time  , Date  No Display In Table Grid In  Fist Time Run Project
Fix By Alter table MySQL to text

001
http://s4.postimg.org/fdmx839x7/2015_09_21_Image_001.png

002
http://s3.postimg.org/dlzo3u6m9/2015_09_21_Image_002.png

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

prahousefamily
I can't see attached images.

Dmitry.

17 Reply by prahousefamily (edited by prahousefamily 2015-09-21 12:38:48)

  • Registered: 2014-02-17
  • Posts: 365

Re: Alpha version 2.040b with support MySQL

Format Date Time  , Date  No Display In Table Grid In  Fist Time Run Project
Fix By Alter table MySQL to text

prahousefamily
I can't see attached images.
Download
For Dmitry.zip

Post's attachments

Attachment icon For Dmitry.zip 112.44 kb, 573 downloads since 2015-09-21 

My Visual Database : I Love You
Easy For Beginner Student For Me
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

prahousefamily

Thank you for the help, fixed:
http://myvisualdatabase.com/download/my … b2.01a.exe



also you need to recreate database.

Dmitry.
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

reberkurdi80
This error not related with MySQL.
Please send me your project to support@drive-software.com
and describe steps for raise this error.

Dmitry.
  • Registered: 2014-09-06
  • Posts: 805

Re: Alpha version 2.040b with support MySQL

hi there,
I have installed the MySQL Community Server:, I have also an account of a cloud server so can download and upload my files.
I also understand that I must choose the Connnection MySql in the database.
To work the same database more than one user they must have the program in there own pc,
My question is if  there is a video to show as step by step the connection between my pC home and the cloud.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

v_pozidis
What kind of cloud server? What there is an operating system?

Dmitry.
  • Registered: 2014-09-06
  • Posts: 805

Re: Alpha version 2.040b with support MySQL

wrong expression, it is not a cloud but a server, but what operating system it has I don't know it


Can we use the google drive or pcoud to work with the Mysql and mvd ?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Alpha version 2.040b with support MySQL

v_pozidis
Definitely not. To use MySQL, you should use Windows or Linux OS server.

Dmitry.
  • Registered: 2014-09-04
  • Posts: 98

Re: Alpha version 2.040b with support MySQL

What is the recommended way to get my sqlite data from my project into the mysql database on my server?  I've connected MVD to the database and it created the table and I can add data thru my program, but I want all my old data too.

  • Registered: 2014-06-25
  • Posts: 863

Re: Alpha version 2.040b with support MySQL

I would recommend to export the data from your current project using SQLite Studio and import them into Mysql using MySQL tools.