Anonymous | Login | Signup for a new account | 2024-04-20 09:21 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Relationship Graph | [ View Issue ] [ Dependency Graph ] | |||
|
||||
|
Viewing Issue Simple Details | |||||
ID | Category | Type | Reproducibility | Date Submitted | Last Update |
0001019 | [In-Portal CMS] Database | bug report | always | 2011-03-13 06:41 | 2011-09-19 16:08 |
Reporter | alex | View Status | public | ||
Assigned To | alex | ||||
Priority | normal | Resolution | fixed | ||
Status | closed | ||||
Summary | 0001019: 2 records are inserted instead of 1 on sql error | ||||
Description |
Class kDBConnection has nice method called doInsert, that allows to insert data into database. It also can work in collect-only mode, when values are collected and then inserted using single database query, like INSERT .. VALUES (...),(...),(...) to improve execution speed. In case, when all sql errors doesn't cause fatal error (e.g. debugger is disabled), then this could happen: * you have 2 inserts into different tables to be executed one after another * first insert fails, since database table corruption * second insert tries to insert values from first insert and it's own values together resulting a failure, since column mismatch occurs. |
||||
Additional Information |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |