Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 19th December 2005, 14:26
flykip flykip is offline
Junior Member
 
Join Date: Dec 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Client can't see entries in the recycle bin

If I login as client I can create a database for my site, if I then delete the database I can't see anything in the recycle bin.
If I login as administrator it's there.
Log back in as client and the recycle bin still shows no entries, but if I click on the [Empty recycle bin] link it does delete it.

The same happens if I create and delete email users.

Regards
Brian
Reply With Quote
Sponsored Links
  #2  
Old 30th January 2006, 23:24
react react is offline
Junior Member
 
Join Date: Jan 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bump because I am seeing the same issue. Any resolution here?
Reply With Quote
  #3  
Old 31st January 2006, 11:07
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,202
Thanks: 829
Thanked 5,420 Times in 4,262 Posts
Default

Have you created the email users as admin or client?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 1st February 2006, 00:33
react react is offline
Junior Member
 
Join Date: Jan 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have tried both ways, creating e-mail users when logged in as admin and then when logged in as client. In both cases admin and reseller can see the entries in the recycle bin but client cannot. When client empties recycle bin the e-mail account is deleted though.
Reply With Quote
  #5  
Old 1st February 2006, 01:02
react react is offline
Junior Member
 
Join Date: Jan 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Taking a look at the logic in isp_kunde/edit/papierkorb.php I see the SQL is as follows:

SELECT tree_id,title,icon,type,doctype_id,doc_id from ".$go_info["modul"]["table_name"]."_nodes where status = '0' and userid = '$userid'"

Unfortunately in thise case $userid is being derived from $_REQUEST["userid"] which is not being passed to the script and is therefore coming in as 0. Looking instead at isp_manager/edit/empty_trash.php which has working SQL we see the following:

SELECT * FROM ".$go_info["modul"]["table_name"]."_nodes where status = 0 and userid = ".$go_info["user"]["userid"])

If I use $go_info["user"]["userid"] instead of $userid in isp_kunde/edit/papierkorb.php it appears to work correctly. Can someone who is more familiar with the code explain which is correct and perhaps why papierkorb.php is not being passed $userid?
Reply With Quote
  #6  
Old 1st February 2006, 10:30
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,202
Thanks: 829
Thanked 5,420 Times in 4,262 Posts
 
Default

Quote:
Originally Posted by react
SELECT * FROM ".$go_info["modul"]["table_name"]."_nodes where status = 0 and userid = ".$go_info["user"]["userid"])
This is the correct query. We will fix it in the next update.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Big client log files Jorem Installation/Configuration 2 13th November 2007 09:52
Empty Recycle Bin jon335 General 40 6th May 2006 11:56
from http to https after installation? Mahir Installation/Configuration 25 7th December 2005 20:40
Getting Client name From a Site & Listing all Users seperately raveneye Feature Requests 0 13th October 2005 20:45
mysqlcheck has found corrupt tables m u r Installation/Configuration 1 18th August 2005 10:47


All times are GMT +2. The time now is 07:26.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.