[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.
Bye
Racke
--
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