Re: [Slashcode-general] Foreign key errors on new slash install

[Jamie M. <ja...@mc...>]

> [Thu Sep  9 02:00:48 2004] [error]
> /admin.pl:Slash::DB::MySQL:/usr/lib/perl5/site_perl/5.8.4/i686-
> /linux-thread-multi/Slash/DB/MySQL.pm:1354:DB=3D'wapav'
> -- hostinfo=3D'Loc alhost via UNIX socket' -- Unknown column
> 'content_type' in 'where clause' -- SELECT extras_textname,
> extras_keyword, type FROM topic_nexus_extras WHERE tid =3D '1'
> AND content_type =3D 'story'
>=20
> I got past this by running the following from the mysql/updates
> file:
>=20
> ALTER TABLE topic_nexus_extras add column content_type
> enum("story","comment") DEFAULT 'story' NOT NULL;
>=20
> So it appears as though some of the upgrades have not made it
> into the initial database setup.

Yep!  We goofed.  I'll fix this in CVS shortly, sorry.


> > But the parent table `slashdb/users` does not currently exist!
>=20
> I would think that's fairly unlikely. If this site you're
> working with's db is 'slashdb' I would think much wouldn't work
> at all if the table 'users' didn't exist.

Right.  Without a 'users' table it's hopeless.

During the install I'm assuming it bombed out, saying this:

    The CREATE TABLE command below failed.  This almost certainly means
    the rest of the slashsite installation will fail, so we're aborting.

If so, then things are badly screwed up.  Do a SHOW TABLES command
in your mysql client and my guess is that the alphabetical list
will cut off somewhere before 'u'.  Let us know where (and, when
you retry the installation, let us know what error caused the
abort).

Without a complete install, you have no chance of getting anything
to work.  Follow the "UNINSTALLING" instructions at the end of the
INSTALL file, then start over on "INSTALLATION" step 6, "Install
your Slash site."

> > [Thu Sep  9 02:22:43 2004] [error] [client 192.168.1.19] File does not =
=20
> > exist:
> > /usr/local/slash/site/www.worcesterapa.org/htdocs/admin-topic-popup.css
> > [Thu Sep  9 02:22:43 2004] [error] [client 192.168.1.19] File does not =
=20
> > exist:
> > /usr/local/slash/site/www.worcesterapa.org/htdocs/admin-topic-popup.js
>=20
> run your symlink-tool :)

No, those are generated by the topic_popup_static.pl task, so you'll
want to run slashd.  Which will utterly fail since you are missing
half your tables :)
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  ja...@mc...