- Desde
- 2 Ago 2006
- Mensajes
- 29
He actualizado a la versión 4.0.3 la última y he seguido todo al pie de la letra, pero mi sorpresa es que me sale el foro pero cuando se intenta entrar en algún post o tema, me sale el siguiente error de la base de datos
Alguien me puede ayudar, gracias
PHP:
Database error in vBulletin 4.0.3:
Invalid SQL:
(SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid,
package.productid AS productid, if(package.productid = 'vbulletin', 1, product.active) AS enabled,
package.class AS class, -1 as isaggregator
FROM package AS package
LEFT JOIN product AS product
ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin'
)
UNION
(SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid,
1, 1, contenttype.class AS class , contenttype.isaggregator
FROM contenttype AS contenttype
INNER JOIN package AS package ON package.packageid = contenttype.packageid
LEFT JOIN product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, April 28th 2010 @ 12:13:51 AM
Error Date : Wednesday, April 28th 2010 @ 12:13:51 AM
Script : http://www.futbolapuesta.es/showthread.php?14683-michael-jackson-en-la-semana-santa&p=67639
Referrer : http://www.futbolapuesta.es/
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.45
Alguien me puede ayudar, gracias