1
ChaoticMess
Buddyfriends or why does this sql statement fail?

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

2
jordi_rc
Re: Buddyfriends or why does this sql statement fail?
  • 2006/12/6 7:26

  • jordi_rc

  • Not too shy to talk

  • Posts: 114

  • Since: 2006/8/21


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.
"Battles are fought by those with the courage to believe. They are won by those who find the heart to share." -MANOWAR

3
jordi_rc
Re: Buddyfriends or why does this sql statement fail?
  • 2006/12/7 6:23

  • jordi_rc

  • Not too shy to talk

  • Posts: 114

  • Since: 2006/8/21


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
"Battles are fought by those with the courage to believe. They are won by those who find the heart to share." -MANOWAR

4
Truelove
Re: Buddyfriends or why does this sql statement fail?
  • 2007/4/27 11:51

  • Truelove

  • Just popping in

  • Posts: 7

  • Since: 2006/1/11


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?

5
jordi_rc
Re: Buddyfriends or why does this sql statement fail?
  • 2007/4/27 13:09

  • jordi_rc

  • Not too shy to talk

  • Posts: 114

  • Since: 2006/8/21


Sorry I no longer support this.
I left Xoops, I changed to another CMS.
It would be nice someone supports this module.

Jordi
"Battles are fought by those with the courage to believe. They are won by those who find the heart to share." -MANOWAR

Login

Who's Online

229 user(s) are online (147 user(s) are browsing Support Forums)


Members: 0


Guests: 229


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits