HTML Logo by World Wide Web Consortium (www.w3.org). 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 compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Unable to install

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#97169 (In Topic #19278)
Avatar

Fan in training

New here, i know html and css, but I'm not experienced at all with CMS's...  I'm having a hard time getting ocPortal to install.  Any wisdom is appreciated:

I just did a manual install of the latest release of ocPortal (no add-ons, themes, plugins or other extra's were installed), chmod'ed all permissions, and wanted to proceed to the adminzone to set up my website. I then got the following error message:

------------
Critical error – bailing out
This is an error that has been elevated to critical error status because it occurred during the primary error mechanism reporting system itself (possibly due to it occuring within the standard output framework). It may be masking a secondary error that occurred before this, but was never output - if so, it is likely strongly related to this one, thus fixing this will fix the other.
Unfortunately a query has failed [SHOW OPEN TABLES FROM `omegaiar` WHERE `Table`='ocp_sessions' AND In_use>=1] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `Table`='ocp_sessions' AND In_use>=1' at line 1] (version: 9.0.7, PHP version: 5.2.8, URL: /adminzone/index.php)
------------

Additional info: My first attempt was to use the quick installer, but this failed because "php doesn't have ftp access" (?). When doing the manual install I was warned that I had an old version of MySQL. However, according to my hosting provider (and according to phpMyAdmin), I run MySQL 4.1.20 which should be sufficient to run ocPortal -- i.e. I don't understand the old-version-warning. The warning advised me to add a file "mysql_old" to my root directory. After I got the above error message, I added such a file, but that made no difference. I tried to edit the info.php file, but didn't see any option that could be relevant (tried to change the mod_rewrite option, but that didn't make a difference, and tried to chance the domain from xyz.com to www.xyz.com, but that also didn't change the error).

Anybody have any idea what might be the problem?

kind regards,
Hendrik Jan

Back to the top
 
Posted
Rating:
#97171
Avatar

It looks like we have accidentally broken support for older versions of MySQL.

However, MySQL 5 was released 9 years ago and MySQL 4.1 hasn't had a patch in 4 years… the host really should upgrade.

I'll look into working around the issue, as we do need to ensure ocPortal does meet the stated minimum requirements.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97173
Avatar

this failed because "php doesn't have ftp access" (?)

If the server does not have SuExec, and has no PHP FTP extension, there's no method it can use to extract the files.

When doing the manual install I was warned that I had an old version of MySQL. However, according to my hosting provider (and according to phpMyAdmin), I run MySQL 4.1.20 which should be sufficient to run ocPortal – i.e. I don't understand the old-version-warning

I believe your server's MySQL client library is not matching up to the server's MySQL server version. It should really, and ocPortal assumes they are the same – hence the warning here.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Important!
Posted
Rating:
#97176
Avatar

Automated fix message

HJ Veenstra said

New here, i know html and css, but I'm not experienced at all with CMS's...  I'm having a hard time getting ocPortal to install.  Any wisdom is appreciated:

I just did a manual install of the latest release of ocPortal (no add-ons, themes, plugins or other extra's were installed), chmod'ed all permissions, and wanted to proceed to the adminzone to set up my website. I then got the following error message:

------------
Critical error – bailing out
This is an error that has been elevated to critical error status because it occurred during the primary error mechanism reporting system itself (possibly due to it occuring within the standard output framework). It may be masking a secondary error that occurred before this, but was never output - if so, it is likely strongly related to this one, thus fixing this will fix the other.
Unfortunately a query has failed [SHOW OPEN TABLES FROM `omegaiar` WHERE `Table`='ocp_sessions' AND In_use>=1] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `Table`='ocp_sessions' AND In_use>=1' at line 1] (version: 9.0.7, PHP version: 5.2.8, URL: /adminzone/index.php)
------------

Additional info: My first attempt was to use the quick installer, but this failed because "php doesn't have ftp access" (?). When doing the manual install I was warned that I had an old version of MySQL. However, according to my hosting provider (and according to phpMyAdmin), I run MySQL 4.1.20 which should be sufficient to run ocPortal -- i.e. I don't understand the old-version-warning. The warning advised me to add a file "mysql_old" to my root directory. After I got the above error message, I added such a file, but that made no difference. I tried to edit the info.php file, but didn't see any option that could be relevant (tried to change the mod_rewrite option, but that didn't make a difference, and tried to chance the domain from xyz.com to www.xyz.com, but that also didn't change the error).

Anybody have any idea what might be the problem?

kind regards,
Hendrik Jan

This issue has been filed on the tracker as issue #1237, with a fix.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Important!
 
Posted
Rating:
#97181
Avatar

Fan in training

Chris Graham said

It looks like we have accidentally broken support for older versions of MySQL.

However, MySQL 5 was released 9 years ago and MySQL 4.1 hasn't had a patch in 4 years… the host really should upgrade.

I'll look into working around the issue, as we do need to ensure ocPortal does meet the stated minimum requirements.

Dang!  That's blazingly fast – amazing!  Thx Chris.  And yes, I know 4.1 is old.  I contacted them about it and they seem to have had sw-compilation problems, having to do with their server software or whatever…  Pity really.  They are on the subject, but if they don't resolve it fast enough I will consider switching hosts.  I'd hate to do that though since they're British as well, and I have a weak spot for the Brits. ;)
Back to the top
 
Posted
Rating:
#97182
Avatar

Fan in training

Chris Graham said

This issue has been filed on the tracker as issue #1237, with a fix.

Pardon my ignorance, but I suppose this means I have to reinstall the entire package?  No problem if it does – just want to make sure I don't go through all the hoops again for nothing…
And… your speed & service is beyond belief, esp. considering that it's a Saturday.  Compliments from flatland.
Back to the top
 
Posted
Rating:
#97183
Avatar

Hey,

Just extract sources/database.php (inside the tar) to the server. All I did was to make the new ocPortal lock contention code silently fail on MySQL 4.1, which is fine - we've got up to ocPortal 9.0.7 without needing it, it's only useful on particularly high traffic sites.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97184
Avatar

Fan in training

Chris Graham said

Just extract sources/database.php (inside the tar) to the server.

I'd figured that out indeed :).  Weird.. I thought I'd posted about that.  Oh well…  Thanks again for your fast service.  Hope all goes well from now on…
Back to the top
 
Posted
Rating:
#97185
Avatar

Fan in training

Unfortunately it's not all roses yet... (even though the software does look more than promising!).  After running the Setup Wizard I got an error in step 10 -- some directory not having the right permissions.  I changed permissions to 777, ran the Wizard again, and got the same error for *another* directory.  Changed permissions, Wizard once more... and again...

The last one was: Cannot write to /home/www/omegaiar/sources/hooks/systems/meta/authors.php. File permissions for it (or the directory it is in) have not been set correctly

I don't mind running the wizard a few times, but I start having the feeling something else is wrong here -- or I have to change permissions of the entire filetree to 777 or ... whatever.  Doing this 1 by 1 doesn't feel right.  No idea if it helps, but the stack trace of this last error is thus:

File -> '/home/www/omegaiar/sources/failure.php'
Line -> 792
Function -> 'die_html_trace'
Args -> array

File -> '/home/www/omegaiar/sources/global2.php'
Line -> 1012
Function -> '_fatal_exit'
Args -> array

File -> '/home/www/omegaiar/sources/failure.php'
Line -> 244
Function -> 'fatal_exit'
Args -> array

File -> '/home/www/omegaiar/sources/global2.php'
Line -> 972
Function -> '_generic_exit'
Args -> array

File -> '/home/www/omegaiar/sources/support.php'
Line -> 347
Function -> 'warn_exit'
Args -> array

File -> '/home/www/omegaiar/sources/abstract_file_manager.php'
Line -> 735
Function -> 'intelligent_write_error'
Args -> array ( 0 => '/home/www/omegaiar/sources/hooks/systems/meta/authors.php', )

File -> '/home/www/omegaiar/sources/addons.php'
Line -> 730
Function -> 'afm_delete_file'
Args -> array ( 0 => 'sources/hooks/systems/meta/authors.php', )

File -> '/home/www/omegaiar/adminzone/pages/modules/admin_setupwizard.php'
Line -> 776
Function -> 'uninstall_addon'
Args -> array ( 0 => 'authors', )

File -> '/home/www/omegaiar/adminzone/pages/modules/admin_setupwizard.php'
Line -> 77
Function -> 'step10'
Class -> 'Module_admin_setupwizard'
Type -> '->'
Object -> Module_admin_setupwizard::__set_state(array( ))
Args -> array ( )

File -> '/home/www/omegaiar/sources/zones.php'
Line -> 425
Function -> 'run'
Class -> 'Module_admin_setupwizard'
Type -> '->'
Object -> Module_admin_setupwizard::__set_state(array( ))
Args -> array ( )

File -> '/home/www/omegaiar/sources/site.php'
Line -> 858
Function -> 'load_module_page'
Args -> array ( 0 => 'adminzone/pages/modules/admin_setupwizard.php', 1 => 'admin_setupwizard', )

File -> '/home/www/omegaiar/sources/site.php'
Line -> 646
Function -> 'request_page'
Args -> array ( 0 => 'admin_setupwizard', 1 => true, )

File -> '/home/www/omegaiar/adminzone/index.php'
Line -> 39
Function -> 'do_site'
Args -> array ( )


Back to the top
 
Posted
Rating:
#97187
Avatar

Essentially this web server is very poorly configured. Without FTP and SuExec, there is no way ocPortal can manage its files unless everything is made world-writable. I don't actually ever recall a situation where a proper server has had neither, right back when we started in 2004.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97189
Avatar

Fan in training

Chris Graham said

Essentially this web server is very poorly configured. Without FTP and SuExec, there is no way ocPortal can manage its files unless everything is made world-writable. I don't actually ever recall a situation where a proper server has had neither, right back when we started in 2004.

Chris, your post coincides with the conclusion I had drawn in the meantime: my hosting service s*cks.  An entire day wasted… but not completely, as I come out a lot wiser.  I've just filled in the entire registration form on belief.com, thx to your recommendation someplace else on this site.  2 years of hosting for just $111 is only 20 euros more expensive than what I pay now at yorhost.net.

You've been amazingly helpful today.  Bonus karma-points to you :).  I'll stick with ocPortal, once I've activated my domain on the new servers and redirected the name servers.   Looking forward to running the quick-installer :-).

Time for a beer – we both deserve it…

cheers, Hendrik Jan
Back to the top
 
Posted
Rating:
#97196
Avatar

Fan in training

Switched hosting to eLief yesterday, changed name servers, and this morning ran the quick installer again, now on the new domain.  Again errors all over the place (missing files -- weird, eh?).  Then I discovered eLief's one-click installer in the admin control panel (seems they have the latest version of ocPortal), which gave me a functioning install in a matter of minutes.  Ultracool...

Unfortunately I'll be away from home for the rest of the day, so the real work will have to wait, but for now I'm one happy camper.  Thanks again Chris...

tty, HJ
Back to the top
 
Posted
Rating:
#97209
Avatar

Again errors all over the place (missing files – weird, eh?)

Hmm, what kind of errors? Definitely there should be no install problem on eLief for a fresh install :S.

seems they have the latest version of ocPortal

Yes, we help maintain automated installers across a few platforms.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97221
Avatar

Fan in training

Chris Graham said

Again errors all over the place (missing files – weird, eh?)

Hmm, what kind of errors? Definitely there should be no install problem on eLief for a fresh install :S.

I forgot to make a note, sorry – I was busy being too p*ssed to think clear :).  I do remember it was a banners.xxx file missing – imports/addons/banners.tar maybe?

