[ic] Please Unsubscribe.
Jody Aadland
jaadland@ProSavvy.com
Fri, 30 Mar 2001 06:30:14 -0700
please usncubscribe. Thanks much.
-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]
Sent: Friday, March 30, 2001 3:32 AM
To: interchange-users@lists.akopia.com
Subject: Interchange-users digest, Vol 1 #397 - 20 msgs
Send Interchange-users mailing list submissions to
interchange-users@lists.akopia.com
To subscribe or unsubscribe via the web, visit
http://lists.akopia.com/mailman/listinfo/interchange-users
or, via email, send a message with subject or body 'help' to
interchange-users-request@lists.akopia.com
You can reach the person managing the list at
interchange-users-admin@lists.akopia.com
When replying, please edit your Subject line so it is more specific than
"Re: Contents of Interchange-users digest..."
Today's Topics:
1. Re: Recursive Perl Function? (Mike Heins)
2. Re: Quick question about shipping (Mike Heins)
3. Re: Can't locate object method "test_column" via package "Ven
d::Table::InMemory" (Mike Heins)
4. Re: iso-8895-2 character set (Mike Heins)
5. Re: mv_search_line_return and [loop-pos n] (Mike Heins)
6. Query iteration (Jean-Pierre Parent)
7. RE: Database products EXCEL 1 (Andreas, Scott)
8. [matches] tag returning 50 (ml=10) (Tim Nelson)
9. RE: Two simple questions (Greg)
10. Re: mv_search_line_return and [loop-pos n] (Ed LaFrance)
11. Zelerate going under? (Potential Redhat acquisition) (Dan B)
12. Re: Recursive Perl Function? (Ryan Hertz)
13. Re: Simple question (Ryan Hertz)
14. Re: Query iteration (Mike Heins)
15. More Authorize.Net GlobalSub Issues (Jeromie Clark)
16. Re: admin interface (=?iso-8859-1?Q?Gr=E9goire?= Hubert)
17. Re: One store with many admins (Mike Heins)
18. Re: Runtime error: Could not tie to 'products': Is a directory (Mike
Heins)
19. Re: One store with many admins (Mike Heins)
20. cant transfer to Oracle (Sebastian Kummer)
--__--__--
Message: 1
Date: Thu, 29 Mar 2001 11:11:10 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] Recursive Perl Function?
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting Craig Beasland (craig@hotmix.com.au):
> Hi there,
>
> We would like to add a simple Bulletin Board system to one of our systems.
> The simple solution is to add a function which display a line from the
> BBtable, calls itself to see if there are any "children" which in turn
calls
> itself and so on.
>
You might check out the [tree ...] tag in 4.7.x. It allows you to
specify a master item (thread) and then walk down the tree.
You would want a SQL database for it, though, as I think the
overhead for GDBM would be high. And indexing is a must.
id parent code message
1 99 a
2 a b
3 a c
4 a d
5 a x
6 x y
7 x z
8 99 m
9 99 n
10 99 o
11 o e
12 o f
13 o g
The above sample data would produce:
a mv_level=0, mv_increment=1, mv_children=4
b mv_level=1, mv_increment=1, mv_children=0
c mv_level=1, mv_increment=2, mv_children=0
d mv_level=1, mv_increment=3, mv_children=0
x mv_level=1, mv_increment=4, mv_children=2
y mv_level=2, mv_increment=1, mv_children=0
z mv_level=2, mv_increment=2, mv_children=0
m mv_level=0, mv_increment=1, mv_children=0
n mv_level=0, mv_increment=2, mv_children=0
o mv_level=0, mv_increment=3, mv_children=3
e mv_level=1, mv_increment=1, mv_children=0
f mv_level=1, mv_increment=2, mv_children=0
g mv_level=1, mv_increment=3, mv_children=0
from the tag call:
[tree start=99
parent=parent
child=code
autodetect=1
full=1]
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Unix version of an Outlook-style virus:
It works on the honor system. Please forward this message to everyone
you know, and delete a bunch of your files at random.
--__--__--
Message: 2
Date: Thu, 29 Mar 2001 11:19:22 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] Quick question about shipping
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting Thomas N. Stefanidis (thomas@prometheas.gr):
> Hello,
> i have set the shipping method(and it works fine) but don't know how to
> do the last shipping method :
>
> from 100 till 120 cost=220$
> .....
> from 180 till 200 cost=300$
> i can't do that --> "after 200 kilogram add 15$ for every 20 kilogram
> in the last price (300)
>
> so if the weight will be 220 the cost wil be 315,
> if it's 240 it will be 330.
What is wrong with (replace | with TAB):
MODE|Some shipping mode|200|99999|f my $add = int ((@@TOTAL@@ - 200) / 20);
300 + $add * 15;
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Friends don't let friends use Outlook. -- Bob Blaylock
--__--__--
Message: 3
Date: Thu, 29 Mar 2001 11:35:25 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] Can't locate object method "test_column" via package "Ven
d::Table::InMemory"
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting vasile_abo@wexim.com (vasile_abo@wexim.com):
> Hello everybody here
>
> I've got a strange problem with a Interchange 4.6.3
> on a Linux box with perl 5.6. In error.log I got :
> ###################################
> [28/March/2001:03:36:57 -0500] shop /cgi-bin/shop/order_to_print.html
> Safe: Can't locate object method "test_column" via package "Vend::
> Table::InMemory" at [interchange path here]/lib/Vend/Data.pm line 186.
> >
> > return sprintf("%.2f", $Tag->total_cost({noformat=>1}))
> ###################################
>
> In fact, I got this everytime I try to use $Tag->total_cost
> in a Perl subroutine.
> This problem does not happen when using a GDBM table.
> Does anybody has an idea ?
>
Apparently a defect in lib/Vend/Table/InMemory.pm. Add this line near
the bottom with the similar lines:
*test_column = \&Vend::Table::Common::test_column;
This prevents the typical Safe error when trying to access the superclass.
Added to CVS, stable and devel both.
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Fast, reliable, cheap. Pick two and we'll talk. -- unknown
--__--__--
Message: 4
Date: Thu, 29 Mar 2001 11:43:04 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] iso-8895-2 character set
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting klosar18@email.si (klosar18@email.si):
> We're having problems with interchange when trying to
> import/export iso-8859-2 character set,when we export
> the tables to an xls excel format.The character set
> iso8859-2 fails..letters :èæ¾¹ð.The item list page in
> UI admin pages shows them correctly but when you click
> on edit item the edit item page shows them messed
> up,plus if you import the xsl files back even the
> statically build pages get all messed up and the
> characters are written with weird ascii characters that
> no text editor can show correctly .So if anyone has any
> idea where the problem is please let me know.If it
> helps I'll setup another demo store with login and pass
> where the problem can be viewed.We can't inport any
> products in slovenian language because of this problem.
Try importing/exporting to a tab-delimited file and see if you have the
same problem. If you do, then it is an Interchange problem and we
will certainly take a look at it.
If you don't see the same problem, it is a Spreadheet::WriteExcel
or Spreadsheet::ParseExcel problem, or in our interfacing thereto.
But a quick perusal of the docs for those don't mention any methods
which allow us to specify the character set.
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Be patient. God isn't finished with me yet. -- unknown
--__--__--
Message: 5
Date: Thu, 29 Mar 2001 11:43:57 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] mv_search_line_return and [loop-pos n]
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting Ed LaFrance (edl@newmediaems.com):
> Hello all -
>
> When using mv_search_line_return to put a full row from a db (or text
file)
> into search results, it seems that there is no tag display the full
> row. In the case of a loop search, it seems that one must use
[loop-code],
> [loop-pos 1], [loop-pos 2]...etc. Can anyone confirm this, or is their a
> tag which yields all the fields in the row as one string?
[loop-line]
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled. -- Dick Feynman
--__--__--
Message: 6
From: "Jean-Pierre Parent" <parentjp@videotron.ca>
To: <interchange-users@lists.akopia.com>
Date: Thu, 29 Mar 2001 00:14:00 -0500
charset="Windows-1252"
Subject: [ic] Query iteration
Reply-To: interchange-users@lists.akopia.com
Hi,
I've been reading the doc and cant find a complete example on how to do a
custom query and iterate over the returned records. Does one need use
[mvasp][/mvasp] surrounded code in order to loop through a [query][/query]'s
returned values? I have this done using [query arrayref="myArray"] and then
using $Tmp->{myArray} to fetch the ref inside [mvasp][/mvasp]...but i was
wondering if there is a simpler way to do it? I cant avoid using [query]
since I'm using pattern matching operator with MySQL.
I just need the structure with a few hints on which commands would do the
trick and I'll read in the doc...
Something like:
[query sql="..."][/query]
[loop ???]
My HTML here...along with [item ???]
[/loop]
would be perfect...
Thanks.
Jean-Pierre Parent
--__--__--
Message: 7
From: "Andreas, Scott" <Scott.Andreas@learningco.com>
To: "'interchange-users@lists.akopia.com'"
<interchange-users@lists.akopia.com>
Subject: RE: [ic] Database products EXCEL 1
Date: Thu, 29 Mar 2001 09:49:33 -0800
charset="iso-8859-1"
Reply-To: interchange-users@lists.akopia.com
I didn,t know that you were using mysql...Database products EXCEL 1 will
only work on dbm databases and its text files. However there is a solution
to your problem.
First set up a myodbc on both the unix box and an the users box.
Then setup odbc on the windows machine (assumming thats what your client is
using) using myodbc as the driver of choice and then set up the DSN
connection.
Then use MS Access and set up a link tables to mysql via your DSN
Your client will be able to edit the database directly through
MSAccess...and its automatic(no re-importing or exporting)
All of this is in the documentation on maintaining the databases with
MSAccess is under icdatabses.pdf section 8.3
goodluck
-----Original Message-----
From: interchange-users-admin@lists.akopia.com
[mailto:interchange-users-admin@lists.akopia.com]On Behalf Of
Integricity Support
Sent: Wednesday, March 28, 2001 7:52 PM
To: scott andreas
Subject: [ic] Database products EXCEL 1
Hi,
Thanks for your help with the :
Database products EXCEL 1
However, I get an internal server error when I put the line into my
catalog.cfg
I am using MySQL and IC 4.6.3
Could I take a look at your catalog.cfg to find out where you put it?
Is the space b/w the words tabbed or is it a space?
Thanks in advance!
--
Best regards,
Integricity mailto:support@integricity.com
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
--__--__--
Message: 8
Date: Thu, 29 Mar 2001 13:15:47 -0500
To: "'interchange-users@lists.akopia.com'"
<interchange-users@lists.akopia.com>
From: Tim Nelson <TNELSON@ECS-INC.com>
Subject: [ic] [matches] tag returning 50 (ml=10)
Reply-To: interchange-users@lists.akopia.com
I have a search where I set...
[search-region ml=10]
and it correctly returns 10 records per match, but...
Matches [matches] of [match-count] found.
returns....
Matches 1-50 of 198 found.
Do I have to set ml= somewhere else?????
Thanks.
--__--__--
Message: 9
From: "Greg" <g.gaskill@aboron.com>
To: <interchange-users@lists.akopia.com>
Subject: RE: [ic] Two simple questions
Date: Thu, 29 Mar 2001 13:13:48 -0500
charset="iso-8859-1"
Reply-To: interchange-users@lists.akopia.com
> -----Original Message-----
> From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Neil Lunn
> Sent: Thursday, March 29, 2001 4:58 AM
> To: 'interchange-users@lists.akopia.com'
> Subject: RE: [ic] Two simple questions
>
<snip>
>
> > -----Original Message-----
> > From: Jason Osborne [mailto:jason@sohonetworks.cc]
> > Sent: Thursday, March 29, 2001 7:34 PM
> > To: Interchange Mailing List
> > Subject: [ic] Two simple questions
> >
> > 2. How to I make Interchange publish the static pages to the
> > root of the
> > companies website? Right now it is putting all the static
> > pages under a
> > subdirectory.
>
> Configure the catalog that way.
> [ie From catalog.cfg]
<snip>
You could also do the opposite and change your apache web server
config to inculde this line in the set-up for your site:
DirectoryIndex /cgi-bin/construct/index.html
Assuming all the defaults for the Construct Something Demo
store were used, and that you have the ability to get the apache
config edited.
Greg Gaskill
--__--__--
Message: 10
Date: Thu, 29 Mar 2001 11:01:18 -0800
To: interchange-users@lists.akopia.com
From: Ed LaFrance <edl@newmediaems.com>
Subject: Re: [ic] mv_search_line_return and [loop-pos n]
<5.0.2.1.0.20010326115509.00a615a0@pop.mindspring.com>
Reply-To: interchange-users@lists.akopia.com
At 11:43 AM 03/29/2001 -0500, you wrote:
> > Hello all -
> >
> > When using mv_search_line_return to put a full row from a db (or text
> file)
> > into search results, it seems that there is no tag display the full
> > row. In the case of a loop search, it seems that one must use
> [loop-code],
> > [loop-pos 1], [loop-pos 2]...etc. Can anyone confirm this, or is their
a
> > tag which yields all the fields in the row as one string?
>
> [loop-line]
>
Dear Mike -
Thanks for taking the time to answer this question, and my previous one
regarding [fly-list] and arbitrary databases. I guess you probably know
that the answers to both lay hidden in undocumented features - just a drop
in the bucket compared to those that remain uncovered.
Interchange just keeps getting better. Is there an initiative for the
documentation to keep pace? Does Red Hat/Akopia need assistance with
this? As much as users used to groan about the docs back in the Minivend
days, they were far better and more complete then, than they are now, in my
opinion.
- Ed L.
===============================================================
**** Virtual Hosting w/private IC Installation, $65/month! ****
---------------------------------------------------------------
New Media E.M.S. Software Solutions for Business
463 Main St., Suite D eCommerce | Consulting | Hosting
Placerville, CA 95667 edl@newmediaems.com
(530) 622-9421 http://www.newmediaems.com
(866) 519-4680 Toll-Free (530) 622-9426 Fax
===============================================================
--__--__--
Message: 11
Date: Thu, 29 Mar 2001 12:52:47 -0800
To: interchange-users@lists.akopia.com
From: Dan B <db@cyclonehq.dnsalias.net>
Subject: [ic] Zelerate going under? (Potential Redhat acquisition)
Reply-To: interchange-users@lists.akopia.com
Linux Today quotes a story on the register about Zelerate possibly going
under:
http://linuxtoday.com/news_story.php3?ltsn=2001-03-29-002-21-NW-BZ
http://www.theregister.co.uk/content/4/17959.html
Unless I'm the victim of an April Fools (quite possible).
What about Red Hat coming in to save the day? Akopia skillfully wove
together Tallyman and Minivend (okay, mostly minivend), so why not look at
the possibility of weaving together some of the code from AllComerce? For
example, the "Warehouse Management" and Fulfillment house integration stuff
sounds pretty interesting. While we're at it, maybe some of the fired or
soon-to-be-fired perl-hacking, GPL-coding talent from Zelerate would be
valuable? (AllCommerce is coded in perl *and* under the GPL, so that
should help).
Frankly, I never have trouble recommending business decisions. (Problem
is, people frequently recommend them to me too, i.e., "Be quiet, Dan").
Later,
Dan Browning, Cyclone Computer Systems, danb@cyclonecomputers.com
--__--__--
Message: 12
Date: Thu, 29 Mar 2001 15:15:55 -0700
To: interchange-users@lists.akopia.com
From: Ryan Hertz <rhertz@baits.com>
Subject: Re: [ic] Recursive Perl Function?
ses.com>
Reply-To: interchange-users@lists.akopia.com
At 06:54 AM 3/29/01 , Jim Balcom wrote:
>On Thu, 29 Mar 2001, Craig Beasland wrote:
>
>CB>>We would like to add a simple Bulletin Board system to one of our
systems.
>CB>>The simple solution is to add a function which display a line from the
>CB>>BBtable, calls itself to see if there are any "children" which in turn
>calls
>CB>>itself and so on.
>
>Go to www.worldwidemart.com/scripts
>Matthew Wright has written a ton of scripts in Perl and has them up
>there. One of them is a Bulletin Board, as well as a Guestbook that
>works quite well.
I would avoid those scripts, as they tend to contain many security
risks. Not to mention, wwwboard doesn't scale very well and will bring a
server to its knees faster than a runaway Interchange. :-)
Ryan Hertz tel 800-645-BAIT
Webmaster fax 520-645-2588
Advertising Director http://www.baits.com
Gary Yamamoto Custom Baits, Inc. mailto:rhertz@baits.com
--__--__--
Message: 13
Date: Thu, 29 Mar 2001 15:17:53 -0700
To: interchange-users@lists.akopia.com
From: Ryan Hertz <rhertz@baits.com>
Subject: Re: [ic] Simple question
Reply-To: interchange-users@lists.akopia.com
Is your database INDEXed?
At 08:26 AM 3/29/01 , Ken Lyons wrote:
>My database is too big....over 100 MB, (using standard database type)
>and is taking forever to search.
>I know IC can can use more tables (separate files that act as one database)
>but don't know what commands need to be put in the config file.
Ryan Hertz tel 800-645-BAIT
Webmaster fax 520-645-2588
Advertising Director http://www.baits.com
Gary Yamamoto Custom Baits, Inc. mailto:rhertz@baits.com
--__--__--
Message: 14
Date: Thu, 29 Mar 2001 19:07:47 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] Query iteration
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting Jean-Pierre Parent (parentjp@videotron.ca):
> Hi,
>
> I've been reading the doc and cant find a complete example on how to do a
> custom query and iterate over the returned records. Does one need use
> [mvasp][/mvasp] surrounded code in order to loop through a
[query][/query]'s
> returned values? I have this done using [query arrayref="myArray"] and
then
> using $Tmp->{myArray} to fetch the ref inside [mvasp][/mvasp]...but i was
> wondering if there is a simpler way to do it? I cant avoid using [query]
> since I'm using pattern matching operator with MySQL.
>
> I just need the structure with a few hints on which commands would do the
> trick and I'll read in the doc...
>
> Something like:
>
> [query sql="..."][/query]
> [loop ???]
> My HTML here...along with [item ???]
> [/loop]
>
Maybe this isn't clear from the docs, but:
[query list=1 sql="select * from whatever"]
[sql-param field]
[/query]
is what you want. I can't remember why that isn't the default.....
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
I don't buy from direct telephone or email marketers. This makes it
hard for me to find a phone company. ;>
--__--__--
Message: 15
Date: Thu, 29 Mar 2001 21:21:40 -0600
To: interchange-users@lists.akopia.com
From: Jeromie Clark <jeromie@smoothjazz.com>
Subject: [ic] More Authorize.Net GlobalSub Issues
Reply-To: interchange-users@lists.akopia.com
HI All-
I've read *all* of the documentation I could find on the authorize.net
issues, and am still having problems.
I'm running the store on iServer (FreeBSD) -- it's a slightly quirky
environment -- but IC (4.6.4) runs fine in all other respects (MySQL
support too). My store essentially is a hacked version of construct.
I read all the documentation I could find, and tried to address those
issues, but am still getting the following:
bad custom payment GlobalSub: authorizenet /cgi-bin/istore.cgi/process.html
I've included globalsub/authorizenet in the interchange.cfg.
I've added the MV_XXXX variables via KNAR as per the instructions -- tried
placing them in my catalog.cfg file too...
I followed the suggestion to test the module with perl, and it executes
fine (sans GlobalSub >>EOF and EOF lines).
I have Net::SSLeay and OpenSSL 0.9.4 is already installed by iServer.
Net::SSLeay sees it, but it's above my home directory. My Secure Server
Cert *is* installed and working.
I ran a test script consisting basically of use Net::SSLeay to confirm that
Perl sees the module.
Are there other things I should be looking for? It's pretty difficult to
troubleshoot as it's so transparent.
Order submissions just return the user to the order page with an error
alert, but no actual error displayed.
TIA.
Jeromie Clark
VP of Information Technology
http://www.smoothjazz.com/
Direct Line: (877)626-9694
--------------------------------------------------
--__--__--
Message: 16
Date: Fri, 30 Mar 2001 11:24:04 +0200
From: =?iso-8859-1?Q?Gr=E9goire?= Hubert <gregoire.hubert@fr.alcove.com>
Reply-To: gregoire.hubert@fr.alcove.com
Organization: alcove - l informatique libre
To: interchange-users@lists.akopia.com
Subject: Re: [ic] admin interface
Reply-To: interchange-users@lists.akopia.com
Grégoire Hubert wrote:
> Hi,
>
> I have no access to admin interface...when I click on the admin link
> an Interchange page tells me that the page Admin/index was not found...
>
> Gregoire.
In an other way, do we have to develop the admin interface from scratch or
is there already one existing like the admin interface on the website
interchange demo store ?
Thank you for your assistance...
Grégoire HUBERT.
--__--__--
Message: 17
Date: Fri, 30 Mar 2001 04:51:31 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] One store with many admins
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting oliverf@mail.kdt.de (oliverf@mail.kdt.de):
> Hello list,
>
> first I have to say, that Interchange ist the greatest and best shopping
cart system I´ve found for a long time.
>
> Many Thanks to Mike and all the others !!!
Flattery will get you everywhere. 8-)
>
> My question:
>
> I want to make a shop with a lot of different admins (but only ONE shop)
>
> Those admins should have only the right to edit their articles in the
> database, so they could delete, change or add items to the database.
>
> Is there a chance to do this with Interchange directly, or could it be the
> better way to program a new Interface for them, outside of Interchange ??
>
> I know, that there are a lot questions like this on this list, but i could
> not find a really good answer to it.
>
> So please help.
Interchange supports this, but there had been no UI support for
administering
the table_control hash in the access table.
Basically, you can define an "owner_field" where the username of the
logged-in
user must match that field for them to edit the record.
I had been meaning to do this for some time, but I finally got around to
it because of your message. I just committed it to CVS -- the owner_field
is now fully supported in the access_permissions manager, and owner_field
is honored in the item/database select lists. (I didn't do merchandising
yet, perhaps I never will. 8-)
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer
--__--__--
Message: 18
Date: Fri, 30 Mar 2001 04:53:31 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] Runtime error: Could not tie to 'products': Is a directory
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting vasile_abo@wexim.com (vasile_abo@wexim.com):
> Hello Everybody Here
>
> I've got a strange problem with a Interchange 4.6.3
> on a Linux box with perl 5.6. In error.log I got :
> ######################################
> [27/March/2001:14:55:56 -0500] shop /cgi-bin/shop/IRDA-01.html
> Runtime error: Could not tie to 'products': Is a directory
> at [interchange lib]/lib/Vend/Table/GDBM.pm line 105.
> ######################################
>
> In catalog.cfg I has :
> Database products products.asc TAB
> Database products READ_ONLY 1
> Database products IMPORT_ONCE 1
> ProductFiles products
>
> This problem does not happen when using a InMemory table.
> Does anybody has an idea ?
You don't mention the situation that caused the error.
If it is in the UI, then the fact that you made the table READ_ONLY
is going to cause a problem....
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Any man who is under 30, and is not liberal, has not heart; and any man
who is over 30, and is not a conservative, has not brains.
-- Winston Churchill
--__--__--
Message: 19
Date: Fri, 30 Mar 2001 05:11:09 -0500
From: Mike Heins <mikeh@minivend.com>
To: interchange-users@lists.akopia.com
Subject: Re: [ic] One store with many admins
Reply-To: mike@minivend.com
Reply-To: interchange-users@lists.akopia.com
Quoting Mike Heins (mikeh@minivend.com):
> I had been meaning to do this for some time, but I finally got around to
> it because of your message. I just committed it to CVS -- the owner_field
> is now fully supported in the access_permissions manager, and owner_field
> is honored in the item/database select lists. (I didn't do merchandising
> yet, perhaps I never will. 8-)
>
Oops, I should mention this is only in the 4.7.x development branch
accessed with "cvs co -r DEV_4_7_0".
--
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>
Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun
--__--__--
Message: 20
Reply-To: <sebastian.kummer@pointec.de>
From: "Sebastian Kummer" <sebastian.kummer@pointec.de>
To: <interchange-users@lists.akopia.com>
Date: Fri, 30 Mar 2001 12:28:23 +0200
charset="iso-8859-1"
Subject: [ic] cant transfer to Oracle
Reply-To: interchange-users@lists.akopia.com
hi there,
I'm building a shop, and our client wants to use oracle.
We developed the shop on mysql and everything worked fine.
so, I installed oracle and all drivers.
with perl the connect to oracle is possible.
DSN, login & password are right.
the problem is:
interchange doesn't import any data or create any table. I only get the
error message:
zeit config error: ORA-00942: table or view does not exist (DBD ERROR:
OCIStmtEx
ecute/Describe) at /usr/local/interchange/lib/Vend/Table/DBI.pm line 643.
so i did this manually. I created all tables and imported the data. fine.
Interchange still returns the same error.
any suggestions?
thanks a lot!
Regards,
Sebastian Kummer
---------------------------------------
Sebastian Kummer, sebastian.kummer@pointec.de
Application Developer Technologies
POINTEC GmbH
Ferdinandstrasse 12
D-20095 Hamburg
Fon: [+ 49] (0)40 - 68 87 58 - 0
Fax: [+ 49] (0)40 - 68 87 58 - 22
Besuchen Sie uns: www.pointec.de
---------------------------------------
--__--__--
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
End of Interchange-users Digest