[ic] table editor problems with sql database

[Jim Balcom]

On Fri, 5 Oct 2001, Ed LaFrance wrote:

EL>>>Ok I tracked it down to why the table editor isn't working with sql tables
EL>>>for me, but not sure on the best fix.  Basically, my sql database is very
EL>>>large, and the table editor is not setting mv_auto_export so the changes
EL>>>are not being saved.  If I manually add mv_auto_export=tablename to the
EL>>>resulting html it works fine.  I do not have noexport set btw.
EL>>
EL>>Exporting just creates a text copy of your sql table in tablename.txt.  You
EL>>should not need to do it unless you have a specific reason for wanting the
EL>>text file synchronized with the sql table, as far as I know. Just make sure
EL>>that the mv_searchtype (st) for searches of the table is db or sql, not
EL>>text, and you should be ok.

In 4.6.5 there are a few files in the default db that need to be exported if
you are going to work outside of the user interfaces.

I am finding that area.txt and cat.txt usually need to be exported and
manipulated manually in order to get the pages to come up correctly. If I
leave the sort order and displays to the UI, they don't get displayed the
way that I was trying for.

The user database also needs to be exported in order for me to see the users
password when I need to log in as the customer to enter an order - usually
because the customer refuses to upgrade their browser in order to deal with
my 128-bit security.



-= Jim =-

----------------------------------------------------------------
Jim's Linux-Operated Underground Bomb Shelter

Tagline for Friday, October 05, 2001 at 19:20 PM:
Save the whales. Collect the whole set.

----------------------------------------------------------------
This Linux System has been up 265 hours

My web page: http://www.idk-enterprises.com
----------------------------------------------------------------