Skip to Content
It is currently September 23rd, 2019, 6:22 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
PostPosted: November 12th, 2008, 2:45 pm 
Offline
Junior User
Junior User

Joined: November 10th, 2008, 11:11 am
Posts: 45
When I run the "entry of the crims" PAL, here is the error I get. I made the config changes and renamed it and am confused. Obviously i has something to do with the data base; is it written to work with a specific database?

ERROR: Query error:
Dynamic SQL error
SQL error code-104
Token unknown-line 1, char 251
420
ERROR: SQL: SELECT songlist.id.


Top
 Profile  
Reply with quote  
PostPosted: November 12th, 2008, 8:35 pm 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10442
Location: Denver, CO
it works with mysql, what database did you install?

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: November 13th, 2008, 3:16 am 
Offline
Junior User
Junior User

Joined: November 10th, 2008, 11:11 am
Posts: 45
Firebird


Top
 Profile  
Reply with quote  
PostPosted: November 13th, 2008, 1:00 pm 
Offline
Alumni
Alumni

Joined: March 11th, 2003, 1:34 pm
Posts: 9959
Location: Maui, HI
You'll have to change the SQL to conform to the Firebird dialect then, sorry.

_________________
- Steve Kunitzer
- SVS (Spacial Volunteer Support) / Forum Administrator

Image
Image


Top
 Profile  
Reply with quote  
PostPosted: November 13th, 2008, 1:52 pm 
Offline
Junior User
Junior User

Joined: November 10th, 2008, 11:11 am
Posts: 45
ok... I hate to be a pain, but how do I change the SQL to conform to the Firebird dialect? I know zero about databases (I don't even know if it's one word or two). :?


Top
 Profile  
Reply with quote  
PostPosted: November 13th, 2008, 6:53 pm 
Offline
Alumni
Alumni

Joined: March 11th, 2003, 1:34 pm
Posts: 9959
Location: Maui, HI
Might want to consider switching to use the MySQL database.
You'll find a wider range of support and tools from this community.

_________________
- Steve Kunitzer
- SVS (Spacial Volunteer Support) / Forum Administrator

Image
Image


Top
 Profile  
Reply with quote  
PostPosted: November 13th, 2008, 7:18 pm 
Offline
Junior User
Junior User

Joined: November 10th, 2008, 11:11 am
Posts: 45
I take it I have to uninstall SAM & Firbird to install mysql?


Top
 Profile  
Reply with quote  
PostPosted: November 13th, 2008, 11:53 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
Correct.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group