Forums | Mahara Community
Support
/
New Registered User Can Not Open 'View Profile Page' and 'Edit Profile Page'
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
id  | 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 | |||||
[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/
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?
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.
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.
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?
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?
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...