Announcement

 

Pages: 1

#1 2015-03-01 17:10:13

Mandraek
Member
2015-03-01
6

Database error on migrating from Bluehost to Godaddy

error GoDaddy migration sql

Hello/Hi/Greetings,

Have setup a fresh install on godaddy that works, deleted tables in sql and imported tables from previous installation on bluehost but get error message, any help much appreciated:

ErrorSQL query:
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=ca23b506d9012df1e1dd03b40d2da180&amp;js_frame=right&amp;nocache=5573953450" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.16.custom.css" /> <meta name="robots" content="noindex,nofollow" /> <script src="./js/cross_framing_protection.js?ts=1375007690" type="text/javascript"></script> <script src="./js/jquery/jquery-1.6.2fix-9521.js?ts=1399144421" type="text/javascript"></script> <script src="./js/jquery/jquery-ui-1.8.16.custom.js?ts=137500[...]
MySQL said:
ErrorSQL query:
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=249cdc939c13a4f3b3907004e53157d1&amp;js_frame=right&amp;nocache=5574372419" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.16.custom.css" /> <meta name="robots" content="noindex,nofollow" /> <script src="./js/cross_framing_protection.js?ts=1375007690" type="text/javascript"></script> <script src="./js/jquery/jquery-1.6.2fix-9521.js?ts=1399144421" type="text/javascript"></script> <script src="./js/jquery/jquery-ui-1.8.16.custom.js?ts=137500[...]
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="e' at line 1  - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="e' at line 1


first bit of sql:
-- phpMyAdmin SQL Dump
-- version 3.5.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 01, 2015 at 05:19 AM
-- Server version: 5.5.41-37.0-log
-- PHP Version: 5.4.23

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cretanca_pwg1`
--

-- --------------------------------------------------------

--
-- Table structure for table `piwigo_caddie`
--

DROP TABLE IF EXISTS `piwigo_caddie`;
CREATE TABLE IF NOT EXISTS `piwigo_caddie` (
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `element_id` mediumint(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`element_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `piwigo_caddie`
--

INSERT INTO `piwigo_caddie` (`user_id`, `element_id`) VALUES
(1, 486),
(1, 487),
(1, 488),
(1, 489);

-- --------------------------------------------------------

--
-- Table structure for table `piwigo_categories`
--

DROP TABLE IF EXISTS `piwigo_categories`;
CREATE TABLE IF NOT EXISTS `piwigo_categories` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `id_uppercat` smallint(5) unsigned DEFAULT NULL,
  `comment` text,
  `dir` varchar(255) DEFAULT NULL,
  `rank` smallint(5) unsigned DEFAULT NULL,
  `status` enum('public','private') NOT NULL DEFAULT 'public',
  `site_id` tinyint(4) unsigned DEFAULT NULL,
  `visible` enum('true','false') NOT NULL DEFAULT 'true',
  `representative_picture_id` mediumint(8) unsigned DEFAULT NULL,
  `uppercats` varchar(255) NOT NULL DEFAULT '',
  `commentable` enum('true','false') NOT NULL DEFAULT 'true',
  `global_rank` varchar(255) DEFAULT NULL,
  `image_order` varchar(128) DEFAULT NULL,
  `permalink` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `lastmodified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_i3` (`permalink`),
  KEY `categories_i2` (`id_uppercat`),
  KEY `lastmodified` (`lastmodified`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=99 ;

--
-- Dumping data for table `piwigo_categories`
--

INSERT INTO `piwigo_categories` (`id`, `name`, `id_uppercat`, `comment`, `dir`, `rank`, `status`, `site_id`, `visible`, `representative_picture_id`, `uppercats`, `commentable`, `global_rank`, `image_order`, `permalink`, `lastmodified`) VALUES
(1,



Piwigo version: Piwigo 2.7.4
PHP version: 5.1.73
MySQL version:
Piwigo URL: http://catspyjamas.org/cat-a-logue

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.32-cll-lve - MySQL Community Server (GPL)
Protocol version: 10

cpsrvd 11.48.0.11
Database client version: libmysql - 5.1.73
PHP extension: mysqli

phpMyAdmin

Version information: 4.0.10.7, latest stable version: 4.3.10

Offline

 

#2 2015-03-02 10:45:20

flop25
Piwigo Team
2006-07-06
7037

Re: Database error on migrating from Bluehost to Godaddy

sounds like the export were badly done since you have html code at the middle of it
Bluehost confirms its fine quality as hosting

To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2015-03-02 12:30:31

Mandraek
Member
2015-03-01
6

Re: Database error on migrating from Bluehost to Godaddy

Thanks for your reply flop25, should i take this up with bluehost or try fixing it? or should i try another export, have already done a second export :)

Offline

 

#4 2015-03-02 13:08:53

flop25
Piwigo Team
2006-07-06
7037

Re: Database error on migrating from Bluehost to Godaddy

you could try to export the largest tables like picture or visits/history separatly from the others

To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2015-03-02 13:18:10

Mandraek
Member
2015-03-01
6

Re: Database error on migrating from Bluehost to Godaddy

ok, tried images table only, no error reported except on trying to reach the page i get:
Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'cretanca_pwg1'@'localhost' (using password: YES) in /home/cretanca/public_html/cat-a-logue/include/dblayer/functions_mysqli.inc.php on line 67

Warning: my_error(): Couldn't fetch mysqli in /home/cretanca/public_html/cat-a-logue/include/dblayer/functions_mysqli.inc.php on line 822

Warning: my_error(): Couldn't fetch mysqli in /home/cretanca/public_html/cat-a-logue/include/dblayer/functions_mysqli.inc.php on line 822
Piwigo encountered a non recoverable error

[mysql error ]
Can't connect to server

#1    my_error /home/cretanca/public_html/cat-a-logue/include/common.inc.php(118)
#2    include_once /home/cretanca/public_html/cat-a-logue/index.php(26)

think maybe i have other problems to! :(

Offline

 

#6 2015-03-02 13:22:13

flop25
Piwigo Team
2006-07-06
7037

Re: Database error on migrating from Bluehost to Godaddy

that one is heavily documented and commented here and on the net

To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#7 2015-03-05 22:45:49

Mandraek
Member
2015-03-01
6

Re: Database error on migrating from Bluehost to Godaddy

i give up, rebuilding from scratch! :(

Offline

 

Pages: 1

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact