Conversion of some mysql php functions to oci functions.

amita · Post by **amita** » Tue Jun 27, 2006 1:34 pm

Hi,

I did all the changes required to function_installer.inc.php, function_config.inc.php, db.inc.php, oci8.inc.php and in docs folder i added a entry for file oci8.inc.php in CHANGED_FILES.inc.php.

It is showing Database Extension as Oracle... when i click on "simple installation" it asks for that database name , user, password, host etc. I supplied all the values... and clicked on "Complete Installation" , It showd me Serendipity installed successfully with many warnings.

After that it was asking for Admin user name and password... i provided that but its showing wrong username or password... check credentials...
and then it gave the page with many warnings...

the Serendipity database is created on Oracle Server. While installation, it should insert some tables in database but it is not doing so... No table is added in database.

What may be the problem?
Again one, i unzipped the tar file, then there is agn one zip file ... i unzipped it and i am using that "serendipity-1.0-beta3" files.

I am giving the set of warnings.......here. What may be the problem here?

Thanks,
Amita

Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
ADMIN_FRONTPAGE
NO_ENTRIES_TO_PRINT
« PREVIOUS_PAGE (PAGE_BROWSE_ENTRIES) NEXT_PAGE »
ADMIN_FRONTPAGE
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/

Warning: oci_new_connect() [function.oci-new-connect]: ORA-12154: TNS:could not resolve service name in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 254

Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT name, value
FROM serendipity_config
WHERE authorid = 0/
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT COUNT(placement) AS count from serendipity_plugins WHERE placement='left' /
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT COUNT(placement) AS count from serendipity_plugins WHERE placement='right' /
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
Warning: oci_execute() [function.oci-execute]: ORA-00933: SQL command not properly ended in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT

e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email
, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1151394298 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15/
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
Warning: oci_execute() [function.oci-execute]: ORA-00933: SQL command not properly ended in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT count(distinct e.id)
FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1151394298 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)/
Warning: oci_execute() [function.oci-execute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 81

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order/
POWERED_BY s9y - Design by Carl

Post by **garvinhicking** » Tue Jun 27, 2006 1:49 pm

Hi!

You should do this; edit the serendipity_db_schema_import of your oci8.inc.php file.

There, you should echo/output the used $sql string that is sent to serendipity_db_Query(). So that you can see the output on the installation screen.

Now execute those SQL strings using your favourite Oracle SQL tool, and see if oracle complains about the used SQL. I am sure that the used SQL is still incompatible to Oracle Syntax and there needs to be some modification.

Best regards,
Garvin

amita · Post by **amita** » Tue Jun 27, 2006 2:20 pm

Hi Garvin,

Serendipity will create all these tables first while installation or we have to create them manually? For mysql it was not needed.... but i m not sure abt oracle...

Thanks,
Amita

Post by **garvinhicking** » Tue Jun 27, 2006 2:33 pm

Hi!

Serendipity will create the tables. Read this thread about "db.sql".

Best regards,
Garvin

amita · Post by **amita** » Tue Jun 27, 2006 2:52 pm

I tried by placing echo for $sql query in serendipity_db_query... it is giving the select statements....
but there are no insert statements... and even the tables are not created in oracle database...

This is the line which came after echo...
SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order
---------------------------------------
Warning: ociexecute() [function.ociexecute]: ORA-00942: table or view does not exist in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

SELECT * from serendipity_plugins WHERE placement = '' ORDER BY placement, sort_order----------------------------------------

Tables are not getting created... i changed serendipity_db_schema_import also..,.... as follows

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10}', '{text}','{BOOLEAN}');

static $replace = array('VARCHAR2 ','number ','primary key',
'','number(1)','number(4)','number(11)','number(10)', 'VARCHAR2(255)','');

Where should i check if the tables are getting created or not? it all is irritating me...

Post by **garvinhicking** » Tue Jun 27, 2006 3:13 pm

Hi!

Please show me the sourcecode of your oci8.inc.php file, then I'll tell you what to modify where to see the SQL.

You must of course remove serendipity_config_local.inc.php to be able to re-install serendipity...else s9y will think it is installed if you call it.

But you wanted to modify the installation code, thus you need to check the installation of serendipity.

)

Best regards,
Garvin

amita · Post by **amita** » Wed Jun 28, 2006 6:03 am

Hi Garvin,

I am attaching the source code of oci8.inc.php. Please check it and tell me the changes...

I am deleting serendipity_config_local.inc.php each time while new installation.

Oci8.inc.php
============================
<?php # $Id: mysql.inc.php 878 2006-01-25 19:26:58Z garvinhicking $
# Copyright (c) 2003-2005, Jannis Hermanns (on behalf the Serendipity Developer Team)
# All rights reserved. See LICENSE file for licensing details

/**
* Tells the DB Layer to start a DB transaction.
*
* @access public
*/
function serendipity_db_begin_transaction(){
serendipity_db_query('start transaction');
}

