Cannot Upload - Database Error?

pols1337 · July 04, 2014, 02:36:35 AM

Hi there, I recently had my server administrator upgrade PHP to 5.5.13 and MySQL to 5.7. I also reskinned although I doubt that affects anything. I cannot upload either via the User uploads or the Batch uploads.

- I checked the permissions and the /albums folder shows a 777
- The intermediate and thumbnails are being created

Gallery link: http://adonismale.com/tg/index.php

See photos. Please advise

pols1337 · July 04, 2014, 02:43:14 AM

And if this helps, here is the Critical Error (see screenshot)

Code Select

While executing query 'INSERT INTO cpg15x_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('23', 'userpics/10001/', 'tumblr_mx414oW8UV1qdgdbio1_r1_500~0.jpg', '67720', '96763', '500', '750', '1404434426', '1', 'Cute Guy', 'Guy in pink shirt', '', 'YES', '', '', '', '', '66.199.97.83', '66.199.97.83', '0', '')' in include/picmgmt.inc.php on line 173

mySQL error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'mtime' at row 1

pols1337 · July 04, 2014, 02:44:14 AM

And lastly ... here is the Debug Info

Code Select

ron4mac · July 04, 2014, 07:14:14 AM

Best guess here since I have no way to test it:

You may need to change the three lines in "include/picmgmt.inc.php" around line 169 to the following:

