'dateline' in order clause is ambiguous

[DirtyLude]

I've had this happen as well, and a user has just reported the same thing. Opera and Firefox browsers.

[DirtyLude]

The change that Scott recommended is exactly the change I did; directly alias the post table in the 'order by' clause. Unfortunately, I don't have any say in what database software we're running (free...

[DirtyLude]

I have not modified the database structure at all. I just checked to see if some magic had happened, but none of those tables have a dateline field in them.

It really happened out of the...

[DirtyLude]

I don't know if my provider just updated MySQL or what, but I just started receiving this error.

 Database error in vBulletin 3.0.1: 
Invalid SQL: 
SELECT
post.*, post.username

...

[DirtyLude]

Bringing this back to the top.

For anyone else who's having this problem, I found that GD was indeed installed and working, but JPEG support was not enabled. The JPEG library has to be...

[DirtyLude]

Same problem here. I set both options and I'm unable to see the test image.

GD bundled (2.0.15 compatible) and enabled

[DirtyLude]

So is the main performance bottleneck the memory? The ISP support has been very good and I don't think they would have a problem giving me the /etc/my.cnf file for you to check, and implement any suggested...

[DirtyLude]

I downloaded the sysinfo script that was suggested. Is there any security issues with me just posting the link to it, or should I just relay the basic information it provides?

The thing...

[DirtyLude]

Oops. The link is here:
http://www.hondaprelude.to/mysqlstat.php

I'll download the other script.

[DirtyLude]

I hope someone can analyse this and let me know if you see anything wrong. We're currently running on a shared server, but we are taking up most of the resources and seriously hogging the system. We...

[DirtyLude]

Here's a clip from my own image index page that I wrote. It's not from vBulletin, but it gives you a start on how to do it.

   $imagelist = GetFileList();
   while ( list($i,$image) = each 

...