Gossamer Forum
Home : Products : Gossamer Links : Discussions :

adding a new table while it did not appeared in editor window?????

Quote Reply
adding a new table while it did not appeared in editor window?????
 


i use creator to creat a new table . the same scirpt it works well before and i get what i expected.

how i try to create a new table. while it do create a new table in mysql. while it is no longer appreaed in
editor window ( only show me user. links review............ the new table suposed to be appreaed it as well.. the new table should have appeared here as well)


i wonder what spep i miised? i do a recycle already. or i accsidently deleate any def fine.
? ( i saw the respective def has reside there and the new table has been created in mysql)



i wonder if anyone experience this problem before?
Quote Reply
Re: [courierb] adding a new table while it did not appeared in editor window????? In reply to
Mm, not sure what your asking? =)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [courierb] adding a new table while it did not appeared in editor window????? In reply to
  


Code:
#!/usr/local/bin/perl -w
use lib '/admin';

use Links qw/$DB/;

Links::init('/admin');
my $c = $DB->creator('linktest');
$c->cols([
rl_id => { type => 'INT', not_null => 1 },
rl_url => { type => 'CHAR', size => 255 },
retail_id_fk => { type => 'INT', not_null => 1 },
link_id_fk => { type => 'INT', not_null => 1}
]);
$c->pk('rl_id'); # Set primary key
$c->ai('rl_id'); # Make it auto incremenet
$c->index({
retail_ndx => ['retail_id_fk'],
link_ndx => ['link_id_fk']
}); # Setup indexes for faster searches
$c->fk({
Links => { ID => 'link_id_fk' },
Retailers => { retail_id => 'rl_id' },
}); # Setup foreign keys
$c->create or die "Create failed: $GT::SQL::error";


when i click
http://mydomain.com/admin/admin.cgi
and
http://mydomain.com/admin/admin.cgi?page=db.html

normally the newly created table will apppeared in teh drop down list there
so i could manipulate it accordingly (do the Table Maintenance for add new column change column properties
and the def file will be updated by the system)

Now i found the table was setted up in the database already. and the glink_linktest.def has beed created too
i also do the Resync . but i did not see table "linktest" appeared in the dropped down list in editor window.
(http://mydomain.com/admin/admin.cgi?page=db.html)

i suspect i have mess up somthing or miss some prodedure .
Quote Reply
Re: [courierb] adding a new table while it did not appeared in editor window????? In reply to
Mmm, afraid I'm not sure - sorry. Maybe Adrian/someone at GT can shed some light.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] adding a new table while it did not appeared in editor window????? In reply to
i edited db_nav.html now and now everthing is ok.
maybe i just forget how i did it before.

anyway thanks Andy