seems they have the latest version of ocPortal

Yes, we help maintain automated installers across a few platforms.

I just ran the latest update (906 to 907) from the adminzone, but now I can't get back into the adminzone anymore…  I'm feel I'm losing my patience a  bit…  Stack trace follows.  Sigh…

PHP NOTICE [8] Undefined offset: 3 in sources/site.php on line 1305 (version: 9.0.7, PHP version: 5.2.17, URL: /adminzone/index.php?page=start)

Stack trace…

File -> '/home/omegaart/public_html/sources/failure.php'
Line -> 792
Function -> 'die_html_trace'
Args -> array ( 0 => 'PHP NOTICE [8] Undefined offset: 3 in sources/site.php on line 1305 (version: 9.0.7, PHP version: 5.2.17, URL: /adminzone/index.php?page=start)', )
File -> '/home/omegaart/public_html/sources/global2.php'
Line -> 1012
Function -> '_fatal_exit'
Args -> array ( 0 => 'PHP NOTICE [8] Undefined offset: 3 in sources/site.php on line 1305', )
File -> '/home/omegaart/public_html/sources/failure.php'
Line -> 224
Function -> 'fatal_exit'
Args -> array ( 0 => 'PHP NOTICE [8] Undefined offset: 3 in sources/site.php on line 1305', )
File -> '/home/omegaart/public_html/sources/global2.php'
Line -> 875
Function -> '_ocportal_error_handler'
Args -> array ( 0 => 'notice', 1 => 8, 2 => 'Undefined offset: 3', 3 => 'sources/site.php', 4 => 1305, )
File -> '/home/omegaart/public_html/sources/site.php'
Line -> 1305
Function -> 'ocportal_error_handler'
Args -> array
File -> '/home/omegaart/public_html/sources/site.php'
Line -> 883
Function -> 'load_comcode_page'
Args -> array ( 0 => 'adminzone/pages/comcode/EN/start.txt', 1 => 'adminzone', 2 => 'start', 3 => NULL, 4 => false, )
File -> '/home/omegaart/public_html/sources/site.php'
Line -> 646
Function -> 'request_page'
Args -> array ( 0 => 'start', 1 => true, )
File -> '/home/omegaart/public_html/adminzone/index.php'
Line -> 39
Function -> 'do_site'
Args -> array ( )
Back to the top
 
