Database Error On New Install

[Pc1203]

Error Stuff:

Database error in vBulletin :


Invalid SQL:

SELECT t1.templateid AS templateid_1, t1.title ,
t2.templateid AS templateid_2, t2.title AS title2, t2.styleid AS styleid_2
FROM template AS t1
LEFT JOIN template AS t2 ON (t1.title=t2.title AND t2.styleid=1)
WHERE t1.styleid = -1
ORDER BY t1.title;

MySQL Error : Sort aborted
Error Number : 1028
Date : Monday, December 17th 2007 @ 04:13:17 PM
Script : http://localhost/vb_beta/upload/install/install.php?step=7
Referrer : http://localhost/vb_beta/upload/install/install.php?step=6
IP Address : 127.0.0.1
Username :
Classname : vB_Database


Any Ideas?

[Floris]

Sounds like a config issue with mysql, is the table MyISAM or innodb? Is this on Windows?

[Pc1203]

Sounds like a config issue with mysql, is the table MyISAM or innodb? Is this on Windows?

Windows,.. As for the table type..i duno.

- Pc

[Andy Huang]

Sort aborted may also have to do with your mysqld running out of server resource; is this a windows server of your own or are you on a shared hosting? You should contact your server administrator or hosting provider to check if your mysql daemon's log is showing error entries of it running out of memory.

[Pc1203]

Sort aborted may also have to do with your mysqld running out of server resource; is this a windows server of your own or are you on a shared hosting? You should contact your server administrator or hosting provider to check if your mysql daemon's log is showing error entries of it running out of memory.

This is actually a USB localhost server. Anyway, I guess that's the problem. Thanks :)

- Pc1203.