Another frontend, need opinions (beta release)

[ccandreva]

Valleynerds is backup. However I've found 2 problems:

1) Some of the image links are gives as '/img/' instead of 'img/' . This means they break if you install Supersonic in anything other than the root of your web server. I put my in a subdirectory since I run other things on it. Doing a search and replace of '/img/' to 'img/' fixes this.

2) The general admin settings tries to load a file admin_stuff.php, but this does not exist in the supersonic-PDO-0.15b.rar file.

[compcentral]

Ok.. I'm stuck on the "2. Create DB/Table" step.

What are the needed table(s) in mySQL? I have no trouble creating them manually if I knew what the setup is supposed to be.

Here is the output of step 1:

Connected to db, users table exists.
Connection to Subsonic server OK
Local server ip/port:http://192.168.1.2:8888/
Subsonic server/port:http://192.168.1.2:12345/
Database name:supersonic
Database username:username
Database password:password
Subsonic username:username
Subsonic password:password
API Version:1.2.0
Player name:bologna
Script variables look setup, create the database if you haven't already, then configure your music/video folders

Output of Step 2:
Settings saved. Reloading page.SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'current' can't have a default value

[compcentral]

actually... I think you have a couple of errors in setup.php

should be...

Code: Select all

         $sql = "CREATE TABLE users (
            id INTEGER NOT NULL PRIMARY KEY,
            username TEXT DEFAULT NULL,
            hashed_password TEXT DEFAULT NULL,
            shuffle INTEGER DEFAULT '0',
            timestamp INTEGER DEFAULT '1',
            reap INTEGER DEFAULT '0',
            current TEXT NOT NULL,
            currentsong TEXT NOT NULL,
            currentid TEXT NOT NULL,
            duration TEXT NOT NULL,
            cover TEXT NOT NULL,
            admin INTEGER NOT NULL DEFAULT '0'            
         )";
         $result = $sonic->exec($sql);
         $sql2 = "INSERT INTO users (
            id, username, hashed_password, admin, current, currentsong, currentid, duration, cover
         ) VALUES (
            0, '{$username}', '{$hashed_password}','1','','','','',''
         )";
         $sql1 = "CREATE TABLE config (
            id INTEGER NOT NULL PRIMARY KEY,
            music TEXT DEFAULT NULL,
            video TEXT DEFAULT NULL
         )";


[compcentral]

must be other problems as well... cause it still gives me the same error.

I was able to get the tables created manually and created a user entry into the users table (had to create the sha1 hash first of course)... anyway, now I can login, but I can't see any music/videos, because I'm not sure what goes in the config table. My folders are as follows:

Music(0) = Music
Movies(2) = Video

[compcentral]

I also noticed that the setup.php file reports:

"Connected to db, users table exists."

even when there is no users table. I deleted the user table to try to fix your setup script, but it gives me an error indicating that the user table already exists even though it doesn't...

For some reason, picking a different admin username & password in step 2, using my code in setup.php allowed the tables to be created properly but....

Now I'm stuck on step 3. I tried entering the following in the config table, but still no music/video after I login.

id, music, video
0, true, false
2, false, true

Can someone please look in the config table and tell me what it's supposed to look like? I'll keep plugging away at it, but it's close to finally working... I think.

[brett]

Hi folks, I'm sorry I haven't been around in a while, I started a new job a few months back and have had almost no time to develop the addon.

I've been doing local updates and testing but have yet to push anything to google code. I'm going to be moving away from any kind of database connection entirely. I originally used it to get more comfortable with php and sql in general, and now I feel it's not needed with the improvements to the subsonic API and myself learning a little more about php in general.

As of right now I've managed to integrate the addon into the Subsonic web server using a mod for java which enables php to be used. This removes the need for a 2nd web server to be deployed to use the mod, a huge plus. My goal right now is to make the setup script as seamless and painless as possible, and create better documentation on it. I'd also like to work on an html5 version as I've been fortunate enough to get a hold of an iPad. I just now noticed that there is a mobile version of jQuery which would be pretty awesome to use.

