Forums / Cotonti / Support / User Details SQL Error

DeadX06
#1 2009-06-17 16:20
I know this issue probably cant be solved just by showing you the error and you telling me whats wrong.

The last thing I was remember doing before i noticed the error occurred was editing the tpl files in my skins folder, I added plugins autobanlist, modcp, and slimbox.

The problem is that when i goto users.php AT MY WEBSITE ( i made it so that you can see the users list without signing up so you can see my problem ) everything is fine until you click on any user in the list and this error shows up

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/content/d/e/a/deadx/html/xtremesr/system/database.mysql.php on line 209

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/content/d/e/a/deadx/html/xtremesr/system/database.mysql.php on line 97
Xtreme Street Racing
2009-06-17 01:18
Fatal error : SQL error : 

I dont even rememeber going into the user details when i first upgraded so i really cant tell you how long its been there. But im posting this because when i was searching around i did not find any answers i was looking for, and so i hoping maybe one of you guys had this by any chance and fixed it or know whats wrong and tell me what i can do to fix this.
tensh
#2 2009-06-17 18:53
Did you run sql attached to plugins? I think modcp has a sql which you have to execute on your database.
Lombi
#3 2009-06-17 20:17
You could check which plugins are hooking to users.details (in admin/plugins on the bottom), try to pause each one and see which is causing the issue.
<a href="http://www.domenlo.com">Surreal Art</a>
DeadX06
#4 2009-06-19 02:29
Ok, found out it was MODCP.

I know allot about this CMS but with random stuff like this I learn little stuff i can do to keep me from asking questions and doing it my self. I did everything would think to do, except to pause, I never really even knew that did anything lol.

Thanks Lombi, and tensh.
Lombi
#5 2009-06-19 02:36
While installing and uninstalling removes settings and adds/removes hooks into the core, pausing a part only stops it from running.

In your case that's all that's needed to locate the "guilty plugin"
<a href="http://www.domenlo.com">Surreal Art</a>
DeadX06
#6 2009-06-19 02:46
Actually, I just found out it was not MODCP, it was a old seditio plugin called "Users Recent Pages" and i dont even care about that one, so that one is deleted, the MODCP works fine with it now. Ill make sure to remove those properly.

Thanks again.
pieter
#7 2009-06-19 03:53
But if you do care: User pages for cotonti
... can we help you ...