database error please help

[VBUsers]

i get this when someone trys to empty theyre PM folder why?

Invalid SQL:

SELECT pmid, pmtextid
FROM smora_pm AS pm
LEFT JOIN smora_pmtext AS pmtext USING (pmtextid)
WHERE folderid = 0
AND userid = 2989
AND dateline < 1132581876;

MySQL Error : Column: 'pmtextid' in field list is ambiguous
Error Number : 1052
Date : Monday, November 21st 2005 @ 08:04:54 AM
Script : http://www.lowandloud.com/private.php
Referrer : http://www.lowandloud.com/private.php?do=emptyfolder&folderid=0
IP Address : 00000000
Username : user

[filburt1]

You need to specifically choose a table when referencing the pmtextid colum given, according to the query, it exists in both smora_pmtext and smora_pm.

[VBUsers]

You need to specifically choose a table when referencing the pmtextid colum given, according to the query, it exists in both smora_pmtext and smora_pm.


ok now how can i do that. can you be so kind as to give me the steps.?

[Marco van Herwaarden]

Check the bugtracker (or maybe it was the forum) at vb.com.

A fix was posted by Andreas some time ago.

Think it was just removing the ', pmtextid'