Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.6.8

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in vBulletin 3.6.8

    PHP Code:
     
    Invalid SQL
    :
     
                      
    SELECT cron.*
                      
    FROM cron AS cron
                      LEFT JOIN product 
    AS product ON (cron.product product.productid)
                      
    WHERE cron.nextrun <= 1204144978 AND cron.active 1
                            
    AND (product.productid IS NULL OR product.active 1)
                      
    ORDER BY cron.nextrun
                      LIMIT 1
    ;
     
    MySQL Error  Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
    Error Number 1267
    Date         
    WednesdayFebruary 27th 2008 11:43:02 PM
    Script       
    http://www.mysite.com/vb/cron.php?&rand=829670
    Referrer     http://www.mysite.com/vb/showthread.php?p=8196
    IP Address   0.0.0.0
    Username     
    : &#1590;يف
    Classname    vB_Database 


    What this mean I got alot on my email like this message

  • #2
    As the error says, there is an illegal mix of collations in your database. Tip #5 in this thread explains how to set the collations in your database:

    http://www.vbulletin.com/forum/showthread.php?t=259250

    If you need to change every single collation in the database then I recommend you empty the database and set just the collation of the database itself. Then when you run the installation again all of the new tables should use the new collation of the database.

    Comment


    • #3
      thanks jake ..

      If I do upgrade my vB , won't solve this pro !

      cuz I don't know how to deal with database

      Comment


      • #4
        An upgrade won't fix it. You have to use phpmyadmin as described in that thread.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X