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: mySQL error: Out of range value adjusted for column 'pid' at row 1  (Read 6197 times)

0 Members and 1 Guest are viewing this topic.

y2kboy

  • Coppermine newbie
  • Offline Offline
  • Posts: 3

I hope I'm not repeating a post.  I've been looking through this forum for a week and have done several searches and haven't run accross anything like it. 

I'm running my own web server. 

OS:Windows Server 2003
Apache 2.0.55
PHP 4.4.0
MySQL 5.0.13
Coppermine 1.3.5
ImageMagick Installed
phpMyAdmin 2.6.3 <--(Don't think you really need this but thought I would add it anyway.)

Now to get to the problem.  When I go to upload a file I do the following:

Album: Test Album
File: C:\My Documents\Mercedes\000_0205.JPG
File Title: Test
File description: Test
Keywords: Test

I hit "Upload File" and it says:
Critical error
There was an error while processing a database query.

Code: [Select]
While executing query "INSERT INTO cpg135_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title,
caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES
('', '1', 'userpics/10001/', '000_0205~2.JPG', '232548', '288355', '1040', '772', '1130542870', '1', 'admin', 'test', 'test', 'test', 'YES', '', '', '', '', '{IP ADDRESS REMOVED
FOR SECURITY}', '{IP ADDRESS REMOVED FOR SECURITY}')" on 0

mySQL error: Out of range value adjusted for column 'pid' at row 1

File: C:\webroot\cpg135\include\functions.inc.php - Line: 105

DEBUG INFO
 
Code: [Select]
USER:
------------------
Array
(
    [ID] => 74282ee21d05e9bfd35b5e531234b9c1
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => admin
    [user_password] => ********
    [user_lastvisit] => 2005-10-28 19:16:07
    [user_regdate] => 2005-10-24 13:25:57
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [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] => 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] => 0
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg135_filetypes;
    [1] => SELECT * FROM cpg135_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '48bb6e862e54f2a795ffc4e541caed4d'
    [2] => 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 cpg135_usergroups WHERE group_id in (1)
    [3] => SELECT group_name FROM  cpg135_usergroups WHERE group_id= 1
    [4] => DELETE FROM cpg135_banned WHERE expiry < '2005-10-28 19:41:08'
    [5] => SELECT * FROM cpg135_banned WHERE ip_addr='{IP ADDRESS REMOVED FOR SECURITY}' OR ip_addr='{IP ADDRESS REMOVED FOR SECURITY}' OR
user_id=1
    [6] => SELECT category FROM cpg135_albums WHERE aid='1'
    [7] => INSERT INTO cpg135_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords,
approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES
('', '1', 'userpics/10001/', '000_0205~2.JPG', '232548', '288355', '1040', '772', '1130542870', '1', 'admin', 'test', 'test', 'test', 'YES', '', '', '', '', '{IP ADDRESS REMOVED
FOR SECURITY}', '{IP ADDRESS REMOVED FOR SECURITY}')
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
    [album] => 1
    [MAX_FILE_SIZE] => 1048576
    [title] => test
    [caption] => test
    [keywords] => test
    [event] => picture
)

==========================
VERSION INFO :
------------------
PHP version: 4.4.0 - OK
------------------
mySQL version: 5.0.13-rc-nt
------------------
Coppermine version: 1.3.5
==========================
Module: gd
------------------
module doesn't exist
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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 2.237 seconds - 8 queries in 0.01 seconds - Album set :

Ok, now I did remove the IP addresses just FYI.  I've checked the MySQL 'PID' and don't see anything wrong in the database portion.  I'm sure this has to be some kind of setting in PHP.ini or my Apache settings, but I don't know.
« Last Edit: October 29, 2005, 05:53:39 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: mySQL error: Out of range value adjusted for column 'pid' at row 1
« Reply #1 on: October 29, 2005, 02:01:13 am »

Coppermine doesn't support MySQL 5 fully, version 4.1 is recommended.
Logged

y2kboy

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: mySQL error: Out of range value adjusted for column 'pid' at row 1
« Reply #2 on: October 29, 2005, 02:54:09 am »

I unistalled MySQL 5 and installed 4.1 as suggested.  Do I need to reinstall Coppermine?  I get the following erro when I open the Index.php for coppermine.

Coppermine critical error:
Unable to connect to database !

MySQL said: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Logged

y2kboy

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: mySQL error: Out of range value adjusted for column 'pid' at row 1
« Reply #3 on: October 29, 2005, 03:48:40 am »

Sorry for that....nevermind....I went to the MySQL command prompt and changed the password to the old style and reconfigured coppermine.  It's working now.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.