I dont know, it works for me. Can you run that query in phpMyAdmin and see what the real error is?

Update for anyone having problems with:

"Fatal error: Call to undefined function: htmlheader()"


Open modlog.php

search for this line
and remove it.


Thats it, that fixed it for me... I think for some reason even tho it was commented out php was parsing the semicolon. Not sure exactly, but removing that line fixed the problem for me.

Hope this helps anyone else having the same problem :)

Thanks! How bizarre it happens for 1% of the users.

How do I need to modify modlog.php to have an entry written into the adminlog whenever modlog.php is accessed?

Maybe one entry for just viewing the modlog, but more important: an entry whenever the modlog is pruned.

Hellburn,
Ok. I found the problem with why you were getting that SQL error...

Go to the line that you had to change so the clear logs would work..

When you put this :

<a href=\"$PHP_SELF?rt=".time()."&clearLogs=yes&showL imit=$showLimit';}\">CLEAR ALL LOGS</a>

Notice this part of the above code...

showLimit=$showLimit';}\">

It is missing a \"

It should look like this...

<a href=\"$PHP_SELF?rt=".time()."&clearLogs=yes&showL imit=\"$showLimit;}\">CLEAR ALL LOGS</a>

I highlighted what was missing..

Overgrow. you may want to update your post=))

Do you know why it won't show the to and from parts in the mod log? it doesn't record it??

Thank you this code does work.

mfg

Hellburn

no problem=)) wow.. i solved a problem.. my first one=) YAAAY! im happy=)

Fine, now what about my problem? :)

I don't know how it would look.. but i am guessing that you would have to look in the adminlog and look at how the settings are for how it views all the stuff. then add a similar thing to modlog.... thgat is my guess

I still dont' know how to fix my problem yet. .lol