Standalone will not run [Solved]

This is the place to post technical queries about SQL Yoga

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, trevordevore

Standalone will not run [Solved]

Postby nrprioleau » Wed Aug 17, 2016 10:20 am

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:
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Postby trevordevore » Wed Aug 17, 2016 1:13 pm

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.
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 839
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas

Re: Standalone will not run

Postby nrprioleau » Wed Aug 17, 2016 1:47 pm

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.
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Postby trevordevore » Wed Aug 17, 2016 1:53 pm

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.
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 839
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas

Re: Standalone will not run

Postby nrprioleau » Wed Aug 17, 2016 2:23 pm

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
Attachments
Inclusion.png
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Postby trevordevore » Wed Aug 17, 2016 2:29 pm

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
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 839
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas

Re: Standalone will not run

Postby nrprioleau » Wed Aug 17, 2016 3:31 pm

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"
Attachments
Screen Shot 2016-08-17 at 16.30.10.png
Screen Shot 2016-08-17 at 16.29.53.png
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Postby trevordevore » Wed Aug 17, 2016 5:06 pm

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?
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 839
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas

Re: Standalone will not run

Postby nrprioleau » Thu Aug 18, 2016 11:27 am

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.
Attachments
Screen Shot 2016-08-18 at 12.24.24.png
Screen Shot 2016-08-18 at 12.24.14.png
Screen Shot 2016-08-18 at 12.24.03.png
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Postby nrprioleau » Mon Aug 22, 2016 2:44 pm

Hi Trevor,

Have you had anymore thoughts on this quandary?

Cheers
Nic
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run ** FIXED **

Postby nrprioleau » Thu Aug 25, 2016 9:37 am

I don't know why exactly but I removed the revDB external package in the standalone settings and the app is now running!
nrprioleau
 
Posts: 24
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run [Solved]

Postby trevordevore » Fri Aug 26, 2016 5:44 am

I'm glad you got it working. I was out of ideas.

(Sorry for the delay in responding, I've been traveling.)
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
 
Posts: 839
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas


Return to SQL Yoga

Who is online

Users browsing this forum: No registered users and 0 guests

cron