Welcome, Guest
Username: Password: Remember me

TOPIC: [FIXED] Error on saving item

Edit generates an empty record 30 Mar 2017 17:19 #15072

  • liubov
  • liubov's Avatar
  • Offline
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 279
  • Thank you received: 36
  • Karma: 22
And have right now an SQL error when saving a new Item (3.1.4)
Works fine with 3.0.10

An error has occurred.
0 Unknown column '_conference_id_.published' in 'field list' SQL=SELECT a.id,a.*,_conference_id_.published AS `_conference_id_published`,_intervenant_id_.published AS `_intervenant_id_published` FROM #__demo13672_sessions AS a WHERE `conference_id` = 29 AND `intervenant_id` NOT IN (16) ORDER BY a.conference_id ASC
The administrator has disabled public write access.

Edit generates an empty record 31 Mar 2017 12:00 #15074

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
Fixed.
This was because the session table has no layout. But it was my fault because it should be permitted of course.
The builder was missing the FK declaration in the constructor.

For you the only change is in the constructor of the 'sessions' model
models/sessions.php (front / back)
Coding is now a piece of cake
The administrator has disabled public write access.

Edit generates an empty record 31 Mar 2017 12:32 #15075

  • liubov
  • liubov's Avatar
  • Offline
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 279
  • Thank you received: 36
  • Karma: 22
Right OK,
this point is clear for me.

thkx
The administrator has disabled public write access.
Time to create page: 0.134 seconds

Get Started