Radicore Forum: Bug Reports » New Hosting Account Bug

Home » RADICORE development » Bug Reports » New Hosting Account Bug

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New Hosting Account Bug [message #2196]

Thu, 09 July 2009 07:40

gpatti
Messages: 287
Registered: August 2008

Senior Member

I've noticed that since the latest upgrade creating a hosting account now sets the rdcaccount_id to the value 1 when creating a new account.

Report message to a moderator

Re: New Hosting Account Bug [message #2197 is a reply to message #2196]

Thu, 09 July 2009 09:16

AJM
Messages: 2386
Registered: April 2006
Location: Surrey, UK

Senior Member

Whoops!

Somehow the menu-data.sql script was built without the following entry:

REPLACE INTO `mnu_account` (`rdcaccount_id`, `account_name`, `rdcversion`, `created_date`, `created_user`, `revised_date`, `revised_user`) 
VALUES(1, 'Shared Account', 1, '2007-09-13 11:41:52', 'AJM', NULL, NULL);

This should create the 'shared' account with the id of 1, with all new records having a id greater than 1.

Empty your version of mnu_account, run this sql statement to create the first record, then you can create any new accounts.

I shall update my sql scripts for the next release.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: New Hosting Account Bug [message #2198 is a reply to message #2196]

Thu, 09 July 2009 11:32

gpatti
Messages: 287
Registered: August 2008

Senior Member

This doesn't seem to be the cause of the problem.

Having done that, when I try to add a new account I get the message

Quote:

[rdcaccount_id] A record already exists with this ID.

This suggests that the system is always tring to with rdcaccount_id = 1.

Graham

Report message to a moderator

Re: New Hosting Account Bug [message #2199 is a reply to message #2198]

Thu, 09 July 2009 12:59

AJM
Messages: 2386
Registered: April 2006
Location: Surrey, UK

Senior Member

I don't know where that bug came from, but here's the fix.

Attachment: std.table.class.zip
(Size: 48.39KB, Downloaded 1814 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: New Hosting Account Bug [message #2200 is a reply to message #2196]

Thu, 09 July 2009 14:27

gpatti
Messages: 287
Registered: August 2008

Senior Member

Well...
That fixes the problem of being able to create a new hosting account. However, I'm afraid I've discovered another problem now:
I created a new account to test the fix, and find that now it cannot be deleted. The delete dialog runs ok, but on pressing submit you are returned to the list screen and the account has not been deleted.

I think these bugs were introduced a couple of versions ago actually. I found a backup of std.table.class.inc dated April, and the code in this area is slightly different.

Graham

Report message to a moderator