Solved

#1064 - You have an error in your SQL syntax

Posted on 2006-10-23
8
4,533 Views
Last Modified: 2008-03-10
Hi,

I have read all previous post relating to this, but I am still unable to get my head around the problem and need a little hand holding.

I exported a db before having a server turned off. On a new server I am now trying to import the db via phpMyAdmin.

Unfortunately I do not have access to the old derver to make another backup in a compatible mode.

Here is the error I am getting, is all lost?

Thanks,

Luv2.


Error

SQL-query :  

CREATE TABLE `PLD_CATEGORY` (

`ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`TITLE` varchar( 100 ) NOT NULL default '',
`TITLE_URL` varchar( 100 ) default NULL ,
`DESCRIPTION` varchar( 255 ) default NULL ,
`PARENT_ID` int( 11 ) NOT NULL default '0',
`STATUS` int( 11 ) NOT NULL default '1',
`DATE_ADDED` timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`HITS` int( 11 ) NOT NULL default '0',
`SYMBOLIC` int( 11 ) NOT NULL default '0',
`SYMBOLIC_ID` int( 11 ) NOT NULL default '0',
`newsFile` varchar( 5 ) NOT NULL default '',
PRIMARY KEY ( `ID` ) ,
KEY `PLD_CATEGORY_TITLE_IDX` ( `TITLE` ) ,
KEY `PLD_CATEGORY_TITLE_URL_IDX` ( `TITLE_URL` ) ,
KEY `PLD_CATEGORY_DESCRIPTION_IDX` ( `DESCRIPTION` ) ,
KEY `PLD_CATEGORY_PARENT_ID_IDX` ( `PARENT_ID` ) ,
KEY `PLD_CATEGORY_STATUS_IDX` ( `STATUS` ) ,
KEY `PLD_CATEGORY_HITS_IDX` ( `HITS` )
)ENGINE = MYISAM AUTO_INCREMENT =193DEFAULT CHARSET = latin1

MySQL said:


#1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `HITS` int(11) NOT NULL default' at line 8




0
Comment
Question by:Luv2Muff
  • 4
  • 2
8 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 17791349
what version of MySQL are you running. this error looks like you have a version that is older to when the syntax CURRENT_TIMESTAMP is supported
0
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 17791357
It also looks like you're missing a space between 'default' and 'CURRENT_TIMESTAMP'
0
 

Author Comment

by:Luv2Muff
ID: 17791438
How do I insert the missing space?

I am completely new at this I copied all the SQL into an SQL window, added the space, but still get the same error :-(

Thanks,

Luv2
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Luv2Muff
ID: 17791510
Oh hell, it did not look like that when I submitted, just had 300 lines of code. Will write to support to seee if they can remove the above.
0
 

Author Comment

by:Luv2Muff
ID: 17791596
New server is running:

MySQL 3.23.58
0
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 250 total points
ID: 17791721
3.23 is really old.  It's time to upgrade.
0
 

Author Comment

by:Luv2Muff
ID: 17885411
Apologies for the late response. I have divided the points as that seemed fair. The correct answer was to upgrade. Thanks for your help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Creating and Managing Databases with phpMyAdmin in cPanel.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now