SQL error
FIXED- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- SQL error
01-04-2019 10:21 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I have a small forum (2 users) on my ccgi webspace.
At some point last week it started not loading, instead presenting the error
General Error
Unknown database 'twinnies_ccgigeehaw671788' [1049]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I thought it might just be a short term glitch but as of a few minutes ago this error is still presenting itself.
I have not changed anything for months regarding this forum, and on checking MySQL manager it shows the database as being available.
My non ccgi website is loading normally.
Has anything changed server side that may be causing this, it would not be the first time ….
Fixed! Go to the fix.
Re: SQL error
01-04-2019 10:53 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hey @geehawk,
Thanks for getting in touch with us.
I have checked over your account and can see all domains are active and up to date. Could you specify which domain you are having trouble with?
Thank you.
Re: SQL error
01-04-2019 12:00 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
http://www.theclubman.co.uk/forum.htm is the link to the ccgi forum page which is throwing up the error.
The base website/domain is working fine.
Re: SQL error
01-04-2019 12:34 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks for getting back to us with that information @geehawk.
So I have just taken a look over the link you've posted above, everything seems to be working on your main website apart from the forums. Is there anything that you have changed on the website i.e. coding different? Have you updated the web page recently?
Thanks
Re: SQL error
01-04-2019 12:34 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I wonder if Hostopia have been tinkering with things, because my WordPress site has recently stopped working. I'm getting an Internal Server Error in Internet Explorer and an 'Error establishing a database connection' in Chrome. I'm going to check some files over this evening in case a Wordpress auto-update has messed up.
I believe phpBB has a config.php file. It may be worth you checking yours with a text editor to make sure the database location and login credentials are still correct.
Re: SQL error
01-04-2019 12:39 PM - edited 01-04-2019 12:41 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Re: SQL error
01-04-2019 5:15 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Re: SQL error
01-04-2019 5:43 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
The config file looks fine to me.
Re: SQL error
01-04-2019 6:12 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Re: SQL error
03-04-2019 10:25 AM - edited 03-04-2019 10:27 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'm beginning to suspect my database has gone AWOL as others have reported. (I am very much a novice at this)
Although SQL Manager shows it as an available database I cannot login to it from the manager, should have tried that the other day but I assumed if it was listed it must be there...
Also the databases folder contains a folder with the relevant name but that folder is empty?
Re: SQL error
03-04-2019 10:47 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'm seeing the same, so you are not the only one.
We have a "backup" server so just moved across to that
Re: SQL error
05-04-2019 7:05 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Any updates on this?
Re: SQL error
05-04-2019 10:38 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hi @geehawk
I've bumped the ticket that @MatthewWheeler sent to the Net Ops team.
Apologies for the time this is taking, but thanks for the continued patience you are showing.
Kind Regards,
Alisdair
Re: SQL error
05-04-2019 4:23 PM - edited 05-04-2019 4:26 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@MasterOfReality & @MatthewWheeler
I've just been notified that the ticket has been closed.
I see that our networks team are investigating this as part of the forum thread you have created. This is the best to place to keep this as our community and more experienced agents will be looking at this.
Therefore, not to complicate matters, I will close this ticket in favor of the forum.
Kind regards,
David Hough
As far as I can tell the only investigations that may or not be taking place are as a direct result of the ticket being raised. I suspect that the closing of the ticket will in fact result in even less action than I've seen this week, given that the staff in this thread were using that ticket to chase up this issue.
Can you tell my patience is running out
Re: SQL error
05-04-2019 4:34 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page