Home | Community | Message Board


The Spore Depot
Please support our sponsors.

General Interest >> Science and Technology

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post. Pages: 1
OfflineChromeCrow
one ancient mutha
Male User Gallery

Folding@home Statistics
Registered: 02/21/02
Posts: 1,878
Loc: Hoosier HELL
Last seen: 1 year, 27 days
webmasters HELP ( php )
    #1890694 - 09/07/03 12:49 PM (14 years, 22 days ago)

for those of you that may know a little about phpmyadmin, and the php database system..........

i am installing a pic gallery to the emporium, and have uploaded evertything to the server.

the final piece of work i need to do is to " With phpmyadmin, import coppermine.sql in your database"

i have tried everything i can to get this imported, but alas, i see no import feature anywhere..... and when i try to copy it straight to the database, i get duplicate user id errors??? some one help!!!!! lol where is Matt's when i need him?

Quote:

Error

SQL-query :

ALTER TABLE `nuke_users` ADD `user_group_cp` INT( 11 ) DEFAULT '2' NOT NULL ,
ADD `user_active_cp` ENUM( 'YES', 'NO' ) DEFAULT 'YES' NOT NULL

MySQL said:


Duplicate column name 'user_group_cp'

Back





Post Extras: Print Post  Remind Me! Notify Moderator
OfflineRhizoid
carbon unit
Male

Registered: 01/23/00
Posts: 1,728
Loc: Europe
Last seen: 1 month, 5 days
Re: webmasters HELP ( php ) [Re: ChromeCrow]
    #1892851 - 09/08/03 03:20 AM (14 years, 21 days ago)

I know nothing about PHP (I use mod_perl instead), but that SQL error is something you would get if that same ALTER TABLE statement is executed twice. I think by "import" they only mean that you feed the sql file to the database. I don't know what has happened, but my guess is that some part of the installation has been done twice, so the the parts being added are already present and this results in an error.


Post Extras: Print Post  Remind Me! Notify Moderator
OfflineAnnoA
Experimenter
 User Gallery

Folding@home Statistics
Registered: 06/18/99
Posts: 24,123
Loc: my room
Last seen: 2 months, 28 days
Re: webmasters HELP ( php ) [Re: Rhizoid]
    #1893268 - 09/08/03 09:20 AM (14 years, 21 days ago)

>my guess is that some part of the installation has been done twice, so
>the the parts being added are already present

I second that.


Post Extras: Print Post  Remind Me! Notify Moderator
OfflineSeussA
Error: divide byzero

Folding@home Statistics
Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 8 months, 16 days
Re: webmasters HELP ( php ) [Re: Anno]
    #1893318 - 09/08/03 09:47 AM (14 years, 21 days ago)

> ALTER TABLE `nuke_users` ADD `user_group_cp` INT( 11 ) DEFAULT '2' NOT NULL ,
ADD `user_active_cp` ENUM( 'YES', 'NO' ) DEFAULT 'YES' NOT NULL


Take out the second 'ADD' and it should work fine, or break it into two seperate alter table definitions...

alter table nuke_users add column user_group_cp int(11) default 2 not null;
alter table nuke_users add column user_active_cp enum('yes','no') default 'yes' not null;


--------------------
Just another spore in the wind.


Post Extras: Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

General Interest >> Science and Technology

Similar ThreadsPosterViewsRepliesLast post
* phpmyadmin ChromeCrow 285 0 10/01/06 02:51 PM
by ChromeCrow
* PHP people HELLA_TIGHT 565 8 06/02/07 01:20 PM
by Ythan
* PHP/MySQL question elbisivni 643 4 05/15/08 03:25 PM
by elbisivni
* PHP/MySQL question daytripper05 767 7 04/28/08 06:43 PM
by daytripper05
* gentoo profiles / default USE flag question sherm 872 4 12/17/08 03:06 PM
by insectvhore
* How do php/CSS heirarchies work? OJK 431 2 09/24/07 01:01 AM
by Ythan
* Changing default media player in XP? Stein 713 2 08/14/03 08:28 AM
by Seuss
* Quick Question - Changing Default Browser MisterKite 811 3 06/15/04 04:09 PM
by MisterKite

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Lana, trendal, automan
588 topic views. 0 members, 2 guests and 1 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
Avalon Magic Plants
Please support our sponsors.

Copyright 1997-2017 Mind Media. Some rights reserved.

Generated in 0.021 seconds spending 0.006 seconds on 19 queries.