not unique table 1066 error

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Jack0127
Registered User
Posts: 6
Joined: Wed Feb 14, 2018 12:01 am

not unique table 1066 error

Post by Jack0127 » Thu Feb 22, 2018 7:01 am

Hello.

I am using version 3.2.2 of phpbb.

As an error occurs as shown below, the board can not connect itself.
SQL ERROR [ mysqli ]
Not unique talbe/alias: 't' [1066]
And SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
phpbb_error_not_unique_table_1066.png

This symptom occurred after the enable prefixed solved extension.

If prefixed solved extension is disabled, phpbb can be used normally.

Is there any way to avoid an error using the prefix solution?

I'm using these extensions.
phpbb_installed_extensions.png

P.S.
I wonder what kind of extension are topic solved extension currently used by phpbb.com community.

User avatar
AmigoJack
Registered User
Posts: 5315
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: not unique table 1066 error

Post by AmigoJack » Thu Feb 22, 2018 8:29 am

Jack0127 wrote:
Thu Feb 22, 2018 7:01 am
talbe
And SQL error
In the future you might want to copy the text instead of re-typing it - that will prevent you from making mistakes.

Jack0127 wrote:
Thu Feb 22, 2018 7:01 am
Is there any way to avoid an error using the prefix solution?
You should report the issue and/or ask if it is compatible with 3.2.x, as its manual only speaks of 3.1.x. The author also exists on this board - as per Re: [BETA][3.1] [pre]fixed - Topic Prefixes extension you're not the first one having this issue - but since the extension is marked as "abandoned" you cannot reply there either.
The worst thing about censorship is ███████████

Jack0127
Registered User
Posts: 6
Joined: Wed Feb 14, 2018 12:01 am

Re: not unique table 1066 error

Post by Jack0127 » Thu Feb 22, 2018 11:00 am

AmigoJack wrote:
Thu Feb 22, 2018 8:29 am
In the future you might want to copy the text instead of re-typing it - that will prevent you from making mistakes.
OK!. I got it. ;)
AmigoJack wrote:
Thu Feb 22, 2018 8:29 am
You should report the issue and/or ask if it is compatible with 3.2.x, as its manual only speaks of 3.1.x. The author also exists on this board - as per Re: [BETA][3.1] [pre]fixed - Topic Prefixes extension you're not the first one having this issue - but since the extension is marked as "abandoned" you cannot reply there either.
Yes I saw that topic too. So I installed that extension. But I don't have any more options.

Thank you for your kindly answer.


Oh. Do you know the name of the topic solved extension that this community is using?
topic_solved_phpbb.png

User avatar
canonknipser
Registered User
Posts: 1593
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: not unique table 1066 error

Post by canonknipser » Thu Feb 22, 2018 11:14 am

As far as I know, that is no extension, but just a simple topic icon set by the support team members when a topic has been solved


Edit: see attached file
tick.gif
tick.gif (242 Bytes) Viewed 218 times
Last edited by canonknipser on Thu Feb 22, 2018 11:19 am, edited 1 time in total.
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

User avatar
Lumpy Burgertushie
Registered User
Posts: 64852
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: not unique table 1066 error

Post by Lumpy Burgertushie » Thu Feb 22, 2018 11:15 am

I believe all you have to do is add whatever icon you want via the admin panel, then make sure topic icons are turned on in the admin panel and then just choose it when either creating a post or editing a post etc.

don't know what you need an extension for.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

User avatar
AmigoJack
Registered User
Posts: 5315
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: not unique table 1066 error

Post by AmigoJack » Thu Feb 22, 2018 11:32 am

Lumpy Burgertushie wrote:
Thu Feb 22, 2018 11:15 am
don't know what you need an extension for
I'd want to search for solved topics - by default you can't search posts based on icons.

Jack0127, if all you need is the "topic solved" scenario, consider using post icons (whereas you can add as many icons as you want, not only "done" symbols).
The worst thing about censorship is ███████████

Jack0127
Registered User
Posts: 6
Joined: Wed Feb 14, 2018 12:01 am

Re: not unique table 1066 error

Post by Jack0127 » Thu Feb 22, 2018 2:08 pm

canonknipser wrote:
Thu Feb 22, 2018 11:14 am
As far as I know, that is no extension, but just a simple topic icon set by the support team members when a topic has been solved


Edit: see attached filetick.gif
Thank you very much for icon. :D
I have to searh for icon set method.

Jack0127
Registered User
Posts: 6
Joined: Wed Feb 14, 2018 12:01 am

Re: not unique table 1066 error

Post by Jack0127 » Thu Feb 22, 2018 2:15 pm

Lumpy Burgertushie wrote:
Thu Feb 22, 2018 11:15 am
I believe all you have to do is add whatever icon you want via the admin panel, then make sure topic icons are turned on in the admin panel and then just choose it when either creating a post or editing a post etc.

don't know what you need an extension for.


robert
Seeing your post, I should read the manual more carefully.
There are steps I need to lock the topics but this is really too easy.
Thank you for your advice!

Jack0127
Registered User
Posts: 6
Joined: Wed Feb 14, 2018 12:01 am

Re: not unique table 1066 error

Post by Jack0127 » Thu Feb 22, 2018 2:25 pm

Jack0127, if all you need is the "topic solved" scenario, consider using post icons (whereas you can add as many icons as you want, not only "done" symbols).
OK. I think that topic icon method is currently best option.
I can't check who left the best response, but it seems like it is also a good idea.
My question have been partially solved.

Thank you everyone! :D
Thank-You-Free-PNG-Image.png

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Brf, invenio and 21 guests