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