problem when move from localhost to website - Joomla! Forum - community, help and support
please when move local host website when move sql database
export > import show problem:
error
sql query:
create table `er0c5_assets` (
`id` int(10) unsigned not null comment 'primary key',
`parent_id` int(11) not null default '0'comment
)
mysql said: documentation
#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near ')' @ line 4
thx
export > import show problem:
error
sql query:
create table `er0c5_assets` (
`id` int(10) unsigned not null comment 'primary key',
`parent_id` int(11) not null default '0'comment
)
mysql said: documentation
#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near ')' @ line 4
thx
the problem on line 3 `parent_id` int(11) not null default '0'comment, have not added specified "comment" on line. sql statement should have appeared this!
create table `er0c5_assets` (
`id` int(10) unsigned not null comment 'primary key',
`parent_id` int(11) not null default '0' comment 'parent id'
)
where 'parent id' specified comment
hope work you
create table `er0c5_assets` (
`id` int(10) unsigned not null comment 'primary key',
`parent_id` int(11) not null default '0' comment 'parent id'
)
where 'parent id' specified comment
hope work you
Comments
Post a Comment