Error
  • Can't create/write to file '/tmp/#sql_52f2_2.MAI' (Errcode: 28 "No space left on device") SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM w2zbg_content AS a LEFT JOIN w2zbg_categories AS c ON c.id = a.catid LEFT JOIN w2zbg_users AS ua ON ua.id = a.created_by LEFT JOIN w2zbg_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM w2zbg_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN w2zbg_categories as parent ON parent.id = c.parent_id LEFT JOIN w2zbg_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM w2zbg_categories AS cat JOIN w2zbg_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN w2zbg_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-07-24 02:56:16') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-07-24 02:56:16') AND a.catid IN (19) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.created , a.created DESC LIMIT 0, 4 Can't create/write to file '/tmp/#sql_52f2_2.MAI' (Errcode: 28 "No space left on device") SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM w2zbg_content AS a LEFT JOIN w2zbg_categories AS c ON c.id = a.catid LEFT JOIN w2zbg_users AS ua ON ua.id = a.created_by LEFT JOIN w2zbg_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM w2zbg_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN w2zbg_categories as parent ON parent.id = c.parent_id LEFT JOIN w2zbg_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM w2zbg_categories AS cat JOIN w2zbg_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN w2zbg_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-07-24 02:56:16') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-07-24 02:56:16') AND a.catid IN (19) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.created , a.created DESC
  •  

    IT Concultancy

     

    Dreams maker Inc. is a IT consulting services firm specializing in Business Intelligence, E-Business Solutions, and custom solutions, providing IT services for companies in the South Asia regions.Dreams maker Inc. is distinguished by seasoned and exceptional IT consultant professionals with the business acumen to align our customers.more...

  •  

    Real Estate & Land development

     

    Dreamsmaker is the leading online privacy solutions provider with a broad suite of privacy services to help businesses build trust and increase engagement across all of their online channels - including websites, mobile applications, advertising, cloud services, business analytics and email marketing.Over 5,000 web properties including those from top companies.more...

  •  

    Education & Study

     

    Dreamsmaker's mission, based on a "Truth in Privacy" framework, is built on a solid foundation of transparency, choice and accountability regarding the collection and use of personal information. Dreamsmaker's privacy seal is recognized and trusted by millions of consumers as a sign of responsible privacy protection practices.Dreamsmaker's mission, based on.more...

  •  

    Tourism

     

    Over 5,000 web properties including those from top companies like Apple, AT&T, Disney, eBay, HP, Microsoft, Nationwide and Yelp rely on Dreamsmaker to ensure compliance with evolving and complex privacy requirements. Dreamsmaker's mission, based on a "Truth in Privacy" framework, is built on a solid foundation of transparency, choice and accountability.more...

News & Events

About us
Dreamsmaker is the leading online privacy solutions provider with a broad suite of privacy services to help businesses build trust and increase.
Read more ...
Mission & Vision
Dreamsmaker is the leading online privacy solutions provider with a broad suite of privacy services to help businesses build trust and increase.
Read more ...
Our Goal

Lorem invidunt ut labore et dolore. Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt

Read more ...
Award and Achivement
Dreams maker Inc. is a IT consulting services firm specializing in Business Intelligence, E-Business
Read more ...
History & Milestone

Dreamsmaker's mission, based on a "Truth in Privacy" framework, is built on a solid foundation of transparency.

Read more ...