PHPDEV+PHPMyADmin+PHPNuke6.9: na alle adviezen: nog probleem

[Jazzper]

Na een hele avond +nacht toch maar een draadje. Andere fora alsmede google alsmede een mooi php boek op schoot helpen me niet:

Ik probeer PHPNuke op te zetten. Is keurig gedocumenteerd.. tot het fout gaat. Onderstaande fout is wel bekend en wordt meestal opgelost door de --- opmerkingen te hashen (hehe pardon? nee # deze). Gedaan (nou ja, alle comments weggehaald...) maar veroorzaakt nieuwe meldingen. Ja ik heb het netjes gedaan

Enfin:

Mijn probleem:


info:

PHPNuke 6.9
phpMyAdmin 2.3.2
PHPDEV4.2.3
Apache 1.3.27
MySQL 4.0.0-alpha-nt draait op localhost als root@localhost

config.php
-------------

code:

$dbhost = "localhost";
$dbuname = "root";
$dbpass = "";
$dbname = "nuke";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SdFk*fa28367-dm56w69.3a2fDS+e9";
$gfx_chk = 7;

(dit is engels, ik heb geen zin meer om het te vertalen om 03.22.. sorry daarvoor)

1. Installed PHPDev and than in subfolder /www unpacked phpnuke
2. started the apache/mysql service
3. opened PHPMyAdmin
4. created table nuke
5. in nuke.sql I removed all the commentary (--- lines). Those gave too much errors..
6. then in phpmyadmin: SQL > browse >nuke.sql

and whazaaa...

Database nuke running on localhost
Error


First some code, followed by what i tried etc.

SQL-query :

code:

CREATE TABLE nuke_contactbook(

uid int( 11 ) NOT NULL default '0',
contactid int( 11 ) NOT NULL auto_increment,
firstname varchar( 50 ) default NULL ,
lastname varchar( 50 ) default NULL ,
email varchar( 255 ) default NULL ,
company varchar( 255 ) default NULL ,
homeaddress varchar( 255 ) default NULL ,
city varchar( 80 ) default NULL ,
homephone varchar( 255 ) default NULL ,
workphone varchar( 255 ) default NULL ,
homepage varchar( 255 ) default NULL ,
IM varchar( 255 ) default NULL ,
events text,
reminders int( 11 ) default NULL ,
notes text,
PRIMARY KEY ( contactid ) ,
KEY uid( uid ) ,
KEY contactid( contactid ) 
) TYPE = MyISAM 

MySQL said: 


You have an error in your SQL syntax near 'events text,
  reminders int(11) default NULL,
  notes text,
  PRIMARY KEY  (con' at line 14

----------------------------
here is line 14 with surrounding text:

code:

CREATE TABLE confirm (
  confirm_id char(32) NOT NULL default '',
  session_id char(32) NOT NULL default '',
  code char(6) NOT NULL default '',
  PRIMARY KEY  (session_id,confirm_id)
) TYPE=MyISAM;


CREATE TABLE nuke_authors (
  aid varchar(25) NOT NULL default '',
  name varchar(50) default NULL,
  url varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  pwd varchar(40) default NULL,             <<<<<<<<<<<< LINE 14!!!!!!
  counter int(11) NOT NULL default '0',
  radminarticle tinyint(2) NOT NULL default '0',
  radmintopic tinyint(2) NOT NULL default '0',
  radminuser tinyint(2) NOT NULL default '0',
  radminsurvey tinyint(2) NOT NULL default '0',
  radminsection tinyint(2) NOT NULL default '0',
  radminlink tinyint(2) NOT NULL default '0',
  radminephem tinyint(2) NOT NULL default '0',
  radminfaq tinyint(2) NOT NULL default '0',
  radmindownload tinyint(2) NOT NULL default '0',
  radminreviews tinyint(2) NOT NULL default '0',
  radminnewsletter tinyint(2) NOT NULL default '0',
  radminforum tinyint(2) NOT NULL default '0',
  radmincontent tinyint(2) NOT NULL default '0',
  radminency tinyint(2) NOT NULL default '0',
  radminsuper tinyint(2) NOT NULL default '1',
  admlanguage varchar(30) NOT NULL default '',
  PRIMARY KEY  (aid),
  KEY aid (aid)
) TYPE=MyISAM;



CREATE TABLE nuke_autonews (
  anid int(11) NOT NULL auto_increment,
  catid int(11) NOT NULL default '0',
  aid varchar(30) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  time varchar(19) NOT NULL default '',
  hometext text NOT NULL,
  bodytext text NOT NULL,
  topic int(3) NOT NULL default '1',
  informant varchar(20) NOT NULL default '',
  notes text NOT NULL,
  ihome int(1) NOT NULL default '0',
  alanguage varchar(30) NOT NULL default '',
  acomm int(1) NOT NULL default '0',
  associated text NOT NULL,
  PRIMARY KEY  (anid),
  KEY anid (anid)
) TYPE=MyISAM;

----------------------------
if I search for the string it in here:

code:

CREATE TABLE nuke_contactbook (
  uid int(11) NOT NULL default '0',
  contactid int(11) NOT NULL auto_increment,
  firstname varchar(50) default NULL,
  lastname varchar(50) default NULL,
  email varchar(255) default NULL,
  company varchar(255) default NULL,
  homeaddress varchar(255) default NULL,
  city varchar(80) default NULL,
  homephone varchar(255) default NULL,
  workphone varchar(255) default NULL,
  homepage varchar(255) default NULL,
  IM varchar(255) default NULL,
  re text,
  reminders int(11) default NULL,      <<<<<<<<<<< HERE!!!!!!!
  notes text,
  PRIMARY KEY  (contactid),
  KEY uid (uid),
  KEY contactid (contactid)
) TYPE=MyISAM;

Solutions i tried already:
I removed comments
I made var global on in php.ini

Any idea what could be wrong??
Everyrhing I've read on the forums was about the removing of commentary. (or replacing).
This is different...

By trying different things (copy paste the text right into SQL or doing it over and over again some things will work.. but

not good..
I've never changed settings of password/user in Mysql thus that should be good too...

Ben benieuwd...

[ Voor 8% gewijzigd door Jazzper op 14-11-2003 03:24 ]

[whoami]

Ehm, dit is een nederlandstalig forum, dus willen we ook alle topics in het nederlands.
Je moet je engelse tekst die je op andere fora post niet gewoon copy/pasten naar hier.

Je zult dus ergens een syntax error hebben in je SQL. Misschien is er wel een of andere columnnaam een reserved word ofzo. (email of pwd bv).
Je kan backticks gebruiken rond je veldnamen als dat het geval is, maar een betere oplossing imho is om toch maar een andere naam te verzinnen.