Kolbi
06.01.2010, 12:04
Habe mein Testboard auf vB 4.0.0pl1 geupdatet und das Update lief ohne Probleme durch.
Nun bekomme ich aber im Board MySQL Fehlermeldungen:
http://localhost/blog.php
Database error in vBulletin 4.0.0:
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 vb_package AS package
LEFT JOIN vb_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 vb_contenttype AS contenttype
INNER JOIN vb_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN vb_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );
MySQL Error : Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, January 6th 2010 @ 12:00:49 PM
Error Date : Wednesday, January 6th 2010 @ 12:00:50 PM
Script : http://localhost/blog.php
Referrer : http://localhost/forum.php
IP Address : 127.0.0.1
Username : Kolbi
Classname : vB_Database
MySQL Version : 5.1.37oder
http://localhost/content.php
Database error in vBulletin 4.0.0:
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 vb_package AS package
LEFT JOIN vb_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 vb_contenttype AS contenttype
INNER JOIN vb_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN vb_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );
MySQL Error : Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, January 6th 2010 @ 12:00:51 PM
Error Date : Wednesday, January 6th 2010 @ 12:00:51 PM
Script : http://localhost/content.php
Referrer : http://localhost/forum.php
IP Address : 127.0.0.1
Username : Kolbi
Classname : vB_Database
MySQL Version : 5.1.37Das ist da falsch? :)
Nun bekomme ich aber im Board MySQL Fehlermeldungen:
http://localhost/blog.php
Database error in vBulletin 4.0.0:
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 vb_package AS package
LEFT JOIN vb_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 vb_contenttype AS contenttype
INNER JOIN vb_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN vb_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );
MySQL Error : Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, January 6th 2010 @ 12:00:49 PM
Error Date : Wednesday, January 6th 2010 @ 12:00:50 PM
Script : http://localhost/blog.php
Referrer : http://localhost/forum.php
IP Address : 127.0.0.1
Username : Kolbi
Classname : vB_Database
MySQL Version : 5.1.37oder
http://localhost/content.php
Database error in vBulletin 4.0.0:
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 vb_package AS package
LEFT JOIN vb_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 vb_contenttype AS contenttype
INNER JOIN vb_package AS package ON package.packageid = contenttype.packageid
LEFT JOIN vb_product AS product ON product.productid = package.productid
WHERE product.active = 1
OR package.productid = 'vbulletin' );
MySQL Error : Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Wednesday, January 6th 2010 @ 12:00:51 PM
Error Date : Wednesday, January 6th 2010 @ 12:00:51 PM
Script : http://localhost/content.php
Referrer : http://localhost/forum.php
IP Address : 127.0.0.1
Username : Kolbi
Classname : vB_Database
MySQL Version : 5.1.37Das ist da falsch? :)