How to set up Webmail Plus? Is there a documentation anywhere??
| Project: | Webmail Plus |
| Version: | 6.x-1.3 |
| Component: | Documentation |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Hi all,
for two days I have been trying to set up webmai plus on my testserver. I am getting nowhere. The only thing that I get, is the following message (no matter what I use as a uid):
"user warning: Unknown column 'variable' in 'field list' query: SELECT `variable`,`value` FROM webmail_plus_user_preferences WHERE uid=1 in /sites/all/modules/webmail_plus/webmail_plus.module on line 1032."
What's more the system asks for a password and when I try to insert one it tells me that I may not change my password - which I did not do in the first place.
This is very frustrating!
Is there a documentation anywhere (the one on the project page does not load any page)? My provider does not know the webmail plus interface and can not help me. Here I can't seem to find any documentation.
Can anyone help?
Paul.
#1
Here are some feedback from the Webmail Plus module.
* user warning: Unknown column 'variable' in 'field list' query: SELECT `variable`,`value` FROM webmail_plus_user_preferences WHERE uid=1 in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 1032.
* user warning: Table 'zooot.webmail_plus_user_threads' doesn't exist query: SELECT COUNT(*) FROM webmail_plus_user_threads WHERE uid=1 AND folder='' in */sites/all/modules/webmail_plus/webmail_plus.view_threads.inc on line 193.
* user warning: Table 'zooot.webmail_plus_user_threads' doesn't exist query: SELECT * FROM webmail_plus_user_threads WHERE uid=1 AND folder='' ORDER BY `date` DESC LIMIT 0, 50 in */sites/all/modules/webmail_plus/webmail_plus.view_threads.inc on line 193.
* user warning: Unknown column 'variable' in 'field list' query: SELECT `variable`,`value` FROM webmail_plus_user_preferences WHERE uid=1 in */sites/all/modules/webmail_plus/webmail_plus.module on line 1032.
* user warning: Table 'zooot.webmail_plus_user_threads' doesn't exist query: SELECT COUNT(*) FROM webmail_plus_user_threads WHERE uid=1 AND folder='' in */sites/all/modules/webmail_plus/webmail_plus.view_threads.inc on line 193.
* user warning: Table 'zooot.webmail_plus_user_threads' doesn't exist query: SELECT * FROM webmail_plus_user_threads WHERE uid=1 AND folder='' ORDER BY `date` DESC LIMIT 0, 50 in */sites/all/modules/webmail_plus/webmail_plus.view_threads.inc on line 193.
#2
The error festival continues: When trying to save the webmail plus preferences in my account settings I get the following errors:
* user warning: Unknown column 'variable' in 'field list' query: SELECT `variable`,`value` FROM webmail_plus_user_preferences WHERE uid=1 in */sites/all/modules/webmail_plus/webmail_plus.module on line 1032.
* user warning: Unknown column 'variable' in 'where clause' query: SELECT COUNT(*) AS matches FROM
webmail_plus_user_preferences WHERE uid=1 AND variable='conversations_per_page' LIMIT 1 in */sites/all/modules/webmail_plus/webmail_plus.module on line 1080.
* user warning: Unknown column 'variable' in 'field list' query: INSERT INTO webmail_plus_user_preferences(uid, `variable`, `value`) VALUES(1, 'conversations_per_page', '25') in */sites/all/modules/webmail_plus/webmail_plus.module on line 1086.
* user warning: Unknown column 'variable' in 'where clause' query: SELECT COUNT(*) AS matches FROM webmail_plus_user_preferences WHERE uid=1 AND variable='thread_messages' LIMIT 1 in */sites/all/modules/webmail_plus/webmail_plus.module on line 1080.
* user warning: Unknown column 'variable' in 'field list' query: INSERT INTO webmail_plus_user_preferences(uid, `variable`, `value`) VALUES(1, 'thread_messages', '1') in */sites/all/modules/webmail_plus/webmail_plus.module on line 1086.
* user warning: Unknown column 'variable' in 'field list' query: SELECT `variable`,`value` FROM webmail_plus_user_preferences WHERE uid=1 in */sites/all/modules/webmail_plus/webmail_plus.module on line 1032.
Is this an error in my setup or is there still a bug in the module? A hint would be nice. And if it is an error in my setup could you point out where I went wrong or at least point to a documentation? The link on the project page leads to a 404 error.
Thank you for your patience and this wonderful (once it works) module.
Paul.
#3
If it helps any: this is what it says around line 1032 in the webmail_plus.module:
/**
* returns personal preferences for the user
*
* @param unknown_type $uid
* @return unknown
*/
function webmail_plus_get_user_preferences($uid="") {
global $user;
if($user->uid==0) return false;
if ($uid=="") $uid=$user->uid;
$preferences = db_query('SELECT `variable`,`value` FROM {webmail_plus_user_preferences} WHERE uid=%d', $uid);
while($preference = db_fetch_object($preferences)) {
$rs[$preference->variable]=$preference->value;
}
return webmail_array_to_object($rs);
}
#4
Try completly uninstalling the module ( via admin/build/modules/uninstall ) and then reinstall it. Apparently the DB-schema has been changed without using the update-funktions in the .install-file.
I still can't get it to work though, but at least the error is gone :)
#5
Cool, thank you.
Did what you said. De-Activated and De-installed all the modules (AES/MAIL_API/WEBMAIL_PLUS) and then reinstalled them in the following order:
1. AES
2. MAIL API
3. IMAP-WU API
4. WEBMAIL PLUS
And all the pesky error-messages disappeared. Only just before I tried to configure Webmail Plus I had two last error messages:
mcrypt_generic() [function.mcrypt-generic]: An empty string was passed in /media/disk/www/zooot/sites/all/modules/aes/aes.module on line 494.
mcrypt_generic() [function.mcrypt-generic]: An empty string was passed in /media/disk/www/zooot/sites/all/modules/aes/aes.module on line 494.
There are two users on my test server. Does this have something to do with the users' passwords?
Anyway, to cut a log story short. This time I get no more errors but I also did not get the menue item "webmail plus" and of course the whole module does not work. It does not send and it does not receive.
I fear this will be a long way until this works - esecially with the rich documentation.
Anyway thanks for helping me get rif of the errors.
Paul.
#6
I tried webmail plus, AES and Mail API on one of my live servers today (just to find out if there is a problem with my test server) and the result was the same.
Webmail Plus could not connect to the mail server at AnHosting. And it did not create any menue items again. The only place I could access any webmail functions are at "my account" and of course in the admin section of the three modules.
I found one other error message though. When clicking on "filters" under "webmail plus" in "my account" I get the following message:
Unknown column 'id' in 'order clause' query: SELECT * FROM webmail_plus_user_filters WHERE uid=1 ORDER BY id DESC LIMIT 0, 50 in */sites/all/modules/webmail_plus/webmail_plus.user_preferences_filters.inc on line 60.
Is there anyone out there who acctually got this module to work?
#7
Interesting: the new version still does not create any menu links. It still does not conect to any mail server. But it comes with some new messages for the admin:
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 51.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 52.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 53.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 54.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 55.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 56.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 57.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 58.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 59.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 60.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 61.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 62.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 63.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 64.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 65.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 66.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 67.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 68.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 69.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 70.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 71.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 72.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 73.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 74.
* warning: Attempt to assign property of non-object in /media/disk/www/zooot/sites/all/modules/webmail_plus/webmail_plus.module on line 75.
Paul.
#8
I can't get it working, too. Folders:No folders found. Email: This function is not available. I think, I entered the Serverdata correctly.
I would be thankfull for a tutotial!
#9
I would lover to know how to set this up.
I've tried alot and is in the same situation as witzel it appears.
#10
Using phpmyadmin, I added id to the following table and added id to the primary key.
CREATE TABLE IF NOT EXISTS `webmail_plus_user_filters` (`uid` int(11) NOT NULL,
`id` int(10) unsigned NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`active` int(11) NOT NULL default '1',
`from` varchar(128) NOT NULL default '',
`to` varchar(128) NOT NULL default '',
`cc` varchar(128) NOT NULL default '',
`subject` varchar(128) NOT NULL default '',
`has_words` int(11) default NULL,
`doesnt_have_words` int(11) default NULL,
`has_attachments` int(11) default NULL,
`mark_as_read` int(11) default NULL,
`star_it` int(11) default NULL,
`apply_tag` varchar(128) default '',
`forward` varchar(128) default '',
`forward_emails` varchar(128) default '',
`delete` int(11) NOT NULL,
PRIMARY KEY (`uid`,`id`)
) ENGINE=MyISAM;
#11
A start on documentation: http://drupal.org/node/369604
#12
...I've fully read the documentation.
I have followed all of the directions accurately, but the module doesn't work for me either.
I get the same type of error as described is the previous comments (above).
#13
This was very usefull Thanks wu_trax!!