By Date: <-- -->
By Thread: <-- -->

[Bug 5414] New: crashed when trying to install bible module

Please do not reply directly to this message. All additional comments should
be made in the comments box of this bug report.

http://bugs.xaraya.com/show_bug.cgi?id=5414

           Summary: crashed when trying to install bible module
           Product: App - Modules
           Version: Weekly Tarball
          Platform: Intel
               URL: http://it.southnashvillesda.org/
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P3 - Standard
         Component: Bible
        AssignedTo: curtis (at) farnham.com
        ReportedBy: skeebrent (at) gmail.com
         QAContact: jojodee (at) xaraya.com


Xaraya Version:    1.0.2
PHP version:       4.4.2-1
WebServer:         2.0.55-4

will trying to install bible this error was receved
my mysql version is. 5.0.16-1

Reproducible: Always
Steps to Reproduce:
1.install bible
2.Error page

Actual Results:  
Module Installation Failed
Database Query Error

ErrorNo: 1067, Message:Database error while executing: 'CREATE TABLE
xar_bible_texts (xar_tid INTEGER NOT NULL AUTO_INCREMENT, xar_sname VARCHAR(32)
NOT NULL , xar_lname VARCHAR(128) NOT NULL , xar_file VARCHAR(128) NOT NULL ,
xar_md5 VARCHAR(32) NOT NULL , xar_config_exists BOOL NOT NULL DEFAULT '' ,
xar_md5_config VARCHAR(32) NOT NULL , xar_state TINYINT NOT NULL , xar_type
TINYINT NOT NULL , PRIMARY KEY (xar_tid))'; error description is: 'Invalid
default value for 'xar_config_exists''.

A database query could not be executed, either because the query could not be
understood or because it returned unexpected results.

     at xarexception__dberrorhandler(xarException.php:464)
     Array
