mysql syntax error while creating table in phpMysql

[andysmith]

i dont know why its happening but i get this same error when creating a table on my web provider:

Database d60137024 - Table usr_profiles running on MySQL Server Farm 2
Error

SQL-query :

CREATE TABLE usr_profiles (

memid INT( 2 ) AUTO_INCREMENT,
memname VARCHAR( 50 ) ,
memlevel INT( 3 ) ,
membio BLOB( 500 ) ,
mailaddress VARCHAR( 50 ) ,
mempassword VARCHAR( 14 ) ,
joindate VARCHAR( 30 ) ,
placeholder1 VARCHAR( 1 ) ,
placeholder2 VARCHAR( 1 ) ,
placeholder3 VARCHAR( 1 )
) COMMENT = 'Default website profile storage'

MySQL said:

You have an error in your SQL syntax near '(500), mailaddress VARCHAR(50), mempassword VARCHAR(14), joindate VARCHAR(' at line 1

any ideas? please and thanks 🙂

[tsinka]

Hi,

use
membio BLOB,
instead of
membio BLOB( 500 ) ,

According to the manual specifiying the length of a BLOB field is invalid.

If you try e.g. to specify the length of a BLOB field with phpMyAdmin it simply ignores that and executes the query without the length parameter.

Thomas

[andysmith]

thank you very much! worked perfectly after that 🙂