<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugzilla.yoctoproject.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.6"
          urlbase="https://bugzilla.yoctoproject.org/"
          
          maintainer="it-coreprojects-helpdesk@linuxfoundation.org"
>

    <bug>
          <bug_id>13341</bug_id>
          
          <creation_ts>2019-05-08 19:05:34 +0000</creation_ts>
          <short_desc>Fields in orm_layer too small for URLs</short_desc>
          <delta_ts>2023-07-27 09:17:24 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>7</classification_id>
          <classification>Build System, Metadata &amp; Runtime</classification>
          <product>Toaster</product>
          <component>toaster</component>
          <version>0.0.0</version>
          <rep_platform>x86</rep_platform>
          <op_sys>Multiple</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>WORKSFORME</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>Medium</priority>
          <bug_severity>normal</bug_severity>
          <target_milestone>4.3 M2</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="John Gorkos">jgorkos</reporter>
          <assigned_to name="David Reyna">david.reyna</assigned_to>
          <cc>jessica.zhang</cc>
    
    <cc>randy.macleod</cc>
    
    <cc>stanciux.mihail</cc>
          
          <qa_contact name="Toaster default assignee">toaster</qa_contact>
          <cf_os>---</cf_os>
          <cf_regression_type>---</cf_regression_type>
          
          <cf_docchange>Don&apos;t know</cf_docchange>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>83741</commentid>
    <comment_count>0</comment_count>
    <who name="John Gorkos">jgorkos</who>
    <bug_when>2019-05-08 19:05:34 +0000</bug_when>
    <thetext>While installing Toaster &quot;from scratch&quot;, during the &apos;checksettings&apos; phase of the installation manual at step 6 of section 3.9.2, I&apos;m seeing &quot;data too long for column vcs_web_tree_base_url&quot; errors during database population.  After altering the database fields in orm_layer from varchar(200) to varchar(400), I see this:

MariaDB [toaster_data]&gt; select max(length(vcs_web_tree_base_url)) from orm_layer;
+------------------------------------+
| max(length(vcs_web_tree_base_url)) |
+------------------------------------+
|                                205 |
+------------------------------------+
1 row in set (0.001 sec)

MariaDB [toaster_data]&gt; select max(length(vcs_web_file_base_url)) from orm_layer;
+------------------------------------+
| max(length(vcs_web_file_base_url)) |
+------------------------------------+
|                                205 |
+------------------------------------+
1 row in set (0.001 sec)

I&apos;m also seeing other instances of columns being too small for the data:
Updating recipes 13%2019-05-08 10:55:18,691 WARNING Failed saving recipe (1406, &quot;Data too long for column &apos;license&apos; at row 1&quot;)
That appears to be in table orm_recipe, where license is varchar(200).
I&apos;m wondering if just declaring these as &quot;text&quot; or &quot;varchar&quot; of undefined length would be a quick solution.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>96117</commentid>
    <comment_count>1</comment_count>
    <who name="David Reyna">david.reyna</who>
    <bug_when>2023-07-27 09:17:24 +0000</bug_when>
    <thetext>Per Kieran McNulty (WInd River) &quot;I can set up a production instance without raising the error. Used mysql. Although the checksettings command that is supposed to raise an error gives no output, which is suspicious, I can continue with the setup process fine.&quot;

David</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>