- problem:[0.02s] DB Error: no such field --> select `booking`.`booking_uid`, `booking`.`customer_uid`, `booking`.`bookinggroup_uid`, `booking`.`unit_uid`, `booking`.`resource_uid`, `booking`.`affiliate_uid`, `booking`.`affiliatepayref`, `booking`.`siteskinuid`, `booking`.`affskinuid`, `booking`.`affcommrate`, UNIX_TIMESTAMP(`booking`.`fromdate`) as `fromdate`, `booking`.`state_uid`, `booking`.`pending_bookingtra_uid`, UNIX_TIMESTAMP(`booking`.`todate`) as `todate`, `booking`.`amount`, `booking`.`commission`, `booking`.`levy`, `booking`.`bankfee`, `booking`.`affiliatecommission`, `booking`.`ratetype_uid`, `booking`.`comments`, `booking`.`myref`, `booking`.`refnum`, UNIX_TIMESTAMP(`booking`.`timestamp`) as `timestamp`, `booking`.`from_carhirebranch_uid`, `booking`.`to_carhirebranch_uid`, UNIX_TIMESTAMP(`booking`.`timestampbackup`) as `timestampbackup`, `booking`.`stoformcauth`, `booking`.`stoformproinv`, UNIX_TIMESTAMP(`booking`.`stopayresource`) as `stopayresource`, UNIX_TIMESTAMP(`booking`.`stochargecard`) as `stochargecard`, `booking`.`stobatchnum`, `booking`.`stoamountreceived`, `booking`.`stoamountpaid`, `booking`.`storefunded`, UNIX_TIMESTAMP(`booking`.`storefundeddate`) as `storefundeddate`, `booking`.`storesourcepaid`, UNIX_TIMESTAMP(`booking`.`stodeprequired`) as `stodeprequired`, UNIX_TIMESTAMP(`booking`.`stodeppayresource`) as `stodeppayresource`, `booking`.`stodepbatchnum`, `booking`.`stodepamountreceived`, `booking`.`stodepamountpaid`, `booking`.`stodeprefunded`, UNIX_TIMESTAMP(`booking`.`stodeprefundeddate`) as `stodeprefundeddate`, `booking`.`stodepresourcepaid`, `booking`.`stohotelrefund`, `booking`.`lastadmin_login_uid`, `booking`.`owner_login_uid`, UNIX_TIMESTAMP(`booking`.`lastadmindatetime`) as `lastadmindatetime`, `booking`.`previous_state_uid`, `booking`.`olddepflag`, `booking`.`oldpayflag`, `booking`.`flagbatchedpayment`, `booking`.`campaign`, `booking`.`campaignmedium`, `booking`.`adgroup`, `booking`.`meta`, `booking`.`ccfee`, `commission` * (`affiliate`.`rate` / 100.0) AS affiliatecommission from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid LIMIT 0,20 [nativecode=1054 ** Unknown column 'booking.affiliate_uid' in 'on clause']
- backtrace:[0.02s]
Obj Feedback->backtrace() in db.inc.php:70 query(select `booking`.`booking_uid`, `booking`.`customer_uid`, `booking`.`bookinggroup_uid`, `booking`.`unit_uid`, `booking`.`resource_uid`, `booking`.`affiliate_uid`, `booking`.`affiliatepayref`, `booking`.`siteskinuid`, `booking`.`affskinuid`, `booking`.`affcommrate`, UNIX_TIMESTAMP(`booking`.`fromdate`) as `fromdate`, `booking`.`state_uid`, `booking`.`pending_bookingtra_uid`, UNIX_TIMESTAMP(`booking`.`todate`) as `todate`, `booking`.`amount`, `booking`.`commission`, `booking`.`levy`, `booking`.`bankfee`, `booking`.`affiliatecommission`, `booking`.`ratetype_uid`, `booking`.`comments`, `booking`.`myref`, `booking`.`refnum`, UNIX_TIMESTAMP(`booking`.`timestamp`) as `timestamp`, `booking`.`from_carhirebranch_uid`, `booking`.`to_carhirebranch_uid`, UNIX_TIMESTAMP(`booking`.`timestampbackup`) as `timestampbackup`, `booking`.`stoformcauth`, `booking`.`stoformproinv`, UNIX_TIMESTAMP(`booking`.`stopayresource`) as `stopayresource`, UNIX_TIMESTAMP(`booking`.`stochargecard`) as `stochargecard`, `booking`.`stobatchnum`, `booking`.`stoamountreceived`, `booking`.`stoamountpaid`, `booking`.`storefunded`, UNIX_TIMESTAMP(`booking`.`storefundeddate`) as `storefundeddate`, `booking`.`storesourcepaid`, UNIX_TIMESTAMP(`booking`.`stodeprequired`) as `stodeprequired`, UNIX_TIMESTAMP(`booking`.`stodeppayresource`) as `stodeppayresource`, `booking`.`stodepbatchnum`, `booking`.`stodepamountreceived`, `booking`.`stodepamountpaid`, `booking`.`stodeprefunded`, UNIX_TIMESTAMP(`booking`.`stodeprefundeddate`) as `stodeprefundeddate`, `booking`.`stodepresourcepaid`, `booking`.`stohotelrefund`, `booking`.`lastadmin_login_uid`, `booking`.`owner_login_uid`, UNIX_TIMESTAMP(`booking`.`lastadmindatetime`) as `lastadmindatetime`, `booking`.`previous_state_uid`, `booking`.`olddepflag`, `booking`.`oldpayflag`, `booking`.`flagbatchedpayment`, `booking`.`campaign`, `booking`.`campaignmedium`, `booking`.`adgroup`, `booking`.`meta`, `booking`.`ccfee`, `commission` * (`affiliate`.`rate` / 100.0) AS affiliatecommission from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid LIMIT 0,20, [Object (DB_mysql)], [NULL]) in db.inc.php:159 mget(select `booking`.`booking_uid`, `booking`.`customer_uid`, `booking`.`bookinggroup_uid`, `booking`.`unit_uid`, `booking`.`resource_uid`, `booking`.`affiliate_uid`, `booking`.`affiliatepayref`, `booking`.`siteskinuid`, `booking`.`affskinuid`, `booking`.`affcommrate`, UNIX_TIMESTAMP(`booking`.`fromdate`) as `fromdate`, `booking`.`state_uid`, `booking`.`pending_bookingtra_uid`, UNIX_TIMESTAMP(`booking`.`todate`) as `todate`, `booking`.`amount`, `booking`.`commission`, `booking`.`levy`, `booking`.`bankfee`, `booking`.`affiliatecommission`, `booking`.`ratetype_uid`, `booking`.`comments`, `booking`.`myref`, `booking`.`refnum`, UNIX_TIMESTAMP(`booking`.`timestamp`) as `timestamp`, `booking`.`from_carhirebranch_uid`, `booking`.`to_carhirebranch_uid`, UNIX_TIMESTAMP(`booking`.`timestampbackup`) as `timestampbackup`, `booking`.`stoformcauth`, `booking`.`stoformproinv`, UNIX_TIMESTAMP(`booking`.`stopayresource`) as `stopayresource`, UNIX_TIMESTAMP(`booking`.`stochargecard`) as `stochargecard`, `booking`.`stobatchnum`, `booking`.`stoamountreceived`, `booking`.`stoamountpaid`, `booking`.`storefunded`, UNIX_TIMESTAMP(`booking`.`storefundeddate`) as `storefundeddate`, `booking`.`storesourcepaid`, UNIX_TIMESTAMP(`booking`.`stodeprequired`) as `stodeprequired`, UNIX_TIMESTAMP(`booking`.`stodeppayresource`) as `stodeppayresource`, `booking`.`stodepbatchnum`, `booking`.`stodepamountreceived`, `booking`.`stodepamountpaid`, `booking`.`stodeprefunded`, UNIX_TIMESTAMP(`booking`.`stodeprefundeddate`) as `stodeprefundeddate`, `booking`.`stodepresourcepaid`, `booking`.`stohotelrefund`, `booking`.`lastadmin_login_uid`, `booking`.`owner_login_uid`, UNIX_TIMESTAMP(`booking`.`lastadmindatetime`) as `lastadmindatetime`, `booking`.`previous_state_uid`, `booking`.`olddepflag`, `booking`.`oldpayflag`, `booking`.`flagbatchedpayment`, `booking`.`campaign`, `booking`.`campaignmedium`, `booking`.`adgroup`, `booking`.`meta`, `booking`.`ccfee`, `commission` * (`affiliate`.`rate` / 100.0) AS affiliatecommission from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid LIMIT 0,20) in Datacontrol.class.php:869 Obj Datacontrol->mload([Array (0)], [Array (3)], [Array (2)], [NULL], [NULL], [Array (1)]) in Datacontrol.class.php:916 Obj Datacontrol->get_view_table_as_list_data([NULL], [Array (3)], [Array (2)], [NULL], [NULL], [Array (1)]) in Dataview.class.php:856 Obj Dataview->view_table_as_list([NULL], [Array (3)], [Array (6)], [NULL], 255) in Dataview.class.php:1424 Obj Dataview->action_list([Object (Bookingcontrol)], [Array (3)]) in Bookingview.class.php:64 Obj Bookingview->action_list([Object (Bookingcontrol)], [Array (3)]) in Dataview.class.php:94 Obj Dataview->Dataview([Object (Bookingcontrol)], [Array (3)]) in Application.class.php:124 Obj Application->create_data_view([Array (1)]) in Application.class.php:74 Obj Application->create_application([Array (2)], [NULL], [Array (0)]) in _application.class.php:13 Obj _application->create_application([Array (2)], [NULL]) in index_ned.php:179 include(/var/www/securebooking.org/bookings_git/index_ned.php) in index.php:143
- problem:[0.02s] DB Error: no such field --> select COUNT(*) from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid [nativecode=1054 ** Unknown column 'booking.affiliate_uid' in 'on clause']
- backtrace:[0.02s]
Obj Feedback->backtrace() in db.inc.php:70 query(select COUNT(*) from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid , [Object (DB_mysql)], [NULL]) in db.inc.php:124 get(select COUNT(*) from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid , [Object (DB_mysql)], [NULL]) in db.inc.php:95 getone(select COUNT(*) from `booking`, `login`, `login_affiliate_link` LEFT JOIN `affiliate` ON (`booking`.`affiliate_uid` = `affiliate`.`affiliate_uid`) WHERE login.login_uid IS NULL AND login_affiliate_link.login_uid = login.login_uid AND booking.affiliate_uid = login_affiliate_link.affiliate_uid ) in Datacontrol.class.php:1044 Obj Datacontrol->get_count_from_dim([Array (3)], [NULL]) in Dataview.class.php:919 Obj Dataview->view_table_as_list([NULL], [Array (3)], [Array (6)], [NULL], 255) in Dataview.class.php:1424 Obj Dataview->action_list([Object (Bookingcontrol)], [Array (3)]) in Bookingview.class.php:64 Obj Bookingview->action_list([Object (Bookingcontrol)], [Array (3)]) in Dataview.class.php:94 Obj Dataview->Dataview([Object (Bookingcontrol)], [Array (3)]) in Application.class.php:124 Obj Application->create_data_view([Array (1)]) in Application.class.php:74 Obj Application->create_application([Array (2)], [NULL], [Array (0)]) in _application.class.php:13 Obj _application->create_application([Array (2)], [NULL]) in index_ned.php:179 include(/var/www/securebooking.org/bookings_git/index_ned.php) in index.php:143
- notice:[0.02s] bookinggroup: none
- problem:[0.02s] You do not have permission: load table: bookinggroup
- notice:[0.27s] carhirebranch: none
- problem:[0.27s] You do not have permission: load table: carhirebranch
- notice:[0.27s] carhirebranch: none
- problem:[0.27s] You do not have permission: load table: carhirebranch
|
|
| |