Announcement

Collapse
No announcement yet.

Database error on new thread

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

  • Lats
    replied
    Check this thread, fairly easy to fix.

    Leave a comment:


  • IrDVB
    started a topic Database error on new thread

    Database error on new thread

    Hi,
    I encountered some problem the other day while I was upgrading vBulletin, which seems to have caused the forum the following problem: No member can make new threads and when you click on the “New Thread” button the following error is produced:

    Code:
    Database error
    
    Invalid SQL:
    
    			SELECT prefix.*, prefixpermission.usergroupid AS restriction
    			FROM forumprefixset AS forumprefixset
    			INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
    			INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
    			LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
    			WHERE forumprefixset.forumid = 342
    			ORDER BY prefixset.displayorder, prefix.displayorder;
    
    MySQL Error   : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
    Error Number  : 1267
    Request Date  : Saturday, February 28th 2009 @ 02:04:48 AM
    Error Date    : Saturday, February 28th 2009 @ 02:04:48 AM
    Script        : 
    Referrer      : 
    IP Address    : 
    Username      : Admin
    Classname     : vB_Database
    MySQL Version : 5.0.67-community-log
    Please help me with this issue.

Related Topics

Collapse

  • coolv1994
    Database Error
    by coolv1994
    Database error in vBulletin 5.1.4:

    Invalid SQL:
    CREATE TABLE tmp_nodestats AS SELECT node.parentid AS nodeid, count(nv.nodeid) AS tmpvisitors,
    nv.totalcount - IFNULL(existing.replies,...
    Wed 24 Dec '14, 12:28am
Working...
X