|
Page 1 of 1
|
 spirit22 
Joined: April 2013
Posts: 51
|
 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.
|
#1 Fri 03 May, 2013 16:46 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
Limun
Joined: January 2008
Posts: 1334
Location:  [Censor]
|
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! 
|
#2 Fri 03 May, 2013 20:10 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Double Options Of Polls With The New Update
Hi Limun, I searched this table everywhere and can't find it. Where is it?
|
#3 Fri 03 May, 2013 23:16 |
|
Limun
Joined: January 2008
Posts: 1334
Location: [Censor]
|
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!
|
#4 Sat 04 May, 2013 06:23 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location:  Borgo San Michele
|
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
|
#5 Sat 04 May, 2013 13:18 |
|
spirit22
Joined: April 2013
Posts: 51
|
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 |
#6 Mon 06 May, 2013 00:39 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location:  Earth, Europe, the Netherlands, Rotterdam
|
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?¿?)  
|
#7 Mon 06 May, 2013 02:49 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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.
##### 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
|
#8 Mon 06 May, 2013 22:56 |
|
spirit22
Joined: April 2013
Posts: 51
|
Re: Double Options Of Polls With The New Update
Ok, no problem. I will remove the old options and put them back. Thanks guys.
|
#9 Tue 07 May, 2013 19:17 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Double Options Of Polls With The New Update
Just remove the doubles, nothing to put back 
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#10 Tue 07 May, 2013 22:04 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
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
|
|
|
|
