|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
I'm upgrading from 7.0 to 7.0.2 and get the following message on running the upgrade.php script:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/www/jakchat/forums/libs/mysql.inc.php on line 44
Fatal error: Call to undefined function: smartyprepare() in /home/www/jakchat/forums/libs/ubbthreads.inc.php on line 753
any suggestions?
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
don't know if this is related, but one of my administrators unwittingly reopened my board while it was upgrading. could this have left the database in an open state, thus causing the above problem?? and if so, how do i now close the database, keeping in mind that i no longer have access to the control panel ...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
From the error it looks like the MySQL server has actually died and not available. If this is still happening, then you should contact your host.
|
|
|
|
Joined: Oct 2006
Posts: 358
enthusiast
|
enthusiast
Joined: Oct 2006
Posts: 358 |
Do you have phpMyAdmin installed?
--BIll B
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
From the error it looks like the MySQL server has actually died and not available. If this is still happening, then you should contact your host. no, it's definately up. must be some other issue. could my mysql server setup options have been overwritten during the upgrade?? perhaps i've overwritten them?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/www/jakchat/forums/libs/mysql.inc.php on line 44 commonly when I see this error MySQL isn't running
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
according to my ISP customer support, they have no problem. indeed, they wrote a quick program on my system that connected. my mysql host is not localhost, but something else. could my host setting be overwritten during the copying of files or something? just speculating ... i've not nothing more to go on, and my users are clamouring
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
my mysql host is not localhost, but something else. could my host setting be overwritten during the copying of files or something? just speculating ... i've not nothing more to go on, and my users are clamouring You could check your includes/config.inc.php file and see what host yoru forum istrying to connect to
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
this is all includes/config.inc.php contains:
<?php
$config = array ();
?>
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
umm, this is in your forum directory right? cas it should contain a LOT more...
Did you follow the upgrade guide? Such as not overwriting your includes or cachebuilders directories?
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
i may have copied includes in a moment of distraction ... too many kids running around the office on sunday morning ... cachebuilders and styles were definately left alone
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
run install.php to the "create yoru admin user" screen and you should be safe, from there run upgrade.php.
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
i seem to have got my system back .... a few pieces have fallen off, but it's largely intact. thanks!
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
one of the things that has not yet come back is my shout box! it just stays blank, and won't accept posts.
may be unrelated, however my firefox debugger reports this error when my main page opens
uncaught exception: Permission denied to call method XMLHttpRequest.open
same problem in IE7.
do i need to replace a file that may ahve been overwritten??
Last edited by KuKuKaChu; 11/26/2006 3:39 AM.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
That sounds like a domain name issue. Normally you'll see this if you have your full url set to domain.com but you are visiting by www.domain.com, or vice versa. There are some security precautions with AJAX in that it will only allow you to use it on the exact domain you're currently on. Hopefully that makes a bit of sense.
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
yes, i found the problem. my configuration had lost the setting where i declared more than one domain (eg, http://www.jakchat.com|http://jakchat.com) that fixed that problem ... now for all the rest buggering up your configuration files is not recommended. you may wish be make a note of that in your documentation
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
haha, but even Rick buggers his config file
|
|
|
|
Joined: Jun 2006
Posts: 136
member
|
member
Joined: Jun 2006
Posts: 136 |
a perhaps unrelated problem: i am unable to use the language editor.
/forums/admin/languageeditor.php comes up completely blank.
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
re-upload that file and the associated template for it.
|
|
|
1 members (Ruben),
1,277
guests, and
207
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|