Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Double Options Of Polls With The New Update 
 
With the new update I have doubled all survey options.

Anyone know why? How i can correct it? Thanks.


 doublepolls
 



 
spirit22Send private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
can you please check ip_poll_options table
 




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
Hi Limun, I searched this table everywhere and can't find it. Where is it?
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
try search
ip_3poll_options
 




____________
We are the phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!
 
LimunSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
Maybe you didn't update properly... it could be tricky to fix this.

How many old polls do you have?

If you create a new poll, does it work properly?
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
Hi guys.


Here is the ip_3poll_options

IMAGE DELETED



I have about 30 or 40 old polls.

When I create new works perfectly, The fail It's only with the old polls.
 



 
Last edited by spirit22 on Tue 07 May, 2013 19:30; edited 1 time in total 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
I guess you simply have not done the DB checks (like I said in another thread)... ACP >> Database Maintenance.

Otherwise, have you tried edttng manually, one by one? (probably MG's next response )

Also.. yes MG, it was a messy install withmany repair tries.
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
It is very tough to fix now honestly... I think best solution is to remove old options manually.

The code to fix Polls is as follow, but it works only on old DB, it would mess up everything on IP 2.0.

Code: [Download] [Hide] [Select]
##### POLL CONVERSION - BEGIN
# Table: 'phpbb_poll_options'
CREATE TABLE `phpbb_poll_options` (
    poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
    topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    poll_option_text text NOT NULL,
    poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    KEY poll_opt_id (poll_option_id),
    KEY topic_id (topic_id)
);

# Table: 'phpbb_poll_votes'
CREATE TABLE `phpbb_poll_votes` (
    topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
    vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    vote_user_ip varchar(40) DEFAULT '' NOT NULL,
    KEY topic_id (topic_id),
    KEY vote_user_id (vote_user_id),
    KEY vote_user_ip (vote_user_ip)
);

##ADD
ALTER TABLE `phpbb_topics` ADD `poll_title` varchar(255) DEFAULT '' NOT NULL AFTER `topic_type`;
ALTER TABLE `phpbb_topics` ADD `poll_start` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_title`;
ALTER TABLE `phpbb_topics` ADD `poll_length` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_start`;
ALTER TABLE `phpbb_topics` ADD `poll_max_options` tinyint(4) DEFAULT '1' NOT NULL AFTER `poll_length`;
ALTER TABLE `phpbb_topics` ADD `poll_last_vote` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_max_options`;
ALTER TABLE `phpbb_topics` ADD `poll_vote_change` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_last_vote`;

UPDATE phpbb_topics t, phpbb_vote_desc vd
SET t.poll_title = vd.vote_text, t.poll_start = vd.vote_start, t.poll_length = vd.vote_length, t.poll_max_options = 1, t.poll_vote_change = 0
WHERE t.topic_vote = 1
AND vd.topic_id = t.topic_id;

INSERT INTO `phpbb_poll_options`
SELECT vr.vote_option_id, vd.topic_id, vr.vote_option_text, vr.vote_result
FROM `phpbb_vote_desc` vd, `phpbb_vote_results` vr
WHERE vr.vote_id = vd.vote_id
ORDER BY vd.topic_id ASC, vd.vote_id ASC, vr.vote_option_id ASC;

INSERT INTO `phpbb_poll_votes`
SELECT vd.topic_id, vv.vote_cast, vv.vote_user_id, vv.vote_user_ip
FROM `phpbb_vote_desc` vd, `phpbb_vote_voters` vv
WHERE vd.vote_id = vv.vote_id
ORDER BY vd.topic_id ASC, vv.vote_user_id ASC;

##REMOVE
ALTER TABLE `phpbb_topics` DROP `topic_vote`;
DROP TABLE `phpbb_vote_desc`;
DROP TABLE `phpbb_vote_results`;
DROP TABLE `phpbb_vote_voters`;
##### POLL CONVERSION - END

 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
Ok, no problem. I will remove the old options and put them back. Thanks guys.
 



 
spirit22Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Double Options Of Polls With The New Update 
 
Just remove the doubles, nothing to put back
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events