small issue with omcollabBookmarks extension

[Taikonaut]

Hi everybody,

at first, thanks for this great piece of software!:)

After installation, I'm receiving this error message:

Code: Select all

Warning: DOMDocument::loadXML() [function.DOMDocument-loadXML]: Extra content at the end of the document in Entity, line: 2 in .../wiki/extensions/omCollabBookmarks/omCollabBookmarks.php on line 131

Could somebody show me how to get rid of this?

Thanks a lot!
Taiko

[Sean.mcclowry]

Hi Taiko - thanks for posting, we will take a look. I've added it to here:
http://waterloo.openmethodology.org/tra ... ticket/103

Are you on the network when you see that and are you using the latest version of omCollab?

Thanks
Sean

[Taikonaut]

Thanks Sean!

I'm using version 1.009.6.! I'll install the newest version and keep you informed.

Regards,
Taiko

[Taikonaut]

Same issue in last version!

Any hint?

Regards,
taiko

warning message as mentioned in the opening posting

screenshot.png (37.6 KiB) Viewed 437 times

*edit: Now it is line 132

[Richard]

Hi Taiko,
Would you please access the url http://yourhost/bookmarks/api/posts_public.php?term=omcollab after the installation is finished, And give us a full screen snapshot.

thanks,
Richard

[Taikonaut]

Hi, thanks for your efforts!

Here is the message you asked for:

Code: Select all

Fatal error: SQL ERROR [ mysql ]

Unknown column 'B.bHash' in 'where clause'

CALLING PAGE

/OmCollab2/bookmarks/api/posts_public.php&term=omcollab

SQL

