[URGENTE] Problemas después de actualizar

Database error in vBulletin 4.0.8:

Invalid SQL:

SELECT contenttype.contenttypeid AS itemid

FROM foro_contenttype AS contenttype
INNER JOIN foro_package AS package
ON package.packageid = contenttype.packageid LEFT JOIN foro_product AS product
ON product.productid = package.productid
WHERE
1 = 1 AND (product.active = '1' OR package.productid = 'vbulletin') AND contenttype.canattach = '1';

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, October 27th 2010 @ 07:46:33 PM
Error Date : Wednesday, October 27th 2010 @ 07:46:33 PM
Script : Comunidad de PokeSpain
Referrer : Comunidad de PokeSpain
IP Address : 90.162.20.109
Username : BlackFire
Classname : vB_Database
MySQL Version : 5.0.91-community

Hacer clic para expandir...

Andrés Durán dijo:

Hola,

El problema que se te presenta se debe a una mezcla de varios juegos de caracteres en las tablas de la base de datos. Es decir, todas las tablas de la base de datos deben tener el mismo juego de caracteres, no pueden haber algunas con un juego, y otras con otro.

Lo que debes hacer (o debiste, si ya es que te respondió el soporte de vBulletin) es editar vía phpMyAdmin cada una de las tablas y definir el juego de caracteres acorde con el de la base de datos.

Hacer clic para expandir...

Database error in vBulletin 3.8.6:

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 foro_package AS package
LEFT JOIN foro_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 foro_contenttype AS contenttype
INNER JOIN foro_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN foro_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, October 28th 2010 @ 06:37:38 PM
Error Date : Thursday, October 28th 2010 @ 06:37:38 PM
Script : vBulletin 4.0 Upgrade System Step 9) Albums System Alterations
Referrer : vBulletin 4.0 Upgrade System Step 8) Attachment System Alterations (5/5)
IP Address : 90.162.17.104
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community

Hacer clic para expandir...