The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/portal.php 39 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!

Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums



(Advanced Search)

Forum Statistics
» Members: 1,007
» Latest member: kavitasinghji
» Forum threads: 1,324
» Forum posts: 7,788

Full Statistics

Online Users
There are currently 621 online users.
» 0 Member(s) | 619 Guest(s)
Bing, Google

Latest Threads
UserSpice Alpha Testing a...
Forum: News Center
Last Post: ivinsons
11-08-2024, 06:13 PM
» Replies: 13
» Views: 42,475
UserSpice 4.4 Development
Forum: News Center
Last Post: Amelie12
09-21-2024, 12:23 PM
» Replies: 4
» Views: 15,199
Welcome to the new UserSp...
Forum: News Center
Last Post: ivinsons
08-25-2024, 07:39 AM
» Replies: 2
» Views: 27,918
How to use hasPerm
Forum: UserSpice 4.4
Last Post: mudmin
07-20-2019, 02:45 PM
» Replies: 1
» Views: 13,755
Session issue? What I sho...
Forum: UserSpice 4.4
Last Post: Parth
07-17-2019, 05:06 PM
» Replies: 4
» Views: 14,502
Email Error
Forum: UserSpice 4.4
Last Post: Brandin
07-17-2019, 04:47 PM
» Replies: 1
» Views: 6,623
{ Missing Text } after up...
Forum: UserSpice 4.4
Last Post: Brandin
07-16-2019, 04:23 PM
» Replies: 22
» Views: 53,638
Best Practice Info
Forum: New to UserSpice?
Last Post: Brandin
07-16-2019, 11:55 AM
» Replies: 1
» Views: 13,490
Force to use 2FA -always-
Forum: UserSpice 4.4
Last Post: Brandin
07-12-2019, 12:43 PM
» Replies: 1
» Views: 6,636
e-mail not verifying
Forum: UserSpice 4.4
Last Post: LBC
07-10-2019, 11:34 AM
» Replies: 31
» Views: 76,232

 
  How to make index.php starting page
Posted by: Nicolas - 10-31-2018, 05:28 PM - Forum: UserSpice 4.3 and Below - Replies (4)

Hello,
I'm very new to US, i'm trying to figure out how it works.
I found that i should place my files in the directory /userc. This works fine (as expected)
I want to use index.php as my starting page where users can login or register.
But if i copy index.php from root to /userc/ and modifie some text to distinguish from the one in root and go to my website: localhost/spice/ i still get the original index.php from the root. I also modified

PHP Code:
require_once '../users/init.php'

which works with other pages.
Should i edit index.php from the root to change it into what i want? or am i doing something wrong? As i understand that at an upgrade the index.php from the root will be overwrote by the new one.
Best regards,
Nicolas


  $db->query with "LIMIT ? OFFSET ?" not working.
Posted by: larry.giroux@qcdatabase.com - 10-28-2018, 05:28 PM - Forum: UserSpice 4.3 and Below - Replies (4)

This query will not work if I try to bind the limit and the offset. I works fine if I type in 'LIMIT 20 OFFSET 0'.

Code:
$q = 'SELECT *, DATE_FORMAT(l.date, "%m/%d/%Y") as `date`
FROM db_listings l 
WHERE l.omit=0 
AND l.closed=0 
ORDER BY l.id DESC 
LIMIT ? OFFSET ?;';


This line binds the variables.

Code:
$db->query($q,array($arr['lim'],$arr['off']));


