Re: [Pushpool Web Frontend] Simplecoin v4.0 Opensource PHP/MySQL

ok I almost have your pool up I have one sql issue thats causing the site to fail. I get

Code:

PHP Fatal error: Call to a member function fetch() on a non-object in /var/www/simplecoin/includes/stats.php on line 276

So I google some and take a look at line 276, I see its under function usersharecount()

Code:

if ($currentSharesR = $currentSharesQ->fetch()) {

Apparently when the fetch fails it returns a false, and its expecting an object so the error causes more errors Grin

I think my understanding fails at the SQL code above it here:

Code:

$sql = "SELECT count(id) as id FROM shares WHERE id > $lastwinningshare AND username in ('".implode("','",$workers)."')";

I have the database set up properly, it has all the tables, pushpoold is working away I can create a worker (if I comment out the above code) and login and submit shares. Thanks for any help.

edit:
nevermind I found out it was because there was no $lastwinningshare I manually set it to 1 now everything is good (untill i find a block lol)