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

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Install problems	lala1973nc	Script Installation	1	09-09-2006 12:57 AM
1.8.2 Install Problems	vinyl-junkie	Script Installation	1	07-13-2004 10:06 PM
Install did not work-Can't create database.	tams	Script Installation	10	03-13-2004 12:55 PM
Version 1.8.0 Install Problems	Charter	Mod Submissions	9	01-23-2004 09:08 PM
Install problems...	rayvd	Script Installation	4	10-15-2003 01:02 PM

11-14-2006, 10: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

11-17-2006, 09:46 AM	#2
Vadim Green Mole Join Date: Nov 2006 Posts: 3	Can't find the edit-buttom. I have installed 1.8.8 and it works.

12-08-2006, 12:28 PM	#3
Dave A Purple Mole Join Date: Aug 2004 Location: North Island New Zealand Posts: 170	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.