coppermine-gallery.com/forum

I am a noob so its probably something simple ...

While executing query "INSERT INTO cpalbums (category, title, uploads, pos) VALUES ('2', 'Rose Mcgowan', 'NO',  '1')" on 0

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


USER:
------------------
Array
(
    [ID] => f2fb1980284cdc98580d1f8379509b7c
    [am] => 1
    [lang] => english
)

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

• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [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] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpfiletypes; (0.001s)
      [1] => select * from cpplugins order by priority asc; (0.001s)
      [2] => delete from `copper`.cpsessions where time<1161175882 and remember=0; (0.001s)
      [3] => delete from `copper`.cpsessions where time<1159969882; (0s)
      [4] => select user_id from `copper`.cpsessions where session_id=md5("ad61cc2830f8d899d271720245088eef9853eb93594eb0b08ac7837628028f58"); (0.001s)
      [5] => select user_id as id, user_password as password from `copper`.cpusers 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 `copper`.cpusers AS u INNER JOIN `copper`.cpusergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
      [7] => SELECT user_group_list FROM `copper`.cpusers 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 cpusergroups WHERE group_id in (1) (0.001s)
      [9] => SELECT group_name FROM  cpusergroups WHERE group_id= 1 (0.001s)
      [10] => update `copper`.cpsessions set time='1161179482' where session_id=md5('ad61cc2830f8d899d271720245088eef9853eb93594eb0b08ac7837628028f58'); (0.001s)
      [11] => SELECT user_favpics FROM cpfavpics WHERE user_id = 1 (0.001s)
      [12] => DELETE FROM cpbanned WHERE expiry < '2006-10-18 08:51:22' (0.001s)
      [13] => SELECT * FROM cpbanned WHERE (ip_addr='209.215.82.14' OR ip_addr='209.215.82.14' OR user_id=1) AND brute_force=0 (0s)
      [14] => SELECT COUNT(*) FROM cppictures WHERE approved = 'NO' (0.001s)
      [15] => INSERT INTO cpalbums (category, title, uploads, pos) VALUES ('2', 'Rose Mcgowan', 'NO',  '1') (0.001s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [what] => albmgr
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
      [delete_album] =>
      [sort_order] =>
      [cat] => 2
      [to] => Array
          (
             
• => album_no=0,album_nm=\'Rose Mcgowan\',album_sort=1,action=1
          )
  
      [album_nm] => *****
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.4 - OK
  ------------------
  mySQL version: 5.0.26-community-nt
  ------------------
  Coppermine version: 1.4.9(stable)
  ==========================
  Module: gd
  ------------------
  module doesn't exist
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 3.23.49
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  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 | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .;c:\php4\pear | .;c:\php4\pear
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | no value | no value
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.172 seconds - 16 queries in 0.012 seconds - Album set : ; Meta set: ;
  

- Do not post debug output unless requested
- Upgrade to most recent version (currently 1.4.9)

It is 1.4.9.

This has already been fixed for the next version of Coppermine, the code to change can be viewed in svn (http://svn.sourceforge.net/viewvc/coppermine/trunk/stable/delete.php?r1=3303&r2=3309).

oops sorry missed the debug info !
Just wondering that's why it was there ;)