Welcome, Guest
Username Password: Remember me

Cant save admin adjustments | Cant save new files
(1 viewing) (1) Guest
Please be sure to provide your Joomla version, Php version, MySQL version, and how to recreate the problem.
  • Page:
  • 1

TOPIC: Cant save admin adjustments | Cant save new files

Cant save admin adjustments | Cant save new files 28 Sep 2011 10:50 #2838

  • tobisagt
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
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
Last Edit: 28 Sep 2011 10:50 by tobisagt.

Re: Cant save admin adjustments | Cant save new files 28 Sep 2011 13:55 #2841

  • Tom
  • OFFLINE
  • Moderator
  • Posts: 305
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

Re: Cant save admin adjustments | Cant save new files 05 Oct 2011 12:47 #2863

  • tobisagt
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
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!

Re: Cant save admin adjustments | Cant save new files 05 Oct 2011 13:35 #2867

  • Tom
  • OFFLINE
  • Moderator
  • Posts: 305
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
  • Page:
  • 1
Time to create page: 0.74 seconds