vb.org Archive

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)
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.

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:
  1. - on the "who is online"-page the small triangle for the sorting makes the column header to big by a few pixels
  2. - Forumdisplay pages would not have their threads sprite statusicons added in latest vBulletin. Users supplied fix, post 536
  3. - 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


All times are GMT. The time now is 06:08 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01775 seconds
  • Memory Usage 1,756KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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