SMF Development > Fixed or Bogus Bugs

Resource Boolean Error SOLVED may delete or whatever

(1/1)

tpgames:
UPDATE: SOLVED New install works. And, when I installed the theme, I didn't like it cluttering up the entire theme folder, so moved it to its own folder. I'm not sure what I did here, as I don't remember, but I think that was the issue. So, no bug, and this can be deleted, closed whatever you want to do with it. Friend can't duplicate the error in the new install, which leads me to suspect it was the theme.
Thanks! [I did post a solution over in my other thread, so this one can be deleted. OCD error. :P ]

The Issue: Friend gets resource boolean error when trying to access the forum. He has not been able to log in, but I have been able to log in (even as him). He is on Windows XP.

Important Details:
However, the installer of the forum (Me! :P ) forgot to remove all instances of " &", "`", ":" or " ' " before pressing "Okay". So, that might have negatively impacted the php code. I do know better. Also I did put child inside of a child, inside of a child.

Is this something you guys can fix? Is it a bug? Or WinXP issue?
Should I start over and uninstall and reinstall?
And yes, it might be my error due to "adding what developer never expected a person to do with the forum".
Thanks!  ;D
   

Version(s) of SMF: 2.0.2
    Your Setup:
        List any Modifications you have installed: None
        List any Themes you have installed: Synthetic
        List any non-English Language packs you have installed: None
        Are you using UTF-8? No. I want to though.
Did a new install in different folder to get this answer, and new install insist on ISO-8859-1 for English. I couldn't find it before.  ::)

        What caching level are you using? Default values. I refused to change them.
    Server Software:
        Apache/IIS version?: 2.2.22
        PHP version?: 5.3.10
        Database type and version: MySQL version    5.1.63-cll
        Any other related server information? Architecture    x86_64
Operating system    linux

    Where the Error Occurred:
The error message:

--- Code: --- Warning: mysql_real_escape_string() expects parameter 2 to be resource, boolean given in /home2/globalwr/public_html/smf/Sources/Subs-Db-mysql.php on line 132
--- End code ---
        File: Subs-Db-mysql.php
        Line: 132
        Any relevant errors in the SMF error log (if so please post them)?:

1. The forum using, forum maintenance says NO errors.
2. The php error log file (I accessed behind the scenes) says error, and repeats that error every time my friend tries to access the page. And my cPanel error log says error exist. But, the forum's admin panel always says NO errors, and has NO log of there being errors. [This makes me wonder if I need to uninstall and redo a fresh install.]


    How to Reproduce this Error?: on XP computer go to link of forum. That is how he gets the error. Also, this error was not reproducable on a Mac.
    Additional Information?

1. I did a new install before these issues.
2. I did have " & " in a title of a category. I forgot to switch it to " and ".
3. I did have a child of a child in at least one board.
4. I changed my board and moved things such that no more childs of childs exist, and no more then 6 childs in any one board. I also removed all " &, :, ` " from all titles and descriptions in Categories, Boards, Child and Topics.


Thanks again!

Arantor:
Doing a search on the error message would find you a topic discussing the topic, the root cause and a possible code fix.

emanuele:
For the record:
http://www.simplemachines.org/community/index.php?topic=423482.msg2969724#msg2969724

tpgames:
Thanks! I never thought to look THAT far back. lol I am going to implement the first code fix too even though we aren' t having those issues currently.

Navigation

[0] Message Index