Thread

My client has had his site updated by a third party using expression engine and I am now trying to import the site and database to my server. The server is a 1and1 shared server and as such is not localhost. I have run the wizard script and it says I am good to go.

However when importing the database I am getting the following error…

#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 ‘CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `comment` tex

This is the whole sql segment…

CREATE TABLE `exp_comments` (
`comment_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`site_id` int( 4 ) unsigned NOT NULL default '1',
`entry_id` int( 10 ) unsigned NOT NULL default '0',
`weblog_id` int( 4 ) unsigned NOT NULL ,
`author_id` int( 10 ) unsigned NOT NULL default '0',
`status` char( 1 ) NOT NULL default 'o',
`name` varchar( 50 ) NOT NULL ,
`email` varchar( 50 ) NOT NULL ,
`url` varchar( 75 ) NOT NULL ,
`location` varchar( 50 ) NOT NULL ,
`ip_address` varchar( 16 ) NOT NULL ,
`comment_date` int( 10 ) NOT NULL ,
`edit_date` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`comment` text NOT NULL ,
`notify` char( 1 ) NOT NULL default 'n',
PRIMARY KEY ( `comment_id` ) ,
KEY `entry_id` ( `entry_id` ) ,
KEY `weblog_id` ( `weblog_id` ) ,
KEY `author_id` ( `author_id` ) ,
KEY `status` ( `status` ) ,
KEY `site_id` ( `site_id` )
) ENGINE = MYISAM AUTO_INCREMENT =1

the mysql version is v4

Can anybody point out the problem please ?

Thanks

Jim

What version are you trying to import/export from? The properties of the TIMESTAMP data type differ significantly in several ways between MySQL versions.

It’s from V5.0.77 to V4

Well, that won’t work I think, without perhaps a special compatibility flag. Consider upgrading MySQL 4, extended (!) support just ended.

Thanks Ingmar…
Hmmmm I will have to get onto 1and1 see if the will update

Actually I have just checked php info (don’t trust 1and1 cp)
And it says
MySQL
Client API version   5.0.67

So I guess it’s actually V5.0.67 ?

You might want to ask your host just to make sure. It certainly looks like an incompatibility issue down to different versions of MySQL.

I dropped the “default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
And it’s now importing fine.
However if i try to browse to the site im getting an “Internal Server Error”

I have entered everything in the config page as it should be so I think it has something to do with the paths page ?

edit:

Actually i have just deleted a .htaccess file that was there and now its working
all it contained was php_value memory_limit 32M
Is it part of EE normally ?

No, EE does not ship with a default .htaccess file. Deleting it should have no adverse affects.

Thats great 😊
Thanks for sticking with me while I bring up these issues as they arrive.
Everything seems to be working now.
Had a few problems with the paths page but i have sorted it now.

Just one final thing.
I’m getting a very odd thing occurring with my url’s.
instead of http://www.mysite.com/site/applications/
I’m getting…
http://www.mysite.com/site/applications/?phpMyAdmin=b239f6a2fb6f904186541776c92778b0
for each of the sites weblog areas.
If I choose an actual article then its seems fine.

It’s very odd that it is mentioning phpmyadmin !!!

Edit:
Sorry searched and found solutions !!!

So all is well, now?

Yes thanks Sue, all is now well 😊

Glad you got things sorted! Please feel free to post again 😊