| Fungsten |
07-14-2010 07:53 PM |
Quote:
Originally Posted by Paul M
(Post 2069207)
What DB errors exactly do users get ?
|
I get sent a lot of these.
Quote:
Database error in vBulletin 4.0.4:
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 : Table 'XXXXXXXX.contenttype' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 14th 2010 @ 11:26:01 AM
Error Date : Wednesday, July 14th 2010 @ 11:26:02 AM
Script : http://www.XXXXXXXXXXXXXXXXXX.com/fo...?88-BBW-thread.
Referrer :
IP Address : XX.XXX.XXX.XXX
Username : Unregistered
Classname : vB_Database
MySQL Version :
|
And I get this if I click on a thread:
Quote:
Database error in vBulletin 4.0.4:
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 : Table 'XXXXXXXXXXXXXX.contenttype' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 14th 2010 @ 03:50:58 PM
Error Date : Wednesday, July 14th 2010 @ 03:50:59 PM
Script : http://www.XXXXXXXXXXXXX.com/forum/s...php?108360-RIP
Referrer : http://www.XXXXXXXXXXXXXXX.com/forum/index.php
IP Address :
Username : XXXXXXXXXXXXXX
Classname : vB_Database
MySQL Version : 5.0.91-community
|
|
More Information