Additional Polls

[zijO]

How to change order of polls?

[zijO]

ah it's alphabetical order :-)

[dmacleo]

smf 2 rc4 tried applying update that was posted today,
get this error:

Duplicate key name 'id_topic'
File: /xxxx/xxx/xxx/Packages/temp/install2.php
Line: 59

line 59 looks to be blank.
I did have this installed on rc3, do I have to delete database tables?
if so which ones? I did not see anything that stood out to me.

[Windy]

I don't believe that's supposed to happen, what database system are you using?

[dmacleo]

MySql 5.0.91 running off site5.com host.

[Windy]

It looks like it might be a bug with SMF, fortunately I think I can work around it.

[Rafferty]

smf 2 rc4 tried applying update that was posted today,
get this error:

Duplicate key name 'id_topic'
File: /xxxx/xxx/xxx/Packages/temp/install2.php
Line: 59

line 59 looks to be blank.
I did have this installed on rc3, do I have to delete database tables?
if so which ones? I did not see anything that stood out to me.

Same error here:

Duplicate column name 'id_topic'
File: /home/www/xxxxxx.com/forum/Packages/temp/install2.php
Line: 43

[C4G-TK]

I had this installed on RC3 as well and just upgraded to RC4 and got the same error.
I had uninstalled my mods prior to the upgrade and this is only the third mod that I've tried to install since that point.
(Simple Portal and Ad Management Mod being the only other two.)


Duplicate key name 'id_topic'
File: /home/xxxxxxx/public_html/Packages/temp/install2.php
Line: 59

ALTER TABLE measfonx_ilm_polls
ADD INDEX id_topic (id_topic)
File: /home/xxxxxxx/public_html/Packages/temp/install2.php
Line: 59

Code Select Expand

54: $smcFunc['db_add_index'] (
55: '{db_prefix}polls',
56: array(
57: 'columns' => array('id_topic'),
58: )
==>59: );
60:
61: $request = $smcFunc['db_query'] ('', '
62: SELECT p.id_poll
63: FROM {db_prefix}polls AS p
64: WHERE p.id_topic = 0 OR p.id_topic IS NULL'
65: );



Installed the MOD by doing this:
I just went into PHP MyAdmin in my database and went to  _polls and deleted the id_topic field.
Then, I just went back into Admin for the packages and installed without any problem.

[Windy]

I hope you deleted just the index and not the whole column.

Anyway, I've added a new version that specifically fixes this issue, if you aren't encountering this issue then there is no reason to upgrade.

[Rafferty]

Still getting the following:

Duplicate column name 'id_topic'
File: /home/www/xxxxxx.com/forum/Packages/temp/install2.php
Line: 43

[dmacleo]

I hope you deleted just the index and not the whole column.

Anyway, I've added a new version that specifically fixes this issue, if you aren't encountering this issue then there is no reason to upgrade.

seems to work, thank you.

[Windy]

Still getting the following:

Duplicate column name 'id_topic'
File: /home/www/xxxxxx.com/forum/Packages/temp/install2.php
Line: 43

database system?

[Rafferty]

what do you mean?

[dmacleo]

think shes asking for specifics on server, mysql version and php version.

[Rafferty]

Still getting the following:

Duplicate column name 'id_topic'
File: /home/www/xxxxxx.com/forum/Packages/temp/install2.php
Line: 43

database system?

PHP5 -     * Server version: 5.0.32-Debian_7etch1~bpo.1-log
    * Protocol version: 10
    * User:
    * MySQL charset: UTF-8 Unicode (utf8)

Web server

    * Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7e
    * MySQL client version: 5.0.32
    * PHP extension: mysql

Helpful or no?

[dmacleo]

don't know if its helpful but before I tried installing the newer version I deleted all files related to it including the one in temp folder.
I also had to clear cookies/temp files on pc, not sure why or which of these 2 worked but it then installed fine for me.

[Windy]

Atm I'm sort of at a loss as to what it could be, utf8 is the only thing that I could imagine that might skew it, but I had no issue installing it more than once on a forum using utf8. So at the moment I can only assume that the files have been altered, which is probably pretty unlikely, or for some reason your mysql isn't returning the correct tables names or they're in a format that doesn't allow it to pickup that they're the same. Either way, I haven't been able to reproduce the error.

I might suggest perhaps that I do up a custom package for you to try to install that would spit out some debug information that should help diagnose the issue.

[Rafferty]

I can only add that this has only occurred after I upgraded from RC3 to 4. Additional Polls worked fine before that on RC3

[Windy]

I can only add that this has only occurred after I upgraded from RC3 to 4. Additional Polls worked fine before that on RC3

Did you ever have to reinstall it though?

[Rafferty]

No, only after rc4 upgrade