Home | Community | Message Board

Cannabis Seeds Zamnesia
This site includes paid links. Please support our sponsors.


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!

Shop: Kraken Kratom Red Vein Kratom   Myyco.com Golden Teacher Liquid Culture For Sale

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

Folding@home Statistics
Registered: 02/21/02
Posts: 1,887
Loc: Hoosier HELL
Last seen: 11 months, 14 days
webmasters HELP ( php )
    #1890694 - 09/07/03 10:49 AM (20 years, 6 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





--------------------
ISO: Orissa, Malabar, z strain

Extras: Filter Print Post Top
OfflineRhizoid
carbon unit
Male

Registered: 01/22/00
Posts: 1,739
Loc: Europe
Last seen: 1 month, 18 days
Re: webmasters HELP ( php ) [Re: ChromeCrow]
    #1892851 - 09/08/03 01:20 AM (20 years, 6 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.

Extras: Filter Print Post Top
OfflineAnnoA
Experimenter
 User Gallery

Folding@home Statistics
Registered: 06/17/99
Posts: 24,166
Loc: my room
Last seen: 19 days, 7 hours
Re: webmasters HELP ( php ) [Re: Rhizoid]
    #1893268 - 09/08/03 07:20 AM (20 years, 6 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.

Extras: Filter Print Post Top
OfflineSeussA
Error: divide byzero

Folding@home Statistics
Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 1 month, 19 days
Re: webmasters HELP ( php ) [Re: Anno]
    #1893318 - 09/08/03 07:47 AM (20 years, 6 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.

Extras: Filter Print Post Top
Jump to top Pages: 1

Shop: Kraken Kratom Red Vein Kratom   Myyco.com Golden Teacher Liquid Culture For Sale


Similar ThreadsPosterViewsRepliesLast post
* phpmyadmin ChromeCrow 315 0 10/01/06 12:51 PM
by ChromeCrow
* PHP vs. Cold Fusion Evolving 1,126 7 03/15/03 06:08 AM
by Lana
* Changing default media player in XP? Stein 876 2 08/14/03 06:28 AM
by Seuss
* Quick Question - Changing Default Browser MisterKite 1,258 3 06/15/04 02:09 PM
by MisterKite
* changing default media players... Osker246 572 2 01/08/05 08:50 AM
by Vvellum
* PHP NUKE RIPPING Genius 605 3 11/06/04 05:11 PM
by Ythan
* PHP coders wanted ThePredator 898 10 09/28/05 04:46 PM
by automan
* PHP? Crazy! TinMan 1,108 7 09/11/03 10:44 AM
by 3DSHROOM

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: trendal, automan, Northerner
714 topic views. 0 members, 0 guests and 4 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.024 seconds spending 0.006 seconds on 14 queries.