Posted on: 08/12/03 03:16am
By: bengt
HI
When I try to run the install script for GeekBook(1.2 stable) I only get a blank page(All blocks and my theme, menus is there). In Geeklogs error.log i Find this...
\"Tue Aug 12 09:06:46 2003 - Attempting to install the GeekBook Plugin
Tue Aug 12 09:06:46 2003 - Attempting to create table geekbook for GeekBook plugin
Tue Aug 12 09:06:46 2003 - 1064: You have an error in your SQL syntax near \'CREATE TABLE banned_ips (host_ip varchar(255) default NULL)\' at line 1 SQL in question: \"
And in GeekBooks install.php i find:
$createsql = \"CREATE TABLE geekbook (\"
.\"name varchar(50) default NULL,\"
.\"date varchar(40) default NULL,\"
.\"email varchar(50) default NULL,\"
.\"website varchar(100) NOT NULL default \'\',\"
.\"comment longtext,\"
.\"icq int(9) default NULL,\"
.\"aolim varchar(30) default NULL,\"
.\"msn varchar(30) default NULL,\"
.\"yahoo varchar(30) default NULL,\"
.\"ip varchar(255) default NULL,\"
.\"id int(4) NOT NULL auto_increment,\"
.\"PRIMARY KEY (id)\"
.\")\"
.\"CREATE TABLE banned_ips (\"
.\"host_ip varchar(255) default NULL\"
.\")\";
Someone out there to help me?
Regards Bengt Danielsen