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.


Error I think it has to do with POLLS

Login / Search

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

Community saint

After upgrading to 6.0.1 I get this error message

After upgrading to 6.0.1 I get this error message when I try to access the home page (site page) which contains a POLL block.

An error has occurred

Unfortunately a query has failed [SELECT id FROM ocp4_poll_votes WHERE v_poll_id=7 AND (v_voter_id=2 OR v_voter_ip='76.104.219.185') LIMIT 1] [Table 'prehisto_prehisto.ocp4_poll_votes' doesn't exist] (version: 6.0.1, PHP version: 5.2.11, URL: /site/index.php?page=start)

Here is the stack trace:

Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check ocPortal website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File'/home/prehisto/public_html/sources/failure.php'
Line'658'
Function'get_html_trace'
Args 

File'/home/prehisto/public_html/sources/global2.php'
Line'922'
Function'_fatal_exit'
Argsobject
 

File'/home/prehisto/public_html/sources/database/mysql.php'
Line'240'
Function'fatal_exit'
Argsobject
 

File'/home/prehisto/public_html/sources/database.php'
Line'1,063'
Function'db_query'
Class'Database_Static_mysql'
Type'->'
ObjectDatabase_Static_mysql::__set_state(array( ))
Args'SELECT id FROM ocp4_poll_votes WHERE v_poll_id=7 AND (v_voter_id=2 OR v_voter_ip=\'76.104.219.185\')'

array ( 0 => NULL, 1 => 'prehisto_prehisto', )

1

NULL

false

false

false

false
 

File'/home/prehisto/public_html/sources/database.php'
Line'937'
Function'_query'
Class'database_driver'
Type'->'
Objectdatabase_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 9 => 'Site', 4 => 'The Fascinating World of Dinosaurs and Prehistoric Creatures of all Kinds', 59741 => '', 7 => 'Welcome', 8 => 'Admin Zone', 11 => 'Content Management', 10 => 'Collaboration Zone', 14 => 'Forums', 15 => 'Personal Zone', 1 => 'The Fascinating World of Dinosaurs and Prehistoric Creatures of all Kinds', 2 => 'Admin Zone', 5 => 'Content Management', 3 => 'Collaboration Zone', 12 => 'Forum', 13 => 'Personal Zone', 43768 => 'Dino Popularity Poll #3 - Vote: Which Ceratopsian Dinos is Your favorite?', 43769 => 'Triceratops is my favorite.', 43770 => 'Protoceratops is my favorite.', 43771 => 'Styracosaurus is my favorite.', 43772 => 'Udanoceratops is my favorite.', 43773 => '', 43774 => '', 43775 => '', 43776 => '', 43777 => '', 43778 => '', ), 'text_lookup_cache' => array ( 78 => '', 79 => '', 36 => '', 37 => '', 9 => '', 4 => '', 59741 => '', 7 => '', 8 => '', 11 => '', 10 => '', 14 => '', 15 => '', 1 => '', 2 => '', 5 => '', 3 => '', 12 => '', 13 => '', 43768 => '', 43769 => '', 43770 => '', 43771 => '', 43772 => '', 43773 => '', 43774 => '', 43775 => '', 43776 => '', 43777 => '', 43778 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args'SELECT id FROM ocp4_poll_votes WHERE v_poll_id=7 AND (v_voter_id=2 OR v_voter_ip=\'76.104.219.185\')'

1

NULL

false

false

NULL

''
 

File'/home/prehisto/public_html/sources/database.php'
Line'630'
Function'query'
Class'database_driver'
Type'->'
Objectdatabase_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 9 => 'Site', 4 => 'The Fascinating World of Dinosaurs and Prehistoric Creatures of all Kinds', 59741 => '', 7 => 'Welcome', 8 => 'Admin Zone', 11 => 'Content Management', 10 => 'Collaboration Zone', 14 => 'Forums', 15 => 'Personal Zone', 1 => 'The Fascinating World of Dinosaurs and Prehistoric Creatures of all Kinds', 2 => 'Admin Zone', 5 => 'Content Management', 3 => 'Collaboration Zone', 12 => 'Forum', 13 => 'Personal Zone', 43768 => 'Dino Popularity Poll #3 - Vote: Which Ceratopsian Dinos is Your favorite?', 43769 => 'Triceratops is my favorite.', 43770 => 'Protoceratops is my favorite.', 43771 => 'Styracosaurus is my favorite.', 43772 => 'Udanoceratops is my favorite.', 43773 => '', 43774 => '', 43775 => '', 43776 => '', 43777 => '', 43778 => '', ), 'text_lookup_cache' => array ( 78 => '', 79 => '', 36 => '', 37 => '', 9 => '', 4 => '', 59741 => '', 7 => '', 8 => '', 11 => '', 10 => '', 14 => '', 15 => '', 1 => '', 2 => '', 5 => '', 3 => '', 12 => '', 13 => '', 43768 => '', 43769 => '', 43770 => '', 43771 => '', 43772 => '', 43773 => '', 43774 => '', 43775 => '', 43776 => '', 43777 => '', 43778 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args'SELECT id FROM ocp4_poll_votes WHERE v_poll_id=7 AND (v_voter_id=2 OR v_voter_ip=\'76.104.219.185\')'

1

NULL

false

false
 

File'/home/prehisto/public_html/sources/polls.php'
Line'128'
Function'query_value_null_ok_full'
Class'database_driver'
Type'->'
Objectdatabase_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 9 => 'Site', 4 => 'The Fascinating World of Dinosaurs and Prehistoric Creatures of all Kinds', 59741 => '', 7 => 'Welcome', 8 => 'Admin Zone', 11 => 'Content Management', 10 => 'Collaboration Zone', 14 => 'Forums', 15 => 'Personal Zone', 1 => 'The Fascinating World of Dinosaurs and Prehistoric Creatures of all Kinds', 2 => 'Admin Zone', 5 => 'Content Management', 3 => 'Collaboration Zone', 12 => 'Forum', 13 => 'Personal Zone', 43768 => 'Dino Popularity Poll #3 - Vote: Which Ceratopsian Dinos is Your favorite?', 43769 => 'Triceratops is my favorite.', 43770 => 'Protoceratops is my favorite.', 43771 => 'Styracosaurus is my favorite.', 43772 => 'Udanoceratops is my favorite.', 43773 => '', 43774 => '', 43775 => '', 43776 => '', 43777 => '', 43778 => '', ), 'text_lookup_cache' => array ( 78 => '', 79 => '', 36 => '', 37 => '', 9 => '', 4 => '', 59741 => '', 7 => '', 8 => '', 11 => '', 10 => '', 14 => '', 15 => '', 1 => '', 2 => '', 5 => '', 3 => '', 12 => '', 13 => '', 43768 => '', 43769 => '', 43770 => '', 43771 => '', 43772 => '', 43773 => '', 43774 => '', 43775 => '', 43776 => '', 43777 => '', 43778 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args'SELECT id FROM ocp4_poll_votes WHERE v_poll_id=7 AND (v_voter_id=2 OR v_voter_ip=\'76.104.219.185\')'
 

File'/home/prehisto/public_html/sources/polls.php'
Line'142'
Function'may_vote_in_poll'
Argsarray ( 'id' => 7, 'question' => 43768, 'option1' => 43769, 'option2' => 43770, 'option3' => 43771, 'option4' => 43772, 'option5' => 43773, 'option6' => 43774, 'option7' => 43775, 'option8' => 43776, 'option9' => 43777, 'option10' => 43778, 'votes1' => 8, 'votes2' => 3, 'votes3' => 8, 'votes4' => 3, 'votes5' => 0, 'votes6' => 0, 'votes7' => 0, 'votes8' => 0, 'votes9' => 0, 'votes10' => 0, 'allow_rating' => 0, 'allow_comments' => 2, 'allow_trackbacks' => 0, 'notes' => '', 'num_options' => 4, 'ip' => '-98.237.145.98-2-98.237.145.98-30-90.237.187.94-1-76.104.219.185-1-162.115.236.101-1-75.168.240.54-22-90.236.187.91-1-81.165.22.82-48-188.125.115.253-1-96.237.101.64-1-118.90.72.243-1-189.62.88.120-1-68.174.223.43-50-189.167.74.125-1-76.7.195.144-1-66.53.229.205-56-170.211.109.61-65-79.117.179.43-1-90.194.38.98-1-98.87.16.102-1-68.232.70.142-1-166.205.15.50-1-12.177.23.62-1', 'is_current' => 1, 'date_and_time' => 1299908391, 'submitter' => 2, 'add_time' => 1277149152, 'poll_views' => 185, 'edit_date' => 1299908391, 't0__text_original' => 'Dino Popularity Poll #3 - Vote: Which Ceratopsian Dinos is Your favorite?', 't0__text_parsed' => '', 't1__text_original' => 'Triceratops is my favorite.', 't1__text_parsed' => '', 't2__text_original' => 'Protoceratops is my favorite.', 't2__text_parsed' => '', 't3__text_original' => 'Styracosaurus is my favorite.', 't3__text_parsed' => '', 't4__text_original' => 'Udanoceratops is my favorite.', 't4__text_parsed' => '', 't5__text_original' => '', 't5__text_parsed' => '', 't6__text_original' => '', 't6__text_parsed' => '', 't7__text_original' => '', 't7__text_parsed' => '', 't8__text_original' => '', 't8__text_parsed' => '', 't9__text_original' => '', 't9__text_parsed' => '', 't10__text_original' => '', 't10__text_parsed' => '', )
 

File'/home/prehisto/public_html/sources/polls.php'
Line'63'
Function'show_poll'
Argsfalse

array ( 'id' => 7, 'question' => 43768, 'option1' => 43769, 'option2' => 43770, 'option3' => 43771, 'option4' => 43772, 'option5' => 43773, 'option6' => 43774, 'option7' => 43775, 'option8' => 43776, 'option9' => 43777, 'option10' => 43778, 'votes1' => 8, 'votes2' => 3, 'votes3' => 8, 'votes4' => 3, 'votes5' => 0, 'votes6' => 0, 'votes7' => 0, 'votes8' => 0, 'votes9' => 0, 'votes10' => 0, 'allow_rating' => 0, 'allow_comments' => 2, 'allow_trackbacks' => 0, 'notes' => '', 'num_options' => 4, 'ip' => '-98.237.145.98-2-98.237.145.98-30-90.237.187.94-1-76.104.219.185-1-162.115.236.101-1-75.168.240.54-22-90.236.187.91-1-81.165.22.82-48-188.125.115.253-1-96.237.101.64-1-118.90.72.243-1-189.62.88.120-1-68.174.223.43-50-189.167.74.125-1-76.7.195.144-1-66.53.229.205-56-170.211.109.61-65-79.117.179.43-1-90.194.38.98-1-98.87.16.102-1-68.232.70.142-1-166.205.15.50-1-12.177.23.62-1', 'is_current' => 1, 'date_and_time' => 1299908391, 'submitter' => 2, 'add_time' => 1277149152, 'poll_views' => 185, 'edit_date' => 1299908391, 't0__text_original' => 'Dino Popularity Poll #3 - Vote: Which Ceratopsian Dinos is Your favorite?', 't0__text_parsed' => '', 't1__text_original' => 'Triceratops is my favorite.', 't1__text_parsed' => '', 't2__text_original' => 'Protoceratops is my favorite.', 't2__text_parsed' => '', 't3__text_original' => 'Styracosaurus is my favorite.', 't3__text_parsed' => '', 't4__text_original' => 'Udanoceratops is my favorite.', 't4__text_parsed' => '', 't5__text_original' => '', 't5__text_parsed' => '', 't6__text_original' => '', 't6__text_parsed' => '', 't7__text_original' => '', 't7__text_parsed' => '', 't8__text_original' => '', 't8__text_parsed' => '', 't9__text_original' => '', 't9__text_parsed' => '', 't10__text_original' => '', 't10__text_parsed' => '', )

'site'
 

File'/home/prehisto/public_html/sources/blocks/main_poll.php'
Line'61'
Function'poll_script'
Argstrue

-1
 

File'/home/prehisto/public_html/sources/zones.php'
Line'676'
Function'run'
Class'Block_main_poll'
Type'->'
ObjectBlock_main_poll::__set_state(array( ))
Argsarray ( 'block' => 'main_poll', )
 

File'/home/prehisto/public_html/sources/tempcode.php'
Line'705'
Function'do_block'
Args'main_poll'

array ( 'block' => 'main_poll', )
 

File'/home/prehisto/public_html/sources/tempcode.php'
Line'977'
Function'handle_symbol_preprocessing'
Argsarray ( 0 => array ( ), 1 => 0, 2 => 'BLOCK', 3 => array ( 0 => 'block=main_poll', ), )

NULL
 

File'/home/prehisto/public_html/sources/site.php'
Line'778'
Function'handle_symbol_preprocessing'
Class'ocp_tempcode'
Type'->'
Objectobject
Args 

File'/home/prehisto/public_html/site/index.php'
Line'51'
Function'do_site'
Args 


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
Posted
Rating:
#67728
Avatar

Possibly both your new bugs are the same thing - did you do the database upgrade step in the upgrader?


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

Community saint

Chris Graham said

Possibly both your new bugs are the same thing - did you do the database upgrade step in the upgrader?
I have not done that - since I thought that would be the last step and my other site worked ok without it and when a I did the database upgrade to the non live site I got the error message I posted a topic about previously.

So I will try it now.


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
Posted
Rating:
#67730
Avatar

Community saint

OK, I applied the database upgrade which declared on screen a sucess message and I am still getting errors. Dont know if they are the same or not but they are so far happening with the same actions

Also I have been getting this error - both before and after the database upgrade.
…this particular one when I try to access the members profile

~~~~~~~~~~~~~

An error occurred when loading this screen onto the web browser. You are being notified of this as you are staff. If you believe this is a bug in the website software, please contact ocProducts with full details. More details are available in your browser's error console. The error was:

28: form_cat_selector is null
http://prehistoricsillustrated.com/themes/pi_theme_a/templates_cached/EN/javascript_validation.js


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
Posted
Rating:
#67733
Avatar

Community saint

Since the POLL block is on the first page (site) and won't load up without error message displayed - I went in the backdoor through CONTENT MANAGEMENT/EDIT COMCODE PAGE and changed the POLL block to a different block and now I am able to access the first page when I open the site - but it still doesnt fix the POLL or QUIZ problems just gets them on the sideline for now.


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
Posted
Rating:
#67734
Avatar

Community saint

Often after an upgrade I run the website cleanup tools in the admin zone and it fixes them for me...worth a try.
Back to the top
 
Posted
Rating:
#67736
Avatar

Community saint

Brian Hay said

Often after an upgrade I run the website cleanup tools in the admin zone and it fixes them for me…worth a try.
just did that again - same. I checked my QUIZZES module and still get the error message - the POLLS is offline …and I have no reason to believe it got fixed when QUIZZES didn't.

Thanks for a sugestion Brian :)


Last edit: by friendly


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
Posted
Rating:
#67772
Avatar

Community saint

Any other ideas about the polls and quiz problems I've had?


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
Posted
Rating:
#67773
Avatar

This should get it running again.

Attachment
site/pages/modules/quiz.php
» Download: quiz.php (29 Kb, 83 downloads so far)


It's very important the 'database upgrade' step is completed for everything except patch upgrades. In this case there was a 'bug' in our framework that caused modules to not properly self upgrade if they added menu items, but if the upgrade steps are performed in sequence it goes smoothly.


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

Polls seems to work now.

Not sure why that Javascript error would happen, especially when viewing a member. Or was it when editing a member? Is it still happening?


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

Community saint

Chris Graham said

This should get it running again.

It's very important the 'database upgrade' step is completed for everything except patch upgrades. In this case there was a 'bug' in our framework that caused modules to not properly self upgrade if they added menu items, but if the upgrade steps are performed in sequence it goes smoothly.
The QUIZ and the POLL problems are gone now and they are working OK now after the php fix.


Last edit: by friendly


Art and Imagination
of David L Friend

http://davidlfriend.com

  My Art Gallery
powered by ocPortal
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: