vb.org Archive - Forum Display Enhancements

Page 4 of 5

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

- - Forum Display Enhancements - Mobile Style Options 4.0 (https://vborg.vbsupport.ru/showthread.php?t=229044)

dartho

05-01-2010 09:34 PM

I don't know - ask the developer. It has nothing to do with this add-on

ToNetU

05-07-2010 01:47 AM

Hello,

It appears that our MySQL query kill script is ending this query prematurely because it is running for upwards of 2-3 minutes without completing:

Code:

[ 1273196161 ] [ *** ] [ 40493302 ] [ 146 ] [ *** ] [ Query ] [ KILLED ] [ ] [ ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0' ]

[ 1273196161 ] [ *** ] [ 40494206 ] [ 80 ] [ *** ] [ Query ] [ KILLED ] [ '***.***.com' ] [ ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0' ]

[ 1273197062 ] [ *** ] [ 40505463 ] [ 52 ] [ *** ] [ Query ] [ KILLED ] [ '***.***.com' ] [ ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0' ]

Unfortunately this limit is in place to prevent queries from becoming stuck and overloading the server. It doesn't look like this query is working properly as it shouldn't need to run for longer than a few seconds. I checked the table "post" and there is not currently a column named mobile.

can i know why it is taking so long for this query to complete?

btw i installed it without any problem in my test forum , but when i tried to install it into my live forum i got this error:

Code:

Database error in vBulletin 4.0.3:



Invalid SQL:

ALTER TABLE `post` ADD `mobile` BOOL NOT NULL DEFAULT '0';



MySQL Error   : MySQL server has gone away

Error Number  : 2006

Request Date  : Thursday, May 6th 2010 @ 08:34:41 PM

Error Date    : Thursday, May 6th 2010 @ 08:36:01 PM

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

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

IP Address    : *****

Username      : tonetu

Classname     : vB_Database

MySQL Version :

maybe the reason is because my test database is 30 mb, but my live database is 3 gb ?

installed, thanks..

dartho

05-07-2010 09:37 PM

try the 1.0.4 version just posted up

tafreeh

05-07-2010 11:14 PM

I think you forgot to add new private message option at mobile style

ToNetU

05-08-2010 12:52 AM

Quote:

Originally Posted by dartho (Post 2033415)

try the 1.0.4 version just posted up

same problem mate, it's taking so long to install it then got this messege:

Code:

Database error in vBulletin 4.0.3:



Invalid SQL:

ALTER TABLE `post` ADD `mobile` BOOL NOT NULL;



MySQL Error   : MySQL server has gone away

Error Number  : 2006

Request Date  : Friday, May 7th 2010 @ 08:48:12 PM

Error Date    : Friday, May 7th 2010 @ 08:51:01 PM

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

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

IP Address    : ***

Username      : tonetu

Classname     : vB_Database

MySQL Version :

Bounce

05-09-2010 05:11 PM

Quote:

Originally Posted by ToNetU (Post 2033493)

same problem mate, it's taking so long to install it then got this messege:

Code:

Database error in vBulletin 4.0.3:



Invalid SQL:

ALTER TABLE `post` ADD `mobile` BOOL NOT NULL;



MySQL Error   : MySQL server has gone away

Error Number  : 2006

Request Date  : Friday, May 7th 2010 @ 08:48:12 PM

Error Date    : Friday, May 7th 2010 @ 08:51:01 PM

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

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

IP Address    : ***

Username      : tonetu

Classname     : vB_Database

MySQL Version :

same error here

dartho

05-09-2010 09:11 PM

I did some testing with ToNetU and it seems if you have a large databse, you will need to run the queries manually, and they could take a while. I'm looking into it ...

CvP	05-10-2010 09:45 AM

hi dartho.
"posted from mobile" is not such a important thing that we actually need a separate field in post table. I think just adding a posted from mobile at the end of the post will be better.

Bounce

05-10-2010 10:02 PM

Quote:

Originally Posted by dartho (Post 2034280)

I did some testing with ToNetU and it seems if you have a large databse, you will need to run the queries manually, and they could take a while. I'm looking into it ...

yip Total space used by the DATA directory 1,824.14 mb

vasiljok3

05-23-2010 03:19 PM

I tried to install the product for about 2 hours, and it was a failure (I manually stopped the process). My database size is about 1gb, is this normal?

Now I have the problem -

HTML Code:

Database error in vBulletin 4.0.3:



Invalid SQL:

ALTER TABLE `post` ADD `mobile` BOOL NOT NULL;



MySQL Error   : Duplicate column name 'mobile'

Error Number  : 1060

Request Date  : Sunday, May 23rd 2010 @ 08:57:28 AM

Error Date    : Sunday, May 23rd 2010 @ 08:57:28 AM

Script        : http://org/admincp/plugin.php?do=productimport

Referrer     : http://org/admincp/plugin.php?do=productadd

I can not install or uninstall the product (it is not in the list of products).

What should I do?

steven s

05-23-2010 08:34 PM

Well that was just too easy.
Thanks!

dartho

05-23-2010 09:52 PM

to uninstall at the stage it got to, you can manually run the folllowing queries:

ALTER TABLE post DROP mobile
ALTER TABLE thread DROP mobile
ALTER TABLE post DROP ua
ALTER TABLE thread DROP ua

If it is not the 'posted by mobile' part you are after, you can use the initial version

dartho

05-24-2010 04:48 AM

just changed teh install/uninsatll queries, nothing new as such ...

kawe	05-25-2010 12:13 AM

why isn't work for me
i try with FIREFOX USER AGENT
but my forum not direct to MOBILE STYLE MODE ( already install this theme )

tafreeh

05-26-2010 03:24 PM

How do i make MGC CHAT BOX work this mobile skin ?

Kolbi

07-01-2010 08:07 PM

The mod doesn´t work for me either.

There can the issue be?

dartho

07-01-2010 09:43 PM

Delete any references to it in the disable add-ons section.

Kolbi

07-01-2010 10:09 PM

You mean remove everything from: Enter code here to disable addons ?

I have done this but it doesn´t work...

dartho

07-01-2010 10:13 PM

then you need to check with the author of the addon

Kolbi

07-01-2010 10:23 PM

?hm you are the author of the Mobile Style Options AddOn?

This mod doesn?t work for me :)

dartho

07-02-2010 12:45 AM

then uninstall it and see if you can get chatbox working

Kolbi

07-02-2010 06:00 AM

I guess you don?t understand me clearly :)

I haven?t a problem with another AddOn in addition with your mod.

My problem is that all is working very well - except the automated redirecting to the mobile style when I?m visiting the site via a mobilephone.
That?s the issue I have.

dartho

07-02-2010 06:54 AM

Sorry Kolbi, I had mistakenly assumed you were replying to the post by tafreeh :redface:

OK - what is it that isn't working for you?

Kolbi

07-02-2010 07:18 AM

No problem :)

The automated redirecting to the mobile style when I?m visiting the site via a mobilephone.
That?s the issue I have.

You can test it: www.buggy125.de

pant	07-02-2010 07:57 AM

Bugger. This has completely screwed all my styles, what's going on?

Kolbi

07-02-2010 08:05 AM

Rebuild them :)

pant	07-02-2010 08:07 AM

I did, still showing the Dartho header on everything, forum logo has disappeared, Ahhhhhhhh

I did a rebuild through counters in admincp?

dartho

07-02-2010 10:04 AM

Quote:

Originally Posted by Kolbi (Post 2063097)

No problem :)

The automated redirecting to the mobile style when I?m visiting the site via a mobilephone.
That?s the issue I have.

You can test it: www.buggy125.de

This doesn't do that! You need https://vborg.vbsupport.ru/showthread.php?t=226946

dartho

07-02-2010 10:07 AM

Quote:

Originally Posted by pant (Post 2063115)

I did, still showing the Dartho header on everything, forum logo has disappeared, Ahhhhhhhh

I did a rebuild through counters in admincp?

Means you have it configured incorrectly - check teh settings in admincp - particularly the "Mobile Style" setting...

. . .

Actually - I just looked at your site - it lookslike you merged the mobile style into your default style?? Nothing to do with this add-on

Kolbi

07-02-2010 11:09 AM

Thank you @dartho.

Wanted do remove this addon and I get this issue:

Quote:

Datenbankfehler in vBulletin 4.0.3:

Invalid SQL:
ALTER TABLE `post` DROP `mobile`;

MySQL-Fehler : Can't DROP 'mobile'; check that column/key exists
Fehler-Nr. : 1091
Fehler-Zeit : Friday, 02.07.2010 @ 14:08:48
Datum : Friday, 02.07.2010 @ 14:08:48
Skript : /plugin.php?do=productkill
Referrer : /plugin.php?do=productdelete&productid=moboptions40 &s=

