Guide 🔥 Prosper202 VPS Install Guide 🔥

Dan D.

New member
Ok,
I started with a fresh install and followed this guide as outlined in this thread.
The only difference to my install was that sellinux was already disabled, so I skipped this part.
It still won't let me create an account?
Tried a normal browser session and incognito as explained.
Any Ideas? Before I try a fresh install again.
1591405619865.png
 

agentf

Well-known member
Community Leader
Sounds like something isn’t right, check log files for the web server see if it can’t shed any light as to what’s happening.

My money is on permissions somewhere
 

Rob12

New member
Hey Guy's,

So last night I upgraded my database to MariaDB 10.3 and ever since then, this is the error I get right after loging in:

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/trackmystuff/public_html/202-config/functions-tracking202.php:2673 Stack trace: #0 /home/trackmystuff/public_html/202-login.php(202): INDEXES::get_ip_id(Object(stdClass)) #1 {main} thrown in /home/trackmystuff/public_html/202-config/functions-tracking202.php on line 2673

I also installed Memcached (which prosper confirmed was working) but I disabled it to make sure that was not the problem.so this is leading me to believe this has to do with upgrading the database to MariaDB 10.3.
 

Rob12

New member
Just another update:

So when I remove this line of code from the functions-tracking202.php, everything works fine and I am able to login without issue:

Code:
  } else {
            $ip_result = _mysqli_query($ip_sql);
            $ip_row = $ip_result->fetch_assoc();
            if ($ip_row['ip_id']) {
                // if this ip already exists, return the ip_id for it.
                $ip_id = $ip_row['ip_id'];
            } else {
                //insert ip
                $ip_id = INDEXES::insert_ip($db,$ip);
            }
        }
      
        //return the ip_id
        return $ip_id;
            }
When I add this code back, then the error comes back. Hopefully, there is a way to fix this without having to remove the code as I'm sure the dev put it there for a reason :)
 

agentf

Well-known member
Community Leader
I'll have a look later at the changes with MariaDB 10.3 if I get the chance but pretty sure i'm running that on all my servers and have installed Prosper202 a number of times!

Maybe @T202Nana can shed some light on to this?
 

T202Nana

Member
Code:
 } else {
            $ip_result = _mysqli_query($ip_sql);
            while($ip_row = $ip_result->fetch_assoc()) {
                // if this ip already exists, return the ip_id for it.
                $ip_id = $ip_row['ip_id'];
            }else{
                //insert ip
                $ip_id = INDEXES::insert_ip($db,$ip);
            }
            
        }
        
        //return the ip_id
        return $ip_id;
         }

Try the above
 

Rob12

New member
Thanks guys, @T202Nana

I got this error after replacing that section:

Code:
 Parse error: syntax error, unexpected 'else' (T_ELSE) in /home/trackmystuff/public_html/202-config/functions-tracking202.php on line 2676
 

agentf

Well-known member
Community Leader
Looks like @T202Nana missed the if statement :p

PHP:
 } else {
            $ip_result = _mysqli_query($ip_sql);
            while($ip_row = $ip_result->fetch_assoc()) {
                if ($ip_row['ip_id']) {
                    // if this ip already exists, return the ip_id for it.
                    $ip_id = $ip_row['ip_id'];
                }else{
                    //insert ip
                    $ip_id = INDEXES::insert_ip($db,$ip);
                }
            }
        
        //return the ip_id
        return $ip_id;
         }
 

Rob12

New member
@agentf this is what I get when using that code above:

Code:
Parse error: syntax error, unexpected 'public' (T_PUBLIC) in /home/trackmystuff/public_html/202-config/functions-tracking202.php on line 2687
 

agentf

Well-known member
Community Leader
ah that's probably down to how the function is declared somewhere else in the code, sorry I won't be able to troubleshoot that without looking at the code which I can't do right now

@T202Nana can you help?
 
Top