Ï just ask this because I installed E-Xoops 1.05 in a server using PHP 5 and it simply doesn't works. So I am wondering if eXV2 is able to run under PHP5 and MySQL 5
And I talked about MySQL too, because I am having an small issue with the forums block in old E-Xoops. If I select the option to show the block under MySQL 5 (not in 4 version), I just get this error:
Code:ERROR
Error Number: 2 [Warning]
Error message: mysql_num_rows(): supplied argument is not a valid MySQL result resource
To file: /home/pedro/public_html/class/database/mysql.php
To line 106
This error is generated by the code in newbb/blocks/newbb_new.php generating this SELECT:
Code:SELECT p.uid, p.topic_id, p.forum_id, p.post_time, p.icon, t.topic_title, t.topic_views, t.topic_replies, f.forum_name FROM e_xoops_bb_posts p, e_xoops_bb_forums f INNER JOIN e_xoops_bb_topics t ON t.topic_last_post_id = p.post_id LEFT JOIN e_xoops_bb_forum_access a ON a.user_id IN(2) WHERE f.forum_id = t.forum_id AND ((f.forum_type = 0) OR (a.forum_id = f.forum_id)) GROUP BY p.topic_id ORDER BY t.topic_time DESC LIMIT 0,5
This same consult works great under MySQL 4.0 but using MySQL 5.0 I got the error in mysql_num_rows function giving 0 as result.
So I wonder if this query is not full compatible with the last MySQL 5.0 version
Any ideas?
luis aka raska
[ Edited by raska on 2007/6/28 1:49 ] |
PHP 5 and MySQL 5 compatible?
My hoster only have 3 or 4 machines running php4 yet, so I imagine he will soon migrate all to PHP 5 and then my old E-Xoops will got fucked 
Database: UML Sheet topic..
