Application error after changing host

asked Apr 18, 2014 by Ciatronical (930 points)
edited Apr 19, 2014 by Ciatronical
I have a new server and transfer Seotoaster with follow steps:
1. Save DB from old server
2. Resave DB on new server
3. Create am tmp-DB on new server
4. Seotoaster with tmp-DB
5. Edit application.ini  database.params.dbname = 'myDB'
6. Copy theme and media from old to new server

It works but after login I have a application error.
I press F5 and I'm loged in.

Its possible you changed database structure??


Rdg Ronny

2 Answers

answered May 1, 2014 by carlo15 (450 points)
Hi,
first things firt. Are you running the same version of SeoToaster on the old and new server?
I moved a SeoToaster webiste from two different VPS running cPanel and Apahce, but under the same hosting, so same structure.

You should check if the path to core is the same under new and old hosting.

Example: home/your_user/site_folder/setoaster_core/
for both sever

if so, you can basically copy-paste everything, and just change the domain pointing (like if you have a DNS redirect, or change the folder it points to, in your sever setting).

With copy-paste I mean:
// old server
1. copy old DB (mysql export from phpmyadmin)
2. copy old files (make a .tar.gz or .zip package)
// new server
3. create new db with SAME db_name, db_user, db_password as the old one
4. import in the new db the old one (mysql import from phpmyadmin)
5.create new folder, with the same name as the old one
6. upload old files and uncompress

Well, to keep the answer short, that should be a starting point. Good luck, keep in touch and update the Question!
answered May 2, 2014 by Ciatronical (930 points)
I have found the error. The Reason was missing Data on the db-restoration.
I have add follow lines an its works perfect.

-- Table structure for table `user_attributes`
--

DROP TABLE IF EXISTS `user_attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_attributes` (
  `user_id` int(10) unsigned NOT NULL,
  `attribute` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`user_id`,`attribute`(20)),
  CONSTRAINT `user_attributes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_attributes`
--

LOCK TABLES `user_attributes` WRITE;
/*!40000 ALTER TABLE `user_attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_attributes` ENABLE KEYS */;
UNLOCK TABLES;
...