If you attempt to clone a search page with a label longer than 23 characters, you get an SQL error message:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'label' at row 1: INSERT INTO {apachesolr_search_page} (page_id, label, description, env_id, search_path, page_title, settings) VALUES ...

This is because the length of the field in the database table is 32 characters, and the clone function is appending " [cloned]" to the existing label, regardless of the existing label's length.

CommentFileSizeAuthor
#2 2614666-cloning_search_page_length-02.patch729 bytesnicrodgers
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

nicrodgers created an issue. See original summary.

nicrodgers’s picture

nicrodgers
Primary language English
Location Monmouthshire, UK
CreditAttribution: nicrodgers at Welsh Government commented
Status: Active » Needs review
FileSize
2614666-cloning_search_page_length-02.patch729 bytes

Attached patch to trim the cloned label to 32 characters where necessary.

nicrodgers’s picture

nicrodgers
Primary language English
Location Monmouthshire, UK
CreditAttribution: nicrodgers at Welsh Government commented
Assigned: nicrodgers » Unassigned
jgrubb’s picture

jgrubb CreditAttribution: jgrubb as a volunteer commented
Assigned: Unassigned » jgrubb
nicrodgers’s picture

nicrodgers
Primary language English
Location Monmouthshire, UK
CreditAttribution: nicrodgers at Welsh Government commented
Assigned: jgrubb » Unassigned

Unassigning, after 7 months of inactivity.

  • nicrodgers authored ed4d812 on 7.x-1.x 
    Issue #2614666 by nicrodgers: SQL error attempting to clone search page...
jgrubb’s picture

jgrubb CreditAttribution: jgrubb as a volunteer commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.