[Forum] Users cannot read PM

[yahiko]

One of my users told me that he can't read the PM, when he try to read them, appear a DB error....
This is the message:

	Database error
The my-web database has encountered a problem.
Please try the following: Load the page again by clicking the Refresh button in your web browser. Open the www.my-web.com home page, then try to open another page. Click the Back button to try another link.
The www.my-web.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.

Regards :S

[acwatts]

You need to post what the actual error was, these should go to your email.

[Matthew Gordon]

That is correct, we need the actual database error. Check the HTML source of the database error page, the actual error message should be there. If it isn't, check the e-mail you supplied for database errors in config.php.

[yahiko]

It'll be this?

Database error in vBulletin 4.1.3:

Invalid SQL:

                                SELECT postid 

                                FROM my-web_post

                                WHERE 

                                    userid = 3

                                    AND threadid = 

                                    AND visible = 1 AND userid > 0 LIMIT 1;

MySQL 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 'AND visible = 1 AND userid > 0 LIMIT 1' at line 6
Error Number  : 1064
Request Date  : Thursday, May 17th 2012 @ 04:36:07 PM
Error Date    : Thursday, May 17th 2012 @ 04:36:07 PM
Script        : [URL]http://www.my-web.com/private.php?do=showpm&pmid=11800[/URL]
Referrer      : [URL]http://www.my-web.com/private.php[/URL]
IP Address    : 000.000.000.000
Username      : prueba
Classname     : vB_Database
MySQL Version :

Regards

[Matthew Gordon]

Try disabling your third-party plugins (Admin CP -> Plugins & Products -> Manage Products) and see if the error persists.

[yahiko]

Good... it's fix it.... I found the hack it's doing this error :S

Now, when I ennable other hack, appear me this error

Database error in vBulletin 4.1.3:

Invalid SQL:

                    SELECT
                        thread.forumid, forum.title AS forumtitle,
                        thread.threadid, thread.title AS threadtitle, postusername, postuserid, thread.visible,
                        thread.lastpost, thread.replycount
                    FROM myforum_thread AS thread
                         LEFT JOIN myforum_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2 AND canview = 1)
                    LEFT JOIN myforum_forum AS forum ON (forum.forumid=thread.forumid)
                    WHERE thread.threadid IN (6792,268,1021,1024,1043,1050,1053,1054,1102,1184,1194,1221,1226,1227,1234,1240,1577,1582,1599,1619,1633,1634,1666,1673,1691,1703,1708,1710,1711,1712,1715,1717,1719,1727,1728,1729,1731,1750,1764,1769,1771,1774,1775,1779,1782,1796,1797,1802,1803,1809,1822,1823,1834,1835,1836,1843,1847,1848,1850,1851,1858,1859,1871,1875,1876,1877,1881,1892,1893,1895,1989,2015,2016,2033,2053,2054,2070,2101,2123,2124,2127,2168,2209,2213,2219,2220,2221,2225,2228,2249,2252,2254,2255,2257,2259,2260,2267,2274,2275,2276,2279,2289,2294,2316,2317,2319,2320,2339,2340,2341,2344,2348,2355,2358,2364,2392,2401,2417,2427,2442,2451,2454,2457,2464,2467,2468,2469,2470,2472,2477,2478,2487,2492,2541,2547,2581,2601,2602,2606,2611,2644,2652,2660,2677,2678,2679,2681,2692,2693,2778,2908,2938,3018,3019,3054,3126,3135,3154,3207,3221,3299,3308,3309,3311,3313,3314,3489,3490,3511,3515,3572,3573,3653,3659,3660,3680,3681,3700,3701,3708,3709,3710,3711,3712,3713,3718,3858,3860,3887,3913,4071,4264,4299,4373,4513,4524,4838,5026,5074,5331,5509,5747,5878,6034,6037,6073,6074,6075,6108,6149,6176,6200,6310,6314,6339,6383,6449,6460,6462,6490,6491,6551,6561,6571,6699,6724,6764,6765,6778,6787,6789,6797,6862,6903,6918,6919,6927,6928,6950,6965,6979,7022,7032,7070,7101,264,272,273,274,275,1098,1162,1237,1241,1258,1323,1332,1337,1389,1497,1546,1572,1601,1674,1689,1726,1817,1824,1831,1927,2042,2060,2146,2157,2301,2350,2513,2550,2553,2565,2673,2762,3293,3595,3640,3893,3975,6661,6713,6714,6715,271,1697,1784,1786,1788,1789,1793,1794,1800,1801,2471,2473,2485,2489,2491,2493,2559,2571,2590,2670,2702,6260,7023,6043,6951)
                    AND thread.visible = 1
                    AND forum.forumid IN (84,130,85,120,Array,Array,Array)
                    LIMIT 10;

MySQL Error   : Unknown column 'Array' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, April 26th 2012 @ 10:27:54 AM
Error Date    : Thursday, April 26th 2012 @ 10:27:54 AM
Script        : http://www.myforum.com/showthread.php?t=$$$$
Referrer      : http://www.myforum.com/showthread.php?t=$$$$
IP Address    : 
Username      : tetsenosuke
Classname     : vB_Database
MySQL Version : 5.1.52-cll

Regards...

[Matthew Gordon]

You'll need to contact the author of the mod in question for support.

[yahiko]

ok
Thanks for everything
Regards