PDA

View Full Version : Problems on Database install


Vadim
11-14-2006, 10:51 AM
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 :cry:

Thanks
Vadim

Vadim
11-17-2006, 09:46 AM
Can't find the edit-buttom.

I have installed 1.8.8 and it works.

Dave A
12-08-2006, 12:28 PM
Did you manage to sort out your problem with the database?
It may have been a permission related issue but it's hard to say at a quick glance.