vb.org Archive - Board Optimization - United-Forum CSS Sprites - ludicrous speed

Page 15 of 17

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)

- - Board Optimization - United-Forum CSS Sprites - ludicrous speed - NOW! (https://vborg.vbsupport.ru/showthread.php?t=266696)

Acido

06-12-2012 02:59 AM

I'm running vb 4.1.12 and i cant upgrade this mod from 0.6.3a or uninstall it to reinstall with the latest version 0.7.2

I'm getting a mysql error as follow:

Code:

Database error in vBulletin 4.1.12:



Invalid SQL:



        SELECT templateid

        FROM template

        WHERE

            edited=1

            AND title IN ('forumhome_forumbit_level1_post', 'forumhome_forumbit_level1_post', 'forumhome_forumbit_level2_post', 'forumhome_forumbit_level2_post', 'forumbits.css', 'forumbits.css', 'forumbits.css', 'threadbit_deleted', 'search_threadbit', 'threadlist.css', 'block_blogentries', 'block_cmsarticles', 'block_newposts', 'block_sgdiscussions', 'block_threads', 'forumdisplay_sortarrow', 'forumhome_forumbit_level1_post', 'navbar', 'navbar', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'pagenav', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadbit', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'threadlist.css', 'FORUMDISPLAY', 'FORUMDISPLAY', 'FORUMDISPLAY', 'FORUMDISPLAY', 'FORUMDISPLAY', 'FORUMDISPLAY', 'forumhome_lastpostby', 'forumhome_lastpostby', 'memberaction_dropdown', 'memberaction_dropdown', 'memberaction_dropdown', 'memberaction_dropdown', 'memberaction_dropdown', 'memberaction_dropdown', 'memberaction_dropdown', 'memberaction_dropdown', 'FORUMHOME', 'FORUMHOME', 'FORUMHOME', 'FORUMHOME', 'forumhome_forumbit_level2_nopost', 'forumhome_forumbit_level2_post', 'forumhome_subforumbit_nopost', 'forumhome_subforumbit_post', 'FORUMHOME', 'FORUMHOME', 'FORUMHOME', 'FORUMHOME', 'FORUMHOME');



MySQL Error   : Unknown column 'edited' in 'where clause'

Error Number  : 1054

Request Date  : Tuesday, June 12th 2012 @ 12:50:26 AM

Error Date    : Tuesday, June 12th 2012 @ 12:50:26 AM

Script        : http://www.mysite.com/admincp/plugin.php?do=productimport

Referrer      : http://www.mysite.com/admincp/plugin.php?do=productadd

IP Address    : 186.57.155.142

Username      : myadminuser

Classname     : vB_Database

MySQL Version : 5.1.61-0+squeeze1-log

Any help ?

animcentral

06-12-2012 05:38 PM

im getting this error when i try to install it

Code:

Database error in vBulletin 4.2.0:



Invalid SQL:



        SELECT t1.templateeditid AS templateeditid_1, t1.varname ,

t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,

t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2 

        FROM templateedit AS t1 

LEFT JOIN templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)

LEFT JOIN templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=45)

        WHERE t1.styleid = -1;



MySQL Error   : Not unique table/alias: 't1'

Error Number  : 1066

Request Date  : Wednesday, June 13th 2012 @ 01:26:23 AM

Error Date    : Wednesday, June 13th 2012 @ 01:26:23 AM

Script        : http://www.animcentral.com/forums/admincp/apm_product.php?do=productimport

Referrer      : http://www.animcentral.com/forums/admincp/apm_product.php?do=productadd

IP Address    : 2.187.112.151

Username      : AliMH

Classname     : vB_Database

MySQL Version : 5.0.95-log

imported_dfmafia

06-20-2012 03:07 AM

mobile styles didn't get the stylevar imgdir_sprite

4.2.0 PL2

everything else is working though

cuco88

06-26-2012 02:04 PM

