xx Re: GoDaddy Upgrade from 2GH to 4GH Linux Hosting Caused Database Connection Error

January 14, 2018, 12:25:05 AM by zorproducts
Has anyone had any success fixing this issue? I just lost my 12 year old 4x4 offroad forum. I am not getting anywhere with GD.

MY
3 comments | Write Comment

xx Help with Banner

January 07, 2018, 01:43:18 AM by The Prole
Hi, I've been asked to update a Banner on our forum.

I read this page from the support section.
Quote
Many themes provide an easy way to show a custom logo or banner for your site. All you need to do is to upload the image file (you can use cpanel or ftp), note the URL, and tell the theme to use that URL. You may want to test your desired logo or banner on a test version of your site, to see if it is compatible with your theme.

Upload your logo/banner to your desired location by using ftp or a method provided by your host. A good place to have the file hosted is the root of your forum (or an images folder there). Note where it is, and obtain its URL.

Login to your forum and go to Admin > Configuration > Current Theme
In the text input labeled Logo image URL:, enter the URL you copied earlier.
Select the Save button to save your change.

Our site uses the Starcraft 2 theme.
Does the image file have to go in the Root Directory? I've been given admin rights to help set this up, but don't have access to the host or cPanel.
Is there any way I could use a third party image site, and paste that URL into the 'LOGO IMAGE URL' box.
I tried it already, but nothing updated.
I then tried experimenting with the code in Sc2.css. I managed to remove the old banner, but couldn't get it to see the new one. I put that code back to the previous state when finished.
Is there something I can put in to make it use a third party URL, like from IMGBB?

Thank you in advance for taking the time to help.
12 comments | Write Comment

sad GoDaddy Upgrade from 2GH to 4GH Linux Hosting Caused Database Connection Error

January 02, 2018, 12:34:15 AM by andrei23
 
Hello all you amazing SMF Wizards!  I need your help!!

GoDaddy just migrated from 2GH Linux hosting to 4GH Linux Hosting and my SMF forum went down.. 12+ years of content and conversation, gone in a poof I had no control over.  Reeeeeeally hopeful someone knows how to get it back online.    :'(

SimpleMachines 1.1.21 is known to have issues with php 5.6, so I downgraded to 5.4 (last time it worked was 5.2 under 2GH). PHP 5.4 supposedly works with SMF 1.1.21 - does it not?

Could a CHMOD perhaps be needed because 4GH defaults for files and folders may be different then they were under 2GH?  Or would those not change as a result of the upgrade? I made amazing progress just by doing a Save As on a file in UTF-8 instead of ANSI as you'll see below, so I've learned not to overlook the simple stuff.

Oh, and I would prefer NOT to upgrade to SMF 2.0.x if at all poss and lose all custom mods - plus I keep reading about nothing but problems with this upgrade if not done from within SMF, which is unfortunately no longer an option.

Forum link: http://www.fx-knight.com/smForum/index.php


Error we are getting:

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.


Their tech suspected the issue might be the syntax of the $db_server path in the settings.php file..

Used to be:
dbname.db.3857732.hostedresource.com

GoDaddy suggested new ones to try are:
grid55mysql277.secureserver.net
shr.prod.phx3.secureserver.net

But.. perhaps unlike WordPress, Simple Machines likes db name to be part of the path as it was originally?
What would be the correct syntax starting with dbname.. and ending with ..secureserver.net?

