Jørn Wildt

Tyring to set up Mediashare for the first time on a fresh install of PostNuke. Using PHP 5.1.4, MySQL 5.0 and Apache 2.0.
I get this error below:
D:\PostNuke\html\modules\mediashare\pninit.php(321): D:\PostNuke\html\modules\mediashare\pneditapi.php(83): "Create album" failed: Field 'ms_modifieddate' doesn't have a default value while executing: INSERT INTO pn_mediashare_albums ( ms_ownerid, ms_createddate, ms_title, ms_keywords, ms_summary, ms_description, ms_topicId, ms_template, ms_parentAlbumId, ms_thumbnailsize, ms_viewkey) VALUES ( 2, NOW(), 'Top', '', '', 'This is the top album (of which there can be only one). You can edit this album to change the title and other attributes of it.', 0, 'standard', 0, '100', round(rand()*9000000000000 + 1000000000000))

Any ideas?

I'm really looking forward to trying out Mediashare!

Thanks!
Mark

That's a bug. Will be fixed.

Fixed in CVS.

Fixed in CVS.

In getAlbums you have a big sql error message when using mysql 5.
"SELECT ms_id, ms_ownerid, UNIX_TIMESTAMP(ms_createddate), UNIX_TIMESTAMP(ms_modifieddate), ms_title, ms_summary, ms_description, ms_keywords, ms_topicId, , , ms_template, ms_parentAlbumId, ms_viewkey, ms_mainmediaid, ms_thumbnailsize, ms_nestedsetleft, ms_nestedsetright, ms_nestedsetlevel FROM pn_mediashare_albums LEFT JOIN ON ms_topicId = WHERE ms_id = 1 "

Please note the , , , and the empty join criteria.

I tried 1.0.1 and cvs both have the same error.

Will check it.

Where can I get the latest code from CVS?

Thanks,
HTNut

Check elfisk on SourceForge.