pragmaMx Support Forum

Hi,

bei der Aktivierung von SQL-Fehler anzeigen? in Adminmenü werden folgende Meldungen angezeigt:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
(1.) Meldung

Error sql_query():
qry: SELECT Count(eid) FROM {prefix}_events WHERE activ=0;
descr: Table 'db00016510.{prefix}_events' doesn't exist ( mysql 1146 )
details:

file: /blocks/block-AdminNews.php # line:  64, cmd: sql_query(),
file: /includes/mx_api.php # line: 814, cmd: include(/blocks/block-AdminN...),
file: /includes/mx_system.php # line: 417, cmd: mxgetblockdata(/blocks/block-AdminN...),
file: /includes/mx_themes.php # line: 177, cmd: mxgetallblocks(/blocks/block-AdminN...),
file: /footer.php # line:  65, cmd: themefooter(/blocks/block-AdminN...),
file: /admin/modules/settings.php # line: 672, cmd: include(/blocks/block-AdminN..., /footer.php),
file: /admin/modules/settings.php # line:1332, cmd: configure(/blocks/block-AdminN..., /footer.php),
file: /admin/case/case.settings.php # line:  23, cmd: include(/blocks/block-AdminN..., /footer.php, /admin/modules/setti...),
file: /admin.php # line: 634, cmd: include(/blocks/block-AdminN..., /footer.php, /admin/modules/setti..., /admin/case/case.set...),
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

und

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
(2.) Meldung

Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:

file: /blocks/block-AdminNews.php # line:  64, cmd: sql_fetch_row(),
file: /includes/mx_api.php # line: 814, cmd: include(/blocks/block-AdminN...),
file: /includes/mx_system.php # line: 417, cmd: mxgetblockdata(/blocks/block-AdminN...),
file: /includes/mx_themes.php # line: 177, cmd: mxgetallblocks(/blocks/block-AdminN...),
file: /footer.php # line:  65, cmd: themefooter(/blocks/block-AdminN...),
file: /admin/modules/settings.php # line: 672, cmd: include(/blocks/block-AdminN..., /footer.php),
file: /admin/modules/settings.php # line:1332, cmd: configure(/blocks/block-AdminN..., /footer.php),
file: /admin/case/case.settings.php # line:  23, cmd: include(/blocks/block-AdminN..., /footer.php, /admin/modules/setti...),
file: /admin.php # line: 634, cmd: include(/blocks/block-AdminN..., /footer.php, /admin/modules/setti..., /admin/case/case.set...),
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Kann mir bitte jemanden sagen, ob diese Meldungen auch bei einer von Euch angezeigt wird?

Wenn JA! warum?

Danke

gabin

Hallo !
Fehler ist :

Zitatdescr: Table 'db00016510.{prefix}_events' doesn't exist ( mysql 1146 )

die Tabelle {prefix}_events existiert nicht.
Verursacher ist block-AdminNews.php welcher versucht diese Tabelle auszulesen um die neuesten
Einträge aus dem Kalender auszulesen.
MfG
jubilee

Gönau :)

im CVS ist der Block schon gefixt.
Da ist er:

Vielen Dank  :thumbup:

MfG
gabin