Gossamer Forum
Home : Products : DBMan SQL : Discussion :

BUG? new table&template invisible in admin area

Quote Reply
BUG? new table&template invisible in admin area
I found a strang question, could anyone help me?

First I install DBman SQL 2.0.2 in a test server in my Intranet. After I add 2 DB tables and 2 set of templates, I move all files and MySQL tables to my official public server. DBman can run in new server, can use this two tables and templates. But I found a strang question in admin area in new server: I can not find these tables and templates in their drop-down box list. In the old server, everything is OK.

I am sure the configure of apache in the 2 server is same. I do not change the file owner & property.
Quote Reply
Re: [cfox] BUG? new table&template invisible in admin area In reply to
Hi,

In Dbsql 2.0, all normal table configurations are stored in another table called Dbsql. Did you move that table as well?
The quick fix for this is just go to Admin >> Create table and create a new table with the same name of your old table . The DbSQL2 will automatically know this table exists and will create a new setup for the table.

Cheers,
jean@gossamer-threads.com

Last edited by:

jean: Jan 31, 2002, 8:52 PM
Quote Reply
Re: [jean] BUG? new table&template invisible in admin area In reply to
Yes. I moved all tables. The Dbsql tables in two server is same.

Ok, your solution worked. When I tried to create the same table, it told me: Table *** have been loaded. Then all are OK.

But how about templates?
Quote Reply
Re: [cfox] BUG? new table&template invisible in admin area In reply to
Hi,

You can set up the template that is used at Admin - Editor - Setup (you have to choose the table which you want to setup at table drop down ).

TheStone.

B.
Quote Reply
Re: [TheStone] BUG? new table&template invisible in admin area In reply to
In the old server I have set up the table to use another set of templates, and it used.

In the new server, the program also used that templates. But when I checked in the admin area > tables > Editors> setup, it used default templates, my templates is invisible in the templates drop-down list.

I checked table Dbsql, the table is using my templates:

+---------------+---------------+
| Tablename | template |
+---------------+---------------+
| doc | doc |
+---------------+---------------+

How to let it know the new templates?
Quote Reply
Re: [cfox] BUG? new table&template invisible in admin area In reply to
Hi,

Take a look at admin/templates, make sure that your template folder does exist.

TheStone.

B.
Quote Reply
Re: [TheStone] BUG? new table&template invisible in admin area In reply to
Yes. It exist. I copyed from default and modified it.

The program know the template, and have been using it. The template is only invisible in template drop-down list.
Quote Reply
Re: [cfox] BUG? new table&template invisible in admin area In reply to
You need to upload your .def files also, thats were the info comes from.Smile
Quote Reply
Re: [Suomi] BUG? new table&template invisible in admin area In reply to
Yes, I uploaded every file. I tar the DBman dir and uploaded. I checked the def files. They are exact same.
Quote Reply
Re: [cfox] BUG? new table&template invisible in admin area In reply to
Hi,

Can you send me the link and admin info of DBMan SQL at

Last edited by:

TheStone: Jul 16, 2003, 1:10 PM