 | |  | | | Photopost Pro Installation & Upgrades If you're having install or upgrade problems | 
February 10th, 2006, 04:42 AM
|
#1 (permalink)
| | Registered User
Join Date: Aug 2005
Posts: 3
| moving pp
Hi
I have moved my PhotoPost (v.5.13) - Installation to another Server. I copied all the files und made a export and import of the database (phpmyadmin). Now i get the following error when i want to add a new Category.
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script: adm-cats
Query: INSERT INTO pp_categories (id,catname,description,catorder,thumbs,parent,header,footer,headtags,password,ugnoview,
ugnoupload,ugnopost,
ugnoanno,ugnovote,watermark,sortorder,frames,maximages,ratingtype,ismember) VALUES(NULL,'testcat','','8','yes',0,'','','','', '', '', '', '', '', '', '', '', '', '', '')
Result: Column 'id' cannot be null
Database handle: Resource id #8
What is wrong?
Last edited by Memo; February 10th, 2006 at 04:53 AM.
| 
|  | |
February 10th, 2006, 04:52 AM
|
#2 (permalink)
| | Registered User
Join Date: Aug 2005
Posts: 3
| Database handle: Resource id #7
When I want to upload a Picture, I get this error:
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script: uploadphoto
Query: INSERT INTO pp_photos (id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,medwidth,
medheight,medsize,approved,lastpost, watermarked,allowprint,extra1,extra2,extra3,extra4,extra5,extra6,ipaddress) values(NULL,'admin', 1, 688, 1139568633, 'ed', 'ddd', '', '20051023_00116.jpg', 600, 450, 73179, 0, 0, 0, 1, 1139568633, 'yes','no','','','','','','','213.221.247.94')
Result: Column 'id' cannot be null
Database handle: Resource id #7
| |
| | |
February 10th, 2006, 05:44 AM
|
#3 (permalink)
| | Registered User
Join Date: Aug 2005
Posts: 3
| solved
Found the error.
missing auto_increment!
sorry.
| |
| | |
February 10th, 2006, 09:12 AM
|
#4 (permalink)
| | Photopost Developer Verified Customer
Join Date: Jun 2002 Location: Abingdon,MD
Posts: 71,683
|  I wonder how that could happen did you create the tables exact?
| |
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread |  Linear Mode | | 
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | | All times are GMT -5. The time now is 07:23 PM. | |