(This is something that seems to be SMF-specific, what it likes to see here, so the GoDaddy tech didn't want to assume that what works for Word Press would also work for SMF.)


Next, we noticed the settings.php file was being saved as ANSI
Changing to encoding to UTF-8 and doing a Save As generated the following:

Warning: Cannot modify header information - headers already sent by (output started at /home/content/32/3857732/html/_fxK2/smForum/Settings.php:1) in /home/content/32/3857732/html/_fxK2/smForum/Sources/Subs-Auth.php on line 346

Warning: Cannot modify header information - headers already sent by (output started at /home/content/32/3857732/html/_fxK2/smForum/Settings.php:1) in /home/content/32/3857732/html/_fxK2/smForum/Sources/Subs-Auth.php on line 347

Warning: Cannot modify header information - headers already sent by (output started at /home/content/32/3857732/html/_fxK2/smForum/Settings.php:1) in /home/content/32/3857732/html/_fxK2/smForum/Sources/Subs-Auth.php on line 348

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.


These are the lines of code in question from /Sources/Subs-Auth.php:

   // Don't cache this page!
   header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
   header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
   header('Cache-Control: no-cache');


So... could it be that 4GH doesn't like the date format 2GH used to use on the headers?
Although.. the error above seems to suggest we already have headers coming from elsewhere?

Really hopeful this gives someone out there a lead on what is causing the database connection error..


Here are the contents of the settings.php file:

########## Forum Info ##########
$mbname = 'fxKnight';      # The name of your forum.
$language = 'english';      # The default language file set for the forum.
$boardurl = 'http://fx-knight.com/smForum';      # URL to your forum's folder. (without the trailing /!)
$webmaster_email = 'support@fxKnight.com';      # Email address to send emails from. (like noreply@yourdomain.com.)
$cookiename = 'fxKnight923';      # Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'dbname.db.3857732.hostedresource.com';
$db_name = 'dbname';
$db_user = 'user';
$db_passwd = 'password';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = '/home/content/32/3857732/html/_fxK2/smForum';      # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = '/home/content/32/3857732/html/_fxK2/smForum/Sources';      # Path to the Sources directory.

 

Any help would be GREATLY appreciated, and I cannot tell you in words how grateful I am for your knowledge & expertise!

-=Andrei 

19 comments | Write Comment

solved Connection problems again! (GoDaddy Host)

December 29, 2017, 02:00:15 PM by Thotos
I have once again started getting connection errors when trying to connect to my forum at www.lanciagammaforum.com

"Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."

I am sure I am using correct setting in Settings.php as I can connect to the database using phpMyAdmin or mysql.php in the home directory of my server using the same credentials and server details as in Settings.php.

"Here is a list of the tables in your database:
- gam073502302533
\ _ _ smf_attachments
\ _ _ smf_ban_groups
\ _ _ smf_ban_items
\ _ _ smf_board_permissions
\ _ _ smf_boards
\ _ _ smf_calendar
\ _ _ smf_calendar_holidays
\ _ _ smf_categories
\ _ _ smf_collapsed_categories
\ _ _ smf_log_actions
\ _ _ smf_log_activity
\ _ _ smf_log_banned
\ _ _ smf_log_boards
\ _ _ smf_log_errors

The connection to "gam073502302533" was successful!
PHP extension used: MySQLi
Server Name: p3nlhg136"

I'm fairly sure the problem is with GoDaddy shared hosting but I can't convince them of this and they insist the problem is with my forum software.

Any suggestions or recommendations for what to do now? I tried upgrading my 1.1.20 forum to 2.0.15 and to 2.1.Beta3 but in both cases I received errors which I didn't understand so I reloaded my forum backup taken before the upgrade.

What's the easiest way of moving the database to a different server? I have another hosting account with Netfirms so I thought since I can't convince GoDaddy to migrate my database I may try moving it myself but not sure what's the best (easiest?) way to do this.

Any suggestions or help will be much appreciated.
44 comments | Write Comment

xx Fatal error: Function name must be a string

December 13, 2017, 10:56:20 AM by serge06
Hi, I am trying to upgrade from a very old SMF 1.115 to the latest, followed the upgrade procedure, when trying to access the upgraded.php for the first time get: Fatal error: Function name must be a string in /upgrade.php on line 859

Line 859 is a "perfect string":
   // Load the modSettings data...
      $request = $smcFunc['db_query']('', '

Please help.
23 comments | Write Comment