Re: [phplib] ct_sql bug - PHPLIB & page_close()
| From: | Bogdan Morar | Date: | Thu, 15 Feb 2001 16:16:00 +0000 |
| Subject: | Re: [phplib] ct_sql bug - PHPLIB & page_close() | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-39927@lists.php.net to get a copy of this message | ||
I have the same problem but i don't study the record which is the
subject of the update query.
I tested just the object "db" from ac_store, which has the props Host,
Database, user. The values of the db are correct in a debug mode (print
the values :o) ) but in the command query($q) is the error.
My user has a insert, update and delete privileges, on a just select
privilege user i hadn't the error.
Example of dabases and users:
class MyDB extend DB_SQL {
Host = "aaa.com";
Database = "MyDataBase";
User = "writeuser";
Password = "xxx";
}
class MySession extend Session {
Host = "aaa.com";
Database = "lib";
User = "writeuser";
Password = "xxx";
}
I had the objects:
page_open (array("sess"=>"MySession"));
X = new MyDB;
....
X->free();
....
page_close();
My error is, after the correct properties Host, Database, User, printed
in debug mode (from ac_store function) MyDataBase.active_session "isn't
a table";
I ask myself why ct_sql.db before the command "query" has the correct
properties and in the "query" function will be used the
MyDataBase.properties.
If you find a solution, please email me.
Bogdan Morar
SO: Redhat 6.2
Database: MySql 3.2.
Php: 3.0.16
Web Server: Apache
PhpLib: 7.2c
Prasad RL wrote:
>
> I know this problem has been discussed before. But then unfortunatly, i still find the bug has
> not been fixed.
>
> The problem seems to be in ac_store() function in ct_sql.inc.
>
> My observations were that
>
> 1. Surprisingly though the page_open() function doesnt create any entry in active_sessions
> table.
>
> 2.When page_close() function is called, it
> gives the following error;
>
> Database error: Invalid SQL: update active_sessions set val='...',
> changed='20010215030837' where sid='8378099455e8f8f96958bc3fc3559cbd' and
> name='Example_Session'
>
> MSSQL Error: 1 (General Error (The MSSQL interface cannot return detailed error messages).)
> Session halted.
>
> (pls note: this error doesnt appear when call to the page_close function is removed)
>
> The program halts with the above error immediately when the query "update active_sessions
> set val=.." is executed.
>
> What could be the cause of this error ?
>
> Why is the function trying to update when there's no entry in active_sessions table.
> and why is the entry not created at first point ?
>
> Any help would be highly appreciated.
>
> Thanks in advance,
>
> Sivaprasad R.L.
>
> p.s. I'm using phplib 7.2c (also tried with 7.2b)