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\', \'
- \', \'
\', \'\\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
| Comment | File | Size | Author |
|---|---|---|---|
| bueditor.install.txt | 5.11 KB | LordVan |
Comments
Comment #1
LordVan commentedone 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 ?)
Comment #2
LordVan commentednever mind last comment. tried it on another site and it worked just fine with the script i attached.
Comment #3
ufku commentedhmm.. 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.
Comment #4
ufku commented