Jump to content

[solved pilot error] Problems starting my site after it has been moved

mpeg69
 Share

Recommended Posts

mpeg69 Newbie

mpeg69

Posted
Posted (edited)

SOLVED !!!!!

 

Hi All,

 

I have moved my site to another host, but is having problems starting my site. Here is what i did:

 

1. Exported all files from my former host

2. Exported all tables and data from my former host

3. Imported all files on new host

4. Imported all tables and data to new SQL server

5. Change the settings.inc file to point at the new database

 

.. when i access the site now (www.haisler.dk) i get an "Internal server error".

.. when i access the admin page, i get the page as expected (but can't login.. but that is another issue i guess)

 

What can be wrong ??

 

The new hosting partner has investigated, and says that it must be something in my Prestashop solution.

 

Thanks in advance.

 

Kind regards

Morten

Edited by El Patron (see edit history)
Link to comment
Share on other sites
mpeg69 Newbie

mpeg69

Posted
  • Author
Posted

Hi ...

 

Thank you very much... i now get the following:

 

Fatal error: Uncaught Table 'haislerd_haisler.ps_shop_url' doesn't exist<br /><br /><pre>SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.haisler.dk' OR su.domain_ssl = 'www.haisler.dk') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC</pre> thrown in /data/home/haislerd/public_html/classes/db/Db.php on line 607

 

But still have no clue what happens...

 

Hope someone still can help me !

 

Thanks.

 

/Morten

Link to comment
Share on other sites
mpeg69 Newbie

mpeg69

Posted
  • Author
Posted
  On 8/12/2013 at 4:09 PM, Enrique Gómez said:

I suppose the name of the new database in settings.inc is haislerd_haisler so it's possible your export file is incorrect. Can you do a search for ps_shop_url in the sql file?

 

Hi,

I have just made a search in the SQL file, and did not find the ps_shop_url ? ..should it be there ?

 

Kind regards

Morten

Link to comment
Share on other sites
Enrique Gómez Collaborator

Enrique Gómez

Posted
Posted
  On 8/12/2013 at 6:14 PM, mpeg69 said:

Hi,

I have just made a search in the SQL file, and did not find the ps_shop_url ? ..should it be there ?

 

Kind regards

Morten

 

Yes something like

 

--
-- Table structure for table `ps_shop_url`
--
CREATE TABLE IF NOT EXISTS `ps_shop_url` (
 `id_shop_url` int(11) unsigned NOT NULL auto_increment,
 `id_shop` int(11) unsigned NOT NULL,
 `domain` varchar(150) NOT NULL,
 `domain_ssl` varchar(150) NOT NULL,
 `physical_uri` varchar(64) NOT NULL,
 `virtual_uri` varchar(64) NOT NULL,
 `main` tinyint(1) NOT NULL,
 `active` tinyint(1) NOT NULL,
 PRIMARY KEY  (`id_shop_url`),
 UNIQUE KEY `full_shop_url` (`domain`,`physical_uri`,`virtual_uri`),
 UNIQUE KEY `full_shop_url_ssl` (`domain_ssl`,`physical_uri`,`virtual_uri`),
 KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `ps_shop_url`
--
INSERT INTO `ps_shop_url` (`id_shop_url`, `id_shop`, `domain`, `domain_ssl`, `physical_uri`, `virtual_uri`, `main`, `active`) VALUES

Link to comment
Share on other sites
mpeg69 Newbie

mpeg69

Posted
  • Author
Posted

Hi again,

 

Strange.. that does not seem to be in the exported SQL ?? ...

 

I also see that after i import the SQL file the complete data is around 80 MB and the other site (from where i export) has around 100MB ??

 

Maybe i do something wrong in the export ??

 

Kind regards

Morten

Link to comment
Share on other sites
Enrique Gómez Collaborator

Enrique Gómez

Posted
Posted
  On 8/12/2013 at 6:39 PM, mpeg69 said:

Hi.. it counted 245.

 

But i can't find anything like "CREATE TABLE IF NOT EXISTS `ps_shop_url`..........."

 

Probably some modules install their tables and it increases the number. Anyway it's very strange that one table in between has not been exported...

  • Like 1
Link to comment
Share on other sites
mpeg69 Newbie

mpeg69

Posted
  • Author
Posted

SOLVED - !!!!

 

Sorry guys.. i now found the problem .. my bad.. i was messing around with a demo site i had, and tried to import this SQL.. and i have made a mess in That SQL ...

 

Sorry for waisting your time.. and thanks a lot for all your help !!!

 

Kind regards

Morten

Link to comment
Share on other sites
mpeg69 Newbie

mpeg69

Posted
  • Author
Posted

.. it is now running, but i have a few problems that i do not know how to solve:

 

Warning: Function addCSS() is deprecated in /data/home/haislerd/public_html/modules/piscesslider/piscesslider.php on line 221

in /data/home/haislerd/public_html/classes/Tools.php on line 1845

 

Warning: Function display() is deprecated in /data/home/haislerd/public_html/classes/controller/Controller.php on line 185

in /data/home/haislerd/public_html/classes/Tools.php on line 1845

 

Kind regards

Morten

Link to comment
Share on other sites
El Patron Mentor

El Patron

Posted
Posted
  On 8/12/2013 at 7:00 PM, mpeg69 said:

SOLVED - !!!!

 

Sorry guys.. i now found the problem .. my bad.. i was messing around with a demo site i had, and tried to import this SQL.. and i have made a mess in That SQL ...

 

Sorry for waisting your time.. and thanks a lot for all your help !!!

 

Kind regards

Morten

 

drop and give us 20....glad you found it...

 

if the site is working fine...then turn off error reporting...it's just a warning that you could ignore..or chase in another forum post...

 

Hat's off to Enrique...make sure to like all his posts....Enrique...your time on this post was awesome.

 

I will mark this as solved...pilot error

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...