Barrels Up Your Woods or Mine Tshirt

SQL Error

Date:

2013-06-19 00:26:57 (CDT)

SQL Error:

Duplicate entry '32767' for key 'PRIMARY'

SQL:

insert into templates set layout_type='MyDB', theme='detail_template', name='', data=' {literal} {/literal} {if $products_list.custom_fields.field_1!=""}{/if} {if $products_list.custom_fields.field_2!=""}{/if} {if $products_list.custom_fields.field_3!=""}{/if} {if $products_list.custom_fields.field_4!=""}{/if} {if $products_list.custom_fields.field_5!=""}{/if} {if $products_list.custom_fields.field_6!=""}{/if} {if $products_list.custom_fields.field_7!=""}{/if} {if $products_list.custom_fields.field_8!=""}{/if} {if $products_list.custom_fields.field_9!=""}{/if} {if $products_list.custom_fields.field_10!=""}{/if} {if $products_list.custom_fields.field_11!=""}{/if} {if $products_list.custom_fields.field_12!=""}{/if} {if $products_list.custom_fields.field_13!=""}{/if} {if $products_list.custom_fields.field_14!=""}{/if} {if $products_list.custom_fields.field_15!=""}{/if} {if $products_list.custom_fields.field_16!=""}{/if} {if $products_list.custom_fields.area_1!=""}{/if} {if $products_list.custom_fields.area_2!=""}{/if} {if $products_list.custom_fields.area_3!=""}{/if} {if $products_list.custom_fields.area_4!=""}{/if} {if $products_list.custom_fields.area_5!=""}{/if} {if $products_list.custom_fields.area_6!=""}{/if} {if $products_list.custom_fields.area_7!=""}{/if} {if $products_list.custom_fields.area_8!=""}{/if}

Name	{$products_list.fields.name}
Unique Identifier	{$products_list.fields.sku}
Description	{$products_list.fields.description}
keywords	{$products_list.fields.keywords}
Available	{$products_list.fields.available}
Active	{$products_list.fields.active}
field_1	{$products_list.custom_fields.field_1}
field_2	{$products_list.custom_fields.field_2}
field_3	{$products_list.custom_fields.field_3}
field_4	{$products_list.custom_fields.field_4}
field_5	{$products_list.custom_fields.field_5}
field_6	{$products_list.custom_fields.field_6}
field_7	{$products_list.custom_fields.field_7}
field_8	{$products_list.custom_fields.field_8}
field_9	{$products_list.custom_fields.field_9}
field_10	{$products_list.custom_fields.field_10}
field_11	{$products_list.custom_fields.field_11}
field_12	{$products_list.custom_fields.field_12}
field_13	{$products_list.custom_fields.field_13}
field_14	{$products_list.custom_fields.field_14}
field_15	{$products_list.custom_fields.field_15}
field_16	{$products_list.custom_fields.field_16}
area_1	{$products_list.custom_fields.area_1}
area_2	{$products_list.custom_fields.area_2}
area_3	{$products_list.custom_fields.area_3}
area_4	{$products_list.custom_fields.area_4}
area_5	{$products_list.custom_fields.area_5}
area_6	{$products_list.custom_fields.area_6}
area_7	{$products_list.custom_fields.area_7}
area_8	{$products_list.custom_fields.area_8}

', access='2'

Backtrace:

