[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Help, database is rebuilding by itself
Help! We are using an mSQL database and for some reason (i can't figure out
what might be causing this since the page referenced is process) when
everything is chugging along nicely, minivend will decide to kill the
database and creates a new one, except it doesn't bother to repopulate it
with any records.
In my catalog.cfg i have set the NoImport directive to : NoImport products
i've included all the corrrect COLUMN_DEFs. I've tried taking out the
NoImport directive but it fails to reimport the database anyway.
If anyone can give me a clue as to what in my code could be causing this
because i have no idea. Mike H. please any insights on why/when this would
occur be very appreciated.
I'm running MV 3.14-3 on solaris using perl 5.005_2. If you need to know
anything else about my setup please let me know. I'm pretty desperate to
get this fixed.
Thanks in advance,
mike k.
snippet of catalog's error.log below.
web1{519}# cat ~/catalogs/anime/error.log
206.154.215.19 5FT8MKe3:206.154.215.19 - [29/November/1999:22:13:10 -0500]
anime /cgi-bin/anime/process table products created: create table products
> code char(32) primary key,
> site char(32),
> category char(8),
> subcategory char(64),
> description char(128),
> cost real,
> weight real,
> new int,
> release char(32),
> product_detail char(128),
> image char(64),
> sale int,
> sale_price real,
> special char(128),
> mature int,
> keyword char(128),
> i_height char(8),
> i_width char(8),
> qty_sold int,
> spo int
> )
>
206.154.215.19 5FT8MKe3:206.154.215.19 - [29/November/1999:22:13:10 -0500]
anime /cgi-bin/anime/process table products index failed: Error reading
table "products" definition (No such file or directory)
206.154.215.19 5FT8MKe3:206.154.215.19 - [29/November/1999:22:13:10 -0500]
anime /cgi-bin/anime/process Runtime error: Error reading table "products"
definition (No such file or directory)
>
205.188.193.179 HnJqeW57:205.188.208.69 - [29/November/1999:22:13:36 -0500]
anime /cgi-bin/anime/scan/MM=28ea437e5641fcf9ad739b7b95514d3e:80:84:10:
Runtime error: execute error: Error reading table "products" definition (No
such file or directory) at /web1/pa000001/mvend/lib/Vend/Table/DBI.pm line
541.
>