PDA

View Full Version : install.sql Problem


ascalyg
11-14-2007, 01:06 PM
Hello, new to the forums so bare with me.

Well as the topic says I kinda have a problem installing the "game" part of PhPraider.

I uploaded it to my webserver and did everything I was supposed to. And when I went to Administration/Configuration and tried to install WoW (alliance) I got this:

ZIP support is not enabled!

So I tried to manually install the install.sql file and went to PhPMyAdmin.
I don't really know how to use PhPMyAdmin, let alone manually install anything on it. But I tried importing the txt file and then I got this error

SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.9.0.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 19, 2007 at 07:44 AM
-- Server version: 5.0.27
-- PHP Version: 5.2.0
--
-- Database: `phpraider`
--
--
-- Dumping data for table `phpraider_attribute`
--
INSERT INTO `phpraider_attribute` ( `attribute_id` , `att_name` , `att_type` , `att_min` , `att_max` , `att_hover` , `att_show` , `att_icon` )
VALUES ( 1, 'Arcane Resistance', 'numeric', 0, 0, 0, 1, 'arcane_resistance.png' ) , ( 2, 'Fire Resistance', 'numeric', 0, 0, 0, 1, 'fire_resistance.png' ) , ( 3, 'Frost Resistance', 'numeric', 0, 0, 0, 1, 'frost_resistance.png' ) , ( 4, 'Nature Resistance', 'numeric', 0, 0, 0, 1, 'nature_resistance.png' ) , ( 5, 'Shadow Resistance', 'numeric', 0, 0, 0, 1, 'shadow_resistance.png' ) , ( 6, 'Damage Gear', 'numeric', 0, 0, 0, 1, 'damage_gear.png' ) , ( 7, 'Healing Gear', 'numeric', 0, 0, 0, 1, 'healing_gear.png' ) ;

MySQL retourneerde: Documentatie
#1062 - Duplicate entry '1' for key 1

And this is where I'm stuck, how do I manually install this txt file with PhPMyAdmin.

Bare in mind, I'm not to knowlegable about all of this, I'm learning as I go. So if one could explain it to me step by step, or point me in the direction where this is already explained, that would be great.

Thanks in advance.

p.s.
Sorry if this has been posted before, but I couldnt find anything on the forums so I decided to make a post. ^^

BoaConstrictor
11-15-2007, 02:47 AM
You're sure you haven't installed this before?

#1062 - Duplicate entry '1' for key 1


That tell me that you allready had something in your phpraider_attributes table.

Just clear out your phpraider_attributes table:

DELETE FROM phpraider_attribute;