Posted
Rating:
#97224
Avatar

I forgot to make a note, sorry - I was busy being too p*ssed to think clear .  I do remember it was a banners.xxx file missing

Usually it's only the manual installer that checks for missing files, and if they were it'd probably be an issue with them truly being missing (i.e. FTP failed on that file for some reason).

I just ran the latest update (906 to 907) from the adminzone, but now I can't get back into the adminzone anymore…

Did you run the cache clearing step?


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97226
Avatar

Fan in training

Chris Graham said

I just ran the latest update (906 to 907) from the adminzone, but now I can't get back into the adminzone anymore…

Did you run the cache clearing step?

Ehrm… nope.  I got a successful install, came back in the Admin panel, and hit the home button.  Bingo, error.

I just did the ctrl-alt-shift-reload trick and got back in.  Great – thx for pointing me in the right direction.
Back to the top
 
Posted
Rating:
#97228
Avatar

The cache clearing step is a part of the upgrade process, step 7 of 8. For this upgrade it is required as we changed the format of one of the caches.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97229
Avatar

Fan in training

Chris Graham said

The cache clearing step is a part of the upgrade process, step 7 of 8. For this upgrade it is required as we changed the format of one of the caches.

I don't see how I could have missed it then.  I don't recall a 'next' button, or a "please now do step 7" kind of thingy.  And I wonder what step 8 of 8 was, which I also must have skipped…
Everything seems hunky dory again though…
Back to the top
 
Posted
Rating:
#97232
Avatar

If you go back into /upgrader.php you'll see there's a table of steps. But don't worry about 8, it's only required if you'd closed the site to do the upgrade.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#97241
Avatar

Fan in training

Chris Graham said

If you go back into /upgrader.php you'll see there's a table of steps. But don't worry about 8, it's only required if you'd closed the site to do the upgrade.

OK, I get it – thanks.  Now back to trying to get a grip on things.  For now my head is spinning…
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Expand