Jump to content

**SOLVED** easyphp


anatak

Recommended Posts

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 MySQL
home computer uses 4.1.9 max
server version is 4.0.23 standard

regards
anatak
Link to comment
Share on other sites

  • 2 weeks later...
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 47

Notice: import_request_variables(): No prefix specified - possible security hazard in c:\easyphp1-8\www\phpnuke\html\mainfile.php on line 64




There 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... :)  ???
Link to comment
Share on other sites

  • 3 months later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.