Page 1 of 1
Error while searching
Posted: 14 Nov 2008 18:30
by ncsuapex
I was trying to search the terms "folder stream"
and got this error.
General Error
SQL ERROR [ postgres ]
ERROR: invalid reference to FROM-clause entry for table "m0" HINT: There is an entry for table "m0", but it cannot be referenced from this part of the query. []
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster:
admin@videolan.org
Re: Error while searching
Posted: 16 Nov 2008 17:44
by siikah
Same here. A single one-word search worked, but then it all stopped working.
Re: Error while searching
Posted: 16 Nov 2008 17:53
by Arite
Intriguing. Any string containing >1 words returns a PostgreSQL error. This occurs with Advanced search too.
Possibly a regression caused by the phpBB 3.0.3 update. I can confirm it is not Style-related since prosilver returns the same error (not that it would be but decided to check just in case).
EDIT: Moved to Forum, Website and Artwork discussion forum.
Arite.
Re: Error while searching
Posted: 17 Nov 2008 03:38
by eaglepep
I too receive the following when trying to do a three word search "add files playlist" in the Windows forum:
General Error
SQL ERROR [ postgres ]
ERROR: invalid reference to FROM-clause entry for table "m0" HINT: There is an entry for table "m0", but it cannot be referenced from this part of the query. []
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Re: Error while searching
Posted: 17 Nov 2008 21:32
by quality
Same here. A single one-word search worked, but then it all stopped working.
Exactly the same here.
Re: Error while searching
Posted: 18 Nov 2008 00:10
by Arite
This appears to be the same bug in phpBB:
http://www.phpbb.com/bugs/phpbb3/ticket ... t_id=19195
However it
was fixed apparently a while ago, so (as I said before) there may have been a regression since 3.0.2.
There are a few other new similar tickets such as this:
http://www.phpbb.com/bugs/phpbb3/37005
Unless j-b recognises it as just a PostgreSQL database issue probably safe to assume it is a bug in 3.0.3.
Arite.
Re: Error while searching
Posted: 18 Nov 2008 07:23
by Jean-Baptiste Kempf
Unless j-b recognises it as just a PostgreSQL database issue probably safe to assume it is a bug in 3.0.3.
Agreed.