We moved the site (ExpressionEngine 1.6.2 - Build: 20080129) to a new server. We did a “backup” and “restore” of the database. And now I’m getting 2 errors.
1. When I try to enter new url values for the gallery module. It says:
MySQL ERROR:
Error Number: 1406
Description: Data too long for column 'gallery_auto_link_urls' at row 1
Query: UPDATE `exp_galleries` SET `gallery_full_name` = 'Portfolio', `gallery_short_name` = 'portfolio_gallery', `gallery_url` = 'http://devweb/2008/index.php/portfolio_gallery/', `gallery_comment_url` = 'http://devweb/2008/index.php/portfolio_gallery/comments/', `gallery_upload_folder` = 'mg_portfolio', `gallery_upload_path` = 'D:/Inetpub/wwwroot/2008/images/mg_portfolio/', `gallery_image_url` = 'http://devweb/2008/images/mg_portfolio/', `gallery_batch_folder` = 'portfolio_batch', `gallery_batch_path` = 'D:/Inetpub/wwwroot/2008/images/portfolio_batch/', `gallery_batch_url` = 'http://devweb/2008/images/portfolio_batch/', `gallery_text_formatting` = 'none', `gallery_auto_link_urls` = 'yes', `gallery_image_protocal` = 'gd2', `gallery_image_lib_path` = '', `gallery_create_thumb` = 'yes', `gallery_thumb_prefix` = '_thumb', `gallery_create_medium` = 'yes', `gallery_medium_prefix` = '_medium', `gallery_thumb_width` = '75', `gallery_thumb_height` = '75', `gallery_medium_width` = '456', `gallery_medium_height` = '304', `gallery_maintain_ratio` = 'yes', `gallery_thumb_quality` = '75', `gallery_medium_quality` = '90', `gallery_wm_type` = 'n', `gallery_wm_vrt_alignment` = 'T', `gallery_wm_hor_alignment` = 'L', `gallery_wm_padding` = '10', `gallery_wm_x_offset` = '0', `gallery_wm_y_offset` = '0', `gallery_wm_apply_to_thumb` = 'n', `gallery_wm_apply_to_medium` = 'n', `gallery_wm_text` = 'Copyright 2008', `gallery_wm_use_font` = 'y', `gallery_wm_font` = 'texb.ttf', `gallery_wm_font_size` = '16', `gallery_wm_text_color` = '#ffff00', `gallery_wm_use_drop_shadow` = 'y', `gallery_wm_shadow_distance` = '1', `gallery_wm_shadow_color` = '#999999', `gallery_wm_image_path` = 'D:/Inetpub/wwwroot/2008/themes/cp_global_images//watermark.png', `gallery_wm_opacity` = '50', `gallery_wm_x_transp` = '2', `gallery_wm_y_transp` = '2', `gallery_wm_test_image_path` = 'D:/Inetpub/wwwroot/2008/themes/cp_global_images//watermark_test.jpg', `gallery_cf_one` = 'n', `gallery_cf_one_label` = 'Custom Field One', `gallery_cf_one_formatting` = 'xhtml', `gallery_cf_one_auto_link` = 'y', `gallery_cf_one_type` = 'i', `gallery_cf_one_rows` = '12', `gallery_cf_one_list` = '', `gallery_cf_one_searchable` = 'y', `gallery_cf_two` = 'n', `gallery_cf_two_label` = 'Custom Field Two', `gallery_cf_two_formatting` = 'xhtml', `gallery_cf_two_auto_link` = 'y', `gallery_cf_two_type` = 'i', `gallery_cf_two_rows` = '12', `gallery_cf_two_list` = '', `gallery_cf_two_searchable` = 'y', `gallery_cf_three` = 'n', `gallery_cf_three_label` = 'Custom Field Three', `gallery_cf_three_formatting` = 'xhtml', `gallery_cf_three_auto_link` = 'y', `gallery_cf_three_type` = 'i', `gallery_cf_three_rows` = '12', `gallery_cf_three_list` = '', `gallery_cf_three_searchable` = 'y', `gallery_cf_four` = 'n', `gallery_cf_four_label` = 'Custom Field Four', `gallery_cf_four_formatting` = 'xhtml', `gallery_cf_four_auto_link` = 'y', `gallery_cf_four_type` = 'i', `gallery_cf_four_rows` = '12', `gallery_cf_four_list` = '', `gallery_cf_four_searchable` = 'y', `gallery_cf_five` = 'n', `gallery_cf_five_label` = 'Custom Field Five', `gallery_cf_five_formatting` = 'xhtml', `gallery_cf_five_auto_link` = 'y', `gallery_cf_five_type` = 'i', `gallery_cf_five_rows` = '12', `gallery_cf_five_list` = '', `gallery_cf_five_searchable` = 'y', `gallery_cf_six` = 'n', `gallery_cf_six_label` = 'Custom Field Six', `gallery_cf_six_formatting` = 'xhtml', `gallery_cf_six_auto_link` = 'y', `gallery_cf_six_type` = 'i', `gallery_cf_six_rows` = '12', `gallery_cf_six_list` = '0', `gallery_cf_six_searchable` = 'y', `gallery_allow_comments` = 'no', `gallery_comment_require_membership` = 'no', `gallery_comment_use_captcha` = 'no', `gallery_comment_expiration` = '0', `gallery_comment_max_chars` = '2500', `gallery_comment_timelock` = '30', `gallery_comment_require_email` = 'yes', `gallery_comment_text_formatting` = 'xhtml', `gallery_comment_html_formatting` = 'safe', `gallery_comment_allow_img_urls` = 'no', `gallery_comment_auto_link_urls` = 'yes', `gallery_comment_notify_authors` = 'no', `gallery_comment_notify` = 'no', `gallery_comment_notify_emails` = '', `gallery_comment_moderate` = 'n' WHERE gallery_id='1</code></pre>
It's odd because according to the source, the value is:
<pre><code>name='gallery_auto_link_urls' value='yes'but the database it setup to handle a single value “y”—right?
I’m not an EE expert. What could have changed? This even happens when I don’t change any of the values.
2. When I log in or out, I receive this message:
MySQL ERROR:
Error Number: 1366
Description: Incorrect integer value: '' for column 'id' at row 1
Query: INSERT INTO `exp_cp_log` (`id`, `member_id`, `username`, `ip_address`, `act_date`, `action`, `site_id`) VALUES ('', '2', 'pmeissner', '192.1.10.17', '1222990207', 'Logged in', '1')