HTML Logo by World Wide Web Consortium ( Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.

devguide (#block_main_comments_devguide_main)

Login / Search

 [ Join | More ]

devguide (#block_main_comments_devguide_main)

This is a spacer post for an ocPortal comment topic. The content this topic relates to: devguide

MySql error

What can I do with this error :
Unfortunately a query has failed [SELECT DISTINCT zone_name FROM ocp2_group_zone_access WHERE (group_id=0) UNION ALL SELECT DISTINCT zone_name FROM ocp2_member_zone_access WHERE member_id=0 AND active_until>1192065060] [You have an error in your SQL syntax near 'UNION ALL SELECT DISTINCT zone_name FROM ocp2_member_zone_access WHERE member_id' at line 1] (ocPortal version: 3.2.4, PHP version: 5.2.4RC4-dev, URL: /cepot/adminzone/index.php?page=admin_setupwizard&type=misc)

What mySQL version does the server have? It looks like you have one too old for ocPortal's requirements, but ocPortal is meant to gracefully degrade in this (still work) - so something is going wrong.

This will help me greatly.



There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: