Wat is er fout aan deze SQL-querty?

[RobinTown]

Code: Selecteer alles

CREATE TABLE phpbb_notes (
  post_id mediumint(8) unsigned NOT NULL auto_increment,
  poster_id mediumint(8) NOT NULL DEFAULT '0',
  post_subject varchar(60) DEFAULT NULL,
  post_text text,
  post_time int(11) NOT NULL DEFAULT '0',
  bbcode_uid varchar(10) DEFAULT NULL,
  bbcode` TINYINT(1) DEFAULT '1' NOT NULL,
  smilies` TINYINT(1) DEFAULT '1' NOT NULL,
  acronym` TINYINT(1) DEFAULT '1' NOT NULL
  PRIMARY KEY  (post_id),
  KEY poster_id (poster_id),
  KEY post_time (post_time)
) TYPE=MyISAM;

INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('notes', '20');

ALTER TABLE phpbb_users ADD user_popup_notes TINYINT(1) DEFAULT '0';

van Personal Notes

[Cheeta]

Code: Selecteer alles

CREATE TABLE phpbb_notes
  post_id mediumint(8) unsigned NOT NULL auto_increment,
  poster_id mediumint(8) NOT NULL DEFAULT '0',
  post_subject varchar(60) DEFAULT NULL,
  post_text text,
  post_time int(11) NOT NULL DEFAULT '0',
  bbcode_uid varchar(10) DEFAULT NULL,
  bbcode` TINYINT(1) DEFAULT '1' NOT NULL,
  smilies` TINYINT(1) DEFAULT '1' NOT NULL,
  acronym` TINYINT(1) DEFAULT '1' NOT NULL
  PRIMARY KEY  (post_id),
  KEY poster_id (poster_id),
  KEY post_time (post_time)
) TYPE=MyISAM;

probeer hem zo eens!

[RobinTown]

dat krijg ik dit

Fout

Er schijnt een fout te zijn in uw SQL query. Mocht de MySQL server een error hebben terug gegeven, probeer dan of uw hiermee uw fout kunt oplossen.

ERROR: Quote niet afgesloten @ 374
STR: `
SQL: CREATE TABLE phpbb_notes
post_id mediumint(8) unsigned NOT NULL auto_increment,
poster_id mediumint(8) NOT NULL DEFAULT '0',
post_subject varchar(60) DEFAULT NULL,
post_text text,
post_time int(11) NOT NULL DEFAULT '0',
bbcode_uid varchar(10) DEFAULT NULL,
bbcode` TINYINT(1) DEFAULT '1' NOT NULL,
smilies` TINYINT(1) DEFAULT '1' NOT NULL,
acronym` TINYINT(1) DEFAULT '1' NOT NULL
PRIMARY KEY (post_id),
KEY poster_id (poster_id),
KEY post_time (post_time)
) TYPE=MyISAM;
SQL-query :

CREATE TABLE phpbb_notes post_id mediumint(8) unsigned NOT NULL auto_increment, poster_id mediumint(8) NOT NULL DEFAULT '0', post_subject varchar(60) DEFAULT NULL, post_text text, post_time int(11) NOT NULL DEFAULT '0', bbcode_uid varchar(10) DEFAULT NULL, bbcode` TINYINT(1) DEFAULT '1' NOT NULL, smilies` TINYINT(1) DEFAULT '1' NOT NULL, acronym` TINYINT(1) DEFAULT '1' NOT NULL PRIMARY KEY (post_id), KEY poster_id (poster_id), KEY post_time (post_time) ) TYPE=MyISAM;

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 'post_id mediumint(8) unsigned NOT NULL auto_increment,
poste

[Documentatie] · [Terug]

[Cheeta]

Code: Selecteer alles

You have an error in your SQL syntax near 'post_id mediumint(8) unsigned NOT NULL DEFAULT auto_increment, 
  poster_id med' at line 2

dit krijg ik regel 2 dus!

ik ga ff verder proberen nog!

mzzl 8)

[Luuk]

Code: Selecteer alles

CREATE TABLE phpbb_notes ( 
  post_id mediumint(8) unsigned NOT NULL auto_increment, 
  poster_id mediumint(8) NOT NULL DEFAULT '0', 
  post_subject varchar(60) DEFAULT NULL, 
  post_text text, 
  post_time int(11) NOT NULL DEFAULT '0', 
  bbcode_uid varchar(10) DEFAULT NULL, 
  bbcode TINYINT(1) DEFAULT '1' NOT NULL, 
  smilies TINYINT(1) DEFAULT '1' NOT NULL, 
  acronym TINYINT(1) DEFAULT '1' NOT NULL, 
  PRIMARY KEY  (post_id), 
  KEY poster_id (poster_id), 
  KEY post_time (post_time) 
) TYPE=MyISAM; 

INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('notes', '20'); 

ALTER TABLE phpbb_users ADD user_popup_notes TINYINT(1) DEFAULT '0';

Zo moet lukken

[Cheeta]

ik heb de mod ook maar ff gedownload en zag er dit bij zitten

http://members.lycos.nl/cheetaforum/db_update_pn.txt

je moet hem alleen ff omzetten in php!
Gewoon met kladblok!

mzzl 8)

[RobinTown]

o ja, *beep*, er staat een db_update bij, ik ga die eerst proberen

[RobinTown]

die lukt ook niet :(

CREATE TABLE phpbb_notes ( post_id mediumint(8) unsigned NOT NULL auto_increment, poster_id mediumint(8) NOT NULL DEFAULT '0', post_subject varchar(60) DEFAULT NULL, post_text text, post_time int(11) NOT NULL DEFAULT '0', bbcode_uid varchar(10) DEFAULT NULL, bbcode` TINYINT(1) DEFAULT '1' NOT NULL, smilies` TINYINT(1) DEFAULT '1' NOT NULL, acronym` TINYINT(1) DEFAULT '1' NOT NULL PRIMARY KEY (post_id), KEY poster_id (poster_id), KEY post_time (post_time) ) TYPE=MyISAM
+++ Error: 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 ' TINYINT(1) DEFAULT '1' NOT NULL, smilies` TINYINT(1) DEFAULT

INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('notes', '20')
+++ Error: Duplicate entry 'notes' for key 1

ALTER TABLE phpbb_users ADD user_popup_notes TINYINT(1) DEFAULT '0'
+++ Error: Duplicate column name 'user_popup_notes'

[Luuk]

Heb je die van mij ook geprobeerd? De tabel aanmaken lukt mezelf wel, dat aanpassen heb ik niet geprobeerd.

[RobinTown]

Heb je die van mij ook geprobeerd? De tabel aanmaken lukt mezelf wel, dat aanpassen heb ik niet geprobeerd.

het is gelukt, als ik nog meer fouten krijg meld ik het

[Luuk]

OK

[RobinTown]

oke, alles is gelukt. Wat is eigenlijk een goede nederlandse naam voor ''notes''

[WebSiteNet]

Notities of aantekeningen.

[mosymuis]

Of Kladblok. Zo heb ik mijn notes mod naar het Nederlands vertaald.