edit-task

Task Name:

Task Description:

TaskGroup ID:

Start Date:

Start Time:

Duration:

Priority:

Status:

Add Photo:

Owner ID:

Content: use HTML Edit Content

<h1 style="text-align: center;">SCRIPT-db_create-v-016</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[REFERENCE] HAVE</strong></li>
<ol>
<li>] # # - script.sql create-database - &nbsp;<a href="/view/task?id=2793" target="_blank">ovu, status</a></li>
</ol>
<li><strong>[2014-12-dd] # # - CREATE-FILE-script-v-016.sql -</strong></li>
<ol>
<li>x]&nbsp;&nbsp;used v-015 - thinking that I have already made some of these changes</li>
</ol>
<li><strong>x] CREATE doc records</strong></li>
<ol>
<li>x] # 4568 - v-015</li>
<li>x] # 4569 - v-016 -</li>
</ol>
<li><strong>x] REVIEW notes from records db-v-014</strong></li>
<ol>
<li>*] notes&nbsp;show that some of these&nbsp;changes have been made&nbsp;(DROP tables ]books in lib, ] chapters ...</li>
<li>x] explains process of constructing CREATE script FROM ....</li>
</ol>
<li><strong>x]&nbsp;RESET all auto increment #'s</strong><ol>
<li>x] to 1</li>
</ol></li>
<li><strong>x] REMOVEd - tables </strong></li>
<ol>
<li>x] webpages-membership</li>
<li>x] tech-hw (custom)</li>
<li>x] viewBooksInLibrary,</li>
<li>x] viewChaptersInBook</li>
</ol>
<li><strong>x] ADD</strong></li>
<ol>
<li>x] photo field to table books as per notes v-014</li>
</ol>
<li><strong>[2014-12-dd] REVIEW notes from record CREATE-db-v-013</strong></li>
<ol>
<li>x]&nbsp;completed - no additional changes requried</li>
</ol>
<li><strong>[2014-12-dd] TEST - script-db-create-v-016</strong><ol>
<li>x] navigate to existing,empty&nbsp;db(db18)</li>
<li>x] sql - paste entire script into</li>
<li>x] RESULT = 31/32 tables created successfully</li>
<li>x] ERROR(s) = 1, view buying - see details below</li>
<li>*] NOTES = view priority and view priority1 are listed as tables, NOT as views</li>
</ol></li>
<li><strong>[2014-12-26] FIX PRB - ERROR db-create</strong></li>
<ol>
<li>x] download 'view creation script' from current db</li>
<li>x] COMPARE - to script in RESULT= dont see the difference</li>
<li>x] swap code for view-buying</li>
<li>x] TRY - generate view with new script&nbsp;RESULT=PASS</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>]</li>
</ol>
<h2>[next]</h2>
<ol>
<li><strong>]</strong></li>
</ol>
<div><hr /><strong><br /></strong></div>
<p><strong>ERROR</strong></p>
<p>CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`donS2`@`%` SQL SECURITY DEFINER VIEW `view_buying` AS select `items`.`id_item` AS `id_item`,`items`.`name_item` AS `name_item`,`items`.`description_item` AS `description_item`,`items`.`parent_id` AS `parent_id`,`items`.`cogs` AS `cogs`,`items`.`quantity` AS `quantity`,`items`.`unit` AS `unit`,`items`.`content_item` AS `content_item`,`items`.`content_format` AS `content_format`,`items`.`photo` AS `photo`,`items`.`status` AS `status`,`items`.`owner` AS `owner`,`items`.`priority` AS `priority`,`itemcategories`.`name_itemCategory` AS `name_itemCategory`,`itemcategories`.`id_itemCategory` AS `id_itemCategory`,`itemcategories`.`parent_id` AS `parent_id_itemCategory`,`inventories`.`name_inventory` AS `name_inventory`,`inventories`.`id_inventory` AS `id_inventory`,`inventories`.`parent_id` AS `inventory_parent_id`,`warehouses`.`name_warehouse` AS `name_warehouse`,`warehouses`.`id_wareh[...]</p>
<p><strong>MySQL said: </strong><a href="http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html" target="mysql_doc"><img class="icon" title="Documentation" src="http://phpmyadmin.basil.arvixe.com/themes/original/img/b_help.png" alt="Documentation" width="11" height="11" /></a></p>
<p><code> #1054 - Unknown column 'itemcategories.<br /><br /> name_itemCategory' in 'order clause'</code></p>