FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Initiating mysql_connect (v.2.7.3)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Initiating mysql_connect (v.2.7.3) [message #28616] Wed, 02 November 2005 11:20 Go to next message
Nick Fedchik is currently offline  Nick Fedchik   Ukraine
Messages: 9
Registered: November 2005
Location: Ukraine
Karma: 0
Junior Member
Hello! I'm newbie admin of fudforum.
Two days ago I convert my forum from phpBB to FUDForum 2.7.3
But I see a long timings when I try open last message in thread and some time it happends just occasionally.

Error Log Browser showed me some errors, two typical error descriptions showed below:
(/usr/local/apache/htdocs/hosting/www.k31.kiev.ua/htdocs/fud/index.php:20
) :
Query: Initiating mysql_connect
_GET: array ( 't' => 'thread', 'frm_id' => '12', 'S' => '2c2b442d126471732f8ee9e25908c749', )
Server Version: Unknown
[Referring Page] http://www.k31.kiev.ua/fud/index.php?t=index&S=2c2b442d126471732f8ee9e25908c749


(/usr/local/apache/htdocs/hosting/www.k31.kiev.ua/htdocs/fud/include/theme/default/db.inc:17
/usr/local/apache/htdocs/hosting/www.k31.kiev.ua/htdocs/fud/include/core.inc:69
/usr/local/apache/htdocs/hosting/www.k31.kiev.ua/htdocs/fud/include/adm.inc:18
/usr/local/apache/htdocs/hosting/www.k31.kiev.ua/htdocs/fud/include/core.inc:63
/usr/local/apache/htdocs/hosting/www.k31.kiev.ua/htdocs/fud/adm/admglobal.php:14
) :
Query: Initiating mysql_connect
_GET: array ( 'S' => '2bb9317a83185a3e7da6a807d332e7e3', 'SQ' => '44b61312cffabdc5456babb384f7c5cc', )
Server Version: Unknown
[Referring Page] http://www.k31.kiev.ua/fud/index.php?S=2bb9317a83185a3e7da6a807d332e7e3&SQ=44b61312cffabdc5456babb384f7c5cc

System Configuration
PHP built On: Linux dc1 2.4.21-297-smp4G #1 SMP Sat Jul 23 07:55:00 UTC 2005 i686
Database Version: 4.0.15-log
PHP Version: 4.4.1
Web Server: Apache
WebServer to PHP interface: apache2handler
Forum Version: 2.7.3
Relavent PHP Settings:
Safe Mode: OFF
Display Errors: OFF
File Uploads: ON
Magic Quotes: OFF
Register Globals: OFF
Output Buffering: Yes
Disabled Functions: none
PSpell Support: No
Zlib Support: Yes


MySQL connection via localhost, same cases both for persistent and per-request connection type.
Is it bug or invalid configuration?
Re: Initiating mysql_connect (v.2.7.3) [message #28622 is a reply to message #28616] Wed, 02 November 2005 18:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
This is not a forum bug, it means that your database server was temporarily too busy to accept new connections.

FUDforum Core Developer
Re: Initiating mysql_connect (v.2.7.3) [message #28640 is a reply to message #28622] Thu, 03 November 2005 09:52 Go to previous messageGo to next message
Nick Fedchik is currently offline  Nick Fedchik   Ukraine
Messages: 9
Registered: November 2005
Location: Ukraine
Karma: 0
Junior Member
Agree.
But there is no delays when I try to open topic, but even each time I've long delays when click on shortcuts to last post (from main page, f.e.)
Also I worry about the
Server Version: Unknown

Re: Initiating mysql_connect (v.2.7.3) [message #28647 is a reply to message #28640] Thu, 03 November 2005 15:07 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
To get MySQL version it needs to connect, since it could not connect it could not fetch the database version.

FUDforum Core Developer
Re: Initiating mysql_connect (v.2.7.3) [message #28656 is a reply to message #28647] Thu, 03 November 2005 16:51 Go to previous messageGo to next message
Nick Fedchik is currently offline  Nick Fedchik   Ukraine
Messages: 9
Registered: November 2005
Location: Ukraine
Karma: 0
Junior Member
My local fresh fudforum installation doesn't showed any problems.

As I informed by my hosting sysadmin, sometime fudforum scripts processing keep all CPU time. This happend when I click on last posted message (in any topic) from forum front page. The problem doesnt happend in admin interface, or on a forums if I go to forum, then to any topic link, then to the first/numbered/last page link.

My suspicions to the results of phpBB export. Rolling Eyes

Don't know how to find a bottleneck... Any ideas?
Re: Initiating mysql_connect (v.2.7.3) [message #28661 is a reply to message #28656] Fri, 04 November 2005 00:00 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Unless your fresh install is running on the same machine it does not mean much.

FUDforum Core Developer
Re: Initiating mysql_connect (v.2.7.3) [message #28664 is a reply to message #28661] Fri, 04 November 2005 09:02 Go to previous message
Nick Fedchik is currently offline  Nick Fedchik   Ukraine
Messages: 9
Registered: November 2005
Location: Ukraine
Karma: 0
Junior Member
It isn't on saame machine, but I will try it today.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Group Manager ("groups_adm.inc" )
Next Topic: duplicate key
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 10:03:32 GMT 2024

Total time taken to generate the page: 0.03898 seconds