Array ( [0] => Array ( [file] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/functions/database_connections.php [line] => 170 [function] => error [class] => dbobject [object] => dbobject Object ( [connection] => Resource id #4 [results] => [dbname] => le_barrelsup [host] => 10.176.233.96 [user] => le_barrelsup [password:dbobject:private] => 2d93c5de8aa0 [error] => Duplicate entry '32767' for key 'PRIMARY' [results_array] => [numrows] => 0 ) [type] => -> [args] => Array ( [0] => insert into templates set layout_type='MyDB', theme='detail_template', name='', data=' {literal} {/literal} {if $products_list.custom_fields.field_1!=""}{/if} {if $products_list.custom_fields.field_2!=""}{/if} {if $products_list.custom_fields.field_3!=""}{/if} {if $products_list.custom_fields.field_4!=""}{/if} {if $products_list.custom_fields.field_5!=""}{/if} {if $products_list.custom_fields.field_6!=""}{/if} {if $products_list.custom_fields.field_7!=""}{/if} {if $products_list.custom_fields.field_8!=""}{/if} {if $products_list.custom_fields.field_9!=""}{/if} {if $products_list.custom_fields.field_10!=""}{/if} {if $products_list.custom_fields.field_11!=""}{/if} {if $products_list.custom_fields.field_12!=""}{/if} {if $products_list.custom_fields.field_13!=""}{/if} {if $products_list.custom_fields.field_14!=""}{/if} {if $products_list.custom_fields.field_15!=""}{/if} {if $products_list.custom_fields.field_16!=""}{/if} {if $products_list.custom_fields.area_1!=""}{/if} {if $products_list.custom_fields.area_2!=""}{/if} {if $products_list.custom_fields.area_3!=""}{/if} {if $products_list.custom_fields.area_4!=""}{/if} {if $products_list.custom_fields.area_5!=""}{/if} {if $products_list.custom_fields.area_6!=""}{/if} {if $products_list.custom_fields.area_7!=""}{/if} {if $products_list.custom_fields.area_8!=""}{/if}

Name	{$products_list.fields.name}
Unique Identifier	{$products_list.fields.sku}
Description	{$products_list.fields.description}
keywords	{$products_list.fields.keywords}
Available	{$products_list.fields.available}
Active	{$products_list.fields.active}
field_1	{$products_list.custom_fields.field_1}
field_2	{$products_list.custom_fields.field_2}
field_3	{$products_list.custom_fields.field_3}
field_4	{$products_list.custom_fields.field_4}
field_5	{$products_list.custom_fields.field_5}
field_6	{$products_list.custom_fields.field_6}
field_7	{$products_list.custom_fields.field_7}
field_8	{$products_list.custom_fields.field_8}
field_9	{$products_list.custom_fields.field_9}
field_10	{$products_list.custom_fields.field_10}
field_11	{$products_list.custom_fields.field_11}
field_12	{$products_list.custom_fields.field_12}
field_13	{$products_list.custom_fields.field_13}
field_14	{$products_list.custom_fields.field_14}
field_15	{$products_list.custom_fields.field_15}
field_16	{$products_list.custom_fields.field_16}
area_1	{$products_list.custom_fields.area_1}
area_2	{$products_list.custom_fields.area_2}
area_3	{$products_list.custom_fields.area_3}
area_4	{$products_list.custom_fields.area_4}
area_5	{$products_list.custom_fields.area_5}
area_6	{$products_list.custom_fields.area_6}
area_7	{$products_list.custom_fields.area_7}
area_8	{$products_list.custom_fields.area_8}

', access='2' ) ) [1] => Array ( [file] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/modules/MyDB/admin/lib/my_db.class.php [line] => 98 [function] => sql [class] => dbobject [object] => dbobject Object ( [connection] => Resource id #4 [results] => [dbname] => le_barrelsup [host] => 10.176.233.96 [user] => le_barrelsup [password:dbobject:private] => 2d93c5de8aa0 [error] => Duplicate entry '32767' for key 'PRIMARY' [results_array] => [numrows] => 0 ) [type] => -> [args] => Array ( [0] => insert into templates set layout_type='MyDB', theme='detail_template', name='', data=' {literal} {/literal} {if $products_list.custom_fields.field_1!=""}{/if} {if $products_list.custom_fields.field_2!=""}{/if} {if $products_list.custom_fields.field_3!=""}{/if} {if $products_list.custom_fields.field_4!=""}{/if} {if $products_list.custom_fields.field_5!=""}{/if} {if $products_list.custom_fields.field_6!=""}{/if} {if $products_list.custom_fields.field_7!=""}{/if} {if $products_list.custom_fields.field_8!=""}{/if} {if $products_list.custom_fields.field_9!=""}{/if} {if $products_list.custom_fields.field_10!=""}{/if} {if $products_list.custom_fields.field_11!=""}{/if} {if $products_list.custom_fields.field_12!=""}{/if} {if $products_list.custom_fields.field_13!=""}{/if} {if $products_list.custom_fields.field_14!=""}{/if} {if $products_list.custom_fields.field_15!=""}{/if} {if $products_list.custom_fields.field_16!=""}{/if} {if $products_list.custom_fields.area_1!=""}{/if} {if $products_list.custom_fields.area_2!=""}{/if} {if $products_list.custom_fields.area_3!=""}{/if} {if $products_list.custom_fields.area_4!=""}{/if} {if $products_list.custom_fields.area_5!=""}{/if} {if $products_list.custom_fields.area_6!=""}{/if} {if $products_list.custom_fields.area_7!=""}{/if} {if $products_list.custom_fields.area_8!=""}{/if}

Name	{$products_list.fields.name}
Unique Identifier	{$products_list.fields.sku}
Description	{$products_list.fields.description}
keywords	{$products_list.fields.keywords}
Available	{$products_list.fields.available}
Active	{$products_list.fields.active}
field_1	{$products_list.custom_fields.field_1}
field_2	{$products_list.custom_fields.field_2}
field_3	{$products_list.custom_fields.field_3}
field_4	{$products_list.custom_fields.field_4}
field_5	{$products_list.custom_fields.field_5}
field_6	{$products_list.custom_fields.field_6}
field_7	{$products_list.custom_fields.field_7}
field_8	{$products_list.custom_fields.field_8}
field_9	{$products_list.custom_fields.field_9}
field_10	{$products_list.custom_fields.field_10}
field_11	{$products_list.custom_fields.field_11}
field_12	{$products_list.custom_fields.field_12}
field_13	{$products_list.custom_fields.field_13}
field_14	{$products_list.custom_fields.field_14}
field_15	{$products_list.custom_fields.field_15}
field_16	{$products_list.custom_fields.field_16}
area_1	{$products_list.custom_fields.area_1}
area_2	{$products_list.custom_fields.area_2}
area_3	{$products_list.custom_fields.area_3}
area_4	{$products_list.custom_fields.area_4}
area_5	{$products_list.custom_fields.area_5}
area_6	{$products_list.custom_fields.area_6}
area_7	{$products_list.custom_fields.area_7}
area_8	{$products_list.custom_fields.area_8}

', access='2' ) ) [2] => Array ( [file] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/modules/MyDB/product_detail.php [line] => 70 [function] => __get [class] => My_DB [object] => My_DB Object ( [db_id] => 30 [description] => [active] => [rows] => [headers] => Array ( [field_1] => Price [field_2] => Cost [field_3] => Supplier [field_4] => Handling Charge [field_5] => Tax [field_6] => Shipping [field_7] => [field_8] => [field_9] => [field_10] => [field_11] => [field_12] => [field_13] => [field_14] => [field_15] => [field_16] => [area_1] => Description [area_2] => Sizes [area_3] => Colors [area_4] => Styles [area_5] => [area_6] => [area_7] => [area_8] => ) [sqldb:My_DB:private] => dbobject Object ( [connection] => Resource id #4 [results] => [dbname] => le_barrelsup [host] => 10.176.233.96 [user] => le_barrelsup [password:dbobject:private] => 2d93c5de8aa0 [error] => Duplicate entry '32767' for key 'PRIMARY' [results_array] => [numrows] => 0 ) [dry:My_DB:private] => [name] => [list_template_id] => [detail_template_id] => [detail_template] => ) [type] => -> [args] => Array ( [0] => detail_template ) ) [3] => Array ( [file] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/modules/MyDB/module_include.php [line] => 8 [args] => Array ( [0] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/modules/MyDB/product_detail.php ) [function] => include ) [4] => Array ( [file] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/index.php [line] => 346 [args] => Array ( [0] => /var/smartsite/production/webs/barrelsup.le1.getliveedit.com/content/modules/MyDB/module_include.php ) [function] => include ) )

Featured Product

Lets Talk Outdoors

The Gallery