vb.org Archive - Mini Mods - Alphabetical List Thread

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Mini Mods - Alphabetical List Thread (https://vborg.vbsupport.ru/showthread.php?t=269048)

Asterix_ita

08-31-2013 04:41 PM

1 Attachment(s)

Sorry and thanks now I have managed to replicate the error

solved

https://vborg.vbsupport.ru/external/2013/08/1.png

Regards

rechoncho

08-31-2013 06:38 PM

You are a genius :eek:

I see you have solved the problem. :up:

I have installed in my forum, and now I have a db error message, when I accede to the list.

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT *
FROM foros_thread
WHERE forumid=89 AND sticky=0 AND visible=1
ORDER BY title ASC COLLATE latin1_spanish_ci;

MySQL Error : 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 'COLLATE latin1_spanish_ci' at line 4
Error Number : 1064
Request Date : Saturday, August 31st 2013 @ 08:55:46 PM
Error Date : Saturday, August 31st 2013 @ 08:55:46 PM
Script : http://forocer.org/showthread.php?t=12629
Referrer : http://forocer.org/metal/f89.html
IP Address : ****
Username : ****
Classname : vB_Database
MySQL Version : 5.1.67

:confused:

Do you know what happen? :erm:

Thank you for all.

Asterix_ita

08-31-2013 07:19 PM

in my server that syntax works, you can try with:

open the file xml and find (two string)

ORDER BY title ASC COLLATE latin1_spanish_ci

replace with

ORDER BY title COLLATE latin1_spanish_ci

or

ORDER BY title COLLATE latin1_general_ci

save and install addon

Regards

rechoncho

08-31-2013 09:59 PM

Quote:

Originally Posted by Asterix_ita (Post 2442205)

Yes, yes, YESSSS !!!!!!

It's works PERFECT !!!!

Take a look:
http://forocer.org/listado-de-metal.html-12629

A LOT OF THANKS my friend.

You're a real GENIUS! http://forocer.org/images/smilies/rezo.gif

Problem solved!!!! I'm very happy http://forocer.org/images/smilies/bravo.gif

See you soon!

REGARDS!!!

Ross L

11-15-2013 06:19 PM

I've managed to get this working on the mobile theme. It isn't perfect, but if you just add the templates it works (you also need to add an additional.css and add the CSS edits from page one).

Toxic2

11-16-2013 09:54 PM

Oh this is sweet ! Thank you

JesWhite

04-08-2014 05:05 PM

this addon is very nice...
nice working...
but i moved another forum and changed everything...
can you fix this problem...
again for example i will add a forum id and addon shows this id's threads...
and when i moved thread this addon shows i added forum threads...

you understand me ?

Gn_Snake

09-09-2015 10:05 AM

Works in 4.2.3?

Manoel J?nior

09-09-2015 06:17 PM

Quote:

Originally Posted by Gn_Snake (Post 2554638)

Works in 4.2.3?

Yes

Stratis

02-15-2018 03:07 PM

Can someone help please?
How insert (target="_blank) in this code:

Code:

<vb:if condition="$ctlist['active_other']">{vb:raw template_ct_thread_list_all_bit}</vb:if>

Thanks in advance :)

All times are GMT. The time now is 11:40 AM.

Page 7 of 8

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01183 seconds Memory Usage 1,739KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: