[ic] Hidden Admin Tables
Dan Browning
interchange-users@interchange.redhat.com
Thu Sep 27 17:28:01 2001
> Having a significant problem with IC. Started with 4.8.2 and
> have been moving
> back to get round it, 4.7.2 looking at 4.6.5 at present.
>
> Problem with 4.8.2 and 4.7.2 in RH7.1. Initially installed and had it
> running. Able to administer and was looking good. Loaded via
> spreadsheet
> interface, 15000+ products. So far so good. Had to head out
> for an hour or so
> came back to upload the products and found a neat little
> error - Hidden Admin
> Tables. So now I can't acces the tables to upload any more. I
> tried removing
> 4.8.2, installing 4.7.2 and it has done the same thing.
>
> Just finished downloading 4.6.5 but would rather not due to
> tax problems (am
> in Australia with a national GST not a state based tax).
>
> Query - what causes the Hidden Admin Tables and how to
> revover so I can work
> and get this thing finished.
>
> I would really appreciate anyoine who knows the answer to
> send a direct email
> as well as to the list, as a resolution for me is quite urgent.
>
> I had a heap of problems installing the spreadsheet perl
> modules early on and
> eventually located the IO-stringy to get past that one,
> really should be in
> the documentation.
>
> Hoping for an answer.
> kevin
For some, deleting their .gdbm databases before starting the daemon helped.
(Maybe sure you have a recent export to .txt, and a backup first).
The thread regarding this issue is attached.
HTH,
-Dan
From: Peter Yoo <pyooic@yootopia.com>
To: interchange-users@developer.akopia.com
Subject: Re: [ic] Upgrading from 4.7.2 to 4.7.7
X-Mailer: Mutt 1.0.1i
Sender: interchange-users-admin@developer.akopia.com
X-BeenThere: interchange-users@lists.akopia.com
X-Mailman-Version: 2.0.5
Reply-To: interchange-users@developer.akopia.com
List-Help: <mailto:interchange-users-request@lists.akopia.com?subject=help>
List-Post: <mailto:interchange-users@lists.akopia.com>
List-Subscribe:
<http://lists.akopia.com/mailman/listinfo/interchange-users>,
<mailto:interchange-users-request@lists.akopia.com?subject=subscribe>
List-Id: Interchange users discussion (high volume)
<interchange-users.lists.akopia.com>
List-Unsubscribe:
<http://lists.akopia.com/mailman/listinfo/interchange-users>,
<mailto:interchange-users-request@lists.akopia.com?subject=unsubscribe>
List-Archive: <http://lists.akopia.com/pipermail/interchange-users/>
X-Original-Date: Wed, 1 Aug 2001 09:28:09 -0700
Date: Wed, 1 Aug 2001 09:28:09 -0700
I'd like to add more info on this problem.
The only access user I have is the default account inter(in my case,
interchange) with the intial password. I cannot even change the password
for the default account.
Where is this infomation kept? The infomation about the access user
accounts with permissions?
Can I manually create/modify accounts?
I do not see them in the MySQL database that I'm useing...
Thanks.
Peter.
On Wed, Aug 01, 2001 at 09:06:39AM -0400, Brian Kosick wrote:
> Yes, I get that admin error also! Anybody want to throw any ideas on the
> table?
>
>
> At 11:36 PM 7/31/01 -0700, you wrote:
> >OK, I believe that I'm almost there now.... upgrading from 4.7.2 to
> >4.7.7 requires much more work than I expected.
> >
> >I was able to follow Brian Kosick's instructions to recover my tables
> >being recognized by Admin pages and being able to export them to backup
> >directory. Thanks, Brian.
> >
> >Now, Wizard works and etc... however, I cannot create new access users :
> >Administration -> Access -> Create new user then type in Real name and
> >user name(pyoo) then click on OK button, I get this message :
> >
> >FATAL error
> >There is no row with index 'pyoo' at
> >/usr/local/interchange/lib/Vend/Table/Common.pm line 258
> >
> >Any idea why I'm getting this and how to fix it?
> >
> >I'm so close to get all of databases work on IC4.7.7.....
> >
> >Thanks.
> >
> > Peter.
> >
> >On Tue, Jul 31, 2001 at 10:03:28PM -0400, Brian Kosick wrote:
> > > Both in interchange.cfg, AND catalog.cfg Take a look at the reference
> > > manual, to see what options are available in each one.
> > >
> > > I was getting a "Runtime Error: Magic number checking" After the perl
> > > upgrade. Did a search from that found out the listings in the
> > > archives. Found out there is a Storable incompatibility problem,
which
> > > causes the gdbm files, to become unreadable.
> > > Summary of solution -> delete all your old gdbm files, and let IC
rebuild
> > > them from the text files.
> > >
> > > Though if you're all ready using 5.6.x, I don't know how much this'll
help.
> > >
> > > The way I deleted the gdbm files is "rm -rf products/*.gdbm" Since
I'm
> > > using the gdbm (GNU DataBase SomethingorOther) IC auto-magically
> > > regenerates the missing gdbm file from the .txt, .asc files. Whether
or
> > > not this behavior is the same using db (Berkeley Database?) I dunno.
I
> > > would imagine so though. Make sure that you export the current db to
> > their
> > > respective text files before you go about deleting them, as it would
suck,
> > > if it rebuilt itself from old outdated info.
> > >
> > > At 06:28 PM 7/31/01 -0700, you wrote:
> > > >Hello,
> > > >
> > > >Where do you enable DisplayErrors? in interchange.cfg file?
> > > >
> > > >I tried to search MailList Archive but couldn't find much about this
> > problem.
> > > >
> > > >I'm running it with Perl5.6.1 on Solaris8...
> > > >
> > > >Can you please tell me more detail on what files I delete in
products/?
> > > >when you say gdbm files, do you mean *.db files? what about
ichelp.db and
> > > >icmenu.db file?
> > > >
> > > >Thanks again.
> > > >
> > > > Peter.
> > > >
> > > >On Tue, Jul 31, 2001 at 08:34:26PM -0400, Brian Kosick wrote:
> > > > > I have/had the same problem, I couldn't figure it out either.
Then, I
> > > > > started running IC with
> > > > >
> > > > > DisplayErrors Yes
> > > > >
> > > > > Ran into a whole bunch of stuff that it was looking for, but
> > couldn't find
> > > > > (aka XSLoader.pm, etc) Did some research, found that it was only
> > > > available
> > > > > in the later versions of perl.
> > > > >
> > > > > I upgraded to perl 5.6.1, went through the headaches that were
> > caused by
> > > > > the upgrade. (Ie recompiling and installing interchange (4.8.0),
then
> > > > > deleting all the gdbm files in products/*, and finally rm -rf
> > > > > session/*)(Make sure you make BACKUPS!!!!) For more info, search
the
> > > > > Archives on this.
> > > > >
> > > > > It appears that 90% of my problems are solved. Error messages
> > almost down
> > > > > to nothing, The tables in Administration->Info and
> > Administration->Tables
> > > > > are showing up, Checking out actually works now.
> > > > >
> > > > > I have two catalogs running under this version of IC.
> > > > >
> > > > > System
> > > > >
> > > > > Cobalt/Sun RaqXTR
> > > > > Cobalt OS (modded version of RH6.2)
> > > > > 256MB RAM
> > > > > RAID 5
> > > > > Perl 5.6.1 (now at least, it was running 5.00504)
> > > > > Interchange 4.8.0
> > > > >
> > > > >
> > > > > 1) I have been meticulously trying to update from MV3.04 to
> > > > > IC(latest) Which now works great! One thing though..Nobodies
written
> > > > a MV
> > > > > 3.04 userdb -> IC(latest) userdb script yet have they? just
though I'd
> > > > > check. This one is using gdbm
> > > > >
> > > > > ^^^^ Definitely NOT for the faint of heart ^^^^^^^^
> > > > >
> > > > > 2) slightly modified demo catalog from IC 4.7.x (2 or 3 i don't
> > > > > remember) Which unfortunately is still suffering from needing the
> > > > &success
> > > > > entry in the profiles.order file, and the basket won't empty on
> > > > > checkout. This one is using pgsql. The table definitions have
changed
> > > > > since this ones been created. Definitely double check your table
> > > > > definitions if you've created a catalog during the early version
of
> > 4.7.x
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > PS
> > > > > I am planning once these projects are live, and I get some time,
to
> > make
> > > > > rpms for cobalt raq's, because I've seen PLENTY of requests for
them.
> > > > >
> > > > > At 04:55 PM 7/31/01 -0700, you wrote:
> > > > > >Hello Again,
> > > > > >
> > > > > >I've backedup my 4.7.2 catalog and started with 4.7.7 template of
> > > > foundation
> > > > > >and gotten as far as getting everything working including Wizard!
> > > > > >
> > > > > >Except.... when I look at Info page(under admin) or Tables, I get
no
> > > > tables!
> > > > > >
> > > > > >Store-front works fine, I can add/edit items with no problem. I
see
> > > > the mysql
> > > > > >database and there are all the tables. But I cannot access
tables
> > > > from Admin
> > > > > >page. When I click on Tables, all it says is Table Manager -
> > Database
> > > > tables
> > > > > >(no listing) - Hidden admin tables:(no listing)
> > > > > >
> > > > > >What do I do to fix this?
> > > > > >
> > > > > >Thanks.
> > > > > >
> > > > > > Peter.
> > > > > >
> > > > > >On Tue, Jul 31, 2001 at 03:45:05PM -0700, Peter Yoo wrote:
> > > > > > > Hello All,
> > > > > > >
> > > > > > > I'm having some problems upgrading my server from 4.7.2 to
4.7.7
> > > > > > > I've added all of the additional fields in the tables my hand
> > on a few
> > > > > > > talbes to match with 4.7.7's tables, and created additional
> > files that
> > > > > > > are there in <catalog dir>/products/*.[txt|sql|db].
> > > > > > >
> > > > > > > Store front-end works fine but once I went in to admin pages,
> > things do
> > > > > > > not work too well.
> > > > > > >
> > > > > > > I cannot export tables, I get this message in the log file:
> > > > > > > 143.183.152.17 VTQTIhc4:143.183.152.17 -
[31/July/2001:15:42:46
> > -0700]
> > > > > > LittleBebe /cgi-bin/littlebebe/admin/export_table Runtime error:
> > Can't
> > > > > > use string ("") as a HASH ref while "strict refs" in use at
> > > > > > /usr/local/interchange/lib/UI/Primitive.pm line 215.
> > > > > > >
> > > > > > > when I try to go thru the Wizard, I get :
> > > > > > > 143.183.152.17 VTQTIhc4:143.183.152.17 -
[31/July/2001:15:43:27
> > -0700]
> > > > > > LittleBebe /cgi-bin/littlebebe/admin/wizard/step_company Runtime
> > error:
> > > > > > Can't use string ("") as a HASH ref while "strict refs" in use
at
> > > > > > /usr/local/interchange/lib/UI/Primitive.pm line 215.
> > > > > > >
> > > > > > > Can someone let me know what I did/didn't do correctly?
> > > > > > >
> > > > > > > Is there a document how to upgrade 4.7.2 to 4.7.7?
> > > > > > >
> > > > > > > I've made so many changes to <catalog dir>/pages/* files
> > already and
> > > > > > I'd like
> > > > > > > to keep the changes that I've made.
> > > > > > >
> > > > > > > Thank you.
> > > > > > >
> > > > > > > Peter.
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > 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
> > > > >
> > > > > Brian Kosick
> > > > > Web Programmer
> > > > > New Age Consulting Service, Inc.
> > > > > 216-619-2000
> > > > > briank@nacs.net
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > >
> > > Brian Kosick
> > > Web Programmer
> > > New Age Consulting Service, Inc.
> > > 216-619-2000
> > > briank@nacs.net
> > >
> > > _______________________________________________
> > > 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
>
> Brian Kosick
> Web Programmer
> New Age Consulting Service, Inc.
> 216-619-2000
> briank@nacs.net
>
> _______________________________________________
> 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