mpeg69 Posted August 12, 2013 Share Posted August 12, 2013 (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 August 12, 2013 by El Patron (see edit history) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted August 12, 2013 Share Posted August 12, 2013 re 500 error, you need to know what is causing it and hopefully search and find solution, see here http://www.prestashop.com/forums/topic/224525-how-to-get-debug-information-for-500-error-or-blank-page/ Link to comment Share on other sites More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 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 More sharing options...
Enrique Gómez Posted August 12, 2013 Share Posted August 12, 2013 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? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted August 12, 2013 Share Posted August 12, 2013 what is your ps version please Link to comment Share on other sites More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 what is your ps version please Hi, It is ver. 1.5.4.1 Link to comment Share on other sites More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 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 More sharing options...
Enrique Gómez Posted August 12, 2013 Share Posted August 12, 2013 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 More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 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 More sharing options...
Enrique Gómez Posted August 12, 2013 Share Posted August 12, 2013 (edited) The database dump begins with ps_access and ends with ps_zone_shop. There must be 243 tables in a prestashop installation. So if you search by CREATE TABLE IF NOT EXISTS you must find 243 occurrences. With Notepad ++: Edited August 12, 2013 by Enrique Gómez (see edit history) 1 Link to comment Share on other sites More sharing options...
Enrique Gómez Posted August 12, 2013 Share Posted August 12, 2013 With big databases it would be better if you can use the mysql command line (if your hostings supports). http://webcheatsheet.com/SQL/mysql_backup_restore.php 1 Link to comment Share on other sites More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 Hi.. it counted 245. But i can't find anything like "CREATE TABLE IF NOT EXISTS `ps_shop_url`..........." Link to comment Share on other sites More sharing options...
Enrique Gómez Posted August 12, 2013 Share Posted August 12, 2013 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... 1 Link to comment Share on other sites More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 Should i actualy be able to see the ps_shop_url` Table in my Old database ?? .. because i can't ?? Link to comment Share on other sites More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 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 More sharing options...
mpeg69 Posted August 12, 2013 Author Share Posted August 12, 2013 .. 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 More sharing options...
PrestaHeroes USA Posted August 12, 2013 Share Posted August 12, 2013 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now