I just tried it on 4.2.0 PL2.
With:
TMS 1.2.0 b4
TMS 1.2.0 b4 Patch
CSS-Sprites 0.7.2
This template fixes

Result: The template modification works, it generates sprites and adds them to my forum, BUT:
- It is not working for the mobile style
- Memberaction_Dropdown is still not found by TMS
- on the "who is online"-page the small triangle for the sorting makes the coloumn to big, so it "destroys" the design (only a few pixel)
- the "unsubscribe a forum"-image is shown 1,5x
and the biggest problem:
- it is not working correctly if you use your own statusicons with a prefix. The generated CSS rules and the inserted CSS Tags are not matching, so no images are shown. This is disappointing. :(

Damn, this looked so promising! I hope, vB will add this default. :) Now I have to uninstall it.

Crotan

06-26-2012 09:44 PM

Quote:

Originally Posted by cuco88 (Post 2343053)

What do you mean your own statusicons with a prefix. I have this working with my own statusicons

screen capture for the "un-subscribe a forum" screw up? Is it possible that you unsubscribe image is grayscale and your using an old version of the GD library? Which was a reoccurring issue for people.

The only outstanding bugs with this mod that I'm aware of:

- on the "who is online"-page the small triangle for the sorting makes the column header to big by a few pixels
- Forumdisplay pages would not have their threads sprite statusicons added in latest vBulletin. Users supplied fix, post 536
- Search pages won't have sprites, needs a template update. Both this and the one above broke because of vbulletin template changes in later versions that this mod hasn't accounted for since released.

Pure Dope

06-27-2012 10:31 PM

oh wow. there has got to be a better way than to make all those template mods manually.

i cannot install tms b/c i have vb4.2.

but i need this.

Crotan

06-28-2012 02:30 AM

Quote:

Originally Posted by Pure Dope (Post 2343425)

oh wow. there has got to be a better way than to make all those template mods manually.

i cannot install tms b/c i have vb4.2.

but i need this.

what's wrong with TMS and vb4.2?

Pure Dope

06-28-2012 03:36 AM

I looked thru the thread and didnt get any confirmation that it worked in 4.2.

The description didnt say so.

fly	06-28-2012 10:37 AM

Quote:

Originally Posted by Pure Dope (Post 2343480)

I looked thru the thread and didnt get any confirmation that it worked in 4.2.

The description didnt say so.

Just try it on your test forum...

qpurser

06-28-2012 10:51 AM

Quote:

Originally Posted by Pure Dope (Post 2343480)

I looked thru the thread and didnt get any confirmation that it worked in 4.2.

The description didnt say so.

Installed it on a test server running 4.2.0 with a custom template and it messed up parts of my forum layout.

Not saying it doesn't work but for me using a custom template it didn't

imported_dfmafia

07-17-2012 03:02 AM

vB 4.2.0 PL 2 with TMS and a ton other mods. all working fine. this mod works as well.

though i wish i could add the stylevar "imgdir_sprites" to the mobile styles...

datoneer

08-06-2012 12:54 PM

Doesn't work good on 4.2.0

datoneer

08-12-2012 03:49 PM

Uninstalled

HondaATC

08-27-2012 11:37 PM

Quote:

Originally Posted by fly (Post 2331384)

See my posts 541 and 543. I'm interested to know if this actually fixes it for others.

I just tried that and a no go for me. Running 4.1.12

fly	08-28-2012 10:12 AM

Quote:

Originally Posted by HondaATC (Post 2360561)

I just tried that and a no go for me. Running 4.1.12

Can you explain what that means?

HondaATC

08-28-2012 10:40 AM

Check the post I quoted. Its a patched xml file that is suppose to make the forum icons work but it does not. I had to uninstall it.

fly	08-28-2012 10:44 AM

Quote:

Originally Posted by HondaATC (Post 2360663)

Check the post I quoted. Its a patched xml file that is suppose to make the forum icons work but it does not. I had to uninstall it.

I know what it was. I posted it. It's worked on 4.1 - 4.2 for me. Do you have a custom style?

