Recent content by BigBlock

Looking at my tables, -1 is an expiration with no limit and the rest are unix times.

Found the solution: select d.`name`, l.* from SubscriptionProperties sp left join Subscriptions s on s.id = sp.subscription_id left join domains d on d.id = s.object_id left join Limits l on l.id = sp.value where sp.`name` = 'limitsId' and l.limit_name = 'expiration' order by value; the...

still does not match up. select s.id, s.object_id, d.name, l.* from Subscriptions s left join domains d on d.id = s.object_id left join Limits l on l.id = s.id where l.limit_name = "expiration" order by d.name DESC; the object id seems to match the domain id, but not the limits... whether you...

I don't see anything in the domains table indicating a subscription ID, the domain id and cl_id do not match the limits table. I don't see any tables indicating they might be a subscription. Where does the subscription ID come from & how does it relate to the domain & limit table? Sorry -...

@IgorG - I see you found the question on stackexchange as well. I have not tested your solution, it may work fine, but I'm running the report from a replicated copy of the psa database [I run a nightly backup of the production environment to my development environment] & the plesk...

I used to have this neat little report that ran on a dashboard I have for my daily stuff that would report on the expiration dates of all my hosted plesk domains [Plesk 9] It looked like this: select d.name, l.* from Limits l left join domains d on l.id =d.id where l.limit_name =...

I'm getting the same errors while trying to delete a domain, I can see it in the domains table, but how do I find out what IP address it's supposed to be using?

As the title says, how do I add a path to the open_basedir in Plesk for all domains? I have to change the open_basedir value for all domains from: {DOCROOT}/:/tmp/ to: {DOCROOT}/:/tmp/:/var/www/vhosts/{DOMAIN?}/ I know where to do it, I just don't know what the variable is for the...