catalyst2 community forums  

Go Back   catalyst2 community forums > Support > Database Support

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old 15-04-2006, 06:28 PM   #1 (permalink)
Registered User
 
Waldovia PM's Avatar
 
Join Date: Jul 2003
Location: West Midlands
Posts: 188
Maximum execution time

I don't know if this is a problem with phpBB or Catalyst so if anyone can assist I would appreciate it.

For the past 3 versions of phpBB (including the latest 2.0.20) I have been unable to delete more than one post at a time without getting a 'time-out' error.

Quote:
Fatal error: Maximum execution time of 30 seconds exceeded in d:\domains\aer-net.co.uk\wwwroot\phpBB2\db\msaccess.php on line 176
Also, (and I don't know if this is connected or not) new members have been unable to register for the same amount of time.

Quote:
SQL Error : Error

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (109, 'Raider', 1142880625, '6051427dcaed97e34d600be7f9ac8bb1', 'test@mydomain.co.uk', '', '', 'occupation', 'where I live', 'my interests', 'fd65748742', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'english', 1, 0, 1, 0, '3d03d4cbc85')

Line : 637
File : usercp_register.php
I hope I haven't posted anything useful to spammers there.

Any suggestions? Please.
__________________
cat4um AT aer-net.co.uk - Cat2 Helpdesk
Waldovia PM is offline   Reply With Quote
Old 15-04-2006, 06:30 PM   #2 (permalink)
Administrator
 
Jacob's Avatar
 
Join Date: May 2003
Posts: 1,299
Have you checked this out of the phpbb support forums?
Jacob is offline   Reply With Quote
Old 15-04-2006, 06:46 PM   #3 (permalink)
Registered User
 
Waldovia PM's Avatar
 
Join Date: Jul 2003
Location: West Midlands
Posts: 188
I've tried that a couple of times.
First time (a week or so ago) the search freezes, second time (yesterday) it gave me page one of hundreds and then wouldn't go to the next page.
Also, I can't get it to search on more than one word, even though there is facility to do this.

I've tried searching on all the relevant words 'maximum', 'execution' etc.
I've gone through hundreds of pages (in date order) trying to find something similar to my problem without result.

The only thing I haven't done is submit a querry but I notice a lot of querries go unanswered.
If I knew for certain it was phpBB at fault and not some setting at Catalyst I could persevere with that line.
__________________
cat4um AT aer-net.co.uk - Cat2 Helpdesk
Waldovia PM is offline   Reply With Quote
Old 15-04-2006, 06:51 PM   #4 (permalink)
Registered User
 
Waldovia PM's Avatar
 
Join Date: Jul 2003
Location: West Midlands
Posts: 188
Forgot to mention:
This is a default setup of phpBB, i.e. there are no midifications.
In the process up upgrading, both those files mentioned in the errors have been replaced.
__________________
cat4um AT aer-net.co.uk - Cat2 Helpdesk
Waldovia PM is offline   Reply With Quote
Old 15-04-2006, 07:15 PM   #5 (permalink)
Registered User
 
Waldovia PM's Avatar
 
Join Date: Jul 2003
Location: West Midlands
Posts: 188
Line : 176
File : msaccess.php
Code:
$this->result = odbc_exec($this->db_connect_id, $query);
Line : 637
File : usercp_register.php
Code:
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
__________________
cat4um AT aer-net.co.uk - Cat2 Helpdesk
Waldovia PM is offline   Reply With Quote
Old 23-04-2006, 11:03 PM   #6 (permalink)
Registered User
 
Waldovia PM's Avatar
 
Join Date: Jul 2003
Location: West Midlands
Posts: 188
I still don't know where I should be looking to try and solve this so I have also asked the same question on the phpBB forum.
__________________
cat4um AT aer-net.co.uk - Cat2 Helpdesk
Waldovia PM is offline   Reply With Quote
Old 29-04-2006, 05:57 PM   #7 (permalink)
CAT5082
 
aMike's Avatar
 
Join Date: Jul 2004
Location: England, North Wales
Posts: 91
dont know about php but on asp its:
<httpRuntime executionTimeout="xxxxx" bla
__________________
Server 2003 sp1, AMD 64 3000+, Aopen, 1GB 400DDR RAM, GF4 ti 4400, Audigy 2, 2x160gig sata HD.
cat2 webserver: strawberry
isp: demon internet
ip: 80.177.1.17

www.idreams3d.net

www.walesdates.co.uk
aMike is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 12:33 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.