1
Hi Everyone,,
I am trying to work with a XOOPS based program called Fusker NE 2.0
I have the files uploaded to my server, and did the install on the program.
There are parts of the program that work fine, and other parts that are DB based that will not work, and return these messages:
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Resource id #48' at line 1]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Resource id #45' at line 1]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Resource id #37' at line 1]
I had a friend look at it, and it appears that someone changed the script (hand-coded) and this is why it won't work:
first regarding the MySQL errors:
I analyzed these errors and got to know that they are caused by wrong code!
Open the file “/class/xoopsgroup.php”, please. There I can show you an example. Please scroll down to line 461.
There you can see the following:
list($count) = $db->get_var($db->query($sql));
The problem is that the function $db->query() returns an mysql-query OBJECT, BUT the function $db->get_var() expects an Sql String (like “SELECT * FROM …”) and not the mysql-query OBJECT! This has definitely been wrongly coded!
When you look over this line you can also read the comment “// HAND CODED”. Do you know who added these hand-coded parts?
It seems that these hand-coded parts spread over several parts of the system. It will be necessary to re-code all these parts before the script will work fine.
Is there anyone that might be able to help me correct this...???
I have the file called FUSKER NE 2.1 uploaded to one of my websites for download at:
The Poison 1I would be willing topay if someone can make this work...:)
The website that developed this script went out of business, and so did their forums for development.
Thank you,,
David
