CMS MADE SIMPLE FORGE

Availability

 

[#8514] a Table missing

avatar
Created By: Jan van Leeuwen (janvl)
Date Submitted: Sun Oct 14 08:30:40 -0400 2012

Assigned To: Robert Campbell (calguy1000)
Version: 1.8.1
CMSMS Version: None
Severity: Critical
Resolution: None
State: Closed
Summary:
a Table missing
Detailed Description:
If you confirm a reservation for a resource on an hourly base
Table 'db10625670-redak.cms_module_availability_reservation_extra' doesn't exist
- DELETE FROM cms_module_availability_reservation_extra WHERE resv_id = 2

"Hourly" remains in the resource's type even if you change the name and the type
to daily
only deleting the resource and defining it new, works

with a reservation for a resource on a daily base "confirmation" leads to:
Table 'db10625670-redak.cms_module_availability_reservation_extra' doesn't exist
- DELETE FROM cms_module_availability_reservation_extra WHERE resv_id = 3

Hourly resources do not show a beginning and an end-date/time like with the
daily resources


History

Comments
avatar
Date: 2013-06-07 09:14
Posted By: Jan van Leeuwen (janvl)

line 169

$flds = "
         id       I KEY AUTO NOT NULL,
         resv_id  I NOT NULL,
         source   C(50) NOT NULL,
         itemid   I NOT NULL,
         sku      C(50),
         name     C(255),
         qty      I NOT NULL,
         itemamt  F NOT NULL,
         data     X
        ";
$sqlarray = $dict->CreateTableSQL(AVAILABILITY_TABLE_RESERVATION_EXTRA);
$dict->ExecuteSQLArray($sqlarray);


should be like this I guess.

$sqlarray = $dict->CreateTableSQL(AVAILABILITY_TABLE_RESERVATION_EXTRA,
				  $flds,$taboptarray);
$dict->ExecuteSQLArray($sqlarray);

Kind regards,
Jan

      
Updates

Updated: 2015-05-26 10:06
cmsms_version_id: 29495 => -1
state: Open => Closed

Updated: 2013-06-07 09:14
resolution_id: => 5