Forum

Hallo,
seit dem ich OPN installiert habe, bekomme ich von OPN bis zu 20 E-Mails am tag. Sie sehen alle gleich aus und haben auch mehr oder weniger den gleichen Inhalt. Wie kann ich das Angemailte Problem beseitigen, oder die Mails abstellen?

und hier die Mail.:
- Debug error detected within form.table.class on Joint Operations - Das Game (http://www.joint-operations-server.de)
in fieldname: jumpday
selected value: 217
selected var type: string
page name: modules/calendar
possible values: 01 [string] 02 [string] 03 [string] 04 [string] 05 [string] 06 [string] 07 [string] 08 [string] 09 [string] 10 [integer] 11 [integer] 12 [integer] 13 [integer] 14 [integer] 15 [integer] 16 [integer] 17 [integer] 18 [integer] 19 [integer] 20 [integer] 21 [integer] 22 [integer] 23 [integer] 24 [integer] 25 [integer] 26 [integer] 27 [integer] 28 [integer] 29 [integer] 30 [integer] 31 [integer] Ausgelöst von der IP Adresse: 66.249.66.82 um 04.07.2007 19:25:02 Die URI die den Fehler ausgelöst hat war:
D:inetpubvhostsjoint-operations-server.dehttpdocs/modules/calendar/index.php?opnparams=XH4AfF11BzADaQUhB2RTZQUnVSIAaFM%2BUjMDPAI7DXEHFVQwAS0GMV03VzcLMQNgAWMCfgY7VmdQeAY0VGoIY1w9


REQUEST_URI=/modules/calendar/index.php?opnparams=XH4AfF11BzADaQUhB2RTZQUnVSIAaFM%2BUjMDPAI7DXEHFVQwAS0GMV03VzcLMQNgAWMCfgY7VmdQeAY0VGoIY1w9

decode information: type=view&eid=5&Date=2007-05-0217

So und jetzt noch ein paar Infos

User information
UNAME:anonymous
UID:1


Client=>>ua ::=> mozilla/5.0 (compatible; googlebot/2.1; +http://www.google.com/bot.html)
>>browser ::=> bot
>>version ::=> 2.1
>>maj_ver ::=> 2
>>min_ver ::=> .1
>>letter_ver ::=> Unknown
>>javascript ::=> 0.0
>>platform ::=> Unknown
>>os ::=> Unknown
>>ip ::=> 66.249.66.82
>>cookies ::=>
>>language ::=> en-us
>>long_name ::=> google
>>gecko ::=> Unknown
>>label ::=> 0
>>shrinkinputbox ::=> 0
>>dpi ::=> 96


Browser : Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
REMOTE_HOST      : 66.249.66.82
REMOTE_NAME      : crawl-66-249-66-82.googlebot.com
SERVER_PORT      : 80
SERVER_PROTOCOL : HTTP/1.1
SERVER_SOFTWARE : Microsoft-IIS/6.0
SERVER_NAME      : www.joint-operations-server.de
SERVER_ADDR      : www.joint-operations-server.de


opn_get_vars
>>type ::=> view
>>eid ::=> 5
>>Date ::=> 2007-05-0217


opn_post_vars


opn_request_vars
>>opnparams ::=>
>>XH4AfF11BzADaQUhB2RTZQUnVSIAaFM+UjMDPAI7DXEHFVQwAS0GMV03VzcLMQNgAWMCfg
>>Y7VmdQeAY0VGoIY1w9
>>type ::=> view
>>eid ::=> 5
>>Date ::=> 2007-05-0217


opn_server_vars
>>ALL_HTTP ::=> HTTP_CONNECTION:Keep-alive
HTTP_ACCEPT:*/*
HTTP_ACCEPT_ENCODING:gzip
HTTP_FROM:googlebot(at)googlebot.com
HTTP_HOST:www.joint-operations-server.de
HTTP_USER_AGENT:Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)

>>HTTPS ::=> off
>>SCRIPT_NAME ::=> /modules/calendar/index.php HTTP_COOKIE ::=>
>>AUTH_PASSWORD ::=> AUTH_TYPE ::=> AUTH_USER ::=> CONTENT_LENGTH ::=> 0
>>CONTENT_TYPE ::=> PATH_TRANSLATED ::=>
>>D:inetpubvhostsjoint-operations-server.dehttpdocs
>>QUERY_STRING ::=>
>>opnparams=XH4AfF11BzADaQUhB2RTZQUnVSIAaFM%2BUjMDPAI7DXEHFVQwAS0GMV03Vz
>>cLMQNgAWMCfgY7VmdQeAY0VGoIY1w9
>>REMOTE_ADDR ::=> 66.249.66.82
>>REMOTE_HOST ::=> 66.249.66.82
>>REMOTE_USER ::=>
>>REQUEST_METHOD ::=> GET
>>SERVER_NAME ::=> www.joint-operations-server.de SERVER_PORT ::=> 80
>>SERVER_PROTOCOL ::=> HTTP/1.1 SERVER_SOFTWARE ::=> Microsoft-IIS/6.0
>>APPL_MD_PATH ::=> /LM/W3SVC/23723/Root APPL_PHYSICAL_PATH ::=>
>>D:inetpubvhostsjoint-operations-server.dehttpdocs
>>INSTANCE_ID ::=> 23723
>>INSTANCE_META_PATH ::=> /LM/W3SVC/23723 LOGON_USER ::=> REQUEST_URI
>>::=>
>>/modules/calendar/index.php?opnparams=XH4AfF11BzADaQUhB2RTZQUnVSIAaFM%
>>2BUjMDPAI7DXEHFVQwAS0GMV03VzcLMQNgAWMCfgY7VmdQeAY0VGoIY1w9
>>URL ::=>
>>/modules/calendar/index.php?opnparams=XH4AfF11BzADaQUhB2RTZQUnVSIAaFM%
>>2BUjMDPAI7DXEHFVQwAS0GMV03VzcLMQNgAWMCfgY7VmdQeAY0VGoIY1w9
>>SCRIPT_FILENAME ::=>
>>D:inetpubvhostsjoint-operations-server.dehttpdocsmodulesca
>>lendarindex.php ORIG_PATH_INFO ::=> /modules/calendar/index.php
>>PATH_INFO ::=> ORIG_PATH_TRANSLATED ::=>
>>D:inetpubvhostsjoint-operations-server.dehttpdocsmodulesca
>>lendarindex.php DOCUMENT_ROOT ::=>
>>D:inetpubvhostsjoint-operations-server.dehttpdocs
>>PHP_SELF ::=> /modules/calendar/index.php HTTP_CONNECTION ::=>
>>Keep-alive HTTP_ACCEPT ::=> */* HTTP_ACCEPT_ENCODING ::=> gzip
>>HTTP_FROM ::=> googlebot(at)googlebot.com HTTP_HOST ::=>
>>www.joint-operations-server.de HTTP_USER_AGENT ::=> Mozilla/5.0
>>(compatible; Googlebot/2.1; +http://www.google.com/bot.html) argv ::=>
>>

• 0 ::=> >>opnparams=XH4AfF11BzADaQUhB2RTZQUnVSIAaFM%2BUjMDPAI7DXEHFVQwAS0GMV03Vz >>cLMQNgAWMCfgY7VmdQeAY0VGoIY1w9

>>argc ::=> 1
>>SERVER_ADDR ::=> www.joint-operations-server.de


Gruß CCED

im errorlog im Admin kannst du die einstellungen über email-Benachrichtigung ausschalten - was natürlich nicht die Fehler behebt

Hallo, danke für die Info, aber da haben wir schon Problem Nr. 2
In den Einstellungen des Errorlogs steht bei
Eintrag in das Errorlog auch als eMail verschicken? NEIN
und bei Errorlog soll als Unixlog arbeiten? ebenfalls.

Gruß cced

1. Möglichkeit das nein noch mal speichern
2. Möglichkeit supporter eingetragen? (der bekommt immer ne mail)

Hallo Stefan,
habe das "Nein" noch einmal gespeichert... mal abwarten...
Aber wie migaja schon sagte, daß behebt ja nicht den eigendlichen Fehler...

Gruß CCED

vielleicht auch mal einen Tipp die Seite upzudaten auf die aktuelle version
openPHPnuke 2.4.2 [Aphrodite] (Revision 95) << das nicht aktuell wir sind schon bei 2.4.7 angekommen, eventuell ist dann das Problem beseitigt

Hallo Spinne
Komisch, diesen Tip gibst du mir jedes mal )
Aber du kennst ja den guten alten Admin-Spruch..

"never touch a running system..."

Die Seite läuft so wie sie ist recht gut und stabil, bis auf ein paar Schönheitsfehler.

Gruß CCED

sicher aber auch das neue läuft einwandfrei und in den releases die gemacht worden sind, sind ja auch einige fehler behoben worden also von daher ist diesmal der spruch never touch a running system.... etwas fehl am platz :-p

also hast du die wahl *gg* errormails oder update

gruss tine

Hallo,
tija, als ob ich es geahnt hätte...
ich habe von 2.4.2 auf 243 ->244 ->245 upgedatet. bis dahin alles OK, dann kam ->246 und 247. und nun..... geht garnichts mehr !

kann man die Updates irgendwie rückgänbgig machen ?

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_exception_register
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassenginefc_engine.php]
FOUND AT 138

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ( (function_name'') AND (exception_name'') )' at line ] in EXECUTE("SELECT id, exception_name, exception_point, function_name, function_file FROM WHERE ( (function_name'') AND (exception_name'') )")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: user_group
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.opn_permissions.php]
FOUND AT 135

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_group_id>=0 ORDER BY user_group_id' at line 1] in EXECUTE("SELECT user_group_id, user_group_text, user_group_members, user_group_webmaster FROM WHERE user_group_id>=0 ORDER BY user_group_id")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: users
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.opn_permissions.php]
FOUND AT 1452

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE uname='shadow'' at line 1] in EXECUTE("SELECT uid FROM WHERE uname='shadow'")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: users
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.opn_permissions.php]
FOUND AT 1003

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE uid=1' at line 1] in EXECUTE("SELECT thold, uorder, umode, commentmax FROM WHERE uid=1")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined offset: 0
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.opn_permissions.php]
FOUND AT 1082

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_user_dat
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsmaster.php]
FOUND AT 436

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_uid=1' at line 1] in EXECUTE("SELECT user_status FROM WHERE user_uid=1")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined offset: 0
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.opn_permissions.php]
FOUND AT 384

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_protector_access
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.protector.php]
FOUND AT 122

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE expire < 2454287.00287' at line 1] in EXECUTE("DELETE FROM WHERE expire < 2454287.00287")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_protector_access
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.protector.php]
FOUND AT 125

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ip, request_uri, expire) VALUES ('87.186.116.185', '/index.php'] in EXECUTE("INSERT INTO (ip, request_uri, expire) VALUES ('87.186.116.185', '/index.php', 2454287.00407)")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
WARNING [8] Undefined index: opn_protector_access
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsclassclass.protector.php]
FOUND AT 127

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
ERROR [512] mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ip='87.186.116.185' AND request_uri='/index.php'' at line ] in EXECUTE("SELECT ip FROM WHERE ip='87.186.116.185' AND request_uri='/index.php'")
FOUND IN [D:inetpubvhostsjoint-operations-server.dehttpdocsincludeopndb-errorhandler.php]
FOUND AT 240

CCED schrieb am 05.07.2007 um 00:09:40 Uhr folgendes:

Hallo,
tija, als ob ich es geahnt hätte...
ich habe von 2.4.2 auf 243 ->244 ->245 upgedatet. bis dahin alles OK, dann kam ->246 und 247. und nun..... geht garnichts mehr !

kann man die Updates irgendwie rückgänbgig machen ?

wenn du zwischen den schritten auch autoupdate hast laufen lassen sollte ja die 244 bei dir noich gegangen sein. also ne full version von 244 sollte da helfen