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.


Attempted to install geolocation statistics option and brought down whole site

Login / Search

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

Fan in training

I clicked something I shouldn't have...

I was in the admin section looking at stats and clicked the button Install geolocation statistics...the system started refreshing the page over and over, with a message saying to let it complete.  How do I undo this??

After about a minute or two, the following came up..

Critical error – bailing out

This is an error that has been elevated to critical error status because it occured 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 occured 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 [UPDATE ocp_sessions SET the_title='An error has occurred', the_zone='adminzone', the_page='admin_stats', the_type='install_data', last_activity=1314322131, the_id='' WHERE (the_session=8740617) LIMIT 1][User 'beary' has exceeded the 'max_questions' resource (current value: 75000)] (version: 7.1.4, PHP version: 5.2.17, URL: /adminzone/index.php?page=admin_stats&type=install_data&lines=2000&position=70000)

Stack trace…

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/failure.php'
Line -> 655
Function -> 'die_html_trace'
Args -> array

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/global2.php'
Line -> 965
Function -> '_fatal_exit'
Args -> array

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/database/mysql.php'
Line -> 246
Function -> 'fatal_exit'
Args -> array

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/database.php'
Line -> 1069
Function -> 'db_query'
Class -> 'Database_Static_mysql'
Object -> Database_Static_mysql::__set_state(array( ))
Type -> '->'
Args -> array ( 0 => 'UPDATE ocp_sessions SET the_title=\'An error has occurred\', the_zone=\'adminzone\', the_page=\'admin_stats\', the_type=\'install_data\', last_activity=1314322131, the_id=\'\' WHERE (the_session=8740617) ', 1 => array ( 0 => NULL, 1 => 'plushpile', ), 2 => 1, 3 => NULL, 4 => false, 5 => false, 6 => false, 7 => false, )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/database.php'
Line -> 750
Function -> '_query'
Class -> 'database_driver'
Object -> database_driver::__set_state(array( 'table_prefix' => 'ocp_', 'connection_read' => array ( 0 => NULL, 1 => 'plushpile', ), 'connection_write' => array ( 0 => NULL, 1 => 'plushpile', ), 'text_lookup_original_cache' => array ( 8 => 'Admin Zone', 2 => 'Admin Zone', 692 => '', 693 => '', 34 => 'Super-moderators', 42 => 'Local', 35 => 'Site staff', 43 => 'Standard member', ), 'text_lookup_cache' => array ( 8 => '', 2 => '', 692 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 693 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 34 => '', 42 => '', 35 => '', 43 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type -> '->'
Args -> array ( 0 => 'UPDATE ocp_sessions SET the_title=\'An error has occurred\', the_zone=\'adminzone\', the_page=\'admin_stats\', the_type=\'install_data\', last_activity=1314322131, the_id=\'\' WHERE (the_session=8740617) ', 1 => 1, 2 => NULL, 3 => false, 4 => false, )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/templates.php'
Line -> 113
Function -> 'query_update'
Class -> 'database_driver'
Object -> database_driver::__set_state(array( 'table_prefix' => 'ocp_', 'connection_read' => array ( 0 => NULL, 1 => 'plushpile', ), 'connection_write' => array ( 0 => NULL, 1 => 'plushpile', ), 'text_lookup_original_cache' => array ( 8 => 'Admin Zone', 2 => 'Admin Zone', 692 => '', 693 => '', 34 => 'Super-moderators', 42 => 'Local', 35 => 'Site staff', 43 => 'Standard member', ), 'text_lookup_cache' => array ( 8 => '', 2 => '', 692 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 693 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 34 => '', 42 => '', 35 => '', 43 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type -> '->'
Args -> array ( 0 => 'sessions', 1 => array ( 'the_title' => 'An error has occurred', 'the_zone' => 'adminzone', 'the_page' => 'admin_stats', 'the_type' => 'install_data', 'last_activity' => 1314322131, 'the_id' => false, ), 2 => array ( 'the_session' => 8740617, ), 3 => '', 4 => 1, )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/failure.php'
Line -> 670
Function -> 'get_page_title'
Args -> array ( 0 => 'ERROR_OCCURED', )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/global2.php'
Line -> 965
Function -> '_fatal_exit'
Args -> array

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/database/mysql.php'
Line -> 246
Function -> 'fatal_exit'
Args -> array

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/database.php'
Line -> 1069
Function -> 'db_query'
Class -> 'Database_Static_mysql'
Object -> Database_Static_mysql::__set_state(array( ))
Type -> '->'
Args -> array ( 0 => 'INSERT INTO ocp_ip_country (begin_num, end_num, country) VALUES (3356034048, 3356035071, \'PY\')', 1 => array ( 0 => NULL, 1 => 'plushpile', ), 2 => NULL, 3 => NULL, 4 => false, 5 => false, 6 => false, 7 => false, )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/database.php'
Line -> 539
Function -> '_query'
Class -> 'database_driver'
Object -> database_driver::__set_state(array( 'table_prefix' => 'ocp_', 'connection_read' => array ( 0 => NULL, 1 => 'plushpile', ), 'connection_write' => array ( 0 => NULL, 1 => 'plushpile', ), 'text_lookup_original_cache' => array ( 8 => 'Admin Zone', 2 => 'Admin Zone', 692 => '', 693 => '', 34 => 'Super-moderators', 42 => 'Local', 35 => 'Site staff', 43 => 'Standard member', ), 'text_lookup_cache' => array ( 8 => '', 2 => '', 692 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 693 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 34 => '', 42 => '', 35 => '', 43 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type -> '->'
Args -> array ( 0 => 'INSERT INTO ocp_ip_country (begin_num, end_num, country) VALUES (3356034048, 3356035071, \'PY\')', 1 => NULL, 2 => NULL, 3 => false, 4 => false, 5 => NULL, 6 => '', 7 => false, )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/adminzone/pages/modules/admin_stats.php'
Line -> 1323
Function -> 'query_insert'
Class -> 'database_driver'
Object -> database_driver::__set_state(array( 'table_prefix' => 'ocp_', 'connection_read' => array ( 0 => NULL, 1 => 'plushpile', ), 'connection_write' => array ( 0 => NULL, 1 => 'plushpile', ), 'text_lookup_original_cache' => array ( 8 => 'Admin Zone', 2 => 'Admin Zone', 692 => '', 693 => '', 34 => 'Super-moderators', 42 => 'Local', 35 => 'Site staff', 43 => 'Standard member', ), 'text_lookup_cache' => array ( 8 => '', 2 => '', 692 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 693 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 34 => '', 42 => '', 35 => '', 43 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type -> '->'
Args -> array ( 0 => 'ip_country', 1 => array ( 'begin_num' => '3356034048', 'end_num' => '3356035071', 'country' => 'PY', ), )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/adminzone/pages/modules/admin_stats.php'
Line -> 197
Function -> 'install_geolocation_data'
Class -> 'Module_admin_stats'
Object -> Module_admin_stats::__set_state(array( ))
Type -> '->'
Args -> array ( )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/zones.php'
Line -> 386
Function -> 'run'
Class -> 'Module_admin_stats'
Object -> Module_admin_stats::__set_state(array( ))
Type -> '->'
Args -> array ( )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/site.php'
Line -> 967
Function -> 'load_module_page'
Args -> array ( 0 => 'adminzone/pages/modules/admin_stats.php', 1 => 'admin_stats', )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/sources/site.php'
Line -> 750
Function -> 'request_page'
Args -> array ( 0 => 'admin_stats', 1 => true, )

File -> '/hermes/bosweb/web046/b463/glo.disposal/plush/adminzone/index.php'
Line -> 51
Function -> 'do_site'
Args -> array ( )

Details here are intended only for the website/system-administrator, not for regular website users.
» If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to  edit the installation options (the info.php file).
ocProducts maintains full documentation for all procedures and tools. These may be found on the ocPortal website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you.

ocPortal is a CMS for building websites, developed by ocProducts.



When trying to get to the front page of the site, we are now getting this:



Critical error – bailing out

The website's first database query (checking the page request is not from a banned IP address) has failed. This almost always means that the database is not set up correctly, which in turns means that either backend database configuration has changed (perhaps the database has been emptied), or the configuration file (info.php) has been incorrectly altered (perhaps to point to an empty database), or you have moved servers and not updated your info.php settings properly or placed your database. It could also mean that the ocp_usersubmitban_ip table orocp_config table alone is missing or corrupt, but this is unlikely. As this is an error due to the website's environment being externally altered by unknown means, the website cannot continue to function or solve the problem itself.
Details here are intended only for the website/system-administrator, not for regular website users.
» If you are a regular website user, please let the website staff deal with this problem.

Depending on the error, and only if the website installation finished, you may need to edit the installation options (the info.php file).
ocProducts maintains full documentation for all procedures and tools. These may be found on the ocPortal website. If you are unable to easily solve this problem, we may be contacted from our website and can help resolve it for you.

ocPortal is a CMS for building websites, developed 

Back to the top
 
Posted
Rating:
#73714
Avatar

Community saint

Looks like you have hit the hourly SQL limit set by your host. This should re-set it self within the hour.

The flashing is normal as its updating the database in chunks (2000 records at a time).

The geolocation data consists of about 105,000 records.

I don't know what is normal for for a typical host, but I've had no problems in the past.

Do you have a Samsung Galaxy S / Galaxy S II ? If so, why not check out my ScreenFree FM Radio .
Back to the top
 
Posted
Rating:
#73720
Avatar

I've only become aware of this particular limit very recently, perhaps it's a fairly new technology to the hosting industry. It's fair enough really.

This will make it use batch queries instead:
Attachment
adminzone/pages/modules/admin_stats.php
» Download: admin_stats.php (61 Kb, 100 downloads so far)

(inserts 100 rows in each single query, i.e. 1% of query total)


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:
#73728
Avatar

Fan in training

Thanks guys,

Board did return to normal after awhile.  We've hit limits on this host before (globat) so this isn't surprising.  They have just recently started promoting ocportal as supported cms software so my guess is it's a new thing for them as well.

Thanks for the quick responses.  The errors had me panicking. :)
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: