Itens ativos
Pesquisa
Login do usuário
Assine o RSS do Drupal-BR
E-commerce + PostgreSQL...
Salve a todos...
Instalei o Modulo, e logo após salvar as alterações fui bombardeado com:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" LINE 2: ecid INTEGER unsigned NOT NULL, ^ in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE TABLE ec_customer ( ecid INTEGER unsigned NOT NULL, type VARCHAR(32) NOT NULL, exid VARCHAR(32) NOT NULL, token VARCHAR(32) NOT NULL, PRIMARY KEY (ecid) ) in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "ec_customer" does not exist in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: CREATE UNIQUE INDEX ec_customer_type ON ec_customer (type, exid) in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "numrefs" violates not-null constraint in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO ec_mail (mid, type, name, subject, body) VALUES (1, 'store customer invoice', 'Default customer invoice', 'Your [site-name] order', 'Dear [txn-billing-firstname] [txn-billing-lastname], Thanks for your recent purchase from [site-name]. This message includes important information about your order. Please take a moment to read it closely, and be sure to save a copy for future reference. ******************************** Billing and Shipping Information ******************************** [txn-bill-plus-ship] ******************************** Order Details ******************************** [txn-items] Questions about your order? Please contact us at [site-mail] ******************************** Shipping Instructions ******************************** We will notify you by email as soon as your order ships. Thanks for shopping at [site-name]. We hope to hear from you again real soon! [site-url]') in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "numrefs" violates not-null constraint in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO ec_mail (mid, type, name, subject, body) VALUES (2, 'store processing error', 'Default processing error', 'Purchase problem, [site-name]', 'Dear Customer It seems there was a problem while processing your order ([txn-id]). Please contact us at [site-mail] for further details. Regards, [site-name] team [site-url]') in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "numrefs" violates not-null constraint in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO ec_mail (mid, type, name, subject, body) VALUES (3, 'store cancel transaction', 'Default order cancellation notice', 'Your [site-name] order has been canceled', 'Dear [txn-billing-firstname] [txn-billing-lastname], Your order ([txn-id]) has been canceled. Please contact us at [site-mail] for further details. Regards, [site-name] team [site-url]') in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "numrefs" violates not-null constraint in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO ec_mail (mid, type, name, subject, body) VALUES (4, 'store ask customer', 'Default query to customer', 'Questions regarding your order from [site-name]', 'Dear [txn-billing-firstname] [txn-billing-lastname], We have some questions regarding your order from [site-name]. Regards, [site-name] team [site-url]') in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "ec_receipt_types" does not exist in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT * FROM ec_receipt_types in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "ec_receipt_types" does not exist in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT * FROM ec_receipt_types in /usr/sites/www/quadros.netforyou.org/includes/database.pgsql.inc on line 144.
Isso tudo me parece problema de implementação no SQL... como se o e-commerce não fosse compativel com postgre. Só que não achei informação nenhuma sobre se é compativel, ou não.
As paginas de configuração dos modulos não abrem...
Alguma dica ou sugestão?
Desde já agradeço
Leon
- Por favor, se logue ou se registre para poder enviar comentários
- 255 leituras




É exatamente o que
É exatamente o que parece...
o brmassa poderia dar mais informações... ele é um dos líderes do projeto...
flw!
--
Pedro Faria de Miranda Pinto
http://www.eusouopedro.com
http://www.phpavancado.net
Bate Papo sobre Drupal? irc://irc.freenode.net/drupal-br
eC issues list
Leon,
parace ser erro das nossas intruções em SQL. Seu vou revisar todas as instruções, em especial as de instalação, pois o Gordon (o outro líder do projeto), não manja muito de SQL portável, que funciona para MySQL e PostgreSQL.
na verdade, imagino que vários destes erros já tenham sido consertados.
De qualquer modo, sugiro que tu use a lista de casos (issues list) do próprio drupal e relate seu erro lá.
abraço,
massa