Topic Solved

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
satandream
Registered User
Posts: 383
Joined: Thu Mar 06, 2008 12:47 pm

Re: Topic Solved

Post by satandream »

Does this error have something with this mod as i get it when i sometimes use search

Code: Select all

General Error
SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN phpbb_topics t ON (p.topic_id = t.topic_id) LEFT JOIN phpbb_forum' at line 2 [1064]

SQL

SELECT p.*, f.forum_id, f.forum_name, f.forum_solve_text, f.forum_solve_color, t.*, u.username, u.username_clean, u.user_sig, u.user_sig_bbcode_uid, u.user_colour LEFT JOIN phpbb_topics t ON (p.topic_id = t.topic_id) LEFT JOIN phpbb_forums f ON (p.forum_id = f.forum_id) LEFT JOIN phpbb_users u ON (p.poster_id = u.user_id) WHERE p.post_id IN ('28657', '28653', '28611', '28463', '28066', '28065', '28062', '28061', '28001', '27974') ORDER BY p.post_time DESC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: search.php
LINE: 716
CALL: dbal_mysqli->sql_query()
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

No. You are for some reason missing the line beginning with FROM.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
Ferrari353
Registered User
Posts: 15
Joined: Wed Jan 20, 2010 4:53 am

Re: Topic Solved

Post by Ferrari353 »

I can't open the subsilver2.xml. install.xml opens fine, but subsilver2.xml won't work....Can somebody help me fix this...? I don't know what the problem is..
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

Opens fine here. Try to download the package again. You need to open it in the contrib directory, do not move it.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
User avatar
Mr_Teddy
I've Been Banned!
Posts: 14
Joined: Sat Feb 13, 2010 10:07 am

Re: Topic Solved

Post by Mr_Teddy »

Great MOD but can only use a Moderator or Administrator the Solved option?
No Support by PM!
Please provide us with the information necessary to assist you by filling out the Support Request Template.
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

The first post in this topic wrote:Modification description: Gives the topicstarter the option off accepting one answer and mark the topic as solved. And mark the topic as unsolved again.
I have updated the image in the third post to show all settings.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
User avatar
Kudlaty
Registered User
Posts: 62
Joined: Sat Feb 10, 2007 8:24 pm
Contact:

Re: Topic Solved

Post by Kudlaty »

great mod,
thx :)
User avatar
knmt
Registered User
Posts: 110
Joined: Fri Aug 29, 2008 10:13 am
Contact:

Re: Topic Solved

Post by knmt »

Been using this mod for some time now and it works great. Not sure if you are going to implement more features, but a "solved" count for a user would be nice =].
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

knmt wrote:Not sure if you are going to implement more features, but a "solved" count for a user would be nice =].
I don't know either and yes it would.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
User avatar
ameisez
Registered User
Posts: 1166
Joined: Sun Nov 04, 2007 7:04 am

Re: Topic Solved

Post by ameisez »

The setting Chooce text instead of solved image:

Can that be different text for every forum or just universal text?

Thanks
PHPBB on HOSTGATOR SERVER. MY PERSONAL CHOICE ;)
Need phpBB images and buttons? HIRE ME
my MOD: BB3 Media Player | a phpbb based media player
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

ameisez wrote:The setting Chooce text instead of solved image:

Can that be different text for every forum or just universal text?

Thanks
You need to set that for each forum.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

Tested and works with phpBB 3.0.7
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
asdfasdf
Registered User
Posts: 74
Joined: Fri Sep 05, 2008 10:18 am

Re: Topic Solved

Post by asdfasdf »

The forum_solve_text don't save (some) special characters correct in the db.
When I type in Ø it's saves is as ??
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: Topic Solved

Post by tumba25 »

Yes, sorry. Forgot to change that.

Open includes/acp/acp_forums.php
Find

Code: Select all

'forum_solve_text'	=> request_var('forum_solve_text', ''),
Replace with

Code: Select all

'forum_solve_text'	=> utf8_normalize_nfc(request_var('forum_solve_text', '', true)),
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
asdfasdf
Registered User
Posts: 74
Joined: Fri Sep 05, 2008 10:18 am

Re: Topic Solved

Post by asdfasdf »

Great, thanks
Locked

Return to “[3.0.x] MOD Database Releases”