Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: Unable to sgn up new user  (Read 8456 times)

0 Members and 1 Guest are viewing this topic.

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
[Solved]: Unable to sgn up new user
« on: August 03, 2009, 10:01:32 pm »

Hi,
I don't have anyplace for new users to sign up, and if I try to input a new user from the admin end I get:

While executing query "INSERT INTO cpgusers(user_regdate, user_active, user_profile6) VALUES (NOW(), 'YES', '')" on 0

mySQL error: Duplicate entry '' for key 2

-------------------------------------------------------------------
USER:
------------------
Array
(
    [ID] => 3f7047fa83d7c8e136809db9408074c2
    [am] => 1
    [lang] => english
    [sort] => na
    [liv] => Array
        (
            
  • => 15
  • [1] => 17
                [2] => 3
            )

        
[theme] => eyeball
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => admin
    [groups] => Array
        (
            
  • => 1

        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 0
    [ufc_min] => 0
    [custom_user_upload] => 0
    [num_file_upload] => 1
    [num_URI_upload] => 0
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 0
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    
  • => SELECT extension, mime, content, player FROM cpgfiletypes; (0s)
  • [1] => select * from cpgplugins order by priority asc; (0s)
        [2] => delete from `db293461997`.cpgsessions where time<1249325769 and remember=0; (0.001s)
        [3] => delete from `db293461997`.cpgsessions where time<1248119769; (0s)
        [4] => select user_id from `db293461997`.cpgsessions where session_id = '40c7ffad333733bce5b0f7f752578a46' (0s)
        [5] => select user_id as id, user_password as password from `db293461997`.cpgusers where user_id=1 (0s)
        [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `db293461997`.cpgusers AS u INNER JOIN `db293461997`.cpgusergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
        [7] => SELECT user_group_list FROM `db293461997`.cpgusers AS u WHERE user_id='1' and user_group_list <> ''; (0s)
        [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpgusergroups WHERE group_id in (1) (0s)
        [9] => SELECT group_name FROM  cpgusergroups WHERE group_id= 1 (0s)
        [10] => update `db293461997`.cpgsessions set time='1249329369' where session_id = '40c7ffad333733bce5b0f7f752578a46' (0s)
        [11] => SELECT user_favpics FROM cpgfavpics WHERE user_id = 1 (0s)
        [12] => DELETE FROM cpgbanned WHERE expiry < '2009-08-03 15:56:09' (0s)
        [13] => SELECT * FROM cpgbanned WHERE (ip_addr='24.89.45.171' OR ip_addr='24.89.45.171' OR user_id=1) AND brute_force=0 (0s)
        [14] => INSERT INTO cpgusers(user_regdate, user_active, user_profile6) VALUES (NOW(), 'YES', '') (0s)
        [15] => SELECT COUNT(*) FROM cpgpictures WHERE approved = 'NO' (0s)
    )

    ==========================
    GET :
    ------------------
    Array
    (
        
[op] => new_user
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.10 - OK
------------------
mySQL version: 5.0.81-log
------------------
Coppermine version: 1.4.25(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.67
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient  
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php5 | .:/usr/lib/php5
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 50000 | 50000
max_input_time | -1 | -1
upload_max_filesize | 20M | 20M
post_max_size | 8M | 8M
==========================
Page generated in 0.091 seconds - 16 queries in 0.001 seconds - Album set : ; Meta set: ;




How do I fix this?

the Fluid Druid
« Last Edit: August 06, 2009, 07:29:35 am by Joachim Müller »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to sgn up new user
« Reply #1 on: August 04, 2009, 09:05:39 am »

In the future, don't post debug_output unless requested. Instead, do as suggested per board rules and always post a link to your gallery when starting a new support thread.
It seems that there is something fishy with your users table: the field user_id needs to be set to auto-increment. Fix that using phpMyAdmin or similar.
Logged

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Unable to sgn up new user
« Reply #2 on: August 04, 2009, 06:19:21 pm »

Hi,
Thanks for your helpful reply.
I really want to use coppermine as an online catalog / store, but have been having constant problems.
I will seee if I can figure out how to apply the fix you described and hopefully that will fix it. btw, the website is http://www.hippyhikingguide.com (I use that domain for development).


Thanks!
the Fluid Druid
Logged

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Unable to sgn up new user
« Reply #3 on: August 04, 2009, 06:24:49 pm »

Hi again,

According to my phpmyadmin it is already set to "auto_increment"
Any other ideas?

Thanks for your help.
the Fluid Druid
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to sgn up new user
« Reply #4 on: August 04, 2009, 07:03:15 pm »

the website is http://www.hippyhikingguide.com (I use that domain for development).
That's not what I have asked for: I haven't asked for a link to your domain, but a link to your coppermine-driven gallery.
Logged

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Unable to sgn up new user
« Reply #5 on: August 04, 2009, 09:27:55 pm »

DOH!

Sorry, I had a stroke back in 2001 and get confused.
I don't have Alzheimers, but I sure have Sometimers!

Here us the url for the gallery it's self:http://www.hippyhikingguide.com/mine/

Thanks again
the Fluid Druid
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to sgn up new user
« Reply #6 on: August 05, 2009, 07:15:18 am »

Registration is disabled, so I can't look at it by myself. This is very frustrating, having to beg for permissions for each step.

Not related to initial install (the gallery is already populated), moving thread accordingly.
Logged

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Unable to sgn up new user
« Reply #7 on: August 05, 2009, 05:16:35 pm »

I apologize for the frustrations, but if you would like to tell me how to enable registration I would be happy to. However when I tried to make a test user (with me logged in as admin of course) I got an error. Otherwise I would have a test account set up for you. Should I try again and post the error?

the fluid Druid
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Unable to sgn up new user
« Reply #8 on: August 05, 2009, 05:26:13 pm »

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Unable to sgn up new user
« Reply #9 on: August 05, 2009, 05:32:58 pm »

Try the manual!

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#admin_user

I had read the manual, but it didn't solve the problem.
I was able to set up a new user (while logged in as admin), after doing a database update.
I don't know why I had to do that, but I noticed it was a database error and was hoping that might fix it.
I now have a test user (username: testman   password: test)
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Unable to sgn up new user
« Reply #10 on: August 05, 2009, 07:48:47 pm »

Have now been able to register.....

Quote
Thank you for registering.

An email with information on how to activate your account was sent to the email address you provided.

looks to be fine from here

thefluiddruid

  • Coppermine newbie
  • Offline Offline
  • Posts: 10
Re: Unable to sgn up new user
« Reply #11 on: August 06, 2009, 02:35:25 am »

Yep, thanks!
It's working great now.
I'm trying to9 set up the shopping cart plugin, however documentation seems to be lacking.
do you know of any good config instructions out there?


Thanks for all your hard work,
the Fluid Druid
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Unable to sgn up new user
« Reply #12 on: August 06, 2009, 07:29:22 am »

I'm trying to9 set up the shopping cart plugin, however documentation seems to be lacking.
do you know of any good config instructions out there?
We have a strict "one issue per thread" policy that you agreed to respect. You had your share of misbehaving and not respecting board rules so far. Now please start respecting them. There will be no more support for you if you don't. And no, there are no such instructions besides the announcement thread for that plugin.

It's working great now.
Marking thread accordingly and locking to avoid the thread getting cluttered.
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 20 queries.