-hi, I'm using Drupal 4.7.2 and I cannot manage to get Pontamail working. When trying to add a ne

query: INSERT INTO pontomail_servers (uid, server_name, server_address, server_port, server_type, user, password, secure, con_ssl, no_tls, validate_cert) VALUES(1, 'grupogid', 'srv3-imap.corecluster.net', '143', 'IMAP', 'informatico@ateneagrupogid.org', 'infor-gid', '0', '0', '0', '0')
error:

It doesn't state the error and the programa execution stops there.

In any case it seems that afterwords Pontomail works sort of ok, I mean I can see the new email received under that account, but Drupal keeps issuing warning messages like this one everytime I access to Pontomail via the Mail menu entry:

* user warning: Unknown column 'server_ip' in 'field list' query: UPDATE pontomail_servers SET server_ip = '62.214.98.112' WHERE sid = 1 in /mounted-storage/home24b/sub002/sc22557-FYHK/enredos/includes/database.mysql.inc on line 120.

How can I get rid off these warnings?

In any case Pontomail looks fantastic. Thanks

Comments

sime’s picture

sime
any/any
Location Melbourne
commented

For some reason update 3 is not working in pontomail.install. I looked in the system table and the schema version is 3, that suggests it executed...???

I don't really know enough about install files to understand why. I just manually ran the sql in update3:
ALTER TABLE {pontomail_servers} ADD COLUMN server_ip varchar(15)

Souvent22’s picture

Souvent22 commented

Hm. Interesting. I shall check the update file.

Jodoar’s picture

Jodoar commented

Hi
I tried the cvs version of Pontomail on my 4.7.3 installation of drupal to see if some other Pontomail problem was solved in that version, and I hit another interesting problem

user warning: Unknown column 'server_ip' in 'field list' query: UPDATE pontomail_servers SET server_ip = '212.78.206.51' WHERE sid = 1

and looking into pontomail.mysql I can see that the refered column is never created, clearly the code or sql script need to be fixed, however I don't know how to so I'm just submitting my findings. I will manually add the column as documented in this thread.
/Jodoar

Souvent22’s picture

Souvent22 commented
Assigned: Unassigned » Souvent22
Priority: Normal » Critical
Status: Active » Fixed

Fixed issue. I didn't have update_3 in the main DDL file for those that doing a fresh install. Aplogies.

Commited/Patched

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)