Re: [mv] MV4.04 SQL Error: "close_table"

["Jason M. Korkin" <jkorkin@korksoft.com>]

******    message to minivend-users from "Jason M. Korkin" <jkorkin@korksoft.com>     ******

Lee,
    I figured out what was going on... I had forgot to define the key in the table statement in
the catalogs mysql directory.  I deleted the .sql file and then did a daemon restart and it worked
like a charm.  Thanks for the help though! ;-)

    Regards,

    Jason Korkin.


Lee Nelson wrote:

> ******    message to minivend-users from Lee Nelson <jld123@pobox.com>     ******
>
> Jason,
>
> >     config error: Can't call method "close_table" on an undefined value
> > at /home/mvend404/lib/Vend/Data.pm line 409.
>
>   I was getting this too in the same version of Minivend.
>
>   It is a side effect of not being able to open a table in your
> SQL database.  Check the following:
>
>   - Connection parameters for your database.
>
>   - Make sure that if you have deleted the SQL table in
>     question, that you have also the deleted the .sql file
>     in the products directory so that minivend can re-import
>     the table.
>
>   - If you have reinstalled MySQL, check that you have
>     also REBUILT and reinstalled Msql-Mysql-Modules-*-tar.gz
>
>   Here's snippet from my catalog.cfg to check against:
>
> Database products products.asc  dbi:mysql:db_name:localhost:3306
> Database products USER          mvuser
> Database products PASS          mvpassword
> Database products DELIMITER     TAB
>
>   Good luck,
>
>     Lee Nelson
>
>
> "Jason M. Korkin" wrote:
> >
> > ******    message to minivend-users from "Jason M. Korkin" <jkorkin@korksoft.com>     ******
> >
> > Hi List:
> >
> >     I'm using MySQL and I keep getting this error as of late with
> > MV4.04...
> >
> >     config error: Can't call method "close_table" on an undefined value
> > at /home/mvend404/lib/Vend/Data.pm line 409.
> >
> >     Any ideas?
> >
> >     Jason.
> >
> > --
> > KORKSOFT - Internet Consulting Group
> > System Integration, E-Commerce, C++/Perl/PHP/ASP
> > http://www.korksoft.com
> > http://www.atworkservers.com
> > Tel: (603) 472-8262
> > Cel: (603) 682-8672
> >
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

--
KORKSOFT - Internet Consulting Group
System Integration, E-Commerce, C++/Perl/PHP/ASP
http://www.korksoft.com
http://www.atworkservers.com
Tel: (603) 472-8262
Cel: (603) 682-8672


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list