I had to go into the query method of the userspice DB class and add a line...
Code:
public function query($sql, $params = array()){
    $this->_pdo->setAttribute( PDO::ATTR_EMULATE_PREPARES, false ); /* ADDED LINE */

Now it works fine. I cannot figure out why it won't work otherwise. I am using uniform server with php 7.1.1 and MySQL 5.6.35. I am new to PDO. I never had issues like this with mysqli. Is this something I am doing wrong?


  us_user_sessions not inserting
Posted by: jholzbach - 10-19-2018, 06:45 PM - Forum: UserSpice 4.3 and Below - Replies (1)

I am having a issue where randomly a row is not created in us_user_sessions when a user logins.  Because of this almost immediately the user is logged out and redirected back to the home page.  In the logs this indicated as the user logged out due to expired session since they didn't have one.  I have been trying to debug the issue but is being tricky to replicate.  I went and added custom logs to storeUser function trying to determine what happening, but of course it decides not to have the error occur anymore for the one account that had been experiencing the issue. 

At the moment this seems to only occur in Google Chrome!.  Has anyone encountered this issue before, and have any idea how to fix it?  The application I am developing is intended to be used primarily in Chrome so users need to be able to login consistently.

Any help here would be greatly appreciated.


  Live website doesn't update when I change code
Posted by: mitchw - 10-19-2018, 03:55 AM - Forum: UserSpice 4.4 - Replies (7)

Hi there, 

Firstly I would like to say what an amazing product you have. However, I am experiencing some issues. Whenever I update any code e.g I remeoved <a class="" href="<?=$us_url_root?>"><img class="img-responsive" src="<?=$us_url_root?>users/images/logo.png" alt="" /></a> from navigation.php and uploaded it to remove the logo entirely the code that has been uploaded in the CPannel editor shows this line gone but the live site still has a logo and shows the reference to logo.png as still being there.

Any help would be greatly appreciated.

Thanks


  Database Connection Test Unsuccessful
Posted by: jlholzbach - 10-17-2018, 08:57 PM - Forum: UserSpice 4.3 and Below - Replies (1)

I am trying to set up UserSpice as I am exploring using for a project I am currently working on.  I have made it to the step where it asks for the database information. I know the information I am entering is correct because I was able to successfully create a database connection using the credentials in a PHP file. 

I had been following the video on the home page and noticed one difference is that there is a space for entering a copyright message, which isn't in the video. Now that doesn't appear to be required field, but is there any chance this could be causing an error.  Also when I try to test the settings it display that it is importing the tables and to wait a moment will also displaying the database connection unsuccessful message at the bottom. Could it be possible there is a bug in the version I downloaded? 

Is there an older version available somewhere that I could try to see if that works?


  during_user_creation script problems
Posted by: eforbes - 10-17-2018, 04:00 PM - Forum: UserSpice 4.3 and Below - Replies (3)

I have been having some problems with the during_user_creation.php script.  I made an extra field in the users table called acount_id.
I tried the example code:
 $db->update('users',$theNewId,['account_id'=>Input::get('account_id')]); 

and nothing happend.

I uncommented dump($_POST); to see what was going on and after creating the user, the page did not show any dump info.


  Manually adding a user
Posted by: lordtopcat - 10-17-2018, 12:02 AM - Forum: UserSpice 4.3 and Below - Replies (2)

Hi,

When I manually add a user in the admin panel, it automatically logs me in as that user?

How can I stop that happening please?

Cheers,
Jamie


  New Admin group, user blocked when updating user
Posted by: lordtopcat - 10-16-2018, 08:56 PM - Forum: UserSpice 4.3 and Below - Replies (2)

Hi there,

I've created another group called "Junior Admins".

I've added a test user to this group, but every time the test user attempts to edit a standard user, they are blocked!! 

I've tested various different permissions, even adding EVERYTHING to this new permission group, and they still get blocked.

Have I missed something?

Cheers,
Jamie


  db updates
Posted by: jtullett - 10-13-2018, 07:24 PM - Forum: UserSpice 4.3 and Below - Replies (2)

Hi again

Question: when UserSpice updates, does it leave the database alone apart from adding any new tables/columns? I want to add some triggers to it, and I'd be sad if they were quietly removed without warning. I'll check first, obviously, but in the past would updates have removed them?

-Jon


  No data insertion. (URGENT HELP)
Posted by: eforbes - 10-12-2018, 12:06 AM - Forum: UserSpice 4.4 - Replies (1)

I created the form from a database table and when i click submit, no record is showing in the table.

<?php
/*
UserSpice 4
An Open Source PHP User Management System
by the UserSpice Team at http://UserSpice.com
This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
?>
<?php require_once '../users/init.php'; ?>
<?php require_once $abs_us_root.$us_url_root.'users/includes/header.php'; ?>
<?php require_once $abs_us_root.$us_url_root.'users/includes/navigation.php'; ?>
<?php if (!securePage($_SERVER['PHP_SELF'])){die();} ?>
<?php
if(!empty($_POST)){
preProcessForm();
}


?>
 <div id="page-wrapper">
 <!-- Page Heading -->
           
          
              <!-- /.row -->


    <div class="container">
       
            <div class="row">
                  <div class="col-xs-12 col-md-10">
  <input type="hidden" name="csrf" value="<?=Token::generate()?>" />
                  <? displayForm('members'); ?>
               
            </div>
        </div>
    </div>
<?php processForm(['debug'=>1]); ?> 
</div> <!-- /container -->

</div> <!-- /#page-wrapper -->

</body>
</html>