phpBB.nl

Hallo ik heb zojuist op mijn forum de chatbox mod en de favo topic mod geinstaleerd nu stond er bij de chatbox mod dat ik dit moest sqlen


#-----[ SQL ]---------------------------------------------
# Run these folloing queries manually or run chatbox_db_install.php once
# Afterthat please remove your chatbox_db_install.php immediately
#
CREATE TABLE phpbb_chatbox (
id int(11) NOT NULL auto_increment,
name varchar(99) NOT NULL,
msg varchar(255) NOT NULL,
timestamp int(10) unsigned NOT NULL,
PRIMARY KEY (id));

CREATE TABLE phpbb_chatbox_session (
username varchar(99) NOT NULL,
lastactive int(10) DEFAULT '0' NOT NULL,
laststatus varchar(8) NOT NULL,
UNIQUE username (username));

en bij de favo topic mod stond

#-----[ SQL ]------------------------------------------
#Where 'phpbb_' is your table prefix
CREATE TABLE `phpbb_favorites` (
`fav_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`topic_id` int(11) NOT NULL default '0',
PRIMARY KEY (`fav_id`)
)

nu voerde ik dit in bij phpmyadmin

CREATE TABLE `phpbb_favorites` (
`fav_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`topic_id` int(11) NOT NULL default '0',
PRIMARY KEY (`fav_id`)
)
CREATE TABLE phpbb_chatbox (
id int(11) NOT NULL auto_increment,
name varchar(99) NOT NULL,
msg varchar(255) NOT NULL,
timestamp int(10) unsigned NOT NULL,
PRIMARY KEY (id));

CREATE TABLE phpbb_chatbox_session (
username varchar(99) NOT NULL,
lastactive int(10) DEFAULT '0' NOT NULL,
laststatus varchar(8) NOT NULL,
UNIQUE username (username));


en toen gaf hij mij de error
Database radio_phpbb - Tabel phpbb_confirm wordt uitgevoerd op freeprohost.com
Fout

SQL-query :

CREATE TABLE `phpbb_favorites` (

`fav_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`user_id` int( 11 ) NOT NULL default '0',
`topic_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `fav_id` )
) CREATE TABLE phpbb_chatbox(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
name varchar( 99 ) NOT NULL ,
msg varchar( 255 ) NOT NULL ,
timestamp int( 10 ) unsigned NOT NULL ,
PRIMARY KEY ( id )
)

MySQL retourneerde:


#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 'CREATE TABLE phpbb_chatbox (
id int(11) NOT NULL auto_increme
[Documentatie] · [Terug]

help me wat moet ik doen als ik nu naar http://radio.freeprohost.com geeft hij een debug mode :}

8) is 8 ) (aanelkaar)

opgelost

klopt :thumb: