Im sry, i have a lot of problems here!

If i want to save the administrator options i get this joomla message:

----
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /www/htdocs/test72362/cgpb/libraries/joomla/database/database/mysqli.php on line 305

Speichern fehlgeschlagen! Fehler: TableAdmin: :store fehlgeschlagen!
Unknown column 'drop_tables' in 'field list' SQL=UPDATE `j17_bsms_admin` SET `podcast`='',`series`='- Kein Bild -',`study`='- Kein Bild -',`teacher`='- Kein Bild -',`media`='speaker24.png',`params`='{\"compat_mode\":\"0\",\"admin_store\":\"0\",\"studylistlimit\":\"\",\"show_location_media\":\"0\",\"popular_limit\":\"10\",\"character_filter\":\"1\",\"format_popular\":\"0\",\"socialnetworking\":\"1\",\"sharetype\":\"1\",\"default_main_image\":\"\",\"default_series_image\":\"\",\"default_teacher_image\":\"\",\"default_download_image\":\"\",\"default_showHide_image\":\"\",\"location_id\":\"-1\",\"teacher_id\":\"10\",\"series_id\":\"-1\",\"booknumber\":\"-1\",\"topic_id\":\"-1\",\"messagetype\":\"1\",\"default_study_image\":\"\",\"download\":\"0\",\"target\":\" \",\"server\":\"1\",\"path\":\"-1\",\"mime\":\"1\",\"from\":\"x\",\"to\":\"x\",\"pFrom\":\"x\",\"pTo\":\"x\"}',`download`='download.png',`main`='openbible.png',`showhide`='- Standardbild -',`drop_tables`='0' WHERE `id`='1'
----

If i want to save a new mediafile the following message arrived:


Save failed with the following error: Tablemediafilesedit: :store failed
Unknown column 'player' in 'field list' SQL=INSERT INTO `j17_bsms_mediafiles` (`id`,`study_id`,`media_image`,`server`,`path`,`published`,`special`,`filename`,`size`,`mime_type`,`podcast_id`,`ordering`,`mediacode`,`createdate`,`link_type`,`article_id`,`comment`,`params`,`player`,`popup`,`downloads`,`plays`) VALUES ('0','102','-1','1','4','1','0','04 sentiment.mp3','','1','','0','','2011-09-28 13:47:48','0','-1','','{\"playerwidth\":\"\",\"playerheight\":\"\",\"itempopuptitle\":\"\",\"itempopupfooter\":\"\",\"popupmargin\":\"50\"}','100','3','N/A','N/A')

I hope this can be fixed

Is this a new installation of JBS? There are definitely problems with your database as if it didn't install completely.

If this is a new installation, I recommend going to the Administration tab of JBS and checking the "Drop Tables on Uninstall" box then going to your Joomla Extension manager and uninstalling.

Then start over and reinstall. Check your db in the table jos_bsms_mediafiles for the field "player" to make sure that is there.

If this is an upgrade then you should open a Support Ticket with an admin user/pass to your site. Link at page bottom.

Tom

Hi Tom,

this is an upgrade but your tip with the database was right.
I compared my database with a fresh installed one and adapted it.

It works now!

Did you run the Migration component first? That's really important when going from JBS 6.2 to 7.x.

Anyway - glad it's working now!

Tom