[MySQL]Probleem
Geplaatst: 13 jun 2004, 15:40
Ik heb een klein probleempje.
Ik moet mn forum naar een andere dir verplaatsen dus dat doe ik via SQL querie's. En als ik die invoer krijg ik het volgende :
Error
SQL-query :
DATABASE bandic00_phpbb1 running ON localhost CREATE TABLE `clanforums_auth_access` (
`group_id` mediumint( 8 ) NOT NULL default '0',
`forum_id` smallint( 5 ) unsigned NOT NULL default '0',
`auth_view` tinyint( 1 ) NOT NULL default '0',
`auth_read` tinyint( 1 ) NOT NULL default '0',
`auth_post` tinyint( 1 ) NOT NULL default '0',
`auth_reply` tinyint( 1 ) NOT NULL default '0',
`auth_edit` tinyint( 1 ) NOT NULL default '0',
`auth_delete` tinyint( 1 ) NOT NULL default '0',
`auth_sticky` tinyint( 1 ) NOT NULL default '0',
`auth_announce` tinyint( 1 ) NOT NULL default '0',
`auth_vote` tinyint( 1 ) NOT NULL default '0',
`auth_pollcreate` tinyint( 1 ) NOT NULL default '0',
`auth_attachments` tinyint( 1 ) NOT NULL default '0',
`auth_mod` tinyint( 1 ) NOT NULL default '0',
KEY `group_id` ( `group_id` ) ,
KEY `forum_id` ( `forum_id` )
) TYPE = MYISAM
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 'Database bandic00_phpbb1 running on localhost
CREATE TABLE `c
Ik moet mn forum naar een andere dir verplaatsen dus dat doe ik via SQL querie's. En als ik die invoer krijg ik het volgende :
Error
SQL-query :
DATABASE bandic00_phpbb1 running ON localhost CREATE TABLE `clanforums_auth_access` (
`group_id` mediumint( 8 ) NOT NULL default '0',
`forum_id` smallint( 5 ) unsigned NOT NULL default '0',
`auth_view` tinyint( 1 ) NOT NULL default '0',
`auth_read` tinyint( 1 ) NOT NULL default '0',
`auth_post` tinyint( 1 ) NOT NULL default '0',
`auth_reply` tinyint( 1 ) NOT NULL default '0',
`auth_edit` tinyint( 1 ) NOT NULL default '0',
`auth_delete` tinyint( 1 ) NOT NULL default '0',
`auth_sticky` tinyint( 1 ) NOT NULL default '0',
`auth_announce` tinyint( 1 ) NOT NULL default '0',
`auth_vote` tinyint( 1 ) NOT NULL default '0',
`auth_pollcreate` tinyint( 1 ) NOT NULL default '0',
`auth_attachments` tinyint( 1 ) NOT NULL default '0',
`auth_mod` tinyint( 1 ) NOT NULL default '0',
KEY `group_id` ( `group_id` ) ,
KEY `forum_id` ( `forum_id` )
) TYPE = MYISAM
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 'Database bandic00_phpbb1 running on localhost
CREATE TABLE `c