Due to enormous amounts of spam, the forum has been set to read-only mode.



Reply to topic  [ 119 posts ]  Go to page Previous  1 ... 5, 6, 7, 8, 9, 10, 11, 12  Next
How to: Use CATweb on the Internet 
Author Message
User avatar

Joined: Mon Feb 06, 2012 10:38 pm
Posts: 24
Location: Amsterdam
Post Re: How to: Use CATweb on the Internet

Dave, (or others)

I followed your instructions and installed the Uniform Server (Coral_8_1_1), copied the Catweb files, using the default installation (C:\Uniserver, Catraxx is in C:\Program Files\CATraxx902).

With Catraxx running, I can see the index file of CATweb, but when i click on Catraxx, I get an error:
ERROR: There is a problem...a database must be specified in the URL when CATraxx is not already running.
But of course Catraxx IS already running...

When I try the default CATweb Apache server, all is working fine, no problem at all...

Any suggestions?

_________________
Groetjes, Jaap (picture is 30 years ago ...)


Tue Feb 07, 2012 10:25 pm
Profile
User avatar

Joined: Mon Feb 06, 2012 10:38 pm
Posts: 24
Location: Amsterdam
Post Re: How to: Use CATweb on the Internet

I follow the instructions in this thread, but when i click on the little icon to play a track (with the link http://localhost/cgi-bin/catweb.cgi?cat ... ter=id=684) i get an error:

Software error:

DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'TrackId ='. (SQL-42000) at CATweb.cgi line 2603.

Seems like the trackid is missing..

_________________
Groetjes, Jaap (picture is 30 years ago ...)


Wed Feb 08, 2012 12:02 am
Profile
User avatar

Joined: Sat Nov 22, 2003 7:47 pm
Posts: 2547
Location: Denmark
Post Re: How to: Use CATweb on the Internet

Do you have the PlayMusic.xsl template?

_________________
Kind regards
Thomas Hamstrup

HAP Software (http://www.hamstrup.dk)

Using Windows 8 PRO 64-bit and CATraxx 9.44


Thu Feb 09, 2012 2:48 pm
Profile WWW
User avatar

Joined: Fri Nov 14, 2003 6:15 pm
Posts: 1425
Post Re: How to: Use CATweb on the Internet

jojaspi wrote:
With Catraxx running, I can see the index file of CATweb, but when i click on Catraxx, I get an error:
ERROR: There is a problem...a database must be specified in the URL when CATraxx is not already running.
But of course Catraxx IS already running...?

This sounds like an issue with permissions. Does it help to use "Run as administrator" to start Coral Apache?

jojaspi wrote:
I follow the instructions in this thread, but when i click on the little icon to play a track (with the link http://localhost/cgi-bin/catweb.cgi?cat ... ter=id=684) i get an error:

Software error:

DBD::ODBC::db prepare failed: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'TrackId ='. (SQL-42000) at CATweb.cgi line 2603.

Seems like the trackid is missing..

Could be a bug in CATweb. Can you confirm that you are using CATweb.cgi version 2.8.5.1?

_________________
Cheers,
Dave


Thu Feb 09, 2012 7:04 pm
Profile WWW
User avatar

Joined: Mon Feb 06, 2012 10:38 pm
Posts: 24
Location: Amsterdam
Post Re: How to: Use CATweb on the Internet

Yes I'm using CATweb.cgi version 2.8.5.1, both with Coral Apache and with the default Catweb Apache.
So I think you're right that it has to do with permissions.
No big deal though, using Coral Apache I can put the database in the link and than it works like it should...

_________________
Groetjes, Jaap (picture is 30 years ago ...)


Thu Feb 09, 2012 11:42 pm
Profile
User avatar

Joined: Mon Feb 06, 2012 10:38 pm
Posts: 24
Location: Amsterdam
Post Re: How to: Use CATweb on the Internet

hamsen wrote:
Do you have the PlayMusic.xsl template?

Yes I made a copy of Track.xml and added your code in the body:
Quote:
<xsl:if test="/data/@dataserver='Yes'">
<script type="text/javascript">
if (/MSIE (\d+\.\d+);/.test(navigator.userAgent))
{document.write('<audio controls="controls" src="PLAY:{trackid/@unformatted}"></audio>');}
else if (/Safari[\/\s](\d+\.\d+)/.test(navigator.userAgent))
{document.write('<BR/><audio controls="controls" src="PLAY:{trackid/@unformatted}"></audio>');}
else if (/Firefox[\/\s](\d+\.\d+)/.test(navigator.userAgent))
{document.write('<embed src="PLAY:{trackid/@unformatted}" HEIGHT="42" WIDTH="300"></embed>');}
else
{document.write('<audio controls="controls" src="PLAY:{trackid/@unformatted}"></audio>');}
</script>
</xsl:if>

and that didn't work.
But when I replaced
Code:
PLAY:{trackid/@unformatted}

with
Code:
PLAY:{data/record/trackdata/trackid/@unformatted}

it worked OK.
So I solved my own problem ... :grin:

I'm an absolut newbee with xml....

_________________
Groetjes, Jaap (picture is 30 years ago ...)


Thu Feb 09, 2012 11:49 pm
Profile
User avatar

Joined: Fri Nov 14, 2003 6:15 pm
Posts: 1425
Post Re: How to: Use CATweb on the Internet

jojaspi wrote:
it worked OK.
So I solved my own problem ... :grin:

Glad you solved it!

_________________
Cheers,
Dave


Fri Feb 10, 2012 4:35 pm
Profile WWW
User avatar

Joined: Mon Feb 06, 2012 10:38 pm
Posts: 24
Location: Amsterdam
Post Re: How to: Use CATweb on the Internet

Any ideas how to translate the PLAYALL command into playable playlists?
I experimented a bit with the Yahoo! Web player but I couldn't get it working very well (translating The PLAYALL command into a xspf playlist on the fly, that the Yahoo! player picked up automatically in it's playlist)...

_________________
Groetjes, Jaap (picture is 30 years ago ...)


Sun Feb 12, 2012 3:48 pm
Profile
User avatar

Joined: Mon Feb 06, 2012 10:38 pm
Posts: 24
Location: Amsterdam
Post Re: How to: Use CATweb on the Internet

I still have issues when using Coral Apache (Catweb MicroApache Server is working fine).
When Catraxx is running I still have to include the database in the Catraxx link.
Also when a list uses more pages (for instance tracklist, albumlist Artistpersonlist), when I want to show the next page, I get an error:
ERROR: Invalid recordset GUID.

And I started Apache as administrator.
It must have to do with a setting in Coral Apache, I think :?: Or is it a bug in Coral?

_________________
Groetjes, Jaap (picture is 30 years ago ...)


Sun Feb 12, 2012 10:30 pm
Profile
User avatar

Joined: Fri Nov 14, 2003 6:15 pm
Posts: 1425
Post Re: How to: Use CATweb on the Internet

jojaspi wrote:
Any ideas how to translate the PLAYALL command into playable playlists?
I experimented a bit with the Yahoo! Web player but I couldn't get it working very well (translating The PLAYALL command into a (hidden) list of links, that the Yahoo! player picked up automatically in it's playlist)...

A couple years ago I had it working somewhat with Yahoo media player and Soundmanager2 but was never satisfied with the result. Unfortunately I don't have the time right now to look into it again. Maybe when things settle down a bit I'll be able to work on it.


jojaspi wrote:
I still have issues when using Coral Apache (Catweb MicroApache Server is working fine).
When Catraxx is running I still have to include the database in the Catraxx link.
Also when a list uses more pages (for instance tracklist, albumlist Artistpersonlist), when I want to show the next page, I get an error:
ERROR: Invalid recordset GUID.

And I started Apache as administrator.
It must have to do with a setting in Coral Apache, I think :?: Or is it a bug in Coral?

Try starting CATraxx with "Run as administrator" too. The fact that you have to enter the database means that CATweb is not connecting with CATraxx's data server so a new instance of CATraxx is started each time. That is also the cause of the error. The GUID does not persist across different instances of CATraxx so the next page of a list template cannot be accessed.

_________________
Cheers,
Dave


Mon Feb 13, 2012 7:54 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 119 posts ]  Go to page Previous  1 ... 5, 6, 7, 8, 9, 10, 11, 12  Next

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:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.