Slidepress- A Fully Customizable, Dynamic Media Player for Wordpress
Slidepress is just the latest offering from Dominey Design, a web development company in Atlanta. Their main focus- AKA obsession- is Slideshowpro- a quick and easy and versatile Flash-based slideshow application available as a Flash Component and a standalone xml-driven swf. Plus they offer an web application called Slideshow Director- a database-driven image and video management application for installation on your won web server.
Dominey’s vision is vast- when you purchase any of their products they offer a number of freebie export scripts for Photoshop, various version of iPhoto, a server -side PHP XML Builder, to make the the process of creating the xml file which form the basis of these slideshow applications. They also offer a Lightroom to SlideshowPro Director upload app.
$24 for an Ounce of GOLD
That ounce of GOLD is the standalone SlideshowPro app.
They have managed to create what I consider that absolute best and versatile slideshow plugin for wordpress. Yes, I know, we wordpress people have a tendency to be cheap so the $24 investment might dissuade you BUT you will be missing out in a big way. Not only does Slidepress work with Dominey’s superb image management app SlideshowPro Director, it also works with WordPress’ native Media Library content and RSS feeds from Flicker etc.
Database Connection Error! 1054: Unknown column
When I first installed the Slidepress plugin I did receive a database error:
Database Connection Error! 1054: Unknown column ‘navThumbLinkBackgroundColor’ in ‘field list’
I re-installed the plugin, I downloaded the plugin again and manually installed it and deactivated and reactivated and it didn’t resolve itself. so I posted in the SlideshowPro forum. It seems that problem is not wide spread but definitely presenting itself for other users.
A quick google for mySQL error 1054 led me to believe that the plugin was neglecting to create the aforementioned table so, while waiting for answer, I decided to muck about and see if I could learn something.
On a lark, I opened slidepress.php in BBEdit and added
navNumberLinkColor text NULL ,
to line 229.
The error message changed to:
Database Connection Error! 1054: Unknown column ‘navThumbLinkBackgroundColor’ in ‘field list’
SO I knew I was onto something.
I added
added navThumbLinkBackgroundColor text NULL ,
to line 233
The plugin works flawlessly now. nearest thing I could figure out was that function action_activate() in slidepress.php is missing a bunch of table names names in the list of tables to create
Great Wiki
The Slidepress plugin is brought to you by the same guys that created the crosdomain creator so it is only right that it is so well-documented. Installation instructions are pretty easy to follow and can be found at
http://slidepress.net/installation.php
Want more installation details?
http://wiki.slideshowpro.net/SSPsa/SP-Installation
time to build a slideshow
At this point I would usually build an illustrated step-by-step tutorial on using this plugin. However, the guys at Dominey beat me to it and, to be honest, I couldn’t possibly do any better.
Find it here.
http://wiki.slideshowpro.net/SSPsa/SP-Usage
UPDATE
Here’s my version of the slidepress.php file for reference. if push comes to shove, you could test your set up by dropping this file in your slidepress folder.
Download SlidePress-php.zip
Twitter: dappjuice
i dunno if i can fix it- beyond creating a slideshow using only the default theme, there are no other real quick fixes. i suspect that is the trouble slideshowpro is running into.
and i would definitely be misrepresenting myself if i said i could fix it, i can diagnose and fix minor database issues and maybe correct some php “punctuation” BUT i am mostly a css jockey with a working knowledge of php as it relates to wordpress.
i have read that downgrading to the previous version helps…and i am on that prowl for that version…
madbadcat´s last blog ..Ask the Photographers #2 : Flashlight Graffiti
thank you for your help, I got it working.
I tried the same thing and I mine is still getting the same error! I can actually pay you to help me fix it. This is the only online resource that has addressed this problem.
Twitter: dappjuice
I actually inserted the two lines
i updated the post to add a jpg of the 2 lines i added so you could se; the format is important because its the array of options for the standalone player.
– plus i also added the zip file containing my amended slidepress.php up there.
see if replacing mine with yours helps.
if not, what error message are you getting?
madbadcat´s last blog ..Slidepress- A Fully Customizable, Dynamic Media Player for Wordpress
Hi, I’m having the same problem with Slidepress. Followed your instructions and no change. Did you replace lines 229 and 233 or add to them? I added your bits next to the existing code on those lines.
Thanks for your help. I like your site.