pant	07-02-2010 11:16 AM

What a ++++ing run around I had because of this style.

In the end I had to delete the style, uninstall the plug in. Reupload the original vb style.xml to the install folder.

Upload tools.php and then import the default style from that point on my site is now working. Maybe I just threw caution to the wind but I would strongly suggest trying this on a test install before you put it on your live site.

I have no idea why it went so badly wrong for me perhaps there was a conflict somewhere as it seems to work for other people just fine.

cbehan

07-02-2010 01:31 PM

I'm having a couple problems with this style.

1. at the top of the screen we get " {$vbulletin->options['mo37_home_link_text']} "
2. The advertising in the footer still appears, but the header ad is gone. I need to get rid of both ads for the style.

dartho

07-02-2010 09:59 PM

@cbehan - Point 1 is a bug in the style, edit the navbar template in the mobile style and replace

Quote:

<a class="navbar" href="{vb:raw $vbulletin->options['mo37_navbar_home']}{vb:raw session.sessionurl_q}">{$vbulletin->options['mo37_home_link_text']}</a>

with

Quote:

<a class="navbar" href="{vb:raw vboptions.mo37_navbar_home}{vb:raw session.sessionurl_q}">{vb:raw vboptions.mo37_home_link_text}</a>

For point 2 edit the footer template and remove the ad hook. Also see this post for another bug fix in the style

@pant - sounds like you merged the mobile style into your master style and overwrote it, never a good idea! Sorry, but that's a user error.

@Kolbi - On sites with large post tables in their DB, there were time outs installing this addon due to a DB update on teh post table. If thius timeout, those columns (mobile, ua) won;t be there and so this error can be ignored - did it remove the add-on otherwise? You can double check for 'ua' and 'mobile' columns in your 'post' and 'thread' tables to check.

pant	07-02-2010 10:55 PM

Quote:

Originally Posted by dartho (Post 2063456)

@pant - sounds like you merged the mobile style into your master style and overwrote it, never a good idea! Sorry, but that's a user error.

I was careful to select no parent, unless I did something else wrong?

Problems occurred when I installed the plugin if you have any ideas about that?

Although what you say rings true, Hmmmmmmm

dartho

07-02-2010 11:16 PM

I've done it myself in the past :o

pant	07-03-2010 08:10 AM

<font size="3">maybe Put A Super Big Warning</font>

PreciseDemise

07-19-2010 01:48 PM

Is there any possibility of adding support for the automatic selection of theme based on an Header script to detect Browser type?

I would love to get this theme & add-on set up for 'my' site, however, having to manually select theme each time I switch from my Pré to my Laptop, is putting me off. If this could be automated based on which device I'm using ... that would be just WOW!

dartho

07-19-2010 09:15 PM

I've done this as a seperate product. See here: https://vborg.vbsupport.ru/showthread.php?t=226946 And yes, it works with vb 4.0, alternatively you could set up a mobile.domainname.com scenario with help from : https://vborg.vbsupport.ru/showthread.php?t=174381

Gursimran

07-22-2010 01:24 PM

Hello, after installing this mod... my home link got damaged

it is showing {$vbulletin->options['mo37_home_link_text']}

EDIT: fixed.... by reading this post

Afsoul

08-11-2010 10:14 AM

Is there any demo to see this style???
If we open the forum using this style via mobile then automatic using this style???
Sry, I ask to much, I'm newbie here, thx for the understanding :)

All times are GMT. The time now is 04:23 PM.

Page 4 of 5

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01341 seconds Memory Usage 1,830KB 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 (4)bbcode_code_printable (1)bbcode_html_printable (9)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 (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: