I was getting the same error as fade2grey (CPG 1.4.3, Win2K3, PHP 5, MySQL 5) and, at the advice of my webhost, I:
* Booted up phpMyAdmin
* Found the table "cpg143_categories"
* Set the DEFAULT column for "description" to NULL.
Ran the newest version of timer, again.
Now, PROVIDED:
* I had a folder under "albums" called "testy" and
* A folder under "testy" called "testy2" (so the directory structure looks like: <root>\cpg143\albums\testy\testy2")
The TIMER script would create the category "testy" with an album in it called "testy2".
That's the good. The bad is it wouldn't upload the pictures in "testy2".
When I turned the debug on, I'd get the following error:
While executing query "INSERT INTO cpg143_pictures (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, position) VALUES ('12', 'testy/testy2/', 'a.jpg', '14702', '17383', '362', '295', '1137635330', '1', '[my server name, edited out]','', '', '', 'YES', '', '', '', '', '', '', 'a.jpg')" on 0
mySQL error: Out of range value adjusted for column 'position' at row 1
File: D:\Inetpub\wwwroot\[my server]\cpg143\include\functions.inc.php - Line: 248
============
Notices:
\include\themes.inc.php
* Warning line 1167: Cannot modify header information - headers already sent by (output started at D:\Inetpub\wwwroot\[my server]\cpg143\timer.php:10)
* Warning line 1168: Cannot modify header information - headers already sent by (output started at D:\Inetpub\wwwroot\[my server]\cpg143\timer.php:10)
\include\functions.inc.php
* Warning line 162: Cannot modify header information - headers already sent by (output started at D:\Inetpub\wwwroot\[my server]\cpg143\timer.php:10)
Little file named "a.jpg". All of 12K.
I tried editing out the "pos" statements in timer.php and then deleting them altogether. I tried changing the DEFAULT column to null and not null or other numbers in the cpg143_pictures table with phpMyAdmin and nothing helped. I tried combinations of the above, too.
Any suggestions? (My webhost does not wish to downgrade MySQL to 4.x.)