Forum Display Enhancements - Mobile Style Options 4.0

This is an add-on for the 4.0 version of my Mobile style. If you do not have this style installed, it is of no use to you!

It adds options to your vBulletin Options for customizing:

• Optionally adds links to default style (in footer or navbar)
• Optionally add 'Posted Via Mobile' message to new posts/threads (message can be customised)
• Optionally display "What's Going On" box in forum home
• Optionally display Style Chooser in footer
• Set 'Home' link URL (rather than editing templates)
• Can hide mobile style from Style Chooser

Install the latest Mobile style (should have same version number as this addon, but may have a different alpha char on end of version number)

Install this add-on and set your options

Version History
1.0.1 - Initial Release port from 3.x
1.0.2 - Fixed up 'Posted via Mobile' options

You can modify how the message displays by editing the "posted_by_mobile_device" template, you could even edit the hook location and have it display above the post

1.0.3 - Reality check for this with issues, no new functionality
1.0.4 - small install change which should stop timeouts on sites with large post tables

[dartho]

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

[ToNetU]

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:

[ 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:

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]

try the 1.0.4 version just posted up

[tafreeh]

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

[ToNetU]

Originally Posted by dartho

try the 1.0.4 version just posted up

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

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]

Originally Posted by ToNetU

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

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]

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]

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]

Originally Posted by dartho

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]

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 -

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?