New User Help

Developers Programming
#1

Hey all, just started using SC5 and it seems really good. However I am having a few issues with it and unfortunately I have to say that SC email support is less than stellar with response times, so I am asking here as well. I am using the included tickets system as a learning tool. It uses sqlite as a default and I am trying to figure out how to convert it to use mysql. I emailed support and asked them and Vitors only answer was
Hi,

You should access the Project Home and edit the connection of the project changing it to MySQL.

Best Regards,

V?tor Jamil
Netmake - Support Team

Well, that doesn’t work. I did that, regenerated the code, created zip and deployed. First time I run it says the db connection isnt set correctly and I log into the back end manager to update it, although I did set it to use mysql in the app. I select mysql, enter host and username for the server, select the db which i created, and click test, which passes. I then logout of the back end, and run again. This time I get the normal login screen, except the dialog pops up saying authentication failed (although authentication is misspelled). I look at the db and no tables have been created. I have asked support specifically what needs to be done to convert this to use mysql. I asked does it create the DB for you? I found out it does not. I asked them if it doesn’t, if I create the DB will it create the schema and populate the tables? I found out it does not. Again, the big issue I have here is support (or the lack of) not answering questions for days at a time. I like the program and it is not exactly inexpensive so I would expect better service from them. Can anyone here in the forums help me with these questions? Also, there seem to be parts of the dev environ that are still showing up in spanish, despite every setting I can find being set to english. Not a big deal.
It says it supports calling COM objects. Are there any examples of this? Are the com objects, properties, etc. accessible from the dev environ? It would be nice if the manual was cleaned up (some stuff doesn’t seem to have translated too well) and available as a PDF. TIA to all for their help.

Kevin

#2

Re: New User Help

Kevin,

Sorry that you are having all these problems. Most are as you mention, based on what you are expecting vs what will happen.

Netmake does show up every once is a while, but it is mostly P2P support. You can purchase a support plan if you want. Contact sales for details.

You should be able to edit the connection, or add a new connection and delete the old. You will find Vitor very helpful if you keep asking.

For the DB, you will have to create the DB, Tables and populate yourself. You could always create a script in your app to do this for you if you want it automated, or if you are just needing the data for testing use PHPmyAdmin or mysqldump to create the data. I am not sure of your server access (shared/dedicated), so I am making suggestions.

Everyone here agrees the help files … need help. Hopefully it will be updated soon.

Please report the misspelled words and language issues to bugs@netmake.com.br

I do believe the COM support will have to be supported using PHP code and not directly with the SC5 IDE. I have not tried this myself, so I could be incorrect on this. I will take a look.

Contact sales/support about the help file. The more people we get to asking about improved help, the better chance we have.

I have used several PHP generators, and I ended up with SC5. There is a curve, but it has a lot of power if you give it a chance.

If you have any more questions, please provide the specific details and I sure someone here can help.

Regards,
Scott.

#3

Re: New User Help

Thanks for the information Scott. I figured if the DB schema had already been created in SQLite and was part of the program that it should create a new db if it doesnt exist on the prod server. Not a big deal I guess but if the app is already created (like the sample apps) and use a db then where is the ddl/schema to be able to recreate it on another machine? Also, since this was just purchased it says I get 60 days support already so I shouldn’t need a support contract yet. :wink: Thanks again for your help and I’ll keep plugging away and see how I make ut.

Kevin

#4

Re: New User Help

Please (and I will as well) make a request for this, to auto-create a schema if it does not exist. That would be a helpful feature for installing apps on new servers.

Perhaps an option to create the schema on the built-in deploy wizard.

Regards,
Scott.