Connection problems again! (GoDaddy Host)

Started by Thotos, December 29, 2017, 02:00:15 PM

Previous topic - Next topic

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.

Aleksi "Lex" Kilpinen

If that is a complete list of the tables in your DB, then you are missing most of them.
Slava
Ukraini!


"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

How you can help SMF

Thotos

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   -

Aleksi "Lex" Kilpinen

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           
Slava
Ukraini!


"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

How you can help SMF

Thotos

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

Thotos

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.


Aleksi "Lex" Kilpinen

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....
Slava
Ukraini!


"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

How you can help SMF

Thotos

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.


Aleksi "Lex" Kilpinen

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.
Slava
Ukraini!


"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

How you can help SMF

Thotos

Quote from: Aleksi "Lex" Kilpinen on December 29, 2017, 02:54:55 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" :-(

Illori

can you ask them to restore a backup from before the site went down?

Aleksi "Lex" Kilpinen

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.
Slava
Ukraini!


"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

How you can help SMF

Thotos

Quote from: Illori on December 29, 2017, 03:04:24 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!

Thotos

Quote from: Aleksi "Lex" Kilpinen 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.

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?

Illori

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.

Aleksi "Lex" Kilpinen

Quote from: Thotos on December 29, 2017, 03:09:43 PM
Quote from: Aleksi "Lex" Kilpinen 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.

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 ;)
Slava
Ukraini!


"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

How you can help SMF

Thotos

Quote from: Illori 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.

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?

Illori

if your new host is a good one, they will migrate everything over for you.

Thotos

Quote from: Illori on December 29, 2017, 03:19:36 PM
if your new host is a good one, they will migrate everything over for you.

Any recommendations?

Arantor

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?

Advertisement: