Serendipity Forums

Code: Select all

Warning: pg_query(): Query failed: ERROR: syntax error at end of input at character 46 in /home/ler/serendipity/include/db/postgres.inc.php on line 83

Warning: pg_num_rows(): supplied argument is not a valid PostgreSQL result resource in /home/ler/serendipity/include/db/postgres.inc.php on line 84

Warning: pg_query(): Query failed: ERROR: syntax error at or near "," at character 64 in /home/ler/serendipity/include/db/postgres.inc.php on line 102
Error in INSERT INTO serendipity_entrycat (entryid, categoryid) VALUES (, 1)
ERROR: syntax error at or near "," at character 64
array (
  0 =>
  array (
    'file' => '/home/ler/serendipity/include/functions_entries.inc.php',
    'line' => 953,
    'function' => 'serendipity_db_query',
    'args' =>
    array (
      0 => 'INSERT INTO serendipity_entrycat (entryid, categoryid) VALUES (, 1)',
    ),
  ),
  1 =>
  array (
    'file' => '/home/ler/serendipity/include/functions_config.inc.php',
    'line' => 329,
    'function' => 'serendipity_updertentry',
    'args' =>
    array (
      0 =>
      array (
        'id' => '',
        'title' => 'Test Entry for DEV\'s...',
        'timestamp' => '1108513789',
        'body' => 'This is a test entry so I can get the traceback :)

LER
',
        'extended' => '',
        'categories' =>
        array (
          0 => '1',
        ),
        'isdraft' => 'false',
        'allow_comments' => 'true',
        'moderate_comments' => 'false',
        'exflag' => false,
      ),
    ),
  ),
  2 =>
  array (
    'file' => '/home/ler/serendipity/include/functions_config.inc.php',
    'line' => 308,
    'function' => 'serendipity_iframe',
    'args' =>
    array (
      0 =>
      array (
        'id' => '',
        'title' => 'Test Entry for DEV\'s...',
        'timestamp' => '1108513789',
        'body' => 'This is a test entry so I can get the traceback :)

LER
',
        'extended' => '',
        'categories' =>
        array (
          0 => '1',
        ),
        'isdraft' => 'false',
        'allow_comments' => 'true',
        'moderate_comments' => 'false',
        'exflag' => false,
      ),
      1 => 'save',
    ),
  ),
  3 =>
  array (
    'file' => '/home/ler/serendipity/serendipity_admin.php',
    'line' => 28,
    'function' => 'serendipity_is_iframe',
    'args' =>
    array (
    ),
  ),
)
INSERT INTO serendipity_entrycat (entryid, categoryid) VALUES (, 1)
Your entry has been saved

Code: Select all

function &serendipity_db_query($sql, $single = false, $result_type = "both", $reportErr = false, $assocKey = false, $assocVal = false, $expectError = false) {
    global $serendipity;
    static $type_map = array(
                         'assoc' => PGSQL_ASSOC,
                         'num'   => PGSQL_NUM,
                         'both'  => PGSQL_BOTH
    );

    /* INSERT THIS: */
    $fp = fopen('pgsql.log', 'a');
    fwrite($fp, '[' . date('d.m.Y H:i') . '] - [' . $_SERVER['REQUEST_URI'] . ']' . "\n");
    fwrite($fp, $sql . "\n\n");
    fclose($fp);
    /* END OF INSERT */

    if (!$expectError && ($reportErr || !$serendipity['production'])) {
        $serendipity['dbLastResult'] = pg_query($serendipity['dbConn'], $sql);
    } else {
        $serendipity['dbLastResult'] = @pg_query($serendipity['dbConn'], $sql);
    }

Code: Select all

INSERT INTO serendipity_entries (title,timestamp,body,extended,isdraft,allow_comments,moderate_comments,exflag,last_modified,comments,author,authorid) values ('test entry', '1108551257', 'to get log for dev', '', 'false', 'true', 'false', '0', '1108551286', '0', 'LER', '1')

Code: Select all

$ psql serendipity 
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

serendipity=# INSERT INTO serendipity_entries (title,timestamp,body,extended,is
draft,allow_comments,moderate_comments,exflag,last_modified,comments,author,aut
horid) values ('test entry', '1108551257', 'to get log for dev', '', 'false', '
true', 'false', '0', '1108551286', '0', 'LER', '1')
serendipity-# ;
INSERT 0 1
serendipity=# 

Code: Select all

SET default_with_oids = true;