Advertisement:

Author Topic: Connection problems again! (GoDaddy Host)  (Read 4651 times)

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Connection problems again! (GoDaddy Host)
« on: December 29, 2017, 02:00:15 PM »
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.

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,861
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Connection problems again! (GoDaddy Host)
« Reply #1 on: December 29, 2017, 02:08:57 PM »
If that is a complete list of the tables in your DB, then you are missing most of them.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #2 on: December 29, 2017, 02:19:01 PM »
That doesn't seem good! What else should I have? phpMyAdmin shows:


Table   Action   RecordsTip   Type   Collation   Size   Overhead
   smf_attachments   Browse    Structure   Search    Insert   Empty    Drop   2,092   MyISAM   latin1_swedish_ci   231.1 KiB   -
   smf_ban_groups   Browse    Structure   Search    Insert   Empty    Drop   20   MyISAM   latin1_swedish_ci   2.6 KiB   -
   smf_ban_items   Browse    Structure   Search    Insert   Empty    Drop   9   MyISAM   latin1_swedish_ci   3.2 KiB   -
   smf_boards   Browse    Structure   Search    Insert   Empty    Drop   7   MyISAM   latin1_swedish_ci   7.1 KiB   -
   smf_board_permissions   Browse    Structure   Search    Insert   Empty    Drop   94   MyISAM   latin1_swedish_ci   5.9 KiB   -
   smf_calendar   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   latin1_swedish_ci   1.0 KiB   -
   smf_calendar_holidays   Browse    Structure   Search    Insert   Empty    Drop   167   MyISAM   latin1_swedish_ci   11.0 KiB   -
   smf_categories   Browse    Structure   Search    Insert   Empty    Drop   3   MyISAM   latin1_swedish_ci   2.1 KiB   -
   smf_collapsed_categories   Browse    Structure   Search    Insert   Empty    Drop   23   MyISAM   latin1_swedish_ci   2.2 KiB   -
   smf_log_actions   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   latin1_swedish_ci   1.0 KiB   -
   smf_log_activity   Browse    Structure   Search    Insert   Empty    Drop   3,973   MyISAM   latin1_swedish_ci   166.2 KiB   -
   smf_log_banned   Browse    Structure   Search    Insert   Empty    Drop   494   MyISAM   latin1_swedish_ci   26.0 KiB   -
   smf_log_boards   Browse    Structure   Search    Insert   Empty    Drop   875   MyISAM   latin1_swedish_ci   22.5 KiB   -
   smf_log_errors   Browse    Structure   Search    Insert   Empty    Drop   246,176   MyISAM   latin1_swedish_ci   65.0 MiB   -

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,861
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Connection problems again! (GoDaddy Host)
« Reply #3 on: December 29, 2017, 02:26:03 PM »
Been a while since I've played around with 1.1 databases, but I think there should be some 40 tables all together.

Something like this

