[ic] Problem with lib/Vend/Table/GDBM.pm (Can MySQL be
used instead?)
Ed LaFrance
interchange-users@lists.akopia.com
Wed Jun 20 16:35:01 2001
At 02:30 PM 06/20/2001 -0500, you wrote:
>Thanks for your input, Ed.
>
>Let me try to clarify. I did get Interchange installed and got the demo
>catalog up and running.
I'll jump it right here and say: search the mailist archives at
developer.akopia.com - there are many posts on this subject and at least
one proposed solution:
http://developer2.akopia.com/archive/interchange-users/2001/msg01819.html
- Ed L.
>However, I seem to be having some problems with certain admin pages. The
>errors I get in the catalog error.log file look like this:
>
>cd943222-a.sxflls1.sd.home.com NauIUWRQ:home.com - [10/June/2001:06:21:41
>-0700] stufftobuy /cgi-bin/stufftobuy/admin/item_up Runtime error: couldn't
>init cache at /usr/home/speedwoo/www/interchange/lib/Vend/Table/GDBM.pm line
>107.
>
>
>
>Similarly, errors like these appear in the Interchange error.log file:
>
>cd943222-a.sxflls1.sd.home.com NauIUWRQ:home.com - [10/June/2001:06:22:14
>-0700] stufftobuy /cgi-bin/stufftobuy/admin/item_edit.html Runtime error:
>couldn't init cache at
>/usr/home/speedwoo/www/interchange/lib/Vend/Table/GDBM.pm line 107.
>
>
>
>Based on this, I'm wondering if I can take the data that is being stored in
>DBM files and move it to MySQL, since the MySQL interface seems to be
>working great.
>
>In the meantime, I'll try running the script you mentioned.
>
>I'd appreciate any further advice on this issue.
>
>Thanks all.
>
>--
>Michael Lehmkuhl <michael@electricpulp.com>
>Partner, Electric Pulp
>
>1.605.988.0177 : 1.888.722.PULP
>electricpulp.com
>
>
> > From: Ed LaFrance <edl@newmediaems.com>
> > Reply-To: interchange-users@developer.akopia.com
> > Date: Wed, 20 Jun 2001 08:54:48 -0700
> > To: interchange-users@developer.akopia.com
> > Subject: Re: [ic] Problem with lib/Vend/Table/GDBM.pm (Can MySQL be used
> > instead?)
> >
> > At 10:38 PM 06/19/2001 -0500, you wrote:
> >> Hello everyone.
> >>
> >> I'm still pretty new to Interchange.
> >>
> >> I've installed a store based on the construct demo using MySQL as the
> >> database. Everything seems to be working except those portions that
> rely on
> >> the .dbm files. I've read posts regarding using the MINIVEND_DBFILE, but
> >> that approach did not work for my installation. I'm in a shared hosted
> >> environment, so I don't have much access to reinstall Perl or things
> of that
> >> sort.
> >>
> >> Is it possible to run all the data through MySQL, rather than storing some
> >> in .dbm files? Both the GDBM and DB_File implementations on my hosting
> >> provider's server seem to be giving me some attitude.
> >>
> >> I've read through the documentation regarding how Interchange uses
> >> databases, but I'm not totally clear what the process would be to move the
> >> data in the .dbm files into MySQL.
> >>
> >
> > You might want to try a script which was included with IC 4.6.x (don't know
> > about 4.7.x): cpan_local_install. You should find it within the IC
> > distribution directory: interchange-4.6.x/dist/src/. This assumes that you
> > installed IC in your home directory using the .tar.gz dist. If your
> > hosting provider runs interchange centrally and merely provides you with a
> > catalog, you should complain loudly about any missing or broken Perl
> > modules. Failing both of those, you can go into yourcat/dbconf/mysql, and
> > try your hand at converting all the .dbm database definitions into mysql
> > definitions - there are plenty of the latter to follow as examples.
> >
> > - Ed L.
> >
> >
> >
> >
> > ===============================================================
> > 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
> > ===============================================================
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users
===============================================================
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
===============================================================