SMF Support > Install and Upgrade Help

Weird database error SOLVED

(1/1)

tpgames:
SOLUTION: Do not clean up messy themes by putting them in their own folder, after you've install the theme. :P
Also, see this thread on this forum. I missed this one.
http://www.simplemachines.org/community/index.php?topic=423482.100

(Fine with this being deleted, moved, or whatever.)
I and the kid do NOT get the following error, but my friend does get the error when he tries to access the website. Also, cPanel logs the error as well, but the SMF admin forum does NOT log the error.

--- 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 ---

here is the part in question. I did not modify anything.

--- Code: --- case 'string':
case 'text':
return sprintf('\'%1$s\'', mysql_real_escape_string($replacement, $connection));
break;
--- End code ---

However, just in case this is useful on my board, I do have

--- Code: --- Jade University -->> Jade Uni-Basic -->> Jade University --> > Classrooms-Images -->> Classes
--- End code ---
These is the order of the main board, and the sub-boards within sub-boards.

Last update: I just installed it and tweaked it, which is why I posted it here. Not sure if its a bug or not.
And yes, I did remove ALL the "&" signs from my "about this board", and the ";)" that I added. I do have " ( ) " thought and a french e in use in a description.
hxxp:globalwritersclub.com/smf/index.php [nonactive] The link. You may or may not get the same error, based on above mentioned facts.

Colin:
Have you tried Repair Errors in Admin -> Forum Maintenance?

tpgames:
yes, I did.
One check I did found:  Slightly outdated personal messages php. (2.0 instead of 2.0.2)

hxxp:globalwritersclub.com/smf/index.php. [nonactive] Link to forum.

But the forum maintenance says:
No errors found. I tried it again, and same thing.

However, he now sees the login page, but still gives same errors. And, I was able to log in using his details with no issues on kid's computer. Also the error log in the php says the same error. But Maintenance logs says NO errors.

Also, I have no mods added to board.

UPDATE:
PHP: 5.3.10
MySQL version    5.1.63-cll
Architecture    x86_64
Operating system    linux
Installed using Softaculous on cPanel Version 11.32.3 (build 19)

Computer details of His (issues): Windows XP, Screen Size: 1024x600. Netbook, 10" screen. He scrolls and has no issues viewing other content and other php databases on his netbook with it being that size. (His computer is the only one having issues. His computer is 32-bit.

Kid's computer is Windows 7, 32-bit (no issues.)
Mine is Windows 7, 64-bit (no issues.)

Last Edit:
1) I did remove ALLsub-boards that were of sub-boards. (I had more then 3 layers previously).

2) I also made more categories to split up the boards more and have less tree branches.
Category: Xavex
Board: Xavex Shoppes (6 boards total)
Child: Clothing. (no more then 3 child boards here, but another board has 6 childs)
There is no Child of a Child anymore.

3) I renamed all titles and descriptions that contained
--- Code: --- &, :, `
--- End code ---
. I hadn't meant to title anything with an "&" in the first place, but forgot to replace it with "and". :P

4) There is no more scrolling to find boards, within the forum layout.

Does this need to go over to bugs? My dad will check to see if the same issue happens on my mom's old Mac. I am trying to find another person with an XP to see if they get the same problem, so we can rule out the OS.
Thanks!  :-\

Navigation

[0] Message Index