[ic] Errors with flex_editor and products directory

[Ron Phipps]

Rick Bragg wrote:
> On Thu, 2008-10-23 at 20:40 +0300, Gert van der Spoel wrote:
>>> -----Original Message-----
>>> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
>>> users-bounces at icdevgroup.org] On Behalf Of Josh Lavin
>>> Sent: donderdag 23 oktober 2008 19:24
>>> To: interchange-users at icdevgroup.org
>>> Subject: Re: [ic] Errors with flex_editor and products directory
>>>
>>> On Oct 23, 2008, at 10:41 AM, Rick Bragg wrote:
>>>
>>>> Hi,
>>>>
>>>> I don't know when it happened, but for some reason, I can't update
>>> any
>>>> data through the admin interface.  Whenever I go to change anything
>>>> in a
>>>> table via the admin interface, I get the following error:
>>>>
>>>> Sorry, there was an error in processing this form action. Please
>>>> report
>>>> the error or try again later. (Cannot open database text source
>>>> file /var/www/www.website.com/catalog/products/COLUMN_DEF: No such
>>>> file
>>>> or directory )
>>>
>>> Check your dbconf/mysql/*.mysql files (or whatever database you're
>>> using). I bet that one of them has the COLUMN_DEF field in the wrong
>>> place...
>> Or a COLUMN_DEF for table X in the .mysql file for table Y  (added a new
>> table and c&p'ed some COLUMN_DEF lines?)
>>
>> CU,
>>
>> Gert
>>
> 
> This has to be it! I did lots of work on these files however, things
> look OK.  Is the format for these .mysql files picky? Is whitespace,
> tabs, etc OK? Will one bad .mysql file break ALL tables in the
> flex_editor? Also, do I need to delete all my .*.sql files and import
> everything again? or can I just edit a .mysql file and restart IC?
> 
> Thanks!
> Rick
> 
> 

Hi Rick,

If you continue to have issues with keeping the .txt and .sql files in 
sync with the database you might consider using the DatabaseAuto 
directive which looks to the database to provide all the information 
about the database at start up.  I use this setting on all of my 
client's sites, both MySQL and Postgres.

Good luck!

-- 
Ron Phipps
End Point Corporation
ron at endpoint.com