SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2004
    Location
    italy
    Posts
    65
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    error with forum phpbb

    The following is the error I get when I click on the pop-up window of a private message on my phpbb forum version 2.011

    Could not find oldest privmsgs

    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 'AND privmsgs_from_userid = 7' at line 4

    SELECT privmsgs_id FROM phpbb_privmsgs WHERE privmsgs_type = 2 AND privmsgs_date = AND privmsgs_from_userid = 7

    Line : 306
    File : /home/rondinel/public_html/forum/privmsg.php

  2. #2
    SitePoint Member Blue Streak's Avatar
    Join Date
    Dec 2004
    Location
    Sydney, Australia
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not phpBB official support obviously (so it may be worth letting them know perhaps) but the only way I can see that coming up is if you have your sentbox size limit set to zero - the code around where you are seeing the error deletes the oldest PM from a full folder, and it is possibly trying to delete a message that isn't actually there.

    I know this may not be a direct answer to your question, but that's the most logical explanation I can find. There might be another reason though.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •