Forum Support

Shape 5
March 28, 2024, 11:27:06 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Need some SQL Help! (Please!)  (Read 1363 times)
gmedia
Jr. Member
**
Offline Offline

Posts: 198



WWW
« on: October 16, 2013, 10:44:37 AM »

Here is my site: www.brewcrewrestoration.com

I recently fired fatcow.com as my host, and am trying to move this site to the new VPS.

I was able to import the SQL tables, but all I get is a white screen.

The only thing I can think of is a different MySQL version.

I had to import using ANSI compatibility mode. Otherwise I'd get an error saying "#1044 - Access denied for user 'brewcrew'@'localhost' to database 'brewcrewrestoration'"

Here are the version numbers:

Fatcow.com MySQL: 5.0.91-log
VPS MySQL: 5.1.70-cll

 I can give cpanel and FTP access if someone wants to help. I need to get this client's site back online.

Thanks a bunch!

Chris
Logged
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #1 on: October 17, 2013, 06:31:11 PM »

Hello,

Just to verify you copied over all the site files to the new host, imported the database and modified in configuration.php file on your server to redirect to your new host? If you have done all this I will see if one of our database experts has any idea what the issue would be.

-Mike
Logged

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
gmedia
Jr. Member
**
Offline Offline

Posts: 198



WWW
« Reply #2 on: October 17, 2013, 07:18:22 PM »

I'm thankful that someone even looked at my post. Thanks!

Yes. Everything you said is correct. All the files are moved. I created a new database and imported the old one. I edited the configuration file to connect to the new database. The site just doesn't show up.

I am using the Shenandoah template with the latest LTR of Joomla.

I am using the latest stable release of PHP on our server as well. I have migrated/imported other sites, but this one is giving me trouble. If I were guessing, it is likely an easy fix, just over my head. All of the pieces are there. I looked through some of the SQL data. It seems ok.

THANK you for even trying to help! No pressure either way, but I'm going to PM you some credentials.

Chris
Logged
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #3 on: October 17, 2013, 08:32:23 PM »

Alright,

You can PM me the Super User and FTP Credentials. Before any of that though please make a full backup of all your site files/databases.

-Mike
Logged

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
gmedia
Jr. Member
**
Offline Offline

Posts: 198



WWW
« Reply #4 on: October 17, 2013, 09:54:59 PM »

Ok. I just PM'ed you.

Chris
Logged
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #5 on: October 17, 2013, 10:15:58 PM »

Thanks,

-Mike
Logged

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
gmedia
Jr. Member
**
Offline Offline

Posts: 198



WWW
« Reply #6 on: October 22, 2013, 03:32:38 AM »

I replied to your PM's. I don't know if you get the notification for them, but I do not. I didn't notice your messages.

Sorry Sad

Chris
Logged
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #7 on: October 22, 2013, 05:54:24 PM »

NP Smiley

-Mike
Logged

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.