smf_attachments           
smf_ban_groups           
smf_ban_items           
smf_boards   
smf_board_permissions           
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           
smf_log_floodcontrol           
smf_log_karma           
smf_log_mark_read           
smf_log_notify           
smf_log_online
smf_log_polls           
smf_log_search_messages           
smf_log_search_results           
smf_log_search_subjects           
smf_log_search_topics           
smf_log_topics           
smf_membergroups           
smf_members
smf_messages           
smf_message_icons           
smf_moderators           
smf_package_servers           
smf_permissions           
smf_personal_messages           
smf_pm_recipients           
smf_polls           
smf_poll_choices           
smf_sessions           
smf_settings           
smf_smileys           
smf_themes           
smf_topics           
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #4 on: December 29, 2017, 02:34:19 PM »
I have another similar car club forum which still works. That has 23 tables which while more than the 14 in the non-working forum is a lot less than the 40 you are suggesting.

   Table   Action   RecordsTip   Type   Collation   Size   Overhead
   smf_attachments   Browse    Structure   Search    Insert   Empty    Drop   4,434   MyISAM   utf8_general_ci   447.3 KiB   -
   smf_ban_groups   Browse    Structure   Search    Insert   Empty    Drop   67   MyISAM   utf8_general_ci   3.8 KiB   -
   smf_ban_items   Browse    Structure   Search    Insert   Empty    Drop   67   MyISAM   utf8_general_ci   4.6 KiB   -
   smf_boards   Browse    Structure   Search    Insert   Empty    Drop   9   MyISAM   utf8_general_ci   7.6 KiB   -
   smf_board_permissions   Browse    Structure   Search    Insert   Empty    Drop   162   MyISAM   utf8_general_ci   10.4 KiB   -
   smf_calendar   Browse    Structure   Search    Insert   Empty    Drop   13   MyISAM   utf8_general_ci   5.3 KiB   -
   smf_calendar_holidays   Browse    Structure   Search    Insert   Empty    Drop   185   MyISAM   utf8_general_ci   11.5 KiB   -
   smf_categories   Browse    Structure   Search    Insert   Empty    Drop   1   MyISAM   utf8_general_ci   2.0 KiB   -
   smf_collapsed_categories   Browse    Structure   Search    Insert   Empty    Drop   26   MyISAM   utf8_general_ci   2.2 KiB   -
   smf_log_actions   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_activity   Browse    Structure   Search    Insert   Empty    Drop   1,054   MyISAM   utf8_general_ci   49.4 KiB   -
   smf_log_banned   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_boards   Browse    Structure   Search    Insert   Empty    Drop   2,023   MyISAM   utf8_general_ci   81.7 KiB   -
   smf_log_errors   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_floodcontrol   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_karma   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_mark_read   Browse    Structure   Search    Insert   Empty    Drop   204   MyISAM   utf8_general_ci   11.8 KiB   -
   smf_log_notify   Browse    Structure   Search    Insert   Empty    Drop   990   MyISAM   utf8_general_ci   27.7 KiB   -
   smf_log_online   Browse    Structure   Search    Insert   Empty    Drop   2   MyISAM   utf8_general_ci   4.5 KiB   -
   smf_log_polls   Browse    Structure   Search    Insert   Empty    Drop   87   MyISAM   utf8_general_ci   4.7 KiB   -
   smf_log_search_messages   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_search_results   Browse    Structure   Search    Insert   Empty    Drop   0   MyISAM   utf8_general_ci   1.0 KiB   -
   smf_log_search_subjects   Browse    Structure   Search    Insert   Empty    Drop   11,809   MyISAM   utf8_general_ci   478.1 KiB   -
23 table(s)   Sum   21,133   MyISAM   latin1_swedish_ci   1.1 MiB   0 B

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #5 on: December 29, 2017, 02:36:55 PM »
Wouldn't a lack of database tables produce a different error? e.g. table 'smf_xyz' not found?
The error "Unable to connect to the database" implies to me that the SMF software cannot get to any tables rather than looking for missing ones. The MySQL.php successfully connect to the database and lists the available 13 tables.


Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,861
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Connection problems again! (GoDaddy Host)
« Reply #6 on: December 29, 2017, 02:39:25 PM »
That DB really shouldn't work if that is all it has in it. It is missing all the actual content, members,  topics, posts...  Are these on the same server?
Or at least the same host? If so, my first guess would be they are having issues....
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #7 on: December 29, 2017, 02:49:48 PM »
The 23 table SMF forum works fine. Have a look at it at www.131mirafiori.com/smf  (let me know if you register and I'll approve your account).

Both my car club forums are with the same host (GoDaddy) but they are on different servers.


Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,861
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Connection problems again! (GoDaddy Host)
« Reply #8 on: December 29, 2017, 02:54:55 PM »
I believe it works, and I can see it works, but still it doesn't change the fact that those database structures are incomplete, and shouldn't work.
Something is wrong somewhere, and I would point my finger towards the host.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #9 on: December 29, 2017, 02:58:04 PM »
........ and I would point my finger towards the host.

That's what I've been doing for about the last week since the forum stopped working :-(
I've worn out all my fingers by the amount of pointing but they keep saying "Nothing wrong our end, it's your problem" :-(

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 49,265
Re: Connection problems again! (GoDaddy Host)
« Reply #10 on: December 29, 2017, 03:04:24 PM »
can you ask them to restore a backup from before the site went down?

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,861
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Connection problems again! (GoDaddy Host)
« Reply #11 on: December 29, 2017, 03:05:16 PM »
Perhaps ask them to make a database dump for you - you can then compare the contents of it to the view you have in PhpMyAdmin.
If they differ, you have a tool against your host. If they are identical, you have a mystery.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #12 on: December 29, 2017, 03:07:37 PM »
can you ask them to restore a backup from before the site went down?

I've already asked that and they said they will restore a backup if I pay them $149.99 :-( and I certainly don't want to do that!

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #13 on: December 29, 2017, 03:09:43 PM »
Perhaps ask them to make a database dump for you - you can then compare the contents of it to the view you have in PhpMyAdmin.
If they differ, you have a tool against your host. If they are identical, you have a mystery.

I'm not sure I fully understand that. How could a database dump by the host not match the view I have in phpMyAdmin? Wouldn't the dump and the phpMyAdmin view come from the same database?

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 49,265
Re: Connection problems again! (GoDaddy Host)
« Reply #14 on: December 29, 2017, 03:10:20 PM »
then you dont have any other option, once you decide what you want to do find a new host as they should not charge you to restore a backup.

Offline Aleksi "Lex" Kilpinen

  • Support Specialist
  • SMF Super Hero
  • *
  • Posts: 16,861
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • aleksi-kilpinen on LinkedIn
Re: Connection problems again! (GoDaddy Host)
« Reply #15 on: December 29, 2017, 03:12:45 PM »
Perhaps ask them to make a database dump for you - you can then compare the contents of it to the view you have in PhpMyAdmin.
If they differ, you have a tool against your host. If they are identical, you have a mystery.

I'm not sure I fully understand that. How could a database dump by the host not match the view I have in phpMyAdmin? Wouldn't the dump and the phpMyAdmin view come from the same database?

I am thinking that you are not seeing the full contents of the database for some reason, while your host has different methods of accessing it directly.
Also, if the dump is whole - you get a backup ;)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #16 on: December 29, 2017, 03:13:38 PM »
then you dont have any other option, once you decide what you want to do find a new host as they should not charge you to restore a backup.

My current hosting plan with GoDaddy is up for renewal on 20/01/2018 so moving to a different host is very much an option. But how do I move the database to a new host? Do I use phpMyAdmin to export everything and then import it to the new host's database server?

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 49,265
Re: Connection problems again! (GoDaddy Host)
« Reply #17 on: December 29, 2017, 03:19:36 PM »
if your new host is a good one, they will migrate everything over for you.

Offline Thotos

  • Semi-Newbie
  • *
  • Posts: 42
  • Gender: Male
Re: Connection problems again! (GoDaddy Host)
« Reply #18 on: December 29, 2017, 03:21:55 PM »
if your new host is a good one, they will migrate everything over for you.

Any recommendations?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,434
    • Arantor on GitHub
Re: Connection problems again! (GoDaddy Host)
« Reply #19 on: December 29, 2017, 03:23:00 PM »
Something is wrong here.

Either those 23 tables aren't the full story and there are hidden tables, or the forum isn't as functional as claimed (on the basis that there is no members, no messages and no topics table)

There isn't, say, a 'next page' button or a page dropdown or similar?
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

You either die a hero or live long enough to see yourself become the villain. It seems you have chosen which, and now I must do the same.