View Single Post
Old 11-14-2006, 09:51 AM   #1
Vadim
Green Mole
 
Join Date: Nov 2006
Posts: 3
Problems on Database install

Good evening
i had installed phpdig, and wanted to create tables. The page redirects me back to fill in the db-datas, which was correct. I tried to install the tables manually by uploading init_db.sql with phpmyadmin. the following error-message appears:

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Serveur: localhost Base de données: phpdig
# --------------------------------------------------------
#
# Structure de la table 'engine'
#
CREATE TABLE ENGINE (
spider_id mediumint( 9 ) DEFAULT '0' NOT NULL ,
key_id mediumint( 9 ) DEFAULT '0' NOT NULL ,
weight smallint( 4 ) DEFAULT '0' NOT NULL ,
KEY key_id( key_id )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE utf8_general_ci

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci' at line 16


Is there some help out there

Thanks
Vadim
Vadim is offline   Reply With Quote