HondaATC

08-28-2012 09:28 PM

Yes, and I use TMS.

fly	08-29-2012 12:32 AM

Quote:

Originally Posted by HondaATC (Post 2360806)

Yes, and I use TMS.

Does it work on a default style with no parent style? I assume it does, which means... I probably can't help you with your custom style.

vauge

08-30-2012 02:36 AM

1 Attachment(s)

Would someone mind uploading a fixed alpha version of paperclip.png or paperclip.gif?

Thanks!

Edit: See attached

Nirjonadda

09-02-2012 02:15 PM

1 Attachment(s)

Bug on option Title ! How to fix option title ?

Mark_Zuckerberg

09-29-2012 07:13 PM

it gives a database error when importing the xml i have uploaded all the files in the respected directories and also installed the template modification mod plz assist further thanks

Mark_Zuckerberg

09-29-2012 07:16 PM

This is the error which comes up when importing in the ACP :(:(

Quote:

Mark_Zuckerberg

10-02-2012 10:06 PM

I am getting a message of 84 out dated templates in admincp when i checked these all are
United-Forum CSS Sprites files what should i do with them?

TheSupportForum

10-02-2012 10:23 PM

Quote:

Originally Posted by Mark_Zuckerberg (Post 2370313)

I am getting a message of 84 out dated templates in admincp when i checked these all are
United-Forum CSS Sprites files what should i do with them?

any of the templates that have ( edit ) click it
where is says : Search for Text

you will need to go into the template listed anback search for part of that code and update the correct code from that template back into the sprite template edits

Mark_Zuckerberg

10-02-2012 11:43 PM

1 Attachment(s)

Quote:

Originally Posted by simonhind (Post 2370321)

But when i go in options i see a blank space inthat and when i click in that blank space Add thread icons to sprite

see the screen shot below?

TheSupportForum

10-02-2012 11:56 PM

Quote:

Originally Posted by Mark_Zuckerberg (Post 2370356)

But when i go in options i see a blank space inthat and when i click in that blank space Add thread icons to sprite

see the screen shot below?

http://img22.imageshack.us/img22/775...1bf9326d29.png

e.g.
http://img641.imageshack.us/img641/1...e55a5d5253.png

after clicking edit
http://img803.imageshack.us/img803/7...c38bf8a3c5.png

open threadbit template and search for highlighted
example just search for <li class="threadbit {vb:raw thread.statusstring} in threadbit template

http://img338.imageshack.us/img338/7...9c3bd118ba.png

as you can see the template code is different and you will need to enter that code into Search for Text shown in the after clicking edit screenshot

Mark_Zuckerberg

10-03-2012 07:02 PM

Quote:

Originally Posted by Mark_Zuckerberg (Post 2370356)

But when i go in options i see a blank space in that and when i click in that blank space Add thread icons to sprite

see the screen shot below?

but why it shows a blank area is this bug or what?

sivaganeshk

10-22-2012 06:49 PM

Works with 4.2 ?? or is there an issue?

majjed2008

10-29-2012 08:28 PM

i tray to do this modification but it is realy hard , after i do every thing how i can check also i get this massage :
!!! Out-of-date Template-Modifications found !!!

There are 12 Template-Modifications that were not desinged for the currently installed vBulletin version. To make sure that vBulletin and your installed Products are working correctly, you must check and maybe modify those Template-Modifications.

Test Template-Modifications

majjed2008

10-29-2012 09:58 PM

i keep reading this thread but it is really hard to me to do it , is there any service to apply this or can some one help please

majjed2008

10-30-2012 06:41 AM

can anyone help me how to delete it ?
and make my tamp let back how it was i dont have backup , all my forum look strange now

Morpheuss89

12-04-2012 04:53 AM

Quote:

Originally Posted by Osbes (Post 2219794)

Version 0.7.2 (06.08.2011)

now supporting folders for forum prefixes

sprite generation splittet to avoid timeouts on sites which a huge number of styles

checks if the gd version is 2.0.36 or higher (experimental)

Version 0.7.1 (01.08.2011)

added support for search.php pages including What's New

some minor bugfixes

Version 0.7.0 (01.08.2011)

full support for ltr/rtl

forum sidebar support added

FORUMDISPLAY support added

Version 0.6.3 (23.07.2011)

Added the possibility to use TMS for automatic template modification.

Icons can now be merged into different sprites and css rollups instead of one big sprite.

Addon is now compatible with vBulletin 4.1.x

Version 0.6.2 (17.07.2011)

Added support for http filepaths and therefore one-way support for CDNs

Templates are now using the cache system

clientscript/sprite_vbulletin_collapse.js removed.

Version 0.6.1 (17.07.2011)

bug-fix: using alternative paths for post icons could cause that these are not includes in the sprite.

Version 0.6.0 (17.07.2011)

possibility to add custom icons into the sprite via plugin-hook sprite_add_icon

added log output during sprite generation in the acp

option to deactivate using post icons in your sprite (default should be on)

Version 0.5.1 (12.07.2011)

Added support php versions < 5.3.0. Addon now just requires php5 due to TypeHinting

Version 0.5.0 (12.07.2011)

Add-On release

FORUMHOME css-sprite support

3 weeks of updates in the last year and after nothing... why ? this mod was really promising... what a pity :/

jreuc

12-12-2012 08:46 AM

I agree that this mod was really promising and should be continued.

I have experienced the same issue as many other people here with the custom status icons (wrong subdirectory used by the mod). A quick fix would be to disable status icons from the CSS sprites. How can we do that ?

Chadi

12-20-2012 10:09 PM

<a href="https://gtmetrix.com/reports/talkjesus.com/eADCrAX4" target="_blank">http://gtmetrix.com/reports/talkjesus.com/eADCrAX4</a>

I followed steps, seems like it created only 2 sprite png files

Still getting an F rating on sprites/css?

Justinphx

12-21-2012 08:32 AM

I installed this months ago and it didn't do anything. It will create a couple of sprites but I am not sure they work. The concept sounded promising but it isn't.

fly	12-21-2012 11:28 AM

Quote:

Originally Posted by Justinphx (Post 2392032)

I installed this months ago and it didn't do anything. It will create a couple of sprites but I am not sure they work. The concept sounded promising but it isn't.

Then you're doing something wrong.

Lpspider

12-24-2012 02:26 AM

Getting the following error upon "refresh" after install:

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM wftemplateedit AS t1
LEFT JOIN wftemplateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN wftemplateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=17)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Sunday, December 23rd 2012 @ 10:19:58 PM
Error Date : Sunday, December 23rd 2012 @ 10:19:59 PM
Script : http://www.site.org/admincp/sprite.php?do=donerefresh
Referrer : http://www.site.org/admincp/sprite.p...esh&startat=18
IP Address : 217.23.15.243
Username : Lpspider
Classname : vB_Database
MySQL Version : 5.0.96-community

Thoughts?

No change in speed or rating for spirits.

Edit:

Updated the tms patch and the product a few pages back and it installed without the errors.

Speed only slightly increased, and "Combine images into CSS sprites" is listed as a high priority.

It looks like the gradient, misc, and site_icons folder weren't included... should they have been?

craigvm

12-31-2012 10:11 PM

this looks a great mod i`ve installed it but when i went to look at the file to see what templates to edit its a .diff file and i`ve got nothing that can open it or i cant find any program to open it and the mod to auto edit the template gave a database error so uninstalled that so can any1 give me the info on what templates to edit in a notepad file please

ProFifaLeagues

12-31-2012 11:38 PM

Quote:

Originally Posted by craigvm (Post 2393897)

Most diff Files will open with Notepad or Notepad++ fella Try again and open yours to See what Differences Show between your template's .

All times are GMT. The time now is 12:19 AM.

Page 15 of 17

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03176 seconds Memory Usage 1,856KB 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 (2)bbcode_code_printable (17)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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: