Hi I'm trying to install 0.98.5 following http://semanticscuttle.sourceforge.net/docs/INSTALL.html with PostgreSQL as the DB and I'm getting the following SQL error. (The deprecated ereg() error is no problem for now.)
<br /> <b>Deprecated</b>: Function ereg() is deprecated in <b>/home/username/SemanticScuttle-0.98.5/src/SemanticScuttle/db/postgres.php</b> on line <b>50</b><br /> <br /> <b>Fatal error</b>: <u>SQL ERROR</u> [ postgresql ]<br /><br />ERROR: column "b.bid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT DISTINCT B.*, U.username, U.name FROM sc_users AS U, ... ^<br /><br /><u>CALLING PAGE</u><br /><br />/bookmarks/index.php&<br /><br /><u>SQL</u><br /><br />SELECT DISTINCT B.*, U.username, U.name FROM sc_users AS U, sc_bookmarks AS B WHERE B.uId = U.uId AND B.bStatus = 0 GROUP BY B.bHash ORDER BY B.bModified DESC LIMIT 10 OFFSET 0<br /> in <b>/home/username/SemanticScuttle-0.98.5/src/SemanticScuttle/db/postgres.php</b> on line <b>481</b><br />
I did not test SemanticScuttle on postgres at all. I don't even have a postgres installation, so you're on your own. Sorry.
Ok. I'll see what I can do.
By the way, I noticed that you have SemanticScuttle on Github as well. Which is the more recent version?
Hi Rad,
Github the mirror of sourceforge. They are both in sync.
-- Regards/Mit freundlichen Grüßen Christian Weiske
-= Geeking around in the name of science since 1982 =-
Got it.
How did you solve the sql problem?
Log in to post a comment.
Hi I'm trying to install 0.98.5 following http://semanticscuttle.sourceforge.net/docs/INSTALL.html with PostgreSQL as the DB and I'm getting the following SQL error. (The deprecated ereg() error is no problem for now.)
I did not test SemanticScuttle on postgres at all. I don't even have a postgres installation, so you're on your own. Sorry.
Ok. I'll see what I can do.
By the way, I noticed that you have SemanticScuttle on Github as well. Which is the more recent version?
Hi Rad,
Github the mirror of sourceforge. They are both in sync.
--
Regards/Mit freundlichen Grüßen
Christian Weiske
-= Geeking around in the name of science since 1982 =-
Got it.
How did you solve the sql problem?