[ic] Displaying SQL-Errors in the Administration Panel

Stefan Hornburg racke at linuxia.de
Wed Jul 9 23:49:26 EDT 2003

On Wed, 9 Jul 2003 14:49:42 -0400
Mike Heins <mike at perusion.com> wrote:

> 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.

Yes, that works, even with 4.8 AFAIK.

> > 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.

As long as there is no Internal Server Error, these messages can be
found in the catalog error log, but a feedback for the user is really
a good idea.


LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

More information about the interchange-users mailing list