In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Relationship Graph View Issue ] Dependency Graph ]
related to child of duplicate of

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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker