vb.org Archive
Page 13 of 19 « First 31112 13 1415 Last »
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?


All times are GMT. The time now is 08:42 PM.
Page 13 of 19 « First 31112 13 1415 Last »
Show 40 post(s) from this thread on one page

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.01243 seconds
  • Memory Usage 1,747KB
  • 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
  • (3)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
  • (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