By compnerd26 on

When im uploading mysql 4.1 from the drupal file i downloaded an error occurs and i cant install drupal is this normal and what can i do to fix it. Thnx

-Compnerd-

⋅ Categories: Drupal 4.7.x

Comments

zerok’s picture

zerok commented

What error exactly?

compnerd26’s picture

compnerd26 commented

Error
SQL query:

-- $Id: database.4.1.mysql,v 1.1.2.1 2006/05/23 18:45:47 killes Exp $
--
-- Table structure for table 'access'
--
CREATE TABLE access(

aid tinyint( 10 ) NOT NULL AUTO_INCREMENT ,
mask varchar( 255 ) NOT NULL default '',
TYPE varchar( 255 ) NOT NULL default '',
STATUS tinyint( 2 ) NOT NULL default '0',
PRIMARY KEY ( aid )
) DEFAULT CHARACTER SET utf8;

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 'DEFAULT CHARACTER SET utf8' at line 8

zerok’s picture

zerok commented

What version of MySQL are you using on the server? If it's lower than 4.1, then use the database/database.4.0.mysql file :-)

compnerd26’s picture

compnerd26 commented

That tip you gave really helped

compnerd26’s picture

compnerd26 commented

"syntax error, unexpected ')', expecting T_VARIABLE or '$' on line 201" now this is comming up what do i do?

-compnerd26-

zerok’s picture

zerok commented

Were and when exactly? Still with MySQL or now with Drupal itself? And could you please post the complete error message? :)

compnerd26’s picture

compnerd26 commented

Not sure. It could have been both. But i cant give you the entire error because it give out personal info srry.

-compnerd26-

styro’s picture

styro commented

A psychic should be along any minute...

Seriously, just mask the personal info part of the error message.

--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ
Example Knowledge Base built using Drupal

esmith’s picture

esmith commented

Does the error look something like this: "syntax error, unexpected ')', expecting T_VARIABLE or '$' in /www/someuser/drupal/somedir/somefile.php on line 201"? If so, we probably need the value of somedir/somefile.php to be of much help.

Well, maybe not. Whatever you changed in that file, you made a syntax error. Plop a copy of the original file back in there and start over.