Database Error - Please Help

[b2bone]

My name is Chuck, I am a new SMF user and I humbly and respectfully request the help of anyone willing.

When I alter the post count on my profile to anything over 100000 I get the following database error message when I go to view my profile:

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 'am a geek!!
ORDER BY minPosts
LIMIT 1' at line 3
File: /home/fleshlus/public_html/forum/Sources/Profile.php
Line: 1264

When I change it back to 100000 or under there is no error. A big thanks to anyone who would know and be willing to inform me what I can do or guide me in the right direction.

[b2bone]

I downloaded the following mod (geek.zip) in this post: click here if your interested. This seemed to fix the problem for me, but I don't yet know why. I'm gonna try to figure out why this happened in the first place and why this mod fixes it. If anyone knows this please inform me. Thanks!

[IchBin™]

Are you running 1.1.13?
Do you have any mods installed besides the one you listed?

Please attach your Sources/Profile.php file to your next post. Do not post the code, but attach the file please.

[b2bone]

Yes, I am running 1.1.13

Here are the mods I have installed:

1.    Downloads System    1.3.4.4    
2.    SMF Gallery Lite    3.0.2    
3.    Next Post Level    1.3.2    
4.    SMF Articles    1.3.2.1    
5.    SMF Links    2.2.1    
6.    EzPortal    0.5.1    
7.    Contact Page    2.0    
8.    Geek Mod    1.0    
9.    SMF Trader System    1.5

I don't know if profile.php changes with the hxxp:geek.zip [nonactive] mod or not so I attached the profile with and without hxxp:geek.zip [nonactive] mod installed. Profile1.php is without hxxp:geek.zip [nonactive] installed Profile2.php is with hxxp:geek.zip [nonactive] installed. After the hxxp:geek.zip [nonactive] installed everything seems to be fine when the post is altered above 100000, but I am still very curious as to why and I plan when I have more time to try and figure this out, but I'm hoping someone already knows this information and would be so kind as to explain this to me. Thanks

[IchBin™]

Well what you're looking at is actually an easter egg. I don't understand why it's not working for you though. It works just fine for me on a fresh install of SMF 1.x for me. To me your error indicates that the SQL is trying to look up the post count but using the "i am a geek" string instead. Not sure why it's not working for you though. And the reason it works when you uninstall is because it removes the "i am a geek" text from the user info in Load.php.

[b2bone]

Thanks so much IchBin, your explanation does give me understanding.