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&token=ca23b506d9012df1e1dd03b40d2da180&js_frame=right&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&token=249cdc939c13a4f3b3907004e53157d1&js_frame=right&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
sounds like the export were badly done since you have html code at the middle of it
Bluehost confirms its fine quality as hosting
Offline
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
you could try to export the largest tables like picture or visits/history separatly from the others
Offline
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
that one is heavily documented and commented here and on the net
Offline
i give up, rebuilding from scratch! :(
Offline