 |
 |
 |
 |
#256679 - 09/07/04 11:25 PM
Error w/ Hivemail 1.3.1
[Re: mdr]
|
Code Monkey
Registered: 06/17/02
Posts: 682
Loc: CA, USA
|
So far I have this mod updating email correctly, but now I can't get new users signed up after upgrading Hivemail to version 1.3.1. <br /> <br />I get this MySQL error in the error log while trying to add an email address for a test user: <br /> <br /> [] Unable to do_query: INSERT INTO .hive_user (userid, username, password, usergroupid, skinid, realname, regdate, lastvisit, cols, birthday, options, replyto, font, timezone, soundid, domain, vbuserid, altemail, aliases) VALUES (NULL, 'alfa164', '81dc9bdb52d04dc20036dbd8313ed055', 2, 1, '', 1094549124, 1094549124, 'a:6:{i:0;s:8:\"priority\";i:1;s:6:\"attach\";i:2;s:4:\"from\";i:3;s:7:\"subject\";i:4;s:8:\"datetime\";i:5;s:4:\"size\";}', '', USER_DEFAULTBITS, 'alfa164@laondalatina.com', 'Verdana|10|Regular|Black|None', '', 26, '@laondalatina.com', 3573, '', 'alfa164') - Unknown column 'vbuserid' in 'field list' [/] <br /> <br />Now I've looked into the .hive_user table in the database and vbuserid field is no longer there. There IS a field called forumuserid. If anyone has any suggestions I would appreciate it. I'm sure it's a very simple fix to make this work with version 1.3.1 of Hivemail, but I can't figure this out. BTW, this error is in the adduser.php script. <br /> <br />****EDIT**** <br />I've solved this by removing vbuserid and replacing it with forumuserid in the ubbthreads_plugin.php file in the hivemail includes folder. I do have a couple other MySQL errors. I'll keep working on this and post the changes that I made for everyone else.
Edited by donJulio (09/08/04 12:03 AM)
_________________________
Too many men. There's too many people making too many problems, and not much love to go around. Can't you see this is the Land of Confusion? <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />
|
|
Top
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#256681 - 09/08/04 09:07 AM
Re: Error w/ Hivemail 1.3.1
[Re: egor]
|
Code Monkey
Registered: 06/17/02
Posts: 682
Loc: CA, USA
|
[]Charles said:<br />yes that was what you were supposed to do in order to fix the error <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> the hivemail team have changed a number of parameters in order to be more open to forum integration and not just vb. [/]<br /><br />Maybe you can provide some insight into this error:<br /><br /> [] Unable to do_query: INSERT INTO .hive_user (userid, username, password, usergroupid, skinid, realname, regdate, lastvisit, cols, birthday, options, replyto, font, timezone, soundid, domain, forumuserid, altemail, aliases) VALUES (NULL, 'test82', '', 2, 1, '', 1094619793, 1094619793, 'a:6:{i:0;s:8:\"priority\";i:1;s:6:\"attach\";i:2;s:4:\"from\";i:3;s:7:\"subject\";i:4;s:8:\"datetime\";i:5;s:4:\"size\";}', '', USER_DEFAULTBITS, 'test82@laondalatina.com', 'Verdana|10|Regular|Black|None', '', 21, '@laondalatina.com', 3589, '', 'test82') - Unknown column 'USER_DEFAULTBITS' in 'field list' [/] <br /><br />What is USER_DEFAULTBITS? That is the only error keeping users from being able to register at the moment <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />
_________________________
Too many men. There's too many people making too many problems, and not much love to go around. Can't you see this is the Land of Confusion? <img src="http://www.ubbdev.com/forum/images/graemlins/confused.gif" alt="" />
|
|
Top
|
|
|
|
 |
 |
 |
 |
|
|