getting the following error when installing:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "," at character 532 in /var/www/goddessofwings.com/htdocs/drupal/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO bueditor_buttons (bid, eid, title, content, icon, accesskey, weight) VALUES (1, 1, 'Insert/edit image', 'php: $imce_url = function_exists(\'imce_menu\') && user_access(\'access imce\') ? url(\'imce/browse\') : \'\'; $L = drupal_to_js(array(\'title\'=>t(\'Insert/edit image\'), \'url\'=>t(\'Image URL\'), \'w\'=>t(\'Width\'), \'h\'=>t(\'Height\'), \'alt\'=>t(\'Alternative text\'), \'ok\'=>t(\'OK\'), \'brw\'=>t(\'Browse\'))); return "js: eDefFileDialog(\'image\', $L, \'$imce_url\');";', 'image.png', 'M', '-10'), (2, 1, 'Insert/edit link', 'php: $imce_url = function_exists(\'imce_menu\') && user_access(\'access imce\') ? url(\'imce/browse\') : \'\'; $L = drupal_to_js(array(\'title\'=>t(\'Insert/edit link\'), \'url\'=>t(\'Link href\'), \'tt\'=>t(\'Title text\'), \'ok\'=>t(\'OK\'), \'brw\'=>t(\'Browse\'))); return "js: eDefFileDialog(\'link\', $L, \'$imce_url\');";', 'link.png', 'L', '-10'), (3, 1, 'Bold', '%TEXT%', 'bold.png', 'B', '-9'), (4, 1, 'Italic', '%TEXT%', 'italic.png', 'I', '-9'), (5, 1, 'Ordered list. Converts selected lines to a numbered list.', 'js: eDefSelProcessLines(\'

    \\n\', \'
  1. \', \'
  2. \', \'\\n

\');', 'ol.png', 'O', '-8'), (6, 1, 'Unordered list. Converts selected lines to a bulleted list.', 'js: eDefSelProcessLines(\'

    \\n\', \'
  • \', \'
  • \', \'\\n

\');', 'ul.png', 'U', '-8'), (7, 1, 'Teaser break', '

', 'teaserbr.png', 'T', '0'), (8, 1, 'Preview selection or whole content.', 'js: eDefPreview();', 'preview.png', 'P', '9'), (9, 1, 'Get help on button functionality.', 'js: eDefHelp();', 'help.png', 'H', '10'); in /var/www/goddessofwings.com/htdocs/drupal/includes/database.pgsql.inc on line 144.

postgresql does not support INSERT INTO ... VALUES (..,..,..,.), (..,..,..) see http://www.postgresql.org/docs/8.1/static/sql-insert.html
seperate inserts for each of the buttons should work just fine. (updated install file attached) - seems to work ok with that but haven't tested everything yet. will add more info if i run into other problems with this

CommentFileSizeAuthor
bueditor.install.txt5.11 KBLordVan

Comments

LordVan’s picture

one thing to note is though that it did nto create the default buttons for me anyway. it did create the default editor however. - it might have just been a glitch on my system or soemthing but thought it is worth mentioning it ..
since i didn't have time i just inserted those rows from the install file manually (after removing the {} around the table names - how does this work from the php file anyway? does db_query stript hem off for pgsql ?)

LordVan’s picture

never mind last comment. tried it on another site and it worked just fine with the script i attached.

ufku’s picture

hmm.. i think multiple insertions was introduced with 8.2 that i used for testing.
i've tested your patch and will soon commit it to cvs.

thank you for your contribution.

ufku’s picture

Status: Active » Closed (fixed)