Standalone will not run [Solved]

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

Post Reply
nrprioleau
Posts: 27
Joined: Mon May 09, 2016 10:53 am

Standalone will not run [Solved]

Post by 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: 

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Standalone will not run

Post by 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 - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

nrprioleau
Posts: 27
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Post by 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.

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Standalone will not run

Post by 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 - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

nrprioleau
Posts: 27
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Post by 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

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Standalone will not run

Post by 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 - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

nrprioleau
Posts: 27
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Post by 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

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Standalone will not run

Post by 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 - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

nrprioleau
Posts: 27
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Post by 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: 27
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run

Post by nrprioleau » Mon Aug 22, 2016 2:44 pm

Hi Trevor,

Have you had anymore thoughts on this quandary?

Cheers
Nic

nrprioleau
Posts: 27
Joined: Mon May 09, 2016 10:53 am

Re: Standalone will not run ** FIXED **

Post by 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!

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 1005
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Standalone will not run [Solved]

Post by 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 - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

Post Reply

Return to “SQL Yoga”