Forums | Mahara Community

Support /
New Registered User Can Not Open 'View Profile Page' and 'Edit Profile Page'


anonymous profile picture
Account deleted
Posts: 23

27 March 2009, 1:23

Hi,

I have another problem with my Mahara 1.1.1. When new registered user login, they can not use 'Edit Profile Page' and 'View Profile Page' menu. There is an error like this:

Mahara System: Site unavailable

A nonrecoverable error occured. This probably means you have encountered a bug in the system
 
 
When I look inside table 'View' in database there is an entry for 'Profile view' for this new member but with incomplete data (some field still NULL). You can see the example below:
 

id Descending title description owner ownerformat group institution startdate stopdate ctime mtime atime submittedto numcolumns layout template copynewuser type
      1234567978   NULL NULL NULL NULL NULL NULL NULL 2009-03-27 11:52:34 2009-03-27 11:52:34 2009-03-27 11:52:34 NULL 0 NULL 0 0  
 
This similar entry will be built again and again everytime user click the both menu. I think Mahara System can create the view id for new user, but can not insert the data to database. How this problem solved? 
 
Oh yeah, there is the error log server, when user click both menu:
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] [WAR] d7 (C:\\xampp\\htdocs\\eportfolio\\lib\\view.php:156) View::create_from_template: Attempting to create a View from another View that is not marked as a template, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * View::create_from_template(array(size 3), false, "3847") at C:\\xampp\\htdocs\\eportfolio\\auth\\user.php:425, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * User->install_profile_view() at C:\\xampp\\htdocs\\eportfolio\\auth\\user.php:403, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * User->get_profile_view() at C:\\xampp\\htdocs\\eportfolio\\user\\view.php:56, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] , referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] [WAR] d7 (C:\\xampp\\htdocs\\eportfolio\\function.php:313) bcdiv() [function.bcdiv]: Division by zero, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * log_message("bcdiv() [function.bcdiv]: Division by zero", 8, true, true, "C:\\xampp\\htdocs\\eportfolio\\function.php", 313) at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:378, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * error(2, "bcdiv() [<a href='function.bcdiv'>function.bcdiv</...", "C:\\xampp\\htdocs\\eportfolio\\function.php", 313, array(size 7)) at Unknown:0, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * bcdiv("0", "", 2) at C:\\xampp\\htdocs\\eportfolio\\function.php:313, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * calcSimilarityBetweenExpert("3847") at C:\\xampp\\htdocs\\eportfolio\\lib\\mahara.php:1899, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * relatedpeople_sideblock() at C:\\xampp\\htdocs\\eportfolio\\lib\\web.php:449, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * smarty() at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:501, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * MaharaException->handle_exception() at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:404, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * exception(object(SystemException)) at Unknown:0, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] , referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] [WAR] d7 (C:\\xampp\\htdocs\\eportfolio\\function.php:313) bcdiv() [function.bcdiv]: Division by zero, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * log_message("bcdiv() [function.bcdiv]: Division by zero", 8, true, true, "C:\\xampp\\htdocs\\eportfolio\\function.php", 313) at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:378, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * error(2, "bcdiv() [<a href='function.bcdiv'>function.bcdiv</...", "C:\\xampp\\htdocs\\eportfolio\\function.php", 313, array(size 8)) at Unknown:0, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * bcdiv("0", "", 2) at C:\\xampp\\htdocs\\eportfolio\\function.php:313, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * calcSimilarityBetweenExpert("3847") at C:\\xampp\\htdocs\\eportfolio\\lib\\mahara.php:1899, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * relatedpeople_sideblock() at C:\\xampp\\htdocs\\eportfolio\\lib\\web.php:449, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * smarty() at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:501, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * MaharaException->handle_exception() at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:404, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * exception(object(SystemException)) at Unknown:0, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] , referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] [WAR] d7 (C:\\xampp\\htdocs\\eportfolio\\function.php:313) bcdiv() [function.bcdiv]: Division by zero, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1] Call stack (most recent first):, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * log_message("bcdiv() [function.bcdiv]: Division by zero", 8, true, true, "C:\\xampp\\htdocs\\eportfolio\\function.php", 313) at C:\\xampp\\htdocs\\eportfolio\\lib\\errors.php:378, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * error(2, "bcdiv() [<a href='function.bcdiv'>function.bcdiv</...", "C:\\xampp\\htdocs\\eportfolio\\function.php", 313, array(size 8)) at Unknown:0, referer: http://localhost/eportfolio/artefact/internal/
[Fri Mar 27 11:52:34 2009] [error] [client 127.0.0.1]   * bcdiv("0", "", 2) at C:\\xampp\\htdocs\\eportfolio\\function.php:313, referer: http://localhost/eportfolio/artefact/internal/
 

 

anonymous profile picture
Account deleted
Posts: 23

27 March 2009, 23:42

I want to add some other information about my problem above. This error appear since I upgraded my mahara from Beta 3 version to RC1 version. When I use database from Beta 3 version, my problem disappear.

The problem is my database consists a lot of new information since Beta 3 version. So I can not downgrade  my database to older version from my backup. 

Is it possible to downgrade mahara database to older version (beta3 version)? Or maybe you have other idea?

anonymous profile picture
Account deleted
Posts: 808

29 March 2009, 16:53

Hi Raymond,

We aren't planning to fix upgrades from those beta versions; they were not intended to be used with production data.

If your database has become inconsistent then the only real option is to read through the php code in htdocs/lib/db/upgrade.php and work out which upgrades have been run, and which haven't, and then try to bring it back into a consistent state using a combination of manual database hacks and repeating the upgrade.

Also, you should use 1.1.2 rather than 1.1.1.  1.1.2 fixed a problem in that profile view upgrade you are having problems with (for MySQL).

Richard.

anonymous profile picture
Account deleted
Posts: 808

29 March 2009, 17:03

Oops I should also mention:

When users hit the "profile view" page mahara tries to create a profile view for them if they don't already have one.  It does this by copying from a "system profile view".  So the first thing you should do is check that your view table has a profile view, owned by a user called 'root' (user id=0)  and you should also make sure that this view record has a 1 in the 'template' column.

anonymous profile picture
Account deleted
Posts: 23

29 March 2009, 23:18

Yes, I have checked my table and I can make sure in table 'view' there is a profile view entry with owner=0. And in table 'usr', I also make sure that there is an entry for userid=0 with username=root. But I still have that problems.... What's the problem?
anonymous profile picture
Account deleted
Posts: 23

30 March 2009, 1:44

The view id in table 'view' can be created by system. But data for some fields was missing (become NULL). You can look example in my earlier post. And the error from apache log tell me about this:

 [Fri Mar 20 13:54:31 2009] [error] [client 127.0.0.1] [WAR] 70 (C:\\xampp\\htdocs\\eportfolio\\lib\\view.php:156) View::create_from_template: Attempting to create a View from another View that is not marked as a template, referer: http://localhost/eportfolio/artefact/internal/

what's problem?

anonymous profile picture
Account deleted
Posts: 23

30 March 2009, 3:01

Sorry, this problem was solved.

It because my view table contain 2 record with the same owner = 0. So, the query can not pick the view ID.

Special thanks for Richard Mansfield for your help...

 

7 results