[Phpmylibrary-users] Re: PhpMyLibrary Users: Attention postnuke users.

[Polerio B. <pt...@ho...>]

Greetings,

I want to make some correction. I've tried to make my _tblbib as not null 
and gave me this error:

---------------------
Database phpmylibrary - table _tblbib running on mysql.sourceforge.net
Error

SQL-query :

ALTER TABLE `phpmylibrary`.`_tblbib` CHANGE `marc` `marc` BLOB DEFAULT 'not 
NULL' NOT NULL

MySQL said:


BLOB column 'marc' can't have a default value

Back

---------------------------

Please do alter the not null statement in your _tblbib and make it NULL. SQL 
below is the copy of the code.

Polerio


#
# Table structure for table `_tblbib`
#

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



>From: "umar" <um...@li...>
>To: "Polerio Babao" <pt...@ho...>
>Subject: Re: PhpMyLibrary Users: Attention postnuke users.
>Date: Wed, 01 May 2002 16:31:03 +0700
>
>Polerio Babao writes:
>
>I already move from PHP-Nuke to PostNuke (Rogue713) and do all the
>instruction from http://phpmylibrary.sourceforge.net/ but I still failed to
>make the database from polerio/mysql/phpmylibrary.sql with message like
>this:
>
>ERROR 1121 at line 17: Column 'anyid' is used with UNIQUE or INDEX but is
>not defined as NOT NULL
>
>Do you know what's the problem? Is the problem at MySql or at my PHP? If so
>what's the best version of MySql and PhP I have to use and can make the
>PhpMyLibrary run well.
>
>Note: the Rogue713 run well at http://library.usu.ac.id
>
>This is what I've done:
>
>1. Unzip the PhpMyLibary-1.0.4a.zip at PhpMyLibrary directory
>2. Move the PhpMyLibrary directory at PostNuke modules directory
>3. Make the blocks for PhpMyLibrary as the instruction
>4. Make the database #mysqladmin create phpmylibrary
>5. #mysql phpmylibrary < polerio/mysql/phpmylibrary.sql
>
>Failed.. :(
>
>ERROR 1121 at line 17: Column 'anyid' is used with UNIQUE or INDEX but is
>not defined as NOT NULL
>
>Thank you for your attention.
>
>
>>Greetings,
>>
>>The phpmylibrary will not run on phpnuke because I made it in
>>postnuke as a module. You should install it in your post-nuke site and not
>>on phpnuke. Visit http://phpmylibrary.sourceforge.net/html site as this
>>would demonstrate you the running phpmylibrary-1.0.4a software installed
>>on postnuke version .713. This also has been tested as a stand-alone
>>application. Visit phpmylibrary site for more info. Thank you for your
>>support in phpmylibrary software I hope that you would install postnuke on
>>your server to finally run the phpmylibrary application. Or perhaps
>>install it as stand-alone application.
>>
>>Note: (This mail has been submitted to phpmylibrary lists so that other
>>other user will benefit from this question.)  I would like to note that
>>phpmylibrary has been tested, created and installed on www.postnuke.com
>>CMS application. I haven't tried it in phpnuke, to run phpmylibrary
>>correctly be sure to check if you're using the postnuke software.
>>
>>Thanks for your email, this mail would help other user as well.
>>
>>Polerio
>
>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


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com