CMS MADE SIMPLE FORGE

Availability

 

[#3835] Cannot add resc prices

avatar
Created By: Prue Rowland (psy)
Date Submitted: Mon Aug 03 19:32:06 -0400 2009

Assigned To:
Version: 1.6
CMSMS Version: None
Severity: Critical
Resolution: None
State: Open
Summary:
Cannot add resc prices
Detailed Description:
After correcting errors mentioned in prev bug report, when trying to editing the
Room and to add resource prices, the following index and db errors occur:

Notice: Undefined index: sunday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 427

Notice: Undefined index: monday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 428

Notice: Undefined index: tuesday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 429

Notice: Undefined index: wednesday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 430

Notice: Undefined index: thursday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 431

Notice: Undefined index: friday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 432

Notice: Undefined index: saturday in
C:\wamp\www\cmstest\modules\Availability\action.admin_edit_rsrc.php on line 433

Noticed the following in action.admin_edit_resc.php:
1.  In the query, there are 13 variables but only 11 question marks.

2. The order of vars on line 185 is 'discount_days, discount_adjust,
discount_type' yet the dbase structure is 'discount_type, discount_days,
discount_adjust '

And in method.install.php:

Install process sets 'resc_id' as a key and in (my) MYSQL this is automatically
set to autoincrement. This causes conflict as cannot insert duplicate keys.

Changing the above has no effect, ie still cannot insert resc prices.

Using:
Cms Version: 1.6.3

Installed Modules:

CMSMailer: 1.73.14
FileManager: 1.0
MenuManager: 1.6.1
ModuleManager: 1.3.1
News: 2.10.2
nuSOAP: 1.0.1
Printing: 1.0.1
Search: 1.6.1
ThemeManager: 1.1.1
TinyMCE: 2.5.1
CGExtensions: 1.16.2
FrontEndUsers: 1.6.8
CGSimpleSmarty: 1.4.3
Availability: 1.6

Config Information:

php_memory_limit: 
process_whole_template: false
max_upload_size: 2000000
default_upload_permission: 664
assume_mod_rewrite: false
page_extension: 
internal_pretty_urls: false
use_hierarchy: true

Php Information:

phpversion: 5.2.9-2
md5_function: On (True)
gd_version: 2
tempnam_function: On (True)
magic_quotes_runtime: Off (False)
memory_limit: 128M
max_execution_time: 30
safe_mode: Off (False)
session_save_path: c:/wamp/tmp (0777)

Server Information:

Server Api: apache2handler
Server Db Type: MySQL (mysql)
Server Db Version: 5.1.33



History