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

Comments

nicrodgers created an issue. See original summary.

nicrodgers’s picture

nicrodgers
Primary language English
Location Monmouthshire, UK
commented
Status: Active » Needs review
StatusFileSize
new 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
commented
Assigned: nicrodgers » Unassigned
jgrubb’s picture

jgrubb commented
Assigned: Unassigned » jgrubb
nicrodgers’s picture

nicrodgers
Primary language English
Location Monmouthshire, UK
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 commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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