[Phpmylibrary-users] Re: PhpMyLibrary Users

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Greetings,

This is what I get from phpmylibrary.sourceforge.net mysql administration. I 
am using phpmyadmin 2.2.6-rc1 and currently using the MySQL version 3.23.36. 
I am using a php-4.06 version of php.

Welcome to phpMyAdmin 2.2.6-rc1
MySQL 3.23.36 running on mysql.sourceforge.net as 
php...@us...

your error said:

ERROR 1121 at line 17: Column 'anyid' is used with UNIQUE or INDEX but is
not defined as NOT NULL

This means that the index tables column anyid is null and that mysql want it 
to be not null.

To repair the error do try to rewrite null to not null on all index tables. 
the index tables are tge tblanyindex, tblauthorindex, tbltitleindex, etc.

Now if you don't want to rewrite the correction just dowload the mysql 
version 3.23.36 which is similar on what I am using in 
phpmylibrary.sourceforge.net/html.

Below are the recode of the phpmylibrary script. Please do try to send me 
the mysql version you are using so that we could warn other phpmylibrary 
user who use the mysql with similar version as yours.

Database phpmylibrary running on mysql.sourceforge.net
# phpMyAdmin MySQL-Dump
# version 2.2.6-rc1
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: mysql.sourceforge.net
# Generation Time: May 01, 2002 at 06:10 AM
# Server version: 3.23.36
# PHP Version: 4.0.6
# Database : `phpmylibrary`
# --------------------------------------------------------

#
# Table structure for table `_tblanybibrelation`
#

CREATE TABLE _tblanybibrelation (
  anyid bigint(10) default NOT NULL,
  bibid bigint(10) default NOT NULL,
  id bigint(10) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY index_anyid_idx (anyid),
  KEY index_bibid_idx (bibid),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblanyindex`
#

CREATE TABLE _tblanyindex (
  id bigint(10) NOT NULL auto_increment,
  any varchar(255) default NOT NULL,
  PRIMARY KEY  (id),
  KEY index_any_idx (any),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblauthorbibrelation`
#

CREATE TABLE _tblauthorbibrelation (
  anyid bigint(10) default NOT NULL,
  bibid bigint(10) default NOT NULL,
  id bigint(10) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY index_anyid_idx (anyid),
  KEY index_bibid_idx (bibid),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblauthorindex`
#

CREATE TABLE _tblauthorindex (
  id bigint(10) NOT NULL auto_increment,
  any varchar(255) default NOT NULL,
  PRIMARY KEY  (id),
  KEY index_any_idx (any),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblbib`
#

CREATE TABLE _tblbib (
  id bigint(5) NOT NULL auto_increment,
  marc blob,
  catid int(1) default '1',
  approved int(1) default '1',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblnotesbibrelation`
#

CREATE TABLE _tblnotesbibrelation (
  anyid bigint(10) default NOT NULL,
  bibid bigint(10) default NOT NULL,
  id bigint(10) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY index_anyid_idx (anyid),
  KEY index_bibid_idx (bibid),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblnotesindex`
#

CREATE TABLE _tblnotesindex (
  id bigint(10) NOT NULL auto_increment,
  any varchar(255) default NOT NULL,
  PRIMARY KEY  (id),
  KEY index_any_idx (any),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblpublisherbibrelation`
#

CREATE TABLE _tblpublisherbibrelation (
  anyid bigint(10) default NOT NULL,
  bibid bigint(10) default NOT NULL,
  id bigint(10) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY index_anyid_idx (anyid),
  KEY index_bibid_idx (bibid),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblpublisherindex`
#

CREATE TABLE _tblpublisherindex (
  id bigint(10) NOT NULL auto_increment,
  any varchar(255) default NOT NULL,
  PRIMARY KEY  (id),
  KEY index_any_idx (any),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblsubjectbibrelation`
#

CREATE TABLE _tblsubjectbibrelation (
  anyid bigint(10) default NOT NULL,
  bibid bigint(10) default NOT NULL,
  id bigint(10) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY index_anyid_idx (anyid),
  KEY index_bibid_idx (bibid),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tblsubjectindex`
#

CREATE TABLE _tblsubjectindex (
  id bigint(10) NOT NULL auto_increment,
  any varchar(255) default NOT NULL,
  PRIMARY KEY  (id),
  KEY index_any_idx (any),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tbltitlebibrelation`
#

CREATE TABLE _tbltitlebibrelation (
  anyid bigint(10) default NOT NULL,
  bibid bigint(10) default NOT NULL,
  id bigint(10) NOT NULL auto_increment,
  PRIMARY KEY  (id),
  KEY index_anyid_idx (anyid),
  KEY index_bibid_idx (bibid),
  KEY index_id_idx (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `_tbltitleindex`
#

CREATE TABLE _tbltitleindex (
  id bigint(10) NOT NULL auto_increment,
  any varchar(255) default NOT NULL,
  PRIMARY KEY  (id),
  KEY index_any_idx (any),
  KEY index_id_idx (id)
) TYPE=MyISAM;

Please do email me for whatever outcome you can get into your phpmylibrary 
installation.

Thanks.

Polerio

>From: "umar" <um...@li...>
>To: "Polerio Babao" <pt...@ho...>
>Subject: Re: PhpMyLibrary Users
>Date: Tue, 30 Apr 2002 09:10:39 +0700
>
>Polerio Babao writes:
>
>Dear Babao,
>
>I've tried to install it both, as module of postnuke or standalone but i
>failed to create database with the message about index etc.
>I follow the instruction as you write but always fail, do u think what's
>wrong ?
>What version of php and mysql at your demo site?
>
>Thank you for your attention,
>
>
>>Thank you for your interest in PhpMyLibrary.
>>If you encounter problems regarding the software, don't hesitate to email
>>me.
>>Thanks.
>>Polerio
>>
>>
>>>From: M Umar S T <um...@li...>
>>>To: pt...@ho...
>>>Subject: PhpMyLibrary Users
>>>Date: Thu, 25 Apr 2002 19:14:20 -0700
>>>
>>>Hiiiii.... i\'m very happy to find this.. sure i\'m realy glad.. thak you
>>>very much, i just found it but not try yet.. btw thank you very much for
>>>all off your hard work
>>>
>>>Sincerely,
>>>
>>>MUST
>>>
>>>
>
>
>
>MUST
>http://library.usu.ac.id

Polerio T. Babao Jr.II
43-A Bagong Lote, Potrero Malabon,
Metro Manila Philippines
http://www.polerio.n3.net
http://phpmylibrary.sourceforge.net
+632 4480621
+632 916 5477736

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.