SELECT DISTINCT B.*, U. username, ( ( SELECT ( IF(AVG(rvalue) IS NULL, 0, AVG(rvalue)) ) * 10 FROM om2_ratings r_0 WHERE r_0.rhash = B.bHash AND r_0.rDateRated < '2009-05-20 18:52:40' AND r_0.rDateRated > '2009-05-13 18:52:40' )+( SELECT ( IF(AVG(rvalue) IS NULL, 0, AVG(rvalue)) ) * 4 FROM om2_ratings r_7 WHERE r_7.rhash = B.bHash AND r_7.rDateRated < '2009-05-13 18:52:40' AND r_7.rDateRated > '2009-04-22 18:52:40' )+( SELECT ( IF(AVG(rvalue) IS NULL, 0, AVG(rvalue)) ) * 2 FROM om2_ratings r_28 WHERE r_28.rhash = B.bHash AND r_28.rDateRated < '2009-04-22 18:52:40' AND r_28.rDateRated > '2008-11-21 18:52:40' ) ) AS popularity FROM om2_users AS U, om2_bookmarks AS B LEFT JOIN om2_tags AS T ON B.bId = T.bId WHERE B.uId = U.uId AND B.bStatus = 0 AND (B.bTitle LIKE "%omcollab%" OR B.bDescriptio in /var/www/OmCollab2/bookmarks/includes/db/mysql.php on line 390

A lot is going wrong here...
after logging in, the following warning occurs:

Code: Select all

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/OmCollab2/wiki/extensions/omCollabSingleSignon.php on line 96

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/OmCollab2/wiki/extensions/omCollabSingleSignon.php on line 119

after an automatic redirect I see this:

Code: Select all

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "UserProfilePage::getProfileCompleteness". MySQL returned error "1054: Unknown column 'up_tv' in 'field list' (localhost)".

Any suggestions? Is my MySQL misconfigured?

Thanks a lot!
Taiko

[Richard]

Hi Taiko,
thanks for your information.
The bHash column of the om2_bookmark doesn't existed, I think that's the primary reason that the XML parsed error comes up in your homepage, you can find the ombookmarks_temp.sql executive file in the _InstallationResources folder, this file recorded sql script executed in process of installing bookmarks module, you can see whether the om2_bookmark table is created properly.

I think you can drop all related databases and reinstall omcollab by using version 1.009.6 of install package, After installation finished, please access url http://yourhost/bookmarks/api/posts_pub ... m=omcollab, if a well-formed XML script is displayed, that means the XML parsed problem is behind you, or please show your screen snapshot, And we can continue to discuss the issue later.

Thanks,
Richard.

[Taikonaut]

Hi again,

thanks for your great and fast support!!

I installed it again and the same errors occured. Then I checked om_bookmarks (as you advised) and it was empty (dunno why), so I inserted the ombookmarks_temp.sql. This repaired bookmarks but leaded to errors in phpbb. This made me reinstall it again, using different databases for each application

Now everything seems to be fine, just the first error in the wiiki persists.

http://localhost/omcollab/bookmarks/api ... m=omcollab is showing this code:

Code: Select all

<posts update="2009-05-21T21:40:43Z" user="unknown user" tag="all" count="2">
<post href="/omcollab/bookmarks/manage.php/129/Example_of_SPAM_bookmark" description="Example of SPAM bookmark" rating="<span style="background:transparent url(/omcollab/common/skins/mike2/images/stars-10x10.gif) repeat scroll left top;width:50px; float:right; height:10px; position:relative; margin-top:-10px; margin-right:13px;"><div  style="background:transparent url(/omcollab/common/skins/mike2/images/stars-10x10.gif) repeat scroll left bottom; overflow:hidden; width: 50px;"><img width="50" height="10" src="/omcollab/common/skins/mike2/images/null.gif"/></div></span>" extended="Occasionally, you will get spammed. Read this bookmarks comments to learn how to manage it." hash="4ff84ed87bfff74f86a7f37d37dce222" tag="<a href='http://localhost/omcollab/bookmarks/tags.php/omcollab examples' target='_blank'>omcollab examples</a>;<a href='http://localhost/omcollab/bookmarks/tags.php/spam spam spam' target='_blank'>spam spam spam</a>" time="2008-07-04"/>
<post href="/omcollab/bookmarks/manage.php/127/MIKE2_0_an_implementation_of_the_omCollab_application_suite" description="MIKE2.0 - an implementation of the omCollab application suite" rating="<span style="background:transparent url(/omcollab/common/skins/mike2/images/stars-10x10.gif) repeat scroll left top;width:50px; float:right; height:10px; position:relative; margin-top:-10px; margin-right:13px;"><div  style="background:transparent url(/omcollab/common/skins/mike2/images/stars-10x10.gif) repeat scroll left bottom; overflow:hidden; width: 50px;"><img width="50" height="10" src="/omcollab/common/skins/mike2/images/null.gif"/></div></span>" extended="This is the first site to use the omCollab application suite" hash="e5e4b3f6980a0c09f60646a258f2954a" tag="<a href='http://localhost/omcollab/bookmarks/tags.php/omcollab examples' target='_blank'>omcollab examples</a>" time="2008-06-12"/>
</posts>

Could you guide me how to proceed to get rid of the warning in mediawiki?

Thanks a lot in advance!
-taiko

*edit*
Registering a new user leads to the following error:

Code: Select all

[phpBB Debug] PHP Notice: in file /var/www/omcollab/wiki/extensions/omCollabSingleSignon.php on line 96: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /var/www/omcollab/wiki/extensions/omCollabSingleSignon.php on line 119: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /var/www/omcollab/wiki/extensions/omCollabSingleSignon.php on line 143: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Return to index page
General Error
SQL ERROR [ mysqli ]

Duplicate entry 'user' for key 2 [1062]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

and to the following error in the wiki (I seem to be logged in as newly created user):

Code: Select all

Database error
From Wiki
Jump to: navigation, search
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "UserProfilePage::getProfileCompleteness". MySQL returned error "1054: Unknown column 'up_tv' in 'field list' (localhost)".

[Sean.mcclowry]

Hi - I just did a fresh install with the latest version and I did find an issue. This is due to some code refactoring that we did in the latest build that did not quite get completed, so it is looking for some missing legacy tables in the social profile component. One patch is required.

If you follow these steps in should work:

1. Download latest zip version of omCollab
2. Create databases as per README
3. Run installer script and input parameters
4. Go into mysql and login into the wiki database and then run this script

Code: Select all

ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_movies text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_books text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_magazines text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_music text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_tv text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_drinks text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_snacks text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_video_games text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_interests text;
ALTER TABLE {omcollab_db_table_prefix}user_profile ADD up_quotes text;

where omcollab_db_table_prefix is the prefix you chose on creation, such as om_

That should would, let us know if it does!

Sean

Other good contacts:
http://mike2.openmethodology.org/w/inde ... iping.wang
http://mike2.openmethodology.org/w/inde ... as.rindler
http://mike2.openmethodology.org/wiki/U ... padopoulos

[Xiping.wang]

Hi ,

Yes, this issue was fixed in version 1.100.2. We will release the zip file soon.