 |
 |
 |
 |
Registered: 05/23/08
Posts: 10
|
|
|
 |
 |
 |
 |
|
|
|
|
|
|
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
|
|
|
|
|
|
|
|
|
|
|
#190251 - 07/06/07 07:03 PM
Re: RE: [FIXED for b4] 7.2.b1 Topics created by Rick.
[Re: gliderdad]
|
|
Registered: 06/04/06
Posts: 255
|
|
in /scripts/userposts.inc.php, there is a line similar to global $in, $config, $dbh, $ubbt_lang, $html, $userob, $user; you'll want to add $var_start, $var_sep, and $var_eq to that list, each seperated by a comma
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#190259 - 07/06/07 08:28 PM
Re: RE: [FIXED for b4] 7.2.b1 Topics created by Rick.
[Re: Ian Spence]
|
|
Registered: 06/08/06
Posts: 1466
Loc: NY
|
|
|
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
|
|
|
#190270 - 07/06/07 08:59 PM
Re: RE: [FIXED for b4] 7.2.b1 Topics created by Rick.
[Re: gliderdad]
|
|
Registered: 06/08/06
Posts: 1466
Loc: NY
|
|
I added and now the line looks like global $in, $config, $dbh, $ubbt_lang, $html, $userob, $user, $var_start, $var_sep, $var_eq; But now getting this error Script: /home/glidercentral/public_html/ubbthreads/scripts/userposts.inc.php
Line#: 150
SQL 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 ''150', 50' at line 10
SQL Error #: 1064
Query: SELECT t3.POST_ID, t1.TOPIC_ID, t3.POST_SUBJECT AS TITLE, t3.POST_POSTED_TIME AS TIME, t1.TOPIC_REPLIES, t2.FORUM_ID, t2.FORUM_TITLE FROM ubbt_TOPICS as t1, ubbt_FORUMS as t2, ubbt_POSTS as t3 WHERE t3.USER_ID = '36' AND t3.TOPIC_ID = t1.TOPIC_ID AND t1.FORUM_ID = t2.FORUM_ID AND t2.FORUM_ID in ( '1', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '2', '20', '21', '22', '23', '24', '26', '27', '28', '29', '3', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '4', '40', '5', '6', '7', '8', '9' ) AND t3.POST_IS_APPROVED = '1' AND t2.FORUM_IS_ACTIVE = '1' ORDER BY t3.POST_POSTED_TIME DESC LIMIT '150', 50
|
|
Top
|
|
|
|
|
|
|
|
|
|
|
Previous Topic
Index
