Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Coppermine blocks in sql the New user creation  (Read 6798 times)

0 Members and 1 Guest are viewing this topic.

Yabba

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
Coppermine blocks in sql the New user creation
« on: October 08, 2006, 06:05:09 am »

I have a big issue regarding creating new user.
Sometimes when im using the manual create user in admin mode im receving an error
The workaround for this is to open the sql database open up cpg149_users and  edit the table and go to User password and uncheck the Not Noll function. ---> save changes and then it works fine again fo maximum 1 day.

What do i have to do to prevent Coppermine to setup the Not Null again?

Some related issue maybe (dont jknow but posting this link to an other issue that is very close to this issue)
http://forum.coppermine-gallery.net/index.php?topic=37084.0
« Last Edit: October 27, 2006, 01:58:51 am by Nibbler »
Logged
We all cannot be pro on coding. (If so all professional programmers schould be unemployed)
Fortunately the rest of us are pro's on other stuff at least this applies to me

Yabba

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 30
Re: Coppermine blocks in sql the New user creation
« Reply #1 on: October 12, 2006, 02:33:15 pm »

I have manage to isolate the issue.
Its recomended from Coppermine crew to run the AdminTools/Update Database (If you have replaced coppermine files, added a modification or upgraded from a previous version of coppermine, make sure to run the database update once. This will create the necessary tables and/or config values in your coppermine database.)

Some modifications has been done and of of course i have performed as requested.
The bug in this thing is that this update also updates the "ALTER TABLE `cpg149_users` CHANGE `user_password` `user_password` VARCHAR( 40 ) NOT NULL" to just NOT NULL

Debug error:
While executing query "INSERT INTO cpg149_users(user_regdate, user_active) VALUES (NOW(), 'YES')" on 0
mySQL error: Field 'user_password' doesn't have a default value

In file:
include\functions.inc.php - Line: 249
This is my 249 line:
cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);

The strange thing is that when i am performing the update in English language the change will not take place, but if i have Swedish activated then i have to change the sql-database?

Logged
We all cannot be pro on coding. (If so all professional programmers schould be unemployed)
Fortunately the rest of us are pro's on other stuff at least this applies to me

kint

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Coppermine blocks in sql the New user creation
« Reply #2 on: November 12, 2006, 03:02:41 am »

I have this problem too.  I'm not sure I understand - did your problem go away
after you ran "Update Database?"  I ran Update Database, and I still get the problem.

My error message is the same as yours, when I try to create new user:

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

mySQL error: Field 'user_password' doesn't have a default value


Any ideas?  Thanks..
Logged

Nibbler

  • Guest
Re: Coppermine blocks in sql the New user creation
« Reply #3 on: November 12, 2006, 03:04:35 am »

A fix for this issue was added to 1.4.10. Do you experience this issue when running that version?
Logged

kint

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Coppermine blocks in sql the New user creation
« Reply #4 on: November 12, 2006, 03:07:05 am »


No, I got this on 1.4.9.  I will try 1.4.10 now.  Thanks for the fast reply!!    :D
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.