on a new installation I get two warnings if choice the modules about >administer >modules

first:
"warning: %v%v() [function.%v]: Query failed: FEHLER: Wert zu lang für Typ character varying(255) in /srv/www/htdocs/drupal/includes/database.pgsql.inc on line 84."
secend:
about line 106 some of
warning insert
There was a whole insert sql-Statment, but i cant remember

Comments

tulli’s picture

tulli commented
Assigned: Unassigned » tulli

the warnings are exactly:

* warning: %v%v() [function.%v]: Query failed: FEHLER: Wert zu lang für Typ character varying(255) in /srv/www/htdocs/drupal-cvs/includes/database.pgsql.inc on line 84.
* user warning: query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('worldpay', 'WorldPay(tm) payment integration for the ecommerce.module. After enabling this module, click through to the Worldpay settings page to connect it to your worldpay(tm) account and customise the various settings.', 'module', 'modules/ecommerce/contrib/worldpay/worldpay.module', 0, 0, 0) in /srv/www/htdocs/drupal-cvs/includes/database.pgsql.inc on line 103.

tulli’s picture

tulli commented

It is a generaly problem of design.
currently it is possible to write a long describtion string in the .module file but the db_Coloumn-size is only 256
if are used variables the strang can expand and so it is all but impossible to chek the size previously

--------- sorry for my BAD English -----------------

zoo33’s picture

zoo33 commented
Priority: Normal » Critical

Confirmed:

Warning: ERROR: value too long for type character varying(255) query: system_modules UPDATE system SET description = 'WorldPay(tm) payment integration for the ecommerce.module. After enabling this module, click through to the <a href="/etcbild/sv/admin/store/settings/worldpay">Worldpay settings page</a> to connect it to your worldpay(tm) account and customise the various settings.', name = 'worldpay', bootstrap = 0, filename = 'modules/contrib/ecommerce/contrib/worldpay/worldpay.module' WHERE filename = 'modules/contrib/ecommerce/contrib/worldpay/worldpay.module'

I suggest we shorten worldpay's description.

Setting to critical as the warnings are displayed regardless of whether you actually use worldpay or not.

(Postgresql, Drupal 4.7.2, ecommerce 4.7 from july 13.)

tulli’s picture

tulli commented

I have solved the problem by prune the description string in worldpay.module

but i got other error by using postgres and ecommerce

the shipping modul produced this error

    * warning: %v%v() [function.%v]: Query failed: FEHLER: Relation »ec_shipping_shipfrom« existiert nicht in /srv/www/htdocs/drupal-cvs/includes/database.pgsql.inc on line 84.
    * user warning: query: SELECT COUNT(*) FROM ec_shipping_shipfrom in /srv/www/htdocs/drupal-cvs/includes/database.pgsql.inc on line 103.
    * warning: %v%v() [function.%v]: Query failed: FEHLER: Relation »ec_shipping_shipfrom« existiert nicht in /srv/www/htdocs/drupal-cvs/includes/database.pgsql.inc on line 84.
    * user warning: query: SELECT * FROM ec_shipping_shipfrom ORDER BY title ASC LIMIT 25 OFFSET 0 in /srv/www/htdocs/drupal-cvs/includes/database.pgsql.inc on line 103.

the bug is ther isnt, thes tabels because the shipping.install have IMHO not corectly create statement for postgres
currently im testing this
I'll post my results next week here

sammys’s picture

sammys commented
Component: other » -- other --
Status: Active » Closed (fixed)

This issue has been fixed. Possibly in another issue thread. Behaviour reported is no longer exhibited in the system.

--
Sammy Spets
Synerger
http://synerger.com