I've been trying to add a new field under "Content Management" in the "Input Management" field. The new field I created is called "Hair Style". But when I click on Hair Style and then to "create new item", I get the error
INSERT INTO dt_hair_style(name,relative_order) VALUES('Bald','1')Table 'hfpersonals.dt_hair_style' doesn't exist
after typing in a word and clicking on save. I'd like to know how to fix this problem in case I would like to add another field in the future.
Here is what I've done so far. Maybe someone could tell me what I'm missing.
I created a hair_style.xml page with the following info:
<xml>
<main_table>dt_hair_style</main_table>
<name>Hair Style list</name>
<options>
<opt name="create_record" type="always"></opt>
<opt name="search" type="sometimes"></opt>
<opt name="main_view" type="always"></opt>
</options>
<view>
<vcol name="bd_counter">#</vcol>
<vcol name="name">Name</vcol>
</view>
<edit>
<ecol name="name" type="string" help="input_management.htm#20">Name</ecol>
</edit>
<sql_actions>
<opt name="order" val="id"></opt>
<opt name="search_by" type="name"></opt>
</sql_actions>
</xml>
In the input_management.php file I put in
<tr bgcolor="#FFFFFF" class="maindescbig">
<td valign="middle" width="20"><img src="images/icon_bullet.gif"></td>
<td><a href="main_frame.php?service=hair_style">Hair Style</a></td>
</tr>
Any help is appreciated!
