Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Error on creating bookable object
(1 viewing) (1) Guest
Universal booking and reservations component for Joomla!.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: Error on creating bookable object

Error on creating bookable object 11 years, 8 months ago #37433

This is the error code, which i receive on saving a bookable Item:

1054 - Es ist ein Fehler aufgetreten
Unknown column 'user_id' in 'field list' SQL=INSERT INTO `krfbm_booking_subject` (`id`,`parent`,`template`,`title`,`alias`,`introtext`,`fulltext`,`total_capacity`,`state`,`ordering`,`publish_up`,`publish_down`,`access`,`hits`,`checked_out`,`checked_out_time`,`user_id`,`params`) VALUES ('0','0','1','xo|one (copy)','xo-one','



Not sure, whats the problem is. Have you any suggestions?

Thanks and kind regards
Christof
Last Edit: 11 years, 8 months ago by chrichro.
The topic has been locked.

Re: Error on creating bookable object 11 years, 8 months ago #37437

Sorry this is the right message.

Unknown column 'user_id' in 'field list' SQL=INSERT INTO `krfbm_booking_subject` (`id`,`parent`,`template`,`title`,`alias`,`introtext`,`total_capacity`,`state`,`ordering`,`publish_up`,`publish_down`,`access`,`hits`,`user_id`,`params`) VALUES ('0','0','0','xo','xo','','1','1','2','2013-03-13 10:36:00','0000-00-00 00:00:00','1','0','259','{\"display_only_one_rtype\":0,\"min_limit\":0,\"image\":\"\",\"images\":\"\",\"files\":\"\",\"reserving\":0,\"use_fix_shedule\":0,\"shedule_to\":null,\"shedule_from\":null,\"display_capacity\":0,\"rlimit_count\":0,\"rlimit_days\":0,\"rlimit_set\":0,\"night_booking\":0,\"night_booking_from\":null,\"night_booking_to\":null,\"keywords\":\"\",\"description\":\"\",\"book_over_timeliness\":0,\"single_deposit\":0,\"single_discount\":\"\",\"single_discount_unit\":\"\",\"minimum_capacity\":0,\"google_maps\":\"off\",\"google_maps_address\":\"\",\"google_maps_width\":0,\"google_maps_heigth\":0,\"google_maps_zoom\":\"\",\"google_maps_code\":\"\",\"google_maps_display\":\"\",\"tax\":\"\",\"show_contact_form\":0,\"contact_email\":\"\"}')
The topic has been locked.

Re: Error on creating bookable object 11 years, 8 months ago #37441

  • mach
  • OFFLINE
  • Posts: 112
Hello Christof,
problem is probably with uncompleted upgrade. Go to the PHPMyAdmin and in Joomla DB run SQL:

ALTER TABLE `krfbm_booking_subject` ADD `user_id` int(11) NOT NULL DEFAULT '0'
ARTIO Support Team
The topic has been locked.

Re: Error on creating bookable object 11 years, 8 months ago #37446

Thank you.

solved!
The topic has been locked.
  • Page:
  • 1
User Login Empty