/**
* Tells the DB Layer to end a DB transaction.
*
* @access public
* @param boolean If true, perform the query. If false, rollback.
*/
function serendipity_db_end_transaction($commit){
if ($commit){
serendipity_db_query('commit');
}else{
serendipity_db_query('rollback');
}
}

/**
* Assemble and return SQL condition for a "IN (...)" clause
*
* @access public
* @param string table column name
* @param array referenced array of values to search for in the "IN (...)" clause
* @param string condition of how to associate the different input values of the $search_ids parameter
* @return string resulting SQL string
*/
function serendipity_db_in_sql($col, &$search_ids, $type = ' OR ') {
return $col . " IN (" . implode(', ', $search_ids) . ")";
}

/**
* Perform a DB Layer SQL query.
*
* This function returns values dependin on the input parameters and the result of the query.
* It can return:
* false if there was an error,
* true if the query succeeded but did not generate any rows
* array of field values if it returned a single row and $single is true
* array of array of field values if it returned row(s) [stacked array]
*
* @access public
* @param string SQL query to execute
* @param boolean Toggle whether the expected result is a single row (TRUE) or multiple rows (FALSE). This affects whether the returned array is 1 or 2 dimensional!
* @param string Result type of the array indexing. Can be one of "assoc" (associative), "num" (numerical), "both" (numerical and associative, default)
* @param boolean If true, errors will be reported. If false, errors will be ignored.
* @param string A possible array key name, so that you can control the multi-dimensional mapping of an array by the key column
* @param string A possible array field name, so that you can control the multi-dimensional mapping of an array by the key column and the field value.
* @param boolean If true, the executed SQL error is known to fail, and should be disregarded (errors can be ignroed on DUPLICATE INDEX queries and the likes)
* @return mixed Returns the result of the SQL query, depending on the input parameters
*/
function &serendipity_db_query($sql, $single = false, $result_type = "both", $reportErr = false, $assocKey = false, $assocVal = false, $expectError = false) {
echo $sql;
global $serendipity;
static $type_map = array(
'assoc' => OCI_ASSOC,
'num' => OCI_NUM,
'both' => OCI_BOTH,
'true' => true,
'false' => false
);

// highlight_string(var_export($sql, 1));

if (!is_resource($serendipity['dbConn'])) {
return false;
}

if ($expectError) {
$c = @OCIParse($serendipity['dbConn'] , $sql);
OCIExecute($c);
} else {
OCIExecute(OCIParse($serendipity['dbConn'] , $sql));
}

if (!$expectError && OCIError($serendipity['dbConn']) != '') {
$msg = '<pre>' . $sql . '</pre> / ' . OCIError($serendipity['dbConn']);
return $msg;
}

if (!$c) {
if (!$expectError && !$serendipity['production']) {
print '<pre>' . $sql . '</pre> / ' . OCIError($serendipity['dbConn']);
if (function_exists('debug_backtrace') && $reportErr == true) {
highlight_string(var_export(debug_backtrace(), 1));
}
}

return $type_map['false'];
}
if ($c === true) {
return $type_map['true'];
}

$result_type = $type_map[$result_type];

switch(OCIRowCount($c)) {
case 0:
if ($single) {
return $type_map['false'];
}
return $type_map['true'];
case 1:
if ($single) {
return OCIFetchStatement($c, $result_type);

}
default:
if ($single) {
return OCIFetchStatement($c, $result_type);
}

$rows = array();
while (($row = OCIFetchStatement($c, $result_type))) {
if (!empty($assocKey) && !empty($assocVal)) {
// You can fetch a key-associated array via the two function parameters assocKey and assocVal
$rows[$row[$assocKey]] = $row[$assocVal];
} else {
$rows[] = $row;
}
}
return $rows;
}
}

/**
* Returns the latest INSERT_ID of an SQL INSERT INTO command, for auto-increment columns
*
* @access public
* @return int Value of the auto-increment column
*/
function serendipity_db_insert_id() {
global $serendipity;

// return mysql_insert_id($serendipity['dbConn']);
}

/**
* Returns the number of affected rows of a SQL query
*
* @access public
* @return int Number of affected rows
*/
function serendipity_db_affected_rows() {
global $serendipity;

return OCIRowCount($serendipity['dbConn']);
}

/**
* Returns the number of updated rows in a SQL query
*
* @access public
* @return int Number of updated rows
*/
function serendipity_db_updated_rows() {
global $serendipity;

preg_match(
"/^[^0-9]+([0-9]+)[^0-9]+([0-9]+)[^0-9]+([0-9]+)/",
mysql_info(),
$arr);
// mysql_affected_rows returns 0 if rows were matched but not changed.
// mysql_info returns rows matched AND rows changed
return $arr[2];
}

/**
* Returns the number of matched rows in a SQL query
*
* @access public
* @return int Number of matched rows
*/
function serendipity_db_matched_rows() {
global $serendipity;

preg_match(
"/^[^0-9]+([0-9]+)[^0-9]+([0-9]+)[^0-9]+([0-9]+)/",
mysql_info(),
$arr);
// mysql_affected_rows returns 0 if rows were matched but not changed.
// mysql_info returns rows matched AND rows changed
return $arr[1];
}

/**
* Returns a escaped string, so that it can be safely included in a SQL string encapsulated within quotes, without allowing SQL injection.
*
* @access public
* @param string input string
* @return string output string
*/
function serendipity_db_escape_string($string) {
global $serendipity;

/* if (is_resource($serendipity['dbConn']) && function_exists('mysql_real_escape_string')) {
return mysql_real_escape_string($string, $serendipity['dbConn']);
} else {
return mysql_escape_string($string);
}*/
}

/**
* Returns the option to a LIMIT SQL statement, because it varies accross DB systems
*
* @access public
* @param int Number of the first row to return data from
* @param int Number of rows to return
* @return string SQL string to pass to a LIMIT statement
*/
function serendipity_db_limit($start, $offset) {
return $start . ', ' . $offset;
}

/**
* Return a LIMIT SQL option to the DB Layer as a full LIMIT statement
*
* @access public
* @param SQL string of a LIMIT option
* @return SQL string containing a full LIMIT statement
*/
function serendipity_db_limit_sql($limitstring) {
return ' LIMIT ' . $limitstring;
}

/**
* Connect to the configured Database
*
* @access public
* @return ressource connection handle
*/
function serendipity_db_connect() {
global $serendipity;

if (isset($serendipity['dbConn'])) {
return $serendipity['dbConn'];
}

if (isset($serendipity['dbPersistent']) && $serendipity['dbPersistent']) {
$function = 'OCIPLogon';
} else {
$function = 'OCILogon';
}

$serendipity['dbConn'] = $function($serendipity['dbUser'], $serendipity['dbPass'],$serendipity['dbHost']);
OCILogon($serendipity['dbUser'], $serendipity['dbPass'],$serendipity['dbName']);
if (defined('SQL_CHARSET') && $serendipity['dbNames']) {
OCIExecute( OCIParse($serendipity['dbConn'], "SET NAMES " . SQL_CHARSET ));
}

return $serendipity['dbConn'];
}

/**
* Prepares a Serendipty query input to fully valid SQL. Replaces certain "template" variables.
*
* @access public
* @param string SQL query with template variables to convert
* @return ressource SQL ressource handle of the executed query
*/
function serendipity_db_schema_import($query) {
static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10}', '{text}','{BOOLEAN}');

static $replace = array('VARCHAR2 ','number ','primary key',
'','number(1)','number(4)','number(11)','number(10)', 'VARCHAR2(255)','');

static $is_utf8 = null;
global $serendipity;

if ($is_utf8 === null) {
$search[] = '{UTF_8}';
if ( (isset($_POST['charset']) && $_POST['charset'] == 'UTF-8/') ||
$serendipity['charset'] == 'UTF-8/' ||
$serendipity['POST']['charset'] == 'UTF-8/' ||
LANG_CHARSET == 'UTF-8' ) {
$replace[] = '/*!40100 CHARACTER SET utf8 COLLATE utf8_unicode_ci */';
} else {
$replace[] = '';
}
}

$query = trim(str_replace($search, $replace, $query));

if ($query{0} == '@') {
// Errors are expected to happen (like duplicate index creation)
return serendipity_db_query(substr($query, 1), false, 'both', false, false, false, true);
} else {
echo $query;
return serendipity_db_query($query);
}
}

/**
* Try to connect to the configured Database (during installation)
*
* @access public
* @param array input configuration array, holding the connection info
* @param array referenced array which holds the errors that might be encountered
* @return boolean return true on success, false on error
*/
function serendipity_db_probe($hash, &$errs) {
global $serendipity;

if (!function_exists('OCILogon')) {
$errs[] = 'No OCI extension found. Please check your webserver installation or contact your systems administrator regarding this problem.';
return false;
}

if (!($c = @OCILogon($hash['dbUser'], $hash['dbPass'],$hash['dbHost']))) {
$errs[] = 'Could not connect to database; check your settings.';
$errs[] = 'The Oracle error was: ' . OCIError();
return false;
}

$serendipity['dbConn'] = $c;

if (!@OCILogon($hash['dbUser'], $hash['dbPass'],$hash['dbName'])) {
$errs[] = 'The database you specified does not exist.';
$errs[] = 'The OCI error was: ' . OCIError();
return false;
}

return true;
}

/**
* Returns the SQL code used for concatenating strings
*
* @access public
* @param string Input string/column to concatenate
* @return string SQL parameter
*/
function serendipity_db_concat($string) {
return 'concat(' . $string . ')';
}

/* vim: set sts=4 ts=4 expandtab : */

Thanks,
Amita[/url]

falk · Post by **falk** » Wed Jun 28, 2006 8:08 am

Replace

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10}', '{text}','{BOOLEAN}');

with

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10)}', '{text}','{BOOLEAN}');

I don't have found more bugs jet.

amita · Post by **amita** » Wed Jun 28, 2006 10:00 am

falk wrote:Replace

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10}', '{text}','{BOOLEAN}');

with

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10)}', '{text}','{BOOLEAN}');

I don't have found more bugs jet.

Hi Falk,

Both the strings are same... what to replace... i didn't get it.

Thanks,
Amita

Post by **garvinhicking** » Wed Jun 28, 2006 10:53 am

Hi!

Sadly you posted your code here unformatted, so I can give you the file back also only unformatted. You should re-indent all the stuff, because now it really looks ugly.

Use \

Code: Select all

...\

blocks here in the forums to enclose your code so that formatting doesn't get lost.

I only changed the serendipity_db_schema_import() function, here it is:

Code: Select all

/**
* Prepares a Serendipty query input to fully valid SQL. Replaces certain "template" variables.
*
* @access public
* @param string SQL query with template variables to convert
* @return ressource SQL ressource handle of the executed query
*/
function serendipity_db_schema_import($query) {
static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','int(1)','int(4)','int(11)','int(10)', 'text','{BOOLEAN}');

static $replace = array('VARCHAR2 ','number ','primary key',
'','number(1)','number(4)','number(11)','number(10)', 'VARCHAR2(255)','');

static $is_utf8 = null;
global $serendipity;

$query = trim(str_replace($search, $replace, $query));

echo "SETUP ROUTINE - EXECUTING QUERY: <pre>$query</pre><br />\n";
if ($query{0} == '@') {
// Errors are expected to happen (like duplicate index creation)
return serendipity_db_query(substr($query, 1), false, 'both', false, false, false, true);
} else {
return serendipity_db_query($query);
}
}

If you now reinstall serendipity, it shoudl give you many SQL output "SETUP ROUTINE - EXECUTING QUERY: ...".

You might also want to use only OCILogin(...) instead of @OCILogin(...). For debugging it's good to not suppress possible error messages.

Also I think this:

Code: Select all

OCIExecute( OCIParse($serendipity['dbConn'], "SET NAMES " . SQL_CHARSET ));

Does notw ork in OCI, I don't think it has a "SET NAMES ..." SQL statement. MySQL needs this to indicate the connection charset.

Also the serendipity_db_escape_string() function still uses mysql functions for you. Replace it with:

Code: Select all

/**
* Returns a escaped string, so that it can be safely included in a SQL string encapsulated within quotes, without allowing SQL injection.
*
* @access public
* @param string input string
* @return string output string
*/
function serendipity_db_escape_string($string) {
global $serendipity;

return addslashes($string);
}

The rest already looks quite good, so I think you're close!

Best regards,
Garvin

falk · Post by **falk** » Wed Jun 28, 2006 11:59 am

amita wrote:
falk wrote:Replace

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10}', '{text}','{BOOLEAN}');

with

static $search = array('{VARCHAR}','{AUTOINCREMENT}', '{PRIMARY}',
'{UNSIGNED}','{int(1)}','{int(4)}','{int(11)}','{int(10)}', '{text}','{BOOLEAN}');

I don't have found more bugs jet.
Hi Falk,

Both the strings are same... what to replace... i didn't get it.

Thanks,
Amita

Look here: {int(10} -> {int(10)}

amita · Post by **amita** » Wed Jun 28, 2006 12:41 pm

Hi Garvin,

I tried by those changes...
but the string that should be replaced in db_import_query is not getting replaced. So The structure which was used was wrong.

So I changed db.sql, means i wrote the syntax there the same as oracle syntax to create table.
But the tables are not getting created actually....when i check for that in sql+ , the tables are not there....

Thanks,
Amita

Post by **garvinhicking** » Wed Jun 28, 2006 12:47 pm

So? What were the SQL queries, and what happens if you enter those SQL queries in your Oracle tool?

And which replacement for example was not made from the db.sql, exactly? What was the actual result and what was the expected result in the SQL queries?

Regards,
Garvin

amita · Post by **amita** » Wed Jun 28, 2006 1:44 pm

Hi Garvin,

I think i am very much confusing you....

For me tables were not getting created automatically while installation. So i created all the tables and indexes manually.
Now it is showing me the proper insert statement with all the values, but the actual insert in tables is not done in serendipity_authors. But i found 41 rows inserted in serendipity_config.

Again " Visit your blog " click asks for username/password. i am giving the correct username and password. but it shows "wrong credentials".

Why now this problem is creating?
I had changed db.sql according to the oracle syntax. Means i have written there directly the Oracle syntax. such as,

Code: Select all

create table serendipity_authors (
  realname varchar2(255) NOT NULL,
  username varchar2(20) default null,
  password varchar2(32) default null,
  authorid varchar2(11) primary key,
  mail_comments number(1) default '1',
  mail_trackbacks number(1) default '1',
  email varchar2(128) not null ,
  userlevel number(4) not null ,
  right_publish number(1) default '1'
);

Now the set of errors/warnings given are:

Code: Select all

Serendipity Installation 
 
Checking to see if the database and tables already exists...SELECT * FROM serendipity_authors they do not
Creating default database setup...SETUP ROUTINE - EXECUTING QUERY: 
CREATE INDEX groupid_idx ON serendipity_groupconfig (id);

CREATE INDEX groupid_idx ON serendipity_groupconfig (id);
Warning: ociexecute() [function.ociexecute]: ORA-00911: invalid character in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

CREATE INDEX groupid_idx ON serendipity_groupconfig (id);
/ SETUP ROUTINE - EXECUTING QUERY: 
CREATE INDEX groupprop_idx ON serendipity_groupconfig (id, property);

CREATE INDEX groupprop_idx ON serendipity_groupconfig (id, property);
Warning: ociexecute() [function.ociexecute]: ORA-00911: invalid character in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

CREATE INDEX groupprop_idx ON serendipity_groupconfig (id, property);
/ SETUP ROUTINE - EXECUTING QUERY: 
CREATE INDEX accessgroup_idx ON serendipity_access(groupid);

CREATE INDEX accessgroup_idx ON serendipity_access(groupid);
Warning: ociexecute() [function.ociexecute]: ORA-00911: invalid character in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

CREATE INDEX accessgroup_idx ON serendipity_access(groupid);
/ SETUP ROUTINE - EXECUTING QUERY: 
CREATE INDEX accessgroupT_idx ON serendipity_access(artifact_id,artifact_type,artifact_mode);

CREATE INDEX accessgroupT_idx ON serendipity_access(artifact_id,artifact_type,artifact_mode);
Warning: ociexecute() [function.ociexecute]: ORA-00911: invalid character in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

CREATE INDEX accessgroupT_idx ON serendipity_access(artifact_id,artifact_type,artifact_mode);
/ SETUP ROUTINE - EXECUTING QUERY: 
CREATE INDEX accessforeign_idx ON serendipity_access(artifact_id);

/ Done
Creating primary author 'Amita'...INSERT INTO serendipity_authors (username, password, realname, email, userlevel) VALUES ('Amita', '81dc9bdb52d04dc20036dbd8313ed055', 'Amita Soni', 'amita.soni@gmail.com', '255')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_AUTHORS"."AUTHORID") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_authors (username, password, realname, email, userlevel)
                        VALUES  ('Amita',
                                 '81dc9bdb52d04dc20036dbd8313ed055',
                                 'Amita Soni',
                                 'amita.soni@gmail.com',
                                 '255')
/ INSERT INTO serendipity_permalinks (permalink, entry_id, type) VALUES ('authors/0-Amita-Soni', '0', 'author')
INSERT INTO serendipity_permalinks
                                                    (permalink, entry_id, type)
                                             VALUES ('authors/0-Amita-Soni', '0', 'author')
/ UPDATE serendipity_authors SET mail_comments = '1' WHERE authorid = 0
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImages', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesDirectories', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesDirectories', 'false')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesAdd', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesAdd', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesDelete', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesDelete', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesMaintainOthers', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesMaintainOthers', 'false')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesViewOthers', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesViewOthers', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesView', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesView', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesSync', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImagesSync', 'false')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminComments', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminComments', 'false')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminTemplates', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminTemplates', 'false')
/ INSERT INTO serendipity_groups (name) VALUES ('USERLEVEL_CHIEF_DESC')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_GROUPS"."ID") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_groups (name) VALUES ('USERLEVEL_CHIEF_DESC')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'userlevel', '1')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'userlevel', '1')
/ SELECT * FROM serendipity_authors WHERE userlevel = 1
SELECT * FROM serendipity_authors WHERE userlevel = 1
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfiguration', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfiguration', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfigurationUserlevel', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfigurationUserlevel', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfigurationNoCreate', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfigurationNoCreate', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfigurationRightPublish', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'personalConfigurationRightPublish', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'siteConfiguration', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'siteConfiguration', 'false')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'blogConfiguration', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'blogConfiguration', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminEntries', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminEntries', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminEntriesMaintainOthers', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminEntriesMaintainOthers', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImport', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminImport', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminCategories', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminCategories', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminCategoriesMaintainOthers', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminCategoriesMaintainOthers', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminCategoriesDelete', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminCategoriesDelete', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsers', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsers', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersDelete', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersDelete', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersEditUserlevel', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersEditUserlevel', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersMaintainSame', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersMaintainSame', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersMaintainOthers', 'false')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersMaintainOthers', 'false')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersCreateNew', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersCreateNew', 'true')
/ INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersGroups', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminUsersGroups', 'true')
INSERT INTO serendipity_groupconfig (id, property, value) VALUES (0, 'adminTemplates', 'true')
/ Done
Setting default template... DELETE FROM serendipity_config where name='template' AND authorid = 0
DELETE FROM serendipity_config where name='template' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('template', 'carl_contest', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('template', 'carl_contest', '0')
/ Done
Installing default plugins... SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_calendar_plugin:37c2a8dafb29d210cde99f6948a4d8db', 0, 'right', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_calendar_plugin:37c2a8dafb29d210cde99f6948a4d8db', 0, 'right', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_quicksearch_plugin:0e63e475babb863fbf408e11186b3688', 0, 'right', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_archives_plugin:1aaf69863336afb6bb2767c4df71d639', 0, 'right', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_archives_plugin:1aaf69863336afb6bb2767c4df71d639', 0, 'right', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_categories_plugin:1faa2a198471e09ecc16808b4ae10a15', 0, 'right', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_categories_plugin:1faa2a198471e09ecc16808b4ae10a15', 0, 'right', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_syndication_plugin:2ead2924d4571bb4f6b742f6561a6a1e', 0, 'right', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_syndication_plugin:2ead2924d4571bb4f6b742f6561a6a1e', 0, 'right', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_superuser_plugin:e6cf73537652925578bf2f7827753e95', 0, 'right', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_superuser_plugin:e6cf73537652925578bf2f7827753e95', 0, 'right', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'right'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_plug_plugin:532da1c00b4ebe9838be384fbcdadacf', 0, 'right', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('@serendipity_plug_plugin:532da1c00b4ebe9838be384fbcdadacf', 0, 'right', '0', '')

/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_s9ymarkup:7c7128efeb1b6ced02c6d67bb59703c8', 0, 'event', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_s9ymarkup:7c7128efeb1b6ced02c6d67bb59703c8', 0, 'event', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_emoticate:4bb152e3f282f3e076831cac17ffc9da', 0, 'event', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_emoticate:4bb152e3f282f3e076831cac17ffc9da', 0, 'event', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_nl2br:90cd9e6ccf42e134d3d9d5f042e524fd', 0, 'event', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_nl2br:90cd9e6ccf42e134d3d9d5f042e524fd', 0, 'event', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_browsercompatibility:525255cb0e40a5fd82e105523bb644ca', 0, 'event', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_browsercompatibility:525255cb0e40a5fd82e105523bb644ca', 0, 'event', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
SELECT MAX(sort_order) as sort_order_max FROM serendipity_plugins WHERE placement = 'event'
/ INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_spamblock:8181cac45dfb6fcb5c8045dba81b2e72', 0, 'event', '0', '')
INSERT INTO serendipity_plugins (name, sort_order, placement, authorid, path) values ('serendipity_event_spamblock:8181cac45dfb6fcb5c8045dba81b2e72', 0, 'event', '0', '')
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ SELECT * from serendipity_plugins WHERE placement = 'event' ORDER BY placement, sort_order
SELECT * from serendipity_plugins  WHERE  placement =  'event'  ORDER BY placement, sort_order
/ Done
Attempting to write .htaccess file...... Done
DELETE FROM serendipity_config where name='serendipityPath' AND authorid = 0
DELETE FROM serendipity_config where name='serendipityPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('serendipityPath', 'E:/Program Files/Apache Group/Apache2/htdocs/serendipity-1.0-beta3.tar/serendipity-1.0-beta3/serendipity/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('serendipityPath', 'E:/Program Files/Apache Group/Apache2/htdocs/serendipity-1.0-beta3.tar/serendipity-1.0-beta3/serendipity/', '0')
/ DELETE FROM serendipity_config where name='uploadPath' AND authorid = 0
DELETE FROM serendipity_config where name='uploadPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('uploadPath', 'uploads/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('uploadPath', 'uploads/', '0')
/ DELETE FROM serendipity_config where name='serendipityHTTPPath' AND authorid = 0
DELETE FROM serendipity_config where name='serendipityHTTPPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('serendipityHTTPPath', '/serendipity-1.0-beta3.tar/serendipity-1.0-beta3/serendipity/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('serendipityHTTPPath', '/serendipity-1.0-beta3.tar/serendipity-1.0-beta3/serendipity/', '0')
/ DELETE FROM serendipity_config where name='templatePath' AND authorid = 0
DELETE FROM serendipity_config where name='templatePath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('templatePath', 'templates/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('templatePath', 'templates/', '0')
/ DELETE FROM serendipity_config where name='uploadHTTPPath' AND authorid = 0
DELETE FROM serendipity_config where name='uploadHTTPPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('uploadHTTPPath', 'uploads/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('uploadHTTPPath', 'uploads/', '0')
/ DELETE FROM serendipity_config where name='baseURL' AND authorid = 0
DELETE FROM serendipity_config where name='baseURL' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('baseURL', 'http://localhost/serendipity-1.0-beta3.tar/serendipity-1.0-beta3/serendipity/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('baseURL', 'http://localhost/serendipity-1.0-beta3.tar/serendipity-1.0-beta3/serendipity/', '0')
/ DELETE FROM serendipity_config where name='autodetect_baseURL' AND authorid = 0
DELETE FROM serendipity_config where name='autodetect_baseURL' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('autodetect_baseURL', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('autodetect_baseURL', '', '0')
/ DELETE FROM serendipity_config where name='indexFile' AND authorid = 0
DELETE FROM serendipity_config where name='indexFile' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('indexFile', 'index.php', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('indexFile', 'index.php', '0')
/ DELETE FROM serendipity_config where name='permalinkStructure' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkStructure' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkStructure', 'archives/%id%-%title%.html', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkStructure', 'archives/%id%-%title%.html', '0')
/ DELETE FROM serendipity_config where name='permalinkAuthorStructure' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkAuthorStructure' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkAuthorStructure', 'authors/%id%-%realname%', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkAuthorStructure', 'authors/%id%-%realname%', '0')
/ DELETE FROM serendipity_config where name='permalinkCategoryStructure' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkCategoryStructure' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkCategoryStructure', 'categories/%id%-%name%', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkCategoryStructure', 'categories/%id%-%name%', '0')
/ DELETE FROM serendipity_config where name='permalinkFeedCategoryStructure' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkFeedCategoryStructure' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkFeedCategoryStructure', 'feeds/categories/%id%-%name%.rss', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkFeedCategoryStructure', 'feeds/categories/%id%-%name%.rss', '0')
/ DELETE FROM serendipity_config where name='permalinkFeedAuthorStructure' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkFeedAuthorStructure' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkFeedAuthorStructure', 'feeds/authors/%id%-%realname%.rss', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkFeedAuthorStructure', 'feeds/authors/%id%-%realname%.rss', '0')
/ DELETE FROM serendipity_config where name='permalinkArchivesPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkArchivesPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkArchivesPath', 'archives', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkArchivesPath', 'archives', '0')
/ DELETE FROM serendipity_config where name='permalinkArchivePath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkArchivePath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkArchivePath', 'archive', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkArchivePath', 'archive', '0')
/ DELETE FROM serendipity_config where name='permalinkCategoriesPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkCategoriesPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkCategoriesPath', 'categories', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkCategoriesPath', 'categories', '0')
/ DELETE FROM serendipity_config where name='permalinkAuthorsPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkAuthorsPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkAuthorsPath', 'authors', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkAuthorsPath', 'authors', '0')
/ DELETE FROM serendipity_config where name='permalinkUnsubscribePath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkUnsubscribePath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkUnsubscribePath', 'unsubscribe', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkUnsubscribePath', 'unsubscribe', '0')
/ DELETE FROM serendipity_config where name='permalinkDeletePath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkDeletePath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkDeletePath', 'delete', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkDeletePath', 'delete', '0')
/ DELETE FROM serendipity_config where name='permalinkApprovePath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkApprovePath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkApprovePath', 'approve', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkApprovePath', 'approve', '0')
/ DELETE FROM serendipity_config where name='permalinkFeedsPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkFeedsPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkFeedsPath', 'feeds', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkFeedsPath', 'feeds', '0')
/ DELETE FROM serendipity_config where name='permalinkPluginPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkPluginPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkPluginPath', 'plugin', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkPluginPath', 'plugin', '0')
/ DELETE FROM serendipity_config where name='permalinkAdminPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkAdminPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkAdminPath', 'admin', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkAdminPath', 'admin', '0')
/ DELETE FROM serendipity_config where name='permalinkSearchPath' AND authorid = 0
DELETE FROM serendipity_config where name='permalinkSearchPath' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('permalinkSearchPath', 'search', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('permalinkSearchPath', 'search', '0')
/ DELETE FROM serendipity_config where name='allowSubscriptions' AND authorid = 0
DELETE FROM serendipity_config where name='allowSubscriptions' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('allowSubscriptions', '1', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('allowSubscriptions', '1', '0')
/ DELETE FROM serendipity_config where name='blogTitle' AND authorid = 0
DELETE FROM serendipity_config where name='blogTitle' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('blogTitle', 'Amita Soni\'s personal blog', '0')
Warning: ociparse() [function.ociparse]: ORA-01756: quoted string not properly terminated in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

Warning: ociexecute() expects parameter 1 to be resource, boolean given in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('blogTitle', 'Amita Soni\'s personal blog', '0')
/ ArrayDELETE FROM serendipity_config where name='blogDescription' AND authorid = 0
DELETE FROM serendipity_config where name='blogDescription' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('blogDescription', 'My little place on the web...', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('blogDescription', 'My little place on the web...', '0')
/ DELETE FROM serendipity_config where name='blogMail' AND authorid = 0
DELETE FROM serendipity_config where name='blogMail' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('blogMail', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('blogMail', '', '0')
/ DELETE FROM serendipity_config where name='lang' AND authorid = 0
DELETE FROM serendipity_config where name='lang' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('lang', 'en', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('lang', 'en', '0')
/ DELETE FROM serendipity_config where name='charset' AND authorid = 0
DELETE FROM serendipity_config where name='charset' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('charset', 'UTF-8/', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('charset', 'UTF-8/', '0')
/ DELETE FROM serendipity_config where name='calendar' AND authorid = 0
DELETE FROM serendipity_config where name='calendar' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('calendar', 'gregorian', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('calendar', 'gregorian', '0')
/ DELETE FROM serendipity_config where name='lang_content_negotiation' AND authorid = 0
DELETE FROM serendipity_config where name='lang_content_negotiation' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('lang_content_negotiation', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('lang_content_negotiation', '', '0')
/ DELETE FROM serendipity_config where name='fetchLimit' AND authorid = 0
DELETE FROM serendipity_config where name='fetchLimit' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('fetchLimit', '15', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('fetchLimit', '15', '0')
/ DELETE FROM serendipity_config where name='useGzip' AND authorid = 0
DELETE FROM serendipity_config where name='useGzip' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('useGzip', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('useGzip', '', '0')
/ DELETE FROM serendipity_config where name='wysiwyg' AND authorid = 0
DELETE FROM serendipity_config where name='wysiwyg' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('wysiwyg', 'false', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('wysiwyg', 'false', '0')
/ DELETE FROM serendipity_config where name='XHTML11' AND authorid = 0
DELETE FROM serendipity_config where name='XHTML11' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('XHTML11', '1', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('XHTML11', '1', '0')
/ DELETE FROM serendipity_config where name='enablePopup' AND authorid = 0
DELETE FROM serendipity_config where name='enablePopup' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('enablePopup', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('enablePopup', '', '0')
/ DELETE FROM serendipity_config where name='embed' AND authorid = 0
DELETE FROM serendipity_config where name='embed' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('embed', 'false', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('embed', 'false', '0')
/ DELETE FROM serendipity_config where name='top_as_links' AND authorid = 0
DELETE FROM serendipity_config where name='top_as_links' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('top_as_links', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('top_as_links', '', '0')
/ DELETE FROM serendipity_config where name='trackReferrer' AND authorid = 0
DELETE FROM serendipity_config where name='trackReferrer' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('trackReferrer', '1', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('trackReferrer', '1', '0')
/ DELETE FROM serendipity_config where name='blockReferer' AND authorid = 0
DELETE FROM serendipity_config where name='blockReferer' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('blockReferer', ';', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('blockReferer', ';', '0')
/ DELETE FROM serendipity_config where name='rewrite' AND authorid = 0
DELETE FROM serendipity_config where name='rewrite' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('rewrite', 'none', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('rewrite', 'none', '0')
/ DELETE FROM serendipity_config where name='serverOffsetHours' AND authorid = 0
DELETE FROM serendipity_config where name='serverOffsetHours' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('serverOffsetHours', '0', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('serverOffsetHours', '0', '0')
/ DELETE FROM serendipity_config where name='showFutureEntries' AND authorid = 0
DELETE FROM serendipity_config where name='showFutureEntries' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('showFutureEntries', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('showFutureEntries', '', '0')
/ DELETE FROM serendipity_config where name='enableACL' AND authorid = 0
DELETE FROM serendipity_config where name='enableACL' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('enableACL', '1', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('enableACL', '1', '0')
/ DELETE FROM serendipity_config where name='magick' AND authorid = 0
DELETE FROM serendipity_config where name='magick' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('magick', '', '0')
Warning: ociexecute() [function.ociexecute]: ORA-01400: cannot insert NULL into ("SCOTT"."SERENDIPITY_CONFIG"."VALUE") in E:\Program Files\Apache Group\Apache2\htdocs\serendipity-1.0-beta3.tar\serendipity-1.0-beta3\serendipity\include\db\oci8.inc.php on line 82

INSERT INTO serendipity_config (name,value,authorid) values ('magick', '', '0')
/ DELETE FROM serendipity_config where name='convert' AND authorid = 0
DELETE FROM serendipity_config where name='convert' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('convert', 'C:\\WINDOWS\\system32/convert.exe', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('convert', 'C:\\WINDOWS\\system32/convert.exe', '0')
/ DELETE FROM serendipity_config where name='thumbSuffix' AND authorid = 0
DELETE FROM serendipity_config where name='thumbSuffix' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('thumbSuffix', 'serendipityThumb', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('thumbSuffix', 'serendipityThumb', '0')
/ DELETE FROM serendipity_config where name='thumbSize' AND authorid = 0
DELETE FROM serendipity_config where name='thumbSize' AND authorid = 0
/ INSERT INTO serendipity_config (name,value,authorid) values ('thumbSize', '110', '0')
INSERT INTO serendipity_config (name,value,authorid) values ('thumbSize', '110', '0')
/ 
Serendipity has been successfully installed
Visit your new blog here
Thank you for choosing Serendipity 


Powered by Serendipity and PHP 5.1.4

What may be the problem now?

I hope , i am not disturbing u a lot...

Thanks,
Garvin.

Post by **garvinhicking** » Wed Jun 28, 2006 1:49 pm

Okay, it seems that the "CREATE INDEX..." statements do not work in Oracle. How would the correct syntax be?

And about db.sql: It would be good if you can check out that string replacements are correctly performed, because else we won't be able to use your OCI interface in the official serendipity distribution. The db.sql should best be delivered out of of a replaced original db.sql by the serendipity_db_schema_import() function.

About the other messages - you cannot login because no entry seems to have been made into the serendipity_authors table. OCI reports "cannot insert NULL into ("SCOTT"."SERENDIPITY_AUTHORS"."AUTHORID") ". Please check what this error message means. You can try to put the used SQL query (it comes before the error) into your Oracle tool to spot the error.

HTH,
Garvin

Conversion of some mysql php functions to oci functions.

agn one problem....

Re: agn one problem....