Page 1 of 1

Standalone will not run [Solved]

Posted: Wed Aug 17, 2016 10:20 am
by nrprioleau
Good day,
I have written a rather large app which is based on glxApp framework and sql yoga. I have got to the point of creating my standalone and have followed the instructions on inclusions, etc but I get the following error when trying to run the standalone. I use mySQL database. The error clearly states "Invalid database type" but it definitely works in development mode. Can someone hint at a possible place to check for a solution.

Code: Select all

Software Version: 1.0.0d1
System: MacOS 10.11.0
Executing at 11:18:56 AM on Wednesday, August 17, 2016
----------
Type: Application 
Object: 
Line: 
Line No: 0
Hint: sqlyoga_connection_err,0,0,invalid database type
sqlyoga_connection_err,0,0,dbconn_connect (4572)
sqlyoga_connection_err,0,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/sql_yoga.rev"
sqlyoga_connection_err,100,0,glxapp_initializeApplication
sqlyoga_connection_err,100,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/application.dat"
sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/glxapp_framework.dat"
----------
Type: Application 
Object: 
Line: 
Line No: 0
Hint: sqlyoga_connection_err,0,0,dbconn_connect (4572)
sqlyoga_connection_err,0,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/sql_yoga.rev"
sqlyoga_connection_err,100,0,glxapp_initializeApplication
sqlyoga_connection_err,100,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/application.dat"
sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/glxapp_framework.dat"
----------
Type: Application 
Object: 
Line: 
Line No: 0
Hint: sqlyoga_connection_err,0,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/sql_yoga.rev"
sqlyoga_connection_err,100,0,glxapp_initializeApplication
sqlyoga_connection_err,100,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/application.dat"
sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/glxapp_framework.dat"
----------
Type: Application 
Object: 
Line: 
Line No: 100
Hint: sqlyoga_connection_err,100,0,glxapp_initializeApplication
sqlyoga_connection_err,100,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/application.dat"
sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/glxapp_framework.dat"
----------
Type: Application 
Object: 
Line: 
Line No: 100
Hint: sqlyoga_connection_err,100,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/application.dat"
sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/glxapp_framework.dat"
----------
Type: Application 
Object: 
Line: 
Line No: 1210
Hint: sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/Produfy Build Files/Produfy1/Produfy.app/Contents/MacOS/components/glxapp_framework.dat"
----------
Type: Application 
Object: 
Line: 
Line No: 
Hint: 

Comments: 

Re: Standalone will not run

Posted: Wed Aug 17, 2016 1:13 pm
by trevordevore
It would appear that the mySQL database driver is not being included in the standalone. Have you included the mySQL driver in the Standalone Builder? You would probably have to manually select it in the standalone builder interface. LiveCode won't automatically find it.

Re: Standalone will not run

Posted: Wed Aug 17, 2016 1:47 pm
by nrprioleau
trevordevore wrote:It would appear that the mySQL database driver is not being included in the standalone. Have you included the mySQL driver in the Standalone Builder? You would probably have to manually select it in the standalone builder interface. LiveCode won't automatically find it.
Hi Trevor, yes I have manually selected it and placed into the externals folder. My application script references that folder too.

Re: Standalone will not run

Posted: Wed Aug 17, 2016 1:53 pm
by trevordevore
Well, let's go everything point by point and see where something goes wrong. Can you provide the following?

1. Screenshot of the relevant standalone builder settings
2. Screenshot or write out the hierarchy of your application folders and files.
3. Include the relevant part of your script that references the database driver folder.

Re: Standalone will not run

Posted: Wed Aug 17, 2016 2:23 pm
by nrprioleau
Hi Trevor,

I've attached a screenshot of inclusions and referenced the externals as below... I've "forced" the folder path to where the externals are located but still not happy.

Code: Select all

on startUp
   put defaultFolder into DataFolderPath 
   put DataFolderPath & "/components/externals/" into myDLLfilePath 
   set the externals of this stack to myDLLfilePath
   pass startUp 
end startUp

Re: Standalone will not run

Posted: Wed Aug 17, 2016 2:29 pm
by trevordevore
Your startup code will not work. The externals property needs a path to the actual external files. In addition, you need to use revSetDatabaseDriverPath to tell LiveCode where to find the database drivers. The other thing to check is that DataFolderPath is the folder you think it should be.

Since you are using the GLX App Framework you could have the framework handle everything for you. Here are instructions on using database drivers with the framework:

http://revolution.screenstepslive.com/s ... -framework

Re: Standalone will not run

Posted: Wed Aug 17, 2016 3:31 pm
by nrprioleau
Hi Trevor,

Thanks for the instructions. I followed them diligently. Still getting this error of Invalid Database Type:

Code: Select all

Type: Application 
Object: 
Line: 
Line No: 0
Hint: sqlyoga_connection_err,0,0,invalid database type
sqlyoga_connection_err,0,0,dbconn_connect (4572)
sqlyoga_connection_err,0,0,stack "/Users/nrprioleau/Documents/MLTELite/components/sql_yoga.rev"
sqlyoga_connection_err,100,0,glxapp_initializeApplication
sqlyoga_connection_err,100,0,stack "/Users/nrprioleau/Documents/MLTELite/components/application.dat"
sqlyoga_connection_err,1210,0,glxapp_loadApplication
353,1210,0,stack "/Users/nrprioleau/Documents/MLTELite/components/glxapp_framework.dat"

Re: Standalone will not run

Posted: Wed Aug 17, 2016 5:06 pm
by trevordevore
The only thing we have confirmed yet is folder structure. What does the hierarchy of files and folders for your standalone app look like? Can you show a screenshot of all of the folders and their contents?

Re: Standalone will not run

Posted: Thu Aug 18, 2016 11:27 am
by nrprioleau
Hi Trevor,

I based my app on the To-Do application structure, the only difference being that I am using mysql not sqlite.
Folder screen shots attached.

Re: Standalone will not run

Posted: Mon Aug 22, 2016 2:44 pm
by nrprioleau
Hi Trevor,

Have you had anymore thoughts on this quandary?

Cheers
Nic

Re: Standalone will not run ** FIXED **

Posted: Thu Aug 25, 2016 9:37 am
by nrprioleau
I don't know why exactly but I removed the revDB external package in the standalone settings and the app is now running!

Re: Standalone will not run [Solved]

Posted: Fri Aug 26, 2016 5:44 am
by trevordevore
I'm glad you got it working. I was out of ideas.

(Sorry for the delay in responding, I've been traveling.)