(
    [0] => mysql
    [1] => EXECUTE
    [2] => 1067
    [3] => Invalid default value for 'xar_config_exists'
    [4] => CREATE TABLE xar_bible_texts (xar_tid INTEGER  NOT NULL 
AUTO_INCREMENT, xar_sname VARCHAR(32)  NOT NULL  , xar_lname VARCHAR(128)  NOT
NULL  , xar_file VARCHAR(128)  NOT NULL  , xar_md5 VARCHAR(32)  NOT NULL  ,
xar_config_exists BOOL  NOT NULL DEFAULT '' , xar_md5_config VARCHAR(32)  NOT
NULL  , xar_state TINYINT  NOT NULL  , xar_type TINYINT  NOT NULL  , PRIMARY KEY
(xar_tid))
    [5] => 
    [6] => adodb_xarmysql Object
        (
            [hasGenID] => 
            [dataProvider] => mysql
            [databaseType] => mysql
            [database] => Xaraya
            [host] => localhost
            [user] => bcordis
            [password] => Sd35bass!
            [debug] => 
            [maxblobsize] => 262144
            [concat_operator] => +
            [substr] => substring
            [length] => length
            [random] => rand()
            [upperCase] => upper
            [fmtDate] => 'Y-m-d'
            [fmtTimeStamp] => 'Y-m-d H:i:s'
            [true] => 1
            [false] => 0
            [replaceQuote] => \'
            [nameQuote] => `
            [charSet] => 
            [metaDatabasesSQL] => 
            [metaTablesSQL] => SHOW TABLES
            [uniqueOrderBy] => 
            [emptyDate] => &nbsp;
            [emptyTimeStamp] => &nbsp;
            [lastInsID] => 
            [hasInsertID] => 1
            [hasAffectedRows] => 1
            [hasTop] => 
            [hasLimit] => 1
            [readOnly] => 
            [hasMoveFirst] => 1
            [hasTransactions] => 
            [genID] => 0
            [raiseErrorFn] => xarException__dbErrorHandler
            [isoDates] => 1
            [cacheSecs] => 3600
            [sysDate] => CURDATE()
            [sysTimeStamp] => NOW()
            [arrayClass] => ADORecordSet_array
            [noNullStrings] => 
            [numCacheHits] => 0
            [numCacheMisses] => 0
            [pageExecuteCountRows] => 1
            [uniqueSort] => 
            [leftOuter] => 
            [rightOuter] => 
            [ansiOuter] => 
            [autoRollback] => 
            [poorAffectedRows] => 1
            [fnExecute] => 
            [fnCacheExecute] => 
            [blobEncodeType] => 
            [rsPrefix] => ADORecordSet_
            [autoCommit] => 1
            [transOff] => 0
            [transCnt] => 0
            [fetchMode] => 
            [_oldRaiseFn] => 
            [_transOK] => 
            [_connectionID] => Resource id #28
            [_errorMsg] => Invalid default value for 'xar_config_exists'
            [_errorCode] => 
            [_queryID] => 
            [_isPersistentConnection] => 
            [_bindInputArray] => 
            [_evalAll] => 
            [_affected] => 
            [_logsql] => 
            [metaColumnsSQL] => SHOW COLUMNS FROM %s
            [forceNewConnect] => 1
            [clientFlags] => 0
            [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
            [_genSeqSQL] => create table %s (id int not null)
            [_genSeq2SQL] => insert into %s values (%s)
            [_dropSeqSQL] => drop table %s
            [databaseName] => Xaraya
            [database_key] => 0
        )

)

     at _execute(adodb.inc.php:861)
     Array
(
    [0] => CREATE TABLE xar_bible_texts (xar_tid INTEGER  NOT NULL 
AUTO_INCREMENT, xar_sname VARCHAR(32)  NOT NULL  , xar_lname VARCHAR(128)  NOT
NULL  , xar_file VARCHAR(128)  NOT NULL  , xar_md5 VARCHAR(32)  NOT NULL  ,
xar_config_exists BOOL  NOT NULL DEFAULT '' , xar_md5_config VARCHAR(32)  NOT
NULL  , xar_state TINYINT  NOT NULL  , xar_type TINYINT  NOT NULL  , PRIMARY KEY
(xar_tid))
    [1] => 
)

     at _execute(adodb-xarmysql.inc.php:35)
     Array
(
    [0] => CREATE TABLE xar_bible_texts (xar_tid INTEGER  NOT NULL 
AUTO_INCREMENT, xar_sname VARCHAR(32)  NOT NULL  , xar_lname VARCHAR(128)  NOT
NULL  , xar_file VARCHAR(128)  NOT NULL  , xar_md5 VARCHAR(32)  NOT NULL  ,
xar_config_exists BOOL  NOT NULL DEFAULT '' , xar_md5_config VARCHAR(32)  NOT
NULL  , xar_state TINYINT  NOT NULL  , xar_type TINYINT  NOT NULL  , PRIMARY KEY
(xar_tid))
    [1] => 
)

     at execute(adodb.inc.php:836)
     Array
(
    [0] => CREATE TABLE xar_bible_texts (xar_tid INTEGER  NOT NULL 
AUTO_INCREMENT, xar_sname VARCHAR(32)  NOT NULL  , xar_lname VARCHAR(128)  NOT
NULL  , xar_file VARCHAR(128)  NOT NULL  , xar_md5 VARCHAR(32)  NOT NULL  ,
xar_config_exists BOOL  NOT NULL DEFAULT '' , xar_md5_config VARCHAR(32)  NOT
NULL  , xar_state TINYINT  NOT NULL  , xar_type TINYINT  NOT NULL  , PRIMARY KEY
(xar_tid))
)

     at bible_init(xarinit.php:40)
     at modules_adminapi_executeinitfunction(executeinitfunction.php:87)
     Array
(
    [0] => Array
        (
            [regid] => 550
            [function] => init
        )

)

     at xarmodapifunc(xarMod.php:996)
     Array
(
    [0] => modules
    [1] => admin
    [2] => executeinitfunction
    [3] => Array
        (
            [regid] => 550
            [function] => init
        )

)

     at modules_adminapi_initialise(initialise.php:56)
     Array
(
    [0] => Array
        (
            [regid] => 550
        )

)

     at xarmodapifunc(xarMod.php:996)
     Array
(
    [0] => modules
    [1] => admin
    [2] => initialise
    [3] => Array
        (
            [regid] => 550
        )

)

     at modules_adminapi_installwithdependencies(installwithdependencies.php:119)
     Array
(
    [0] => Array
        (
            [regid] => 550
        )

)

     at xarmodapifunc(xarMod.php:996)
     Array
(
    [0] => modules
    [1] => admin
    [2] => installwithdependencies
    [3] => Array
        (
            [regid] => 550
        )

)

     at modules_admin_install(install.php:68)
     Array
(
    [0] => Array
        (
        )

)

     at xarmodfunc(xarMod.php:884)
     Array
(
    [0] => modules
    [1] => admin
    [2] => install
)

     at xarmain(index.php:91)


Expected Results:  
show bible installed

-- 
Configure bugmail: http://bugs.xaraya.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
_______________________________________________
Xaraya_bugs mailing list
Xaraya_bugs (at) xaraya.com
http://xaraya.com/mailman/listinfo/xaraya_bugs