Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (SteveS), 29 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 105
Top Posters (30 Days)
Ruben 49
Gizmo 24
DennyP 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#169097 - 11/26/06 12:07 AM upgrade.php error
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
I'm upgrading from 7.0 to 7.0.2 and get the following message on running the upgrade.php script:

Code:
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?


_________________________
Okusi Associates -- Indonesian business and management services
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#169101 - 11/26/06 12:28 AM Re: upgrade.php error [Re: Okusi]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
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 ...
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169103 - 11/26/06 12:56 AM Re: upgrade.php error [Re: Okusi]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#169104 - 11/26/06 12:57 AM Re: upgrade.php error [Re: Okusi]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
Do you have phpMyAdmin installed?
_________________________
--BIll B
Top
#169106 - 11/26/06 01:04 AM Re: upgrade.php error [Re: Rick]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
Originally Posted By: Rick
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?
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169107 - 11/26/06 01:19 AM Re: upgrade.php error [Re: Okusi]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Quote:
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
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#169109 - 11/26/06 01:23 AM Re: upgrade.php error [Re: Gizmo]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
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 \:\(
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169111 - 11/26/06 01:26 AM Re: upgrade.php error [Re: Okusi]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Originally Posted By: KuKuKaChu
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
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#169113 - 11/26/06 01:28 AM Re: upgrade.php error [Re: Gizmo]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
this is all includes/config.inc.php contains:

Code:
<?php
$config = array ();
?>
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169114 - 11/26/06 01:31 AM Re: upgrade.php error [Re: Okusi]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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?
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#169116 - 11/26/06 01:35 AM Re: upgrade.php error [Re: Gizmo]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
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
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169117 - 11/26/06 01:38 AM Re: upgrade.php error [Re: Okusi]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
run install.php to the "create yoru admin user" screen and you should be safe, from there run upgrade.php.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#169118 - 11/26/06 02:07 AM Re: upgrade.php error [Re: Gizmo]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
i seem to have got my system back \:\) .... a few pieces have fallen off, but it's largely intact.

thanks!
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169119 - 11/26/06 02:20 AM Re: upgrade.php error [Re: Okusi]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
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??


Edited by KuKuKaChu (11/26/06 02:39 AM)
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169121 - 11/26/06 02:42 AM Re: upgrade.php error [Re: Okusi]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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 http://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.
Top
#169122 - 11/26/06 03:28 AM Re: upgrade.php error [Re: Rick]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
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 ;\)
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169133 - 11/26/06 05:20 AM Re: upgrade.php error [Re: Okusi]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
haha, but even Rick buggers his config file ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#169140 - 11/26/06 06:46 AM Re: upgrade.php error [Re: Gizmo]
Okusi Offline
member
Registered: 06/05/06
Posts: 163
Loc: Jakarta, Indonesia
a perhaps unrelated problem: i am unable to use the language editor.

/forums/admin/languageeditor.php comes up completely blank.
_________________________
Okusi Associates -- Indonesian business and management services
Top
#169162 - 11/26/06 03:38 PM Re: upgrade.php error [Re: Okusi]
AllenAyres Offline

Registered: 12/29/03
Posts: 1995
Loc: Texas
re-upload that file and the associated template for it.
_________________________
- Allen
- ThreadsDev | PraiseCafe
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
Yesterday at 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image