[ic] Displaying SQL-Errors in the Administration Panel

Mike Heins mike at perusion.com
Wed Jul 9 15:49:42 EDT 2003

Quoting Frank Zibell (frank.zibell at xi-quadrat.de):
> Hello,
> I need to prevent double product items. Items (for us) are equal if 
> "description" and "category" are the same. So I defined an 
> SQL-table-constraint respectively  composite key:
> "alter table products add unique nodoubles (description, category);"
> So from now on the database does not permit item entries, where another 
> entry with the same description and the same category already exists. 
> But when I add such a double entry in the administration panel, there 
> is no error message displayed. The second item is just not created 
> (because the DB says "no") - but no hint for the user. And the 
> autonumber increases! I thought there might be a way to define that 
> rule in database/mysql/products.mysql. But I did not found that 
> documented anywhere.

The autonumber will always increase if you are letting
IC set it, because it has to display it. If you want to
use AUTO_SEQUENCE, I believe the latest versions will 
let the database autonumber it.

> Isn't it possible, that all SQL-Errors are displayed in the 
> administration-panel? That's what I thougt should be the default! I use 
> IC v.4.9.7.

I believe you are right. I have been ignoring this issue for
some time, but will be fixing it soon.

For the moment, you have to look at the global error.log file. Ugh.

Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike at perusion.com>

People who want to share their religious views with you
almost never want you to share yours with them. -- Dave Barry

More information about the interchange-users mailing list