+ Reply to Thread
Results 1 to 2 of 2

Thread: Need assistance with a SPL server problem

  1. #1
    dpogary's Avatar
    dpogary is offline x10 Sophmore dpogary is an unknown quantity at this point
    Join Date
    Jul 2006
    Location
    Hopkins Minnesota
    Posts
    134

    Need assistance with a SPL server problem

    Could not obtain post/user information.

    DEBUG MODE

    SQL Error : 1064 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 'FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id' at line 2

    SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = '1' AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
    I keep recieving this error whenever i try to view a post on my forum...its brand new so this is the first post. i can see it in the SQL server. but it wont show up. any one got some help?

  2. #2
    Richard's Avatar
    Richard is offline x10 Elder Richard is an unknown quantity at this point
    Join Date
    Feb 2005
    Location
    South Africa
    Posts
    1,014

    Re: Need assistance with a SPL server problem

    Code:
    pt.post_subject, pt.bbcode_uid, FROM nuke_bbposts p, nuke_users u
    the comma before "FROM" needs to go. That should sort the problem out.
    sourcewave.net -- Linux is like a teepee, no Windows, no Gates, Apache inside.

+ Reply to Thread

Similar Threads

  1. Server Problem?
    By cyberxzt in forum Free Hosting
    Replies: 7
    Last Post: 09-21-2005, 04:27 PM
  2. New server working great - Another problem
    By bin_asc in forum Free Hosting
    Replies: 6
    Last Post: 09-15-2005, 11:58 AM
  3. 500 internal server error problem!
    By hammerguy in forum Free Hosting
    Replies: 4
    Last Post: 08-23-2005, 09:23 PM
  4. x10hosting Server Problem and I found it
    By Chirantha in forum Free Hosting
    Replies: 0
    Last Post: 08-15-2005, 03:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers