| Re: Buddyfriends or why does this sql statement fail? |
| by jordi_rc on 2007/4/27 13:09:33 Sorry I no longer support this. I left Xoops, I changed to another CMS. It would be nice someone supports this module. Jordi |
| Re: Buddyfriends or why does this sql statement fail? |
| by Truelove on 2007/4/27 11:51:21 I am trying to implement this module. My website is running on: RedHat Linux PHP 5.2.1 MySQL 5.0.37-standard-log Apache 2.0.59 (Unix) Xoops 2.0.16 My problem is this. When I try to add someone as a friend, nothing happens with no (serious) errors. Nothing is inserted in the database. The only error I see, comes from MySQL: PRIMARY and INDEX keys should not both be configured for column `ref` (I translated this, the message could be somewhat different in English) I using the 2.4 alpha download from dev.xoops.org. However it tell me it's version 2.3. Any clues? |
| Re: Buddyfriends or why does this sql statement fail? |
| by jordi_rc on 2006/12/7 6:23:40 Hello I run my own server, I use this configuration: - Xubuntu (=Ubuntu=Debian) Linux - PHP 5 - Xampp as web server - XOOPS 2.0.15 I tested the module in localhost and it works all fine for me. We need to test it in many computers and you all should help to fix the bugs, as I didn't developed the module, just fixed bugs, and I don't have a deep knowledge on how it works. What configuration do you have? Tell please. And please do the following: 1) Remove the module from XOOPS control panel, and install it again from the link I gave in previous message. 2) Look in your XOOPS database and see if you have a table called xoops_buddyfriends. 3) Ensure you have chmod properly all your XOOPS folders. Specially chmod 755 the buddyfriends folder. There is nothing wrong in that the fuid is not posted, because in my installation it is not posted and it works ok. I think maybe the database is not created properly. See please if it exists. Also, I must say that I tested many modules that worked ok for many people and not for me, so there is a million of reasons to a module not working. I must encourage all people to test this module and contribute to make it work on all computers, as this is not stable at all, it seems, or we are losing something. Jordi |
| Re: Buddyfriends or why does this sql statement fail? |
| by jordi_rc on 2006/12/6 7:26:24 Hello Try to download it again, and tell me what happens. I noticed I uploaded a wrong version. http://usuarios.lycos.es/ancientgames/xoops/buddyfriends.zip Jordi. |
| Buddyfriends or why does this sql statement fail? |
| by ChaoticMess on 2006/12/6 4:41:29 Hi, I'm trying to get jordi_rc's patched buddyfriends module to run. See the thread at bottom about his fixed to buddyfriends. I get the '_MF_Problem' message whenever I try to add a buddy to the list. This error code is used only in the code section below. if ($doNot!=1) { $sqlstr ="INSERT INTO ".$xoopsDB->prefix("buddyfriends")." (uid, fuid) VALUES ($myid, $fuid_in)"; $req=mysql_query($sqlstr); if ($req) { # Output some html } else { echo _MF_PROBLEM; } } I echo the sqlstr string right in and html comment after it's built. The string looks like this <!-- INSERT INTO xoops_buddyfriends (uid, fuid) VALUES (2, ) --> Note the empty field for fuid. Obviously the fuid is not being passed by the url called by this http://mysite/modules/buddyfriends/buddy.php?task=ajouter&uid=4 I was hoping someone here is familiar with buddy friends. It looks like a good effort has been made to add this module. This is the thread. Note the zip file is buddyfriends.zip and is listed wrong in the final post. https://xoops.org/modules/newbb/viewtopic.php?topic_id=54136&forum=28&post_id=239385 TIA for any advice. CM |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|