Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

The first run of select statement it fails with ERROR 1424 (HY000)

21 views
Skip to first unread message

Centrino

unread,
Oct 25, 2012, 5:53:54 AM10/25/12
to
I am having the following problem:

When I run the first select statement it fails with ERROR 1424 (HY000)

and inmediatelly running the same statement, I get the correct selection
Subsequent selections run ok, except the fist one.

Server version: 5.5.28 on windows.

Any clue?

Thanks in advance

The log:

mysql> select * from catalogoconf;
ERROR 1424 (HY000): Recursive stored functions and triggers are not allowed.
mysql> select * from catalogoconf;
+------------+--------------+---------+-------------------------+-----------+
| fecha | pprofundidad | eventos | senergia | pmagnitud
|
+------------+--------------+---------+-------------------------+-----------+
| 2011-07-19 | 12.35 | 2 | 20768343135.85590 | 1.76
|
.
.
.
.

Etc.


Luuk

unread,
Oct 26, 2012, 2:30:31 PM10/26/12
to
what happens if you do this prior to select anything?
mysql> show errors;
Empty set (0.00 sec)

mysql> show warnings;
Empty set (0.00 sec)



If this gives a clue, i would look at any stored functions or triggers
in your database....


0 new messages