sad question for the brainy peeps ~

    Date: 03/30/05 (MySQL Communtiy)    Keywords: php, mysql, database, sql

    hi all ~ i have a vB board out there in cyberland and it's got a "random quote" hack (the UQH by kurafire) ~

    anyway, after three years of smooth sailing, it recently developed some kvetchy sickness and i can't figure out the problem.

    this is the error message:

    Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT *
    FROM quotes
    WHERE 1=1 AND mod!='N'
    ORDER BY letter,name ASC
    LIMIT 0,30
    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 '!='N'
    ORDER BY letter,name ASC


    mysql error number: 1064

    Date: Tuesday 29th of March 2005 07:20:54 PM
    Script: http://www.lookingland.com/board/board/quotelist.php?s=


    where it says "script" ~ that URL is completely wrong and i'm not sure where it's trying to call it from ~ (don't know if that's part of the problem? is that in a template?)

    anyway, i'm a complete dummitz about mysql ~ do you think i should just delete the table and rehack the whole thing? (please say no ~ hahahahaha) ~

    anyway, sorry if this is obnoxious. any hints would be very much appreciated.

    : o (

    Source: http://www.livejournal.com/community/mysql/53159.html

« SELECT across multiple tables? || Reading server load »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home