forum.coppermine-gallery.net
Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: etrcoke on November 15, 2003, 09:32:40 pm
-
Ok, Any user created after about 2 days ago can upload and store pics.. however any of the 40 something users created before that are not allowed to. Now I went searching and I remembered during the coppermine install.. the very last sql qurery failed. I thought nothing of it. Now I realize the importance. It is the nuke_users table. So I went to the sql file and ran that query again and this is that it said
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'
That last line was the error for the install.. so how can I fix this?
-
In phpmyadmin:
check the users table and see what the defaults of those fields and if they exist,
Try the queries seperatly
ALTER TABLE `nuke_users` ADD `user_active_cp` ENUM( 'YES', 'NO' ) DEFAULT 'YES' NOT NULL;
ALTER TABLE `nuke_users` ADD `user_group_cp` INT( 11 ) DEFAULT '2' NOT NULL;
any queries that came after that in the install also failed...
so also should runALTER TABLE `nuke_users` ADD `user_lastvisit_cp` DATETIME NOT NULL, ADD `user_regdate_cp` DATETIME NOT NULL;
UPDATE nuke_users SET user_group_cp='3' WHERE user_id='-1';
UPDATE nuke_users SET user_group_cp='3' WHERE user_id='1';
UPDATE nuke_users SET user_group_cp='1' WHERE user_id='2';
-
Umm, ok I ran all the code in the first code box
ALTER TABLE `nuke_users` ADD `user_active_cp` ENUM( 'YES', 'NO' ) DEFAULT 'YES' NOT NULL;
ALTER TABLE `nuke_users` ADD `user_group_cp` INT( 11 ) DEFAULT '2' NOT NULL;
and that is when I recieved the error. What do you think I should do?
-
Run the code in the second box.. and see if that works if not reinstall.
-
Duplicate column name 'user_lastvisit_cp'
that is what i get if i run the second box's code.
I can not reinstall this.. It happens every time i install copperemine. Tell me what the differance is between a user that is new and a user that was already there. There are not very many users so I can just do whatever is needed mannually. Do you have any other ideas for the sql soulitons?
-
Well, I don't really understand each items in the install process. however, looking at the SQL error, it means that the column is already there. That's why you can not add it anymore (the SQL statement is to add a new column). So, look at your table definition, and compare whether that column has the same properties as the one to be added in the SQL statement. If they are the same, then you can skip that SQL statement.
- irving
http://www.IrvingEvaJoan.com
-
Yes, but why is the column there ????
This is a problem with some phpNuke versions so please tell us the answers on the following, because we still don't have a clue why this happens.[list=1]
- Which phpNuke version ?
- From which website did you download phpNuke ?
- Did you upgrade from previous phpNuke versions ?
- Did you add modules, if so which (sum them all) ?
- Did you upgrade from a previous Coppermine ?
- Did you integrate standalone phpBB into phpNuke ?
[/list:o]
Thanks in advance.
-
1 6.9
2 your site
3 fresh install
4 lets see i have had flash mp3 player, clan nuke modules and the shoutbox module
5 new coppermine
6 phpbb that comes with phpnuke
-
2. YOUR SITE? we don't have phpnuke for download...
to set your users right tryUPDATE nuke_users SET user_group_cp='3' WHERE user_id='-1';
UPDATE nuke_users SET user_group_cp='3' WHERE user_id='1';
UPDATE nuke_users SET user_group_cp='1' WHERE user_id='2';//make sure you are user_id 2
-
Ok....
UPDATE nuke_users SET user_group_cp='3' WHERE user_id='-1';
UPDATE nuke_users SET user_group_cp='3' WHERE user_id='1';
UPDATE nuke_users SET user_group_cp='1' WHERE user_id='2';
I ran that and it was succesful.. However it STILL didnt work!
Now I downloaded this module from http://coppermine.findhere.org/modules.php?name=Downloads
I got that link though your forum. I still get the error though.. It says it cant move it to that directory
-
etrcoke: Two things we have have for that you have not given us...
From which website did you download phpNuke ?
Your URL?
-
http://coppermine.findhere.org/modules.php?name=Downloads
I simply went to that site.. and clicked coppermine.. and clicked Coppermine 1.2.0-nuke RC2 (cpgnuke1.2.0rc2.zip) And that is what I used.
-
Well, you still haven't give us a clue on:
1. Your URL. Can you give us a URL so we can test on?
2. Where did you download PHP-Nuke 6.9?
- irving
http://www.IrvingEvaJoan.com
-
OHHH sorry i didnt understand.. I downloaded phpnuke from www.phpnuke.com My site where I am having this problem is www.clan-fire.com
Keep in mind.. if you create an account you will be able to upload pictures.. I just need everyone that was made before I installed cpg to be able to do it.
-
Do you have the backup of the db before you did the fresh install of coppermine we would be interested in what module/block created user_group_cp if any...
Your install failed on that command so the user_group_cp was not set to the default(2)...
The way coppermine is setup all registered members may upload in album where uploading is enabled for that group (registered members user_group_cp=2 user_id=3+)
{anon is -1 or 1 your username should be user_id 2}.
So if you want all registered members to be able to post pictures try:UPDATE nuke_users SET user_group_cp='2' WHERE user_id>='3';
-
OMG, im starting to hate phpmyadmin.. anyways i put in your code and this is what it said.
Affected rows: 0 (Query took 0.0011 sec)
SQL-query : [Edit] [Create PHP Code]
UPDATE nuke_users SET user_group_cp = '2' WHERE user_id >= '3'
If you havent already realized, I am not very good at database shit. If I did something wrong here please explain. Thank you for all of your help. Keep it commin!
-
any ideas?
-
UPDATE nuke_users SET user_group_cp = 2 WHERE user_id > 2
-
It says the same thing that says affected rows 0