Volunteers for Beta 2.0

[Andrew Darby]

Hello, all.  Beta 2.0 is available, but I don't feel comfortable making it official until we get a little more feedback.  Anybody willing to do a test install, create a little content, see if everything works okay?

www.subjectsplus.com/sp2_beta.zip

We also need volunteers to try doing the auto update from 1.x to 2.0.  This should take only a couple of minutes.  Here's an example of an upgrade (without the styling added) of Ithaca College's data (thanks, Ron!):

http://subjectsplus.com/sp2d/

Please let me know if you have a chance to try it out and encounter any problems.

Thanks,

Andrew

[Louisa]

Hello!

SubjectsPlus 2.0 beta looks amazing!  Thank you for your hard work on it!  I haven't gone through everything in detail, but some things I've noticed so far:

1.  in Talkback,when a question is submitted, but isn’t live, we get the message “There was a problem with your submission. Please try again. If you continue to get an error, please contact the administrator “  which feels misleading, since the message does make it into subjectsplus.  It's just awaiting a response and approval.

2.  in videos, I find that I have trouble uploading thumbnails.  It seems like the feature was supposed to make a copy of x.jpg into something like x_medium.jpg, but it didn't for me. 

As for upgrading, I had a little trouble doing the upgrade from 1.0.1 to 2.0. I ended up with the following message "

Problem renaming for existing keyword column.
ALTER TABLE `subject` CHANGE COLUMN `keywords_backup` `keywords` VARCHAR(255)

Please drop database and restore backup before trying again.

" 

Seemed like the upgrade was looking for a nonexistent keywords column in the subject table.   I got it to work by adding the keywords column to the subjects table before running the upgrade. 

[Erin Elliott]

Hi,

Our IT dept installed the 2.0 beta version last night. Below my message are the feedback notes I received from them. Looks like we had the same error message as Louisa and they worked around it the same way.

The library staff haven't started using 2.0 yet but hopefully we'll have some time this week to test out the Summon integration. Thanks so much for this new feature!

Best,
Erin

SubjectsPlus V1.0.1 to V2.0 (Beta)

IIS V6.0, PHP V5.3.10, MySQL V5.5.13 (Windows Server)

While running the updater I received the following error:

-->Updater Error

Problem renaming for existing keyword column.

ALTER TABLE `subject` CHANGE COLUMN `keywords_backup` `keywords` VARCHAR(255)

Please drop database and restore backup before trying again.<--

 

The MySQL user had all necessary privileges: SELECT, INSERT, UPDATE, ALTER, DELETE, CREATE and DROP.

 

The column keywords_backup did not exist. After adding it to the subject table manually the updater completed successfully.

 

After update I could no longer login with the default subjectplus user. I changed the email address for that record in the staff table from its original value of “subjectplus” to an actual email address and I was then able to login.

--
You received this message because you are subscribed to the Google Groups "SubjectsPlus" group.
To unsubscribe from this group and stop receiving emails from it, send an email to subjectsplus...@googlegroups.com.
To post to this group, send email to subjec...@googlegroups.com.
Visit this group at http://groups.google.com/group/subjectsplus?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Andrew Darby]

Hi Louisa and Erin,

Thanks for testing!  The problem you both saw with "keywords" should be fixed in the *just updated* zip.  (We based the updater on the existing SQL from Ithaca College, and they had gone rogue and added a Keywords column--which we needed to backup, drop and add in again.)

As for logging in that first time, I'm not sure I understand where that original value of "subjectsplus" came from.  I think in previous versions the default user was ad...@sp.edu.  Anyway, on first login you need to use the FULL email address of the admin account, i.e., ad...@yourcollege.edu rather than just admin.  The email key hasn't been reset yet (that's done when you continue to configure the site in the admin), so it doesn't know what to attach after "admin."

Louisa, for the problem with the thumbnails, perhaps it's a permission issue:  SP needs to be able to write to assets/images/video_thumbs/ in order to stick the thumbnails in there (it creates both a _small and a _medium version).

For the TalkBack issue, are you testing this on your localhost?  I think you can get that message if it doesn't successfully send an email to the administrator (which can happen if your development machine isn't set up to sent out email).

Andrew

[Louisa]

Just realized that I never went back to respond to this!  Turns out the talkback issue was because I made a mistake typing in the email server name.  As for the thumbnail issue, it turns out that subjectsplus was writing the filename to my directory without the "_medium" in the file name.  The files being uploaded were being posted as "1.jpg", "2.jpg", and etc., when videos.php was looking for "1_medium.jpg", "2_medium.jpg"...  I, then, went into set_picture.php, line 89 on my copy, and edited the filename being posted to include the "_medium".