Delete a user (postgresql) has invalid sql
Posted: Wed Mar 09, 2005 11:06 pm
When i went to delete a user it puked (see bottom)
I am running postgresql 7.4 something. The limit clause is not valid on a delete statement. Also why is there a userlevel clause?
The statement (as far as I can tell) should just be.
DELETE FROM serendipity_authors WHERE authorid=3
Error message:
I am running postgresql 7.4 something. The limit clause is not valid on a delete statement. Also why is there a userlevel clause?
The statement (as far as I can tell) should just be.
DELETE FROM serendipity_authors WHERE authorid=3
Error message:
Code: Select all
Warning: pg_query(): Query failed: ERROR: syntax error at or near "LIMIT" at character 71 in /var/www/duckies.org/serendipity/include/db/postgres.inc.php on line 107
Error in DELETE FROM serendipity_authors WHERE authorid=3 and userlevel <= 255 LIMIT 1
ERROR: syntax error at or near "LIMIT" at character 71
array (
0 =>
array (
'file' => '/var/www/duckies.org/serendipity/include/functions_config.inc.php',
'line' => 20,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => 'DELETE FROM serendipity_authors WHERE authorid=3 and userlevel <= 255 LIMIT 1',
),
),
1 =>
array (
'file' => '/var/www/duckies.org/serendipity/include/admin/users.inc.php',
'line' => 23,
'function' => 'serendipity_deleteauthor',
'args' =>
array (
0 => '3',
),
),
2 =>
array (
'file' => '/var/www/duckies.org/serendipity/serendipity_admin.php',
'line' => 210,
'args' =>
array (
0 => '/var/www/duckies.org/serendipity/include/admin/users.inc.php',
),
'function' => 'include',
),
)
DELETE FROM serendipity_authors WHERE authorid=3 and userlevel <= 255 LIMIT 1