Get Paid to Participate - up to $1 per post!     Twitter     Facebook     Google+
Hosting Discussion
 

forgot password?



Reply


Old
  Post #1 (permalink)   05-23-2017, 11:14 AM
HD Newbie
 
Join Date: Aug 2015
Posts: 4

Status: davem is offline
I have a lot of issues since my host, namecheap.com switched from MySQL to mariadb.
One complete table was dropped in the changeover (newsfeeds)
since I have a testing site for new plug-ins. I just removed joomla and then installed again completely fresh.
Now, I still have a database error shown below.

Database schema version (in #__schemas): 3.7.0-2017-04-19.
Update version (in #__extensions): 3.7.2.
Database driver: mysqli.
145 database changes were checked successfully.
173 database changes did not alter table structure and were skipped.

I cannot enter and save an article or module. The save does not work.

Anybody else have a similar issue

I have requested the host go back to MySQL, but they are committed to maria and want no part of the issues.
I have many, many sites built on this host and this could put me in deep trouble.
I have a ton of sites on namecheap, and it will be a daunting task moving all of them
 
 


Old
  Post #2 (permalink)   05-23-2017, 12:24 PM
HD Newbie
 
Join Date: Jan 2012
Posts: 36

Status: krakenservers is offline
Does namecheap do backups? I believe it is a added cost right? Iv'e seen alot of terrible reviews with namecheap lately. Might be time to back your bags and find a new provider if mysql is necessary im sure you can find a few good deals in the offer section!
 
 
 


Old
  Post #3 (permalink)   05-24-2017, 01:03 PM
HD Newbie
 
Join Date: Apr 2017
Posts: 30

Status: WHGBTom is offline
Id have to agree, it may be time to find a host whichcan give you MySQL. Its a nightmare trying to move DBs across to different platforms, youll always end up with an error somewhere.
__________________
WebHostGB.com - Reseller, Shared, Dedicated & Hybrid
UK Based Web Hosting - 60 Day Money Back Guarantee - 100% SSD - 24/7 Support
Fully Inclusive & Managed UK Small Business Web Design & Hosting Services

cPanel/WHM | Domain & SSL Included | 24/7 UK Support | Transfers Included
 
 
 


Old
  Post #4 (permalink)   05-25-2017, 03:16 PM
HD Community Advisor
 
SenseiSteve's Avatar
 
Join Date: Mar 2009
Location: Saint Louis
Posts: 4,963
Send a message via MSN to SenseiSteve

Status: SenseiSteve is offline
Interesting. I think Namecheap works well for domains, but I too have seen a number of complaints recently about their services.
__________________
ProlimeHost- Dedicated Server Hosting & KVM SSD VPS
Three Datacenter Locations: Los Angeles, Denver & Singapore
SuperMicro Hardware | Multiple Bandwidth Providers | 24/7 On Site Engineers
 
 
 


Old
  Post #5 (permalink)   05-25-2017, 03:29 PM
HD Wizard
 
easyhostmedia's Avatar
 
Join Date: Mar 2011
Location: Northumberland, UK
Posts: 4,989
Send a message via MSN to easyhostmedia

Status: easyhostmedia is offline
They are good at domains, just like 123-reg, but hopeless at anything else.
even with SSL certificates, they are find when you first purchase one, but always messes up renewals ( which comodo have admitted to me when they messed up a couple of mine), but Comodo wont do anything as they are their biggest distributor
__________________
Terry Robertson - CEO The Easyhost Media Group
Niceday Hosting - Affordable Hosting
PowerSSL - - We Secure your World
The Scamlist Forum - Fighting against scammers
 
 
 


Old
  Post #6 (permalink)   05-26-2017, 04:20 PM
HD Newbie
 
Join Date: Apr 2017
Posts: 30

Status: WHGBTom is offline
Quote:
Originally Posted by easyhostmedia View Post
They are good at domains, just like 123-reg, but hopeless at anything else.
even with SSL certificates, they are find when you first purchase one, but always messes up renewals ( which comodo have admitted to me when they messed up a couple of mine), but Comodo wont do anything as they are their biggest distributor
Doesn't sound good! nothing more annoying then having to sort out expired SSLs or anything else like that
__________________
WebHostGB.com - Reseller, Shared, Dedicated & Hybrid
UK Based Web Hosting - 60 Day Money Back Guarantee - 100% SSD - 24/7 Support
Fully Inclusive & Managed UK Small Business Web Design & Hosting Services

cPanel/WHM | Domain & SSL Included | 24/7 UK Support | Transfers Included
 
 
 


Old
  Post #7 (permalink)   05-28-2017, 07:28 AM
HD Community Advisor
 
ughosting's Avatar
 
Join Date: Jan 2011
Location: London
Posts: 607

Status: ughosting is offline
We upgraded from MySQL 5.7 to MariaDB 10.1 way back when.

Having copied the user accounts from three live machines into a test lab machine and then running the migration scripts we had no issues.
When doing it on the live servers we had 2 machines with minor hiccups but no data was ever lost, and the additional downtime did not exceed SLA allowances.

Also as we knew this was a database upgrade, so we had dumped all of the database data (user by user, using a script) before starting the migrations. Just in case disaster struck.

It's possible the Namecheap did the same, it's inexcusable not to have done so.

I'm not sure how much time has past, but you might be able to ask for the dumps.

However, I'm sure that if you have frequented this site long enough, it will have been pointed out that customers are usually required to keep their own backups. (We back up all data every hour, keeping 3 months of backups, but we still require the customer to keep their own regular off-site backups).

It would be interesting to hear how you get on.
__________________
DDoS Protected, LiteSpeed + LiteMage on CloudLinux with SSD Disks, R1Soft, Softaculous, SIteBuilder, BitNinja, LetsEncypt & Patchman
UnixGuru: Accounts with 1-16 CPU Cores, 2-32GB RAM. Why use a VPS?
█ Choose from Shared, Reseller and Elastic-Sites Hosting
 
 
 


Old
  Post #8 (permalink)   05-28-2017, 08:07 AM
HD Addict
 
webling's Avatar
 
Join Date: Dec 2010
Posts: 243

Status: webling is offline
Quote:
Originally Posted by davem View Post
I have a lot of issues since my host, namecheap.com switched from MySQL to mariadb.
One complete table was dropped in the changeover (newsfeeds)
since I have a testing site for new plug-ins. I just removed joomla and then installed again completely fresh.
Now, I still have a database error shown below.

Database schema version (in #__schemas): 3.7.0-2017-04-19.
Update version (in #__extensions): 3.7.2.
Database driver: mysqli.
145 database changes were checked successfully.
173 database changes did not alter table structure and were skipped.

I cannot enter and save an article or module. The save does not work.

Anybody else have a similar issue

I have requested the host go back to MySQL, but they are committed to maria and want no part of the issues.
I have many, many sites built on this host and this could put me in deep trouble.
I have a ton of sites on namecheap, and it will be a daunting task moving all of them
I think I'd find a new web host.
__________________
Chosen Web Host Quality Shared web hosting and Design
Integrity with Excellence - Free backups through cPanel
You can't develop the internet, until you learn to develop yourself
 
 
 


Old
  Post #9 (permalink)   06-01-2017, 07:32 AM
HD Newbie
 
Join Date: Oct 2015
Location: New York, Seattle
Posts: 23
Send a message via Skype™ to PureVoltage

Status: PureVoltage is offline
I would contact them about a backup as any host worth 2 cents would and should have done a dump of all databases before changing over.
 
 
 


Old
  Post #10 (permalink)   06-01-2017, 01:32 PM
HD Community Advisor
 
ughosting's Avatar
 
Join Date: Jan 2011
Location: London
Posts: 607

Status: ughosting is offline
Quote:
Originally Posted by PureVoltage View Post
I would contact them about a backup as any host worth 2 cents would and should have done a dump of all databases before changing over.
Both cPanel and DirectAdmin should by default do this when you update a database, only a very stupid host would choose not to do this,
__________________
DDoS Protected, LiteSpeed + LiteMage on CloudLinux with SSD Disks, R1Soft, Softaculous, SIteBuilder, BitNinja, LetsEncypt & Patchman
UnixGuru: Accounts with 1-16 CPU Cores, 2-32GB RAM. Why use a VPS?
█ Choose from Shared, Reseller and Elastic-Sites Hosting
 
 
 


Old
  Post #11 (permalink)   06-05-2017, 05:09 AM
HD Master
 
whmcsguru's Avatar
 
Join Date: May 2016
Posts: 285
Send a message via Skype™ to whmcsguru

Status: whmcsguru is offline
Hmm, something smells fishy here.

If your host upgraded you to Maria (it really is an upgrade), and your code doesn't work any more, you need to find out what's wrong with your code, not blame your host.

If you're relying on old versions of MySQL (5.0.xxx or 5.1.xxx even), then you need to get up to date. Things are not going to remain that dated forever.
__________________
WHMCS Guru - WHMCS addons, management, support and more.
WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to your WHMCS install!
WHMCS User and IP Extended Control - Take control of your WHMCS install
Linux admin, WHMCS Guru for hire. PM me for more information
 
 
The Following User Says Thank You to whmcsguru For This Useful Post:
edigest (06-05-2017)


Old
  Post #12 (permalink)   06-05-2017, 07:16 PM
HD Newbie
 
Join Date: May 2014
Posts: 43

Status: edigest is offline
=^0 Always bugs me when somebody who doesn't really understand the technology reflexively blames the host.

I migrated a bunch of servers when we committed to MariaDB a couple years ago -- not a single broken database.
__________________
Your IT Concierge
Server Management, Business-class Web Hosting
Speedy, Secure, Stable Hosting for Developers
 
 
 


Old
  Post #13 (permalink)   06-05-2017, 11:33 PM
HD Master
 
whmcsguru's Avatar
 
Join Date: May 2016
Posts: 285
Send a message via Skype™ to whmcsguru

Status: whmcsguru is offline
I've moved DB's to maria and from maria, and really, nothing to eat. Easy peasy. Simply export the DB and you've got a working DB.

Now, again, if you're talking about running old stuff here, then that's on you. Get your crap together and update your code. I mean, come on now!
__________________
WHMCS Guru - WHMCS addons, management, support and more.
WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to your WHMCS install!
WHMCS User and IP Extended Control - Take control of your WHMCS install
Linux admin, WHMCS Guru for hire. PM me for more information
 
 
 
Reply

Thread Tools

New Post New Post   Old Post Old Post
Posting Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Sponsored By: