I have a new installation of 3.3 using:\nIIS 8.5\nMySQL 6.5\nPHP 5.6.9 I can put in new projects and save no problem. When I attempt to edit a project it won't save and this is typical of the error in the PHP log: [08-Jun-2015 11:10:08 America/New_York] D:\\WebSites\\wwwroot\\3prm\\classes\\w2p\\Database\\Query.class.php(1139): query failed(UPDATE `projects` SET `project_company` = '1', `project_name` = '10 VMs for Noresco Westborough', `project_short_name` = '10 VMs for', `project_owner` = '1', `project_url` = '', `project_demo_url` = '', `project_start_date` = '2015-06-01 00:00:00', `project_end_date` = '2015-06-19 00:00:00', `project_status` = 3, `project_color_identifier` = 'FFFFFF', `project_description` = '1166302 Gary Schonvisky', `project_target_budget` = '', `project_creator` = '1', `project_active` = 1, `project_private` = 0, `project_priority` = 0, `project_type` = 0, `project_parent` = 1100, `project_location` = 'BIS', `project_original_parent` = 1100, `project_updated` = '2015-06-08 15:10:08', `project_departments` = '' WHERE project_id = '1100') - error was: Incorrect decimal value: '' for column 'project_target_budget' at row 1 I have tested it successfully on this server using wampserver but for security reasons I have to use IIS. So far I haven't found any other add/update functions that don't work - just this one. Any help is greatly appreciated! --Jennifer

asked 08 Jun '15, 12:59

jjones77's gravatar image

jjones77
011
accept rate: 0%

asked 08 Jun '15, 12:59


Strictly speaking, IIS is right:\nproject_target_budget = '' Indeed, '' is not truely decimal. Probably should be 0. I think Keith has to Change this. Please enter the bug into the bug tracker for w2p.\nThanks, Klaus
permanent link

answered 12 Jun '15, 02:21

opto's gravatar image

opto ♦
7833953125
accept rate: 10%

answered 12 Jun '15, 02:21

In my environment we have the same problem. Mysql = 5.6.24\nPHP = 5.4.16
permanent link

answered 27 Jan '16, 11:31

brpemerson's gravatar image

brpemerson
1
accept rate: 0%

answered 27 Jan '16, 11:31

We resolve change the type of column project_actual_budget and project_target_budget to varchar.
permanent link

answered 27 Jan '16, 12:12

brpemerson's gravatar image

brpemerson
1
accept rate: 0%

answered 27 Jan '16, 12:12

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×1
×1

question asked: 08 Jun '15, 12:59

question was seen: 284 times

last updated: 29 Dec '16, 11:05

Related questions

powered by Bitnami OSQA