Opened 10 years ago

Closed 10 years ago

Last modified 6 years ago

#1110 closed bug (fixed)

SQL Error when I want to see my messagse outbox

Reported by: lemon-head Owned by:
Priority: blocker Milestone: Legacy Resolved
Component: BW Database Keywords:
Cc: jeanyves

Description

The requested page was: http://www.bewelcome.org/bw/mymessages.php?action=ViewMsg&menutab=Sent&msg=13914

That's the message I get:

#0 debug(
query problem with
SELECT SQL_CACHE Accomodation, BirthDate, HideBirthDate, FilePath FROM members LEFT JOIN membersphotos ON members.id = membersphotos.IdMember WHERE members.id = '2883' mysql_error: Column 'FilePath' in field list is ambiguous
) called at [/home/bwrox/www.bewelcome.org/htdocs/bw/lib/bwdb.php:126] #1 sql_query(SELECT SQL_CACHE Accomodation, BirthDate, HideBirthDate, FilePath FROM members LEFT JOIN membersphotos ON members.id = membersphotos.IdMember WHERE members.id = '2883') called at [/home/bwrox/www.bewelcome.org/htdocs/bw/mymessages.php:308] 
query problem with
SELECT SQL_CACHE Accomodation, BirthDate, HideBirthDate, FilePath FROM members LEFT JOIN membersphotos ON members.id = membersphotos.IdMember WHERE members.id = '2883' mysql_error: Column 'FilePath' in field list is ambiguous

System error, please report the following timestamp along the error: [1237032959]

Change History (2)

comment:1 Changed 10 years ago by jeanyves

  • Resolution set to fixed
  • Status changed from new to closed

I just find the reason, I added a temporary new field in members table on production to fix some problem with members main pictures. It worked fine.

But as a secundary consequences this new field was name as the similar one in th membersphotos table and this cause some ambiguous field problem to mysql

I rename the fiend in members table, it works fine now I close the ticket

comment:2 Changed 6 years ago by TimLoal

  • Milestone changed from unassigned to Legacy Resolved
Note: See TracTickets for help on using tickets.