AUS-CITY
Posted By: ShaRp private messages won't work - Tue 04 Mar 2008 02:23:AM
Can't send/read. This is what I get

We encountered a problem. The reason reported was
Script: /var/www/vhosts/aus-city.com/httpdocs/ubbthreads/scripts/viewmessage.inc.php
Line#: 165
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 '' at line 15
SQL Error #: 1064
Query: SELECT p.POST_ID, t.TOPIC_SUBJECT, p.USER_ID, p.POST_BODY, p.POST_TIME, u.USER_DISPLAY_NAME, up.USER_TITLE, up.USER_RATING, up.USER_AVATAR, up.USER_AVATAR_WIDTH, up.USER_AVATAR_HEIGHT, u.USER_REGISTERED_ON, up.USER_TOTAL_POSTS, up.USER_LOCATION, up.USER_SIGNATURE, up.USER_CUSTOM_TITLE, up.USER_ACCEPT_PM, up.USER_HOMEPAGE, up.USER_VISIBLE_ONLINE_STATUS, up.USER_MOOD, up.USER_NAME_COLOR,u.USER_MEMBERSHIP_LEVEL FROM ubbt_PRIVATE_MESSAGE_POSTS p, ubbt_USERS u, ubbt_USER_PROFILE up, ubbt_PRIVATE_MESSAGE_TOPICS t WHERE p.TOPIC_ID = 2737 AND p.TOPIC_ID = t.TOPIC_ID AND p.USER_ID = u.USER_ID AND u.USER_ID = up.USER_ID ORDER BY p.POST_TIME LIMIT 0,

Please click back to return to the previous page.
Posted By: Alisa Re: private messages won't work - Tue 04 Mar 2008 10:49:AM
With the new beta version of this forum recently installed (see this post), some problems might be encountered. Days or weeks from now a new version will be released with many of the bugs worked out. boxing

I tested private messaging and it is working for me. It might take the new release to get yours working again. Hang in there. awww
Posted By: ShaRp Re: private messages won't work - Mon 10 Mar 2008 12:55:AM
I received a test PM from ScanDesk. As usual, it won't work. This is what I'm getting when I click on it

We encountered a problem. The reason reported was
Script: /var/www/vhosts/aus-city.com/httpdocs/ubbthreads/scripts/viewmessage.inc.php
Line#: 165
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 '' at line 15
SQL Error #: 1064
Query: SELECT p.POST_ID, t.TOPIC_SUBJECT, p.USER_ID, p.POST_BODY, p.POST_TIME, u.USER_DISPLAY_NAME, up.USER_TITLE, up.USER_RATING, up.USER_AVATAR, up.USER_AVATAR_WIDTH, up.USER_AVATAR_HEIGHT, u.USER_REGISTERED_ON, up.USER_TOTAL_POSTS, up.USER_LOCATION, up.USER_SIGNATURE, up.USER_CUSTOM_TITLE, up.USER_ACCEPT_PM, up.USER_HOMEPAGE, up.USER_VISIBLE_ONLINE_STATUS, up.USER_MOOD, up.USER_NAME_COLOR,u.USER_MEMBERSHIP_LEVEL FROM ubbt_PRIVATE_MESSAGE_POSTS p, ubbt_USERS u, ubbt_USER_PROFILE up, ubbt_PRIVATE_MESSAGE_TOPICS t WHERE p.TOPIC_ID = 2745 AND p.TOPIC_ID = t.TOPIC_ID AND p.USER_ID = u.USER_ID AND u.USER_ID = up.USER_ID ORDER BY p.POST_TIME LIMIT 0,

Please click back to return to the previous page.
Posted By: Webmaster Re: private messages won't work - Wed 19 Mar 2008 11:01:AM
Hopefully on Friday (UTC) I should be able to install beta 5 which should fix a number of these bugs.
Posted By: Webmaster Re: private messages won't work - Tue 25 Mar 2008 10:04:PM
New version is up it should be resolved
Posted By: ShaRp Re: private messages won't work - Thu 27 Mar 2008 12:04:PM
yes PMs are back in action. thanks
© AUS-CITY Message Forums