Home | Community | Message Board


Marijuana Demystified
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, 3 months
webmasters HELP ( php )
    #1890694 - 09/07/03 12:49 PM (14 years, 3 months 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,729
Loc: Europe
Last seen: 21 days, 20 hours
Re: webmasters HELP ( php ) [Re: ChromeCrow]
    #1892851 - 09/08/03 03:20 AM (14 years, 3 months 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: 5 months, 18 days
Re: webmasters HELP ( php ) [Re: Rhizoid]
    #1893268 - 09/08/03 09:20 AM (14 years, 3 months 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: 11 months, 6 days
Re: webmasters HELP ( php ) [Re: Anno]
    #1893318 - 09/08/03 09:47 AM (14 years, 3 months 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 287 0 10/01/06 02:51 PM
by ChromeCrow
* PHP people HELLA_TIGHT 573 8 06/02/07 01:20 PM
by Ythan
* PHP/MySQL question elbisivni 649 4 05/15/08 03:25 PM
by elbisivni
* PHP/MySQL question daytripper05 778 7 04/28/08 06:43 PM
by daytripper05
* gentoo profiles / default USE flag question sherm 874 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 716 2 08/14/03 08:28 AM
by Seuss
* Quick Question - Changing Default Browser MisterKite 862 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
589 topic views. 0 members, 6 guests and 1 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
World Seed Supply
Please support our sponsors.

Copyright 1997-2017 Mind Media. Some rights reserved.

Generated in 0.028 seconds spending 0.006 seconds on 19 queries.