| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.2.3 |
| Bug #768 | query update failure(postgresql) | ||
|---|---|---|---|
| Submitted: | 2004-02-16 08:22 UTC | ||
| From: | shota at dino dot co dot jp | Assigned: | quipo |
| Status: | Closed | Package: | MDB_QueryTool |
| PHP Version: | 4.2.2 | OS: | Redhat9 |
| Roadmaps: | (Not assigned) | ||
[2004-02-16 08:22 UTC] shota at dino dot co dot jp
Description:
------------
sql update failure when i use postgresql.
when i execute pear/docs/MDB_QueryTool/docs/example.php using postgresql, i can't clear all examples.
in $MDB->_buildselect(), MDB attaches 'tablename.' before fieldname.
so query is failed.
when i try below query without 'uuser.', query is ok.
</pre><h1>10 - adding data using $user->save($data)</h1><pre>6</pre><h1>11 - updating using $user->save($data)</h1><pre>user::MDB Error: syntax error-UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr. foo' WHERE id='6' [nativecode = ERROR: parser: parse error at or near "." at character 23
] (unknown)</pre><pre>user::UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr. foo' WHERE id='6' [nativecode = ERROR: parser: parse error at or near "." at character 23
] (1752)</pre><pre></pre><h1>12 - updating using $user->update($data)</h1><pre>user::MDB Error: syntax error-UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr. foo' WHERE id='6' [nativecode = ERROR: parser: parse error at or near "." at character 23
] (unknown)</pre><pre>user::UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr. foo' WHERE id='6' [nativecode = ERROR: parser: parse error at or near "." at character 23
] (1752)</pre><pre></pre><h1>13 - remove the entry $user->remove(6)</h1><pre>1</pre>
Comments
[2004-02-18 10:32 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2004-02-20 11:06 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2004-02-23 03:49 UTC] shota at dino dot co dot jp
this is table i used for testing.
query=# SELECT * from uuser;
id | login | name | surname | email | isadmin | password
----+-------+---------+----------+---------------+---------+----------------------------------
4 | pp | Paolo | Panto | pp@visionp.de | 1 |
3 | cain | Wolfram | Kriesing | wk@visionp.de | 1 | 8a9d62c756bd894451e63e9a511ded0c
(2 rows)
the result using MDB_QueryTool is
query=# UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr. foo' WHERE id='6';
ERROR: parser: parse error at or near "." at character 23
remove uuser.,
query=# UPDATE uuser SET id='6',login='NEW',name='Mr. foo' WHERE id='6';
UPDATE 0
[2004-03-13 19:06 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!