Joomla Talk

[imagesofvision]

I am running into a problem when trying to move my site (kite photography template) from a machine with:

 phpMyAdmin 2.6.0-pl3 & MySQL 3.23.58

to a machine with:

phpMyAdmin - 2.8.2.4 & MySQL - 5.0.27

I export the database from the existing machine, but when I import into the new machine i get the following error:
--------------------------------------
Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2008 at 06:01 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.10
--
-- Database: `iovjoomla`
--
CREATE DATABASE `iovjoomla` ;

USE iovjoomla;

-- --------------------------------------------------------
--
-- Table structure for table `jos_banner`
--
CREATE TABLE `jos_banner` (
`bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 90 ) NOT NULL default 'banner',
`name` text NOT NULL ,
`alias` varchar( 255 ) NOT NULL default '',
`imptotal` int( 11 ) NOT NULL default '0',
`impmade` int( 11 ) NOT NULL default '0',
`clicks` int( 11 ) NOT NULL default '0',
`imageurl` varchar( 100 ) NOT NULL default '',
`clickurl` varchar( 200 ) NOT NULL default '',
`date` datetime default NULL ,
`showBanner` tinyint( 1 ) NOT NULL default '0',
`checked_out` tinyint( 1 ) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar( 150 ) default NULL ,
`custombannercode` text,
`catid` int( 10 ) unsigned NOT NULL default '0',
`description` text NOT NULL ,
`sticky` tinyint( 1 ) unsigned NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`tags` text NOT NULL ,
`params` text NOT NULL ,
PRIMARY KEY ( `bid` ) ,
KEY `viewbanner` ( `showBanner` ) ,
KEY `idx_banner_catid` ( `catid` )
) TYPE = MYISAM AUTO_INCREMENT =1;

MySQL said: Documentation
#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 'bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `t' at line 1
-----------------------------------------------

I have searched and found lots of info on this but nothing I have found works -- Any help you can provide would be much appreciated!

[mikek]

Hi, I would contact you hosting company about this problem. The errors are showing incorrect sql syntax. All of the syntax is generate when the database is exported from your server.

[imagesofvision]

Problem is that I lease the two machines - the old one is a 4 year old machine with older software -
one post via google said to use compatibility mode when importing into the new db, the php admin has no such
option - do you know anything about compatibility mode??

thanks for your quick response - as usual!

[jonahh]

Try deleting the lines of SQL that the error is complaining about and then importing.

[imagesofvision]

problem is that the lines are the ones that create the main table in the databse...

[m3rl3n]

My case is similar, but not quite.

I am new to Shape 5 and have just last night downloaded Aluma Photography to give my own website and photo business a boost.

I am working on the site on my local machine and I plan to upload that to my host when it is ready. I hope to minimize the down time, however, when I have followed Joomla tutorials in the past to perform this action, it has never worked.  With the complexity of the Shape 5 websites, I was wondering if you have a special tutorial for migrating from a local server to a hosting server?

Thanks,
Dan

[mikek]

Hello, when you move the site to a live site you will just need to edit the configuration.php file to point to the new url's and database information.

If you are having trouble with this please post your question in the aluma photography forum board.