Code Select

        $query = "INSERT INTO {$CONFIG['TABLE_PICTURES']} (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, mtime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('{$CURRENT_PIC_DATA['aid']}', '" . addslashes($CURRENT_PIC_DATA['filepath']) . "', '" . addslashes($CURRENT_PIC_DATA['filename']) . "', '{$CURRENT_PIC_DATA['filesize']}', '{$CURRENT_PIC_DATA['total_filesize']}', '{$CURRENT_PIC_DATA['pwidth']}', '{$CURRENT_PIC_DATA['pheight']}', '" . time() . "','1000-01-01 00:00:00', '{$CURRENT_PIC_DATA['owner_id']}', '{$CURRENT_PIC_DATA['title']}', '{$CURRENT_PIC_DATA['caption']}', '{$CURRENT_PIC_DATA['keywords']}', '{$CURRENT_PIC_DATA['approved']}', '{$CURRENT_PIC_DATA['user1']}', '{$CURRENT_PIC_DATA['user2']}', '{$CURRENT_PIC_DATA['user3']}', '{$CURRENT_PIC_DATA['user4']}', '{$CURRENT_PIC_DATA['pic_raw_ip']}', '{$CURRENT_PIC_DATA['pic_hdr_ip']}', '{$CURRENT_PIC_DATA['position']}', '{$CURRENT_PIC_DATA['guest_token']}')";
    } else  {
        $query = "INSERT INTO {$CONFIG['TABLE_PICTURES']} (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, mtime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('{$CURRENT_PIC_DATA['aid']}', '" . addslashes($CURRENT_PIC_DATA['filepath']) . "', '" . addslashes($CURRENT_PIC_DATA['filename']) . "', '{$CURRENT_PIC_DATA['filesize']}', '{$CURRENT_PIC_DATA['total_filesize']}', '{$CURRENT_PIC_DATA['pwidth']}', '{$CURRENT_PIC_DATA['pheight']}', '" . time() . "','1000-01-01 00:00:00', '{$CURRENT_PIC_DATA['owner_id']}', '', '', '', '{$CURRENT_PIC_DATA['approved']}', '{$CURRENT_PIC_DATA['user1']}', '{$CURRENT_PIC_DATA['user2']}', '{$CURRENT_PIC_DATA['user3']}', '{$CURRENT_PIC_DATA['user4']}', '{$CURRENT_PIC_DATA['pic_raw_ip']}', '{$CURRENT_PIC_DATA['pic_hdr_ip']}', '{$CURRENT_PIC_DATA['position']}', '{$CURRENT_PIC_DATA['guest_token']}')";

[Recommend you save a copy of the file first]

phill104 · July 04, 2014, 12:04:28 PM

Well that was hard work trying to get those versions into WAMP lol.

As suggested the changes by Ron4Mac appear to work. Please confirm if it is good your end.

Αndré · July 04, 2014, 12:09:03 PM

From the MySQL docs:

Quote from: http://dev.mysql.com/doc/refman/5.1/en/datetime.htmlThe supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

I suggest to adjust the default value for the column mtime in your MySQL database instead of modifying core files. I'll fix this for cpg1.5.30 and above.

Αndré · July 04, 2014, 12:28:42 PM

Fixed default value for columns that use the MySQL datatype "datetime" in SVN revision 8720.

pols1337 · July 04, 2014, 06:19:26 PM

Can you direct me to the latest SVN revision?

Also, is include/picmgmt.inc.php the only file that needs to be replaced?

Thanks everyone

phill104 · July 04, 2014, 06:26:06 PM

Details of how to use the SVN are available here - http://documentation.coppermine-gallery.net/en/dev_subversion.htm

Details of the files Andre edited can be found here - http://sourceforge.net/p/coppermine/code/8720/

ron4mac · July 04, 2014, 08:21:01 PM

Quote from: pols1337 on July 04, 2014, 06:19:26 PM
Also, is include/picmgmt.inc.php the only file that needs to be replaced?

To be clear ... you must edit your picmgmt.inc.php file and change the few lines as listed above. You can not replace it with the SVN copy of that file.

Your only other option is to apply these lines to your Coppermine database:

Code Select


ALTER TABLE cpg15x_comments CHANGE `msg_date` `msg_date` datetime NOT NULL default '1000-01-01 00:00:00';
ALTER TABLE cpg15x_pictures CHANGE `mtime` `mtime` datetime NOT NULL default '1000-01-01 00:00:00';
ALTER TABLE cpg15x_users CHANGE `user_lastvisit` `user_lastvisit` datetime NOT NULL default '1000-01-01 00:00:00';
ALTER TABLE cpg15x_users CHANGE `user_regdate` `user_regdate` datetime NOT NULL default '1000-01-01 00:00:00';

Your best solution would be to apply the changes to your database.

Αndré · July 04, 2014, 08:27:08 PM

Actually, the easiest solution (that will also be part of cpg1.5.30) is to add

Code Select

ALTER TABLE CPG_comments CHANGE `msg_date` `msg_date` datetime NOT NULL default '1000-01-01 00:00:00';
ALTER TABLE CPG_pictures CHANGE `mtime` `mtime` datetime NOT NULL default '1000-01-01 00:00:00';
ALTER TABLE CPG_users CHANGE `user_lastvisit` `user_lastvisit` datetime NOT NULL default '1000-01-01 00:00:00';
ALTER TABLE CPG_users CHANGE `user_regdate` `user_regdate` datetime NOT NULL default '1000-01-01 00:00:00';

to the end of sql/update.sql and then run update.php as admin

pols1337 · July 07, 2014, 10:43:10 PM

Quote from: Αndré on July 04, 2014, 08:27:08 PM
Actually, the easiest solution (that will also be part of cpg1.5.30) is to add
Code Select Expand
ALTER TABLE CPG_comments CHANGE `msg_date` `msg_date` datetime NOT NULL default '1000-01-01 00:00:00'; ALTER TABLE CPG_pictures CHANGE `mtime` `mtime` datetime NOT NULL default '1000-01-01 00:00:00'; ALTER TABLE CPG_users CHANGE `user_lastvisit` `user_lastvisit` datetime NOT NULL default '1000-01-01 00:00:00'; ALTER TABLE CPG_users CHANGE `user_regdate` `user_regdate` datetime NOT NULL default '1000-01-01 00:00:00';
to the end of sql/update.sql and then run update.php as admin

I did those two steps. Please see screenshot for my results from update.sql

But when I attempt to batch upload files, I still get the unknown file icon.

pols1337 · July 07, 2014, 10:52:47 PM

Hold on, I may have figured out the problem on my end since I'm still getting the same error:

Code Select

While executing query 'INSERT INTO cpg15x_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position, guest_token) VALUES ('23', 'userpics/10001/', '97c463ff8709fb08a0d07aa9769f2616.jpg', '138911', '177418', '691', '1238', '1404766211', '1', 'Sample photo', 'Description for sample photo', '', 'YES', '', '', '', '', '66.199.97.83', '66.199.97.83', '0', '')' in include/picmgmt.inc.php on line 173

mySQL error: Incorrect datetime value: '0000-00-00 00:00:00' for column 'mtime' at row 1

I think the local server's socket is not configured correctly, so I'm going to have my server admin take a look.

coppermine-gallery.com/forum

News:

Cannot Upload - Database Error?

pols1337

pols1337

pols1337

ron4mac

phill104

Αndré

Αndré

pols1337

phill104

ron4mac

Αndré

pols1337

pols1337