Once again I'm sorry I've been unable to help with support, but I will eventually get another release out the door for those of you who would still like to test it. After not releasing any new updates I can see if you guys would not want to use it anymore, and I feel like that much more of an asshole after barking at the other forum user who was going to release a modification of my addon.

[burjast]

please keep it separated, so i can use it from job where all non standard ports are blocked

[brett]

please keep it separated, so i can use it from job where all non standard ports are blocked

Part of the scripts function is to automatically detect which environment it has been installed to, there will always be support for the standalone as I find that editing the script while running it inside the Subsonic server is near impossible. Subsonic locks almost every file for editing so I have to bring it down everytime I need to publish an update.

I've also got a net top box with Ubuntu on it now, so I'll be able to test a linux version myself.

[freeflysage]

I'm super stoked to hopefully get this working. It's a beautiful interface. I'm trying to get either Dbase set up. I have mysql installed and it created the dbase name, but populated it with nothing. on the sqlite side, i click on create, no apache errors) but the page says "Settings saved. Reloading page.could not find driver"

ideas?

thanks

/sm

[freeflysage]

I decided to try the latest SVN version and the install now works with mysql (with my setup anyway) If i search for a known song or artist it comes up, but I get no list of music or videos even though it's able to find everything. no apache apache errors of any kind.

/sm

I'm super stoked to hopefully get this working. It's a beautiful interface. I'm trying to get either Dbase set up. I have mysql installed and it created the dbase name, but populated it with nothing. on the sqlite side, i click on create, no apache errors) but the page says "Settings saved. Reloading page.could not find driver"

ideas?

thanks

/sm

[brett]

I decided to try the latest SVN version and the install now works with mysql (with my setup anyway) If i search for a known song or artist it comes up, but I get no list of music or videos even though it's able to find everything. no apache apache errors of any kind.

/sm

I'm super stoked to hopefully get this working. It's a beautiful interface. I'm trying to get either Dbase set up. I have mysql installed and it created the dbase name, but populated it with nothing. on the sqlite side, i click on create, no apache errors) but the page says "Settings saved. Reloading page.could not find driver"

ideas?

thanks

/sm

The SVN is completely fragmented right now, I've been updating and removing portions, it should not work.

[freeflysage]

I decided to try the latest SVN version and the install now works with mysql (with my setup anyway) If i search for a known song or artist it comes up, but I get no list of music or videos even though it's able to find everything. no apache apache errors of any kind.

/sm

I'm super stoked to hopefully get this working. It's a beautiful interface. I'm trying to get either Dbase set up. I have mysql installed and it created the dbase name, but populated it with nothing. on the sqlite side, i click on create, no apache errors) but the page says "Settings saved. Reloading page.could not find driver"

ideas?

thanks

/sm

The SVN is completely fragmented right now, I've been updating and removing portions, it should not work.

It may be fragmented, but it's the only rev that comes close to 100% working for me. I've gone back to 15b and get the same error again "Could not find driver"

[freeflysage]

Brett,
While you're trolling this forum, let me first say thanks. I'll be sure and donate once I get everything up and working. A truly beautiful interface, well crafted.
I was wondering if you had any notes on the di.fm plugin you added in? I'd like to add a few similar stations from sky.fm with a similar interface to di.

Thanks, and hope the new job is going well.

/sm

[vividboarder]

Woah! First time browsing this section of the forum and I see this! Great job there.

I know you mentioned the SVN being unstable. Is the trunk stable? Or are the branches unstable? I'm following the project on Google Code so I'll keep my eyes open for when you stabilize it.

Thanks for the hard work! I can't wait to try it out.

[Mycophiles]

wish there was a walkthrough for this. I have a bit of experience with phpadmin but I got lost in making the tables. Could someone give a walkthrough?

Just so you know, personally I have a server running a webpage ( from home) so I admin my own server and subsonic runs on it so I thought I could tackle it but It truly went over my head. Really want to use this interface. I've run subsonic for over a year and have many friends and family that use it also.

Any help appreciated. Thks