Welcome to Geeklog, Anonymous Saturday, September 07 2024 @ 08:32 pm EDT
Geeklog Forums
Help Please
Status: offline
jackknyc
Forum User
Regular Poster
Registered: 12/08/03
Posts: 88
HI.
When I try to open my admin page I get this message: Fatal error: Maximum execution time of 30 seconds exceeded in /usr/www/users/jackknyc/geeklog/system/classes/template.class.php on line 499
My .
When Iasked for help they sent me this email:
Thank you in advance,
Jack K
When I try to open my admin page I get this message: Fatal error: Maximum execution time of 30 seconds exceeded in /usr/www/users/jackknyc/geeklog/system/classes/template.class.php on line 499
My .
When Iasked for help they sent me this email:
Thank you in advance,
Jack K
7
10
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
My spontaneous guess would be that you have a lot of submissions (probably spam) and it takes so long to display them all that you run into the timeout that your hosting service imposes for PHP scripts.
Check your database in phpMyAdmin (or whatever's handy) and see if you have a large number of entries in the gl_eventsubmission, gl_linksubmission, and/or gl_storysubmission tables.
If so, you will have to remove them there (i.e. directly from the database). You may also pick a few obvious keywords or URLs from those submissions and feed Spam-X's Personal Blacklist with them.
bye, Dirk
Check your database in phpMyAdmin (or whatever's handy) and see if you have a large number of entries in the gl_eventsubmission, gl_linksubmission, and/or gl_storysubmission tables.
If so, you will have to remove them there (i.e. directly from the database). You may also pick a few obvious keywords or URLs from those submissions and feed Spam-X's Personal Blacklist with them.
bye, Dirk
11
8
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
As I was just looking into this - here's a quick and dirty workaround. In admin/moderation.php find this piece of code (search for the "run SQL" comment):
if (!empty ($sql)) {
$sql .= ' LIMIT 50'; // <-- add this line
$result = DB_query($sql, 1);
}
That will ensure that only 50 submissions will be requested at once, preventing the timeout. You can then use the first column in the submission queues to select and delete all the entries. It will then display the next 50 entries, and so on.
Just an alternative for those who don't want to mess around in the database ...
bye, Dirk
Text Formatted Code
// run SQL but this time ignore any errorsif (!empty ($sql)) {
$sql .= ' LIMIT 50'; // <-- add this line
$result = DB_query($sql, 1);
}
That will ensure that only 50 submissions will be requested at once, preventing the timeout. You can then use the first column in the submission queues to select and delete all the entries. It will then display the next 50 entries, and so on.
Just an alternative for those who don't want to mess around in the database ...
bye, Dirk
10
8
Quote
Jackknyc
Anonymous
Thanks Ditk,
That's agreat help
That's agreat help
11
11
Quote
All times are EDT. The time is now 08:32 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content