Bug #65492 | MySql updates blank values for the data values captured from form | ||
---|---|---|---|
Submitted: | 2 Jun 2012 12:53 | Modified: | 22 Sep 2012 9:45 |
Reporter: | Alex modirzadeh | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | MySql 5.1.63-cll version: 10 and phpMyAdmin Version information: 3.4.10.1 - php-5.2.x | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[8 Jun 2012 5:51]
Alex modirzadeh
[8 Jun 2012 5:55]
Alex modirzadeh
This is the program that update take place in it between lines 89 - 214
Attachment: agency_mod.php (application/octet-stream, text), 20.27 KiB.
[8 Jun 2012 5:56]
Alex modirzadeh
Agency program - Please refer to the diagram
Attachment: agency.php (application/octet-stream, text), 69.18 KiB.
[8 Jun 2012 5:59]
Alex modirzadeh
This is the agent edit program that we enter the agent's info for update
Attachment: agency_agencyAdmin_editAgentProfile.php (application/octet-stream, text), 11.01 KiB.
[8 Jun 2012 6:00]
Alex modirzadeh
This program shows all the agent related to one agency
Attachment: agency_agencyAdmin_manageAgentProfile_showAgent.php (application/octet-stream, text), 3.07 KiB.
[8 Jun 2012 6:08]
Alex modirzadeh
This program display heading related to the agency
Attachment: agency_agencyAdmin_manageAgentProfile_top.php (application/octet-stream, text), 2.10 KiB.
[8 Jun 2012 6:10]
Alex modirzadeh
this is the menu program by cliking on a button line 116 we start the process
Attachment: agency_agencyAdmin_homePage.php (application/octet-stream, text), 8.40 KiB.
[11 Sep 2012 8:21]
Alex modirzadeh
General Queryt Log File
Attachment: general_log.sql (text/plain), 205.25 KiB.
[13 Sep 2012 4:04]
Alex modirzadeh
General Log file
Attachment: general_log.sql (text/plain), 205.25 KiB.
[17 Sep 2012 23:51]
Alex modirzadeh
database record after update
Attachment: database-record-after-update.jpg (image/pjpeg, text), 121.91 KiB.
[17 Sep 2012 23:52]
Alex modirzadeh
Second Run Log File
Attachment: general_log2.sql (text/plain), 89.00 KiB.