Conversion of some mysql php functions to oci functions.

amita · Post by **amita** » Mon Jul 03, 2006 9:48 am

Hi Garvin,

I tried by replacing the function,

its displaying as follows,

Even i tried putting echo statements in function serendipity_userLoggedIn,
as follows:

Code: Select all

function serendipity_userLoggedIn() {
    if ($_SESSION['serendipityAuthedUser'] === true && IS_installed) {
    echo "user logged in";
        return true;
    } else {
    echo "user not logged in";
        return false;
    }
}

its displaying me as "user not Logged in" .

Is that connection is closed or its not retriving data from the table again?

Thanks,
Amita

Post by **garvinhicking** » Mon Jul 03, 2006 10:05 am

Hi!

You got it in front:

SELECT name, value
FROM serendipity_config
WHERE authorid = 0

This query does not yield any results! But it should return all rows of the table. Check the same changed function in your MySQL s9y installation and then you see how the rows should be returned.

Maybe your serendipity_db_query() function does not work at all. Check it out in MySQL to see how it's supposed to work and return rows.

Best regards,
Garvin

amita · Post by **amita** » Tue Jul 04, 2006 7:43 am

Hi Garvin,

I chnaged the serendipity_db_query function. I just created a samll dummy program to create table, insert rows, select rows etc. its working fine. so i just added those functionality in current Serendipity_db_query()

Code: Select all

   global $serendipity;
    static $type_map = array(
                         'assoc' => OCI_ASSOC,
                         'num'   => OCI_NUM,
                         'both'  => OCI_BOTH,
                         'true'  => true,
                         'false' => false
    );

    if ($expectError) {
       $c = OCIParse($serendipity['dbConn'] , $sql);
       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'];
			    }

   	      echo "<h1>ERROR - Could not parse SQL statement.</h1>";
   	      exit;
         }
	   OCIExecute($c, OCI_DEFAULT);
    }else {
        $c = OCIParse($serendipity['dbConn'] , $sql);
        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'];
			 }

	      echo "<h1>ERROR - Could not parse SQL statement.</h1>";
	      exit;
          }
        OCIExecute($c, OCI_DEFAULT);
    }

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

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

    $result_type = $type_map[$result_type];

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

            }
        default:
            if ($single) {
                echo "Case default";
                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;
    }

And again i tried to install serendipity. Now it is giving me the results as follows:

Code: Select all

What may be the problem in Serendipity_db_query() function? All the values are getting inserted into the oracle database.

Please guide me to get out of this problem....

Thanks,
Amita

amita · Post by **amita** » Tue Jul 04, 2006 8:08 am

Hi Garvin,

I checked with the mysql output also for the same page....

Its showing the whole Arrays... the whole data from serendipity_config table is displayed as an output....

why it is not displaying it to me... ?

I think i m disturbing you a lot... but i cant help...as u r the only source of help for me...

Thanks,
Amita

Post by **garvinhicking** » Tue Jul 04, 2006 12:28 pm

Hi!

Its showing the whole Arrays... the whole data from serendipity_config table is displayed as an output....

Exactly, that is the desired output!

why it is not displaying it to me... ?

Because it seems that your serendipity_db_query does not properly return an array.

I'm sorry, I don't have any Oracle expierence, so I cannot tell you what to use to get the same results as with pgsql, mysql or sqlite. Maybe Falk can help here?

Best regards,
Garvin

amita · Post by **amita** » Wed Jul 05, 2006 7:32 am

Hi Garvin,

We observed different RETURN types in serendipity_db_query() like 'assoc' => OCI_ASSOC,'num' => OCI_NUM,'both' => OCI_BOTH,'true' => true,'false' => false. It shows that any of these types will be returned. But we never observed any code for checking the type of the value returned by serendipity_db_query() in the calling function/program. Then what is the significance of having these many return types ?

Again,
As per the definition of serendipity_db_query(),

Code: Select all

serendipity_db_query(
$sql, 
$single = false, 
$result_type = "both", 
$reportErr = false, 
$assocKey = false, 
$assocVal = false, 
$expectError = false)

, there are different input params which were defaulted to standard values. Can you describe the use of $single, $result_type.

Thanks in advance,
Amita.

Post by **garvinhicking** » Wed Jul 05, 2006 2:38 pm

Hi!

The wanted return code is passed as the 3rd. argument to serendipity_db_query.

Most db queries use "both" as the result type (which yields arrays like $serendipity[0] = 'x', $serendpity['column'] = 'x').

"assoc" only returns textual associations ('column1', 'column2', ...) whereas "num" only returns 0, 1, 2... etc.

Please check the PHPDoc code commentare inside the mysql files to see what $single / $result_type etc. indicates.

The best way for you would be to execute different function calls in your mysql install and see the differents. Like execute "SELECT * FROM serendipity_config" like this:

Code: Select all

print_r(serendipity_db_query("SELECT * FROM serendipity_config"));
print_r(serendipity_db_query("SELECT * FROM serendipity_config", false, 'num'));
print_r(serendipity_db_query("SELECT * FROM serendipity_config", false, 'assoc'));

print_r(serendipity_db_query("SELECT * FROM serendipity_config", true));
print_r(serendipity_db_query("SELECT * FROM serendipity_config", true, 'num'));
print_r(serendipity_db_query("SELECT * FROM serendipity_config", true, 'assoc'));

Best regards,
Garvin

amita · Post by **amita** » Wed Jul 05, 2006 3:12 pm

Hi Garvin,

Thanks for your quick and eloborated explanation. Good news is that, we crossed that point and getting the proper return type(s) from serendipity_db_query(). The below is the value of $serendipity array of PHP which has the values of serendipity_config table.

Code: Select all

The above values are in sink with the MySql values.

The point where we struck now is:-
We are getting a blank page at the 4th stage of installation, where we should get a personal bolg page containing some plug-ins like Calendar and other stuff.

We would like to know basing on which parameters the plug-ins will be decided and added to the bolg page ?

Can I dare to ask your contact number to get clarified with my queries in quick time

? [ if you dont mind on that. ]

Thanks in advance,
Amita.

Post by **garvinhicking** » Wed Jul 05, 2006 3:32 pm

Hi!

Please check your output! MySQL results are different, they do not have the multiple associative arrays you got with your Oracle results.

Instead of:

Code: Select all

    [30] => Array
        (
            [0] => fetchLimit
            [1] => 15
        )

on mysql this looks like:

Code: Select all

    [fetchlimt] => 15

Thus, serendipity is getting values different from what it expects!

My ICQ number should be in my footer: #21392242.

Best regards,
Garvin

amita · Post by **amita** » Thu Jul 06, 2006 9:26 am

Hi Garvin,

We made the array to display in the same format as what mysql displays..

And the exciting thing is we are getting the blog page.... with "John Doe Personel blog" as header. But the control on right hand side of the page are not displayed.

we are getting,

Code: Select all

 
 Error
serendipity error: could not include - exiting.
Error
serendipity error: could not include - exiting.

this error instead of the controls as calendar, RSS Feed, quick search etc.

i think ... now we are very close to it...

But why the controls are not displayed??

Please provide me the proper guideline in this regard....

Thanks,
Amita

Post by **garvinhicking** » Thu Jul 06, 2006 11:52 am

Hi!

It seems like there still are some wrong DB formats for this error.

Check your include/plugin_api.inc.php file. There go to the method "generate_plugins".

There, compare the output of $plugins inside the method with the output of $plugins on your mysql installation.

The error message is created a little bit more down the method:

Code: Select all

'content'       => sprintf(INCLUDE_ERROR, $plugin_data['name']));

This means that $plugin_data['name'] is empty on your installation, but in reality it should hold the classname of the plugin. Plus, you surely are missing other important $plugin_data array values which is why loading the plugins fails!

Best regards,
Garvin

amita · Post by **amita** » Fri Jul 07, 2006 2:24 pm

Hi Garvin,

We are back with the new query here!!!

What does the autoincrement field works in mysql? In more words,
01. For which fields of which tables it should be incremented ?
02. For which fields of which tables it should get the latest value ?

We wrote different sequences in Oracle for all the tables for which we found AUTOINCREMENT keyword in MySql code. Is it ok ??

Please suggest.

Thanks in advance,
Amita.

Post by **garvinhicking** » Fri Jul 07, 2006 2:59 pm

Hi!

We are back with the new query here!!!

I hope you remember me when you got it all up and running, because I'd love to put your work and the oracle interface into Serendipity.

What does the autoincrement field works in mysql? In more words,
01. For which fields of which tables it should be incremented ?
02. For which fields of which tables it should get the latest value ?

The autincrement field automatically inserts primary keys for the tables for new records. This way, the first entry gets ID 1, the second ID 2 and so on - each time a new record is inserted, it will automatically be set to the ID of the next free integer number.

The fields that need auto-increment can be found in the db.sql file, {AUTOINCREMENT} is attached to thos.

We wrote different sequences in Oracle for all the tables for which we found AUTOINCREMENT keyword in MySql code. Is it ok ??

That should be sufficient, even though I am personally not familiar with the concept of sequeneces, because basically mysql handles them internally.

Best regards,
Garvin

amita · Post by **amita** » Fri Jul 07, 2006 3:33 pm

Hi Garvin,

I have little bit different query....

I will give u an example.

In Mysql, the "Authorid" field in serendipity_authors is AutoIncrement field.
But there is "AuthorID" field in serendipity_authorgroups, serendipity_category, serendipity_config , serendipity_entries, etc.

The value of "AuthorID" gets populated by autoincrement in serendipity_authors , but how it gets inserted in different tables.
For me all different tables entries for Authorid are empty.

so , it is giving me problem while fetching entry record for "Edit Entry" and "Create new category".

Please suggest me ...

Thanks,
Amita

Post by **garvinhicking** » Fri Jul 07, 2006 4:25 pm

Hi!

In Mysql, the "Authorid" field in serendipity_authors is AutoIncrement field.
But there is "AuthorID" field in serendipity_authorgroups, serendipity_category, serendipity_config , serendipity_entries, etc.

Yes, that's a usual 1:n association of one primary key to related foreign keys.

The value of "AuthorID" gets populated by autoincrement in serendipity_authors , but how it gets inserted in different tables.
For me all different tables entries for Authorid are empty.

Serendipity retrieves the ID of the last inserted entry via the "serendipity_db_insert_id()" function. On MySQL, this executes the "SELECT LAST_INSERT_ID()" function, which will return the ID of the last inserted primary key. s9y uses this return value to insert corresponding foreign keys into the other tables.

So, by default s9y would create a new author in serendipity_authors, then retriev the author ID via this db_insert_id() function and then INSERT the correponsding ID into the serendipity_authorgroups or other tables.

The same for entry creation: The last insert ID is returned and then used for follow-up functions.

Best regards,
Garvin