anatak Posted June 22, 2006 Share Posted June 22, 2006 Hello I am trying to export a table from my home pc to the server.export using easyphp creates this [code]DROP TABLE IF EXISTS `about`;CREATE TABLE `about` ( `AboutId` int(11) NOT NULL auto_increment, `AboutAuthor` int(11) NOT NULL default '0', `AboutTitle` varchar(255) default NULL, `AboutText` text, `AboutUpdateDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `AboutPostDate` timestamp NOT NULL default '0000-00-00 00:00:00', `AboutHide` tinyint(4) default '1', PRIMARY KEY (`AboutId`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;[/code]this results in the following error 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `AboutPostDat can anyone point me what the correct syntax would be ?I think this is because of different versions fo MySQLhome computer uses 4.1.9 maxserver version is 4.0.23 standardregardsanatak Quote Link to comment Share on other sites More sharing options...
Wildbug Posted June 22, 2006 Share Posted June 22, 2006 Removing this: "default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP" should set things right.That syntax was added in MySQL 4.1.2. Quote Link to comment Share on other sites More sharing options...
anatak Posted June 22, 2006 Author Share Posted June 22, 2006 Thanks for the reply.My hosting firm will change my account to a MySQL 5 Server so I guess I will just wait untill that is done.kind regardsanatak Quote Link to comment Share on other sites More sharing options...
BluwAngel Posted July 7, 2006 Share Posted July 7, 2006 i have problem with PHP (im noob just starting to make something...so please STEP BY STEP)i installed easyphp and i use phpmyadmin for install phpnuke...now when i enter phpmyadmin i have databes named phpnuke(94) and i have all tables installed no errors... anyway wut do do next when i try run http://localhost/phpnuke/html/ all i get is this notes..."Notice: Undefined index: HTTP_ACCEPT_ENCODING in c:\easyphp1-8\www\phpnuke\html\mainfile.php on line 47Notice: import_request_variables(): No prefix specified - possible security hazard in c:\easyphp1-8\www\phpnuke\html\mainfile.php on line 64There seems to be a problem with the MySQL server, sorry for the inconvenience.We should be back shortly."i wanna try set it on localhost for now to test it so please help me... :) ??? Quote Link to comment Share on other sites More sharing options...
anatak Posted October 23, 2006 Author Share Posted October 23, 2006 woopssorry for the extremely late reply.I can't help you with this.I don't use Nuke,did you start a topic for yourself ?if not please do. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.