vb.org Archive
Page 12 of 125 « First 21011 12 13142262112 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Miscellaneous Hacks - Live Topic (https://vborg.vbsupport.ru/showthread.php?t=201228)

AcidX 01-13-2009 09:44 AM
1 Attachment(s)
I got a DB Error when importing the product:

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:
ALTER TABLE `postforumv_` ADD `lastedit` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `dateline`;

MySQL Error  : Table 'web1_db1.postforumv_' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, January 13th 2009 @ 12:41:33 PM
Error Date    : Tuesday, January 13th 2009 @ 12:41:33 PM
Script        : http://forum.kajgana.com/admincp/plugin.php?do=productimport
Referrer      : http://forum.kajgana.com/admincp/plugin.php?do=productadd
IP Address    : xx.xx.xx.xx
Username      : Acid
Classname    : vB_Database_MySQLi
MySQL Version : 5.0.22
You have a problem in the installer.
In all the hurry, I suppouse you made a mistake in the ALTER tables command and PREFIX positions... Lemme fix it :)

Edit: Fixed! (not entirely, don't download)
Attachment 92524

Edit2: Note that the product install proccess might take a while..
Since "`post" is the largest table in the forum - it takes a while untill the SQL changes take effect.

Edit3: Works like a charm so far! :)

Edit4: Post editing doesn't work. There's a new DB Error... I'll try to fix it now.
I suggest that you don't need to rush and install the new version yet, untill Coders Shack updates the installer.

Final edit:
Done! I've got all the errors in the installer fixed. Post editing works too.
If you want to, you can download and test the product untill Coders Shack posts the final version.
Attachment 92528

Anyways, how do I translate this text? Do I have to edit livetopic.js?
Attachment 92527

christicehurst 01-13-2009 12:04 PM
I was the first person to say this would be a big mod and looks like I was right. Good update, keep it up!

AcidX 01-13-2009 12:58 PM
Ideas for 1.03b:

Limit the modification to certain forums (or threads) only.
- I'm not sure if this is possible, but it's worth a try.

Make the page scroll down along with new posts.
- When I'm typing in the QuickReply editor and a new post arrives - the editor goes bellow and I can't see the text. I think the page focus should go to the QR editor, not the latest post.

nascartr 01-13-2009 01:45 PM
So does anyone have any issues with Coders Shack update or should I download AcidX's fix?

KevinL 01-13-2009 01:48 PM
I downloaded it and then used AcidX's fix. Worked mint.

Vinyljunky 01-13-2009 01:50 PM
Am I right in thinking this wont work with vB Optimise 1.3.2 ?

I ask because this mod doesnt seem to be working for me :confused:


Thanks

VJ

KevinL 01-13-2009 01:52 PM
Quote:
Originally Posted by Vinyljunky (Post 1710972)
Am I right in thinking this wont work with vB Optimise 1.3.2 ?

I ask because this mod doesnt seem to be working for me :confused:


Thanks

VJ
Works fine with it

Coders Shack 01-13-2009 02:10 PM
ohh man :( lol

sorry about that... GAH

Coders Shack 01-13-2009 02:22 PM
Quote:
Originally Posted by AcidX (Post 1710788)
I got a DB Error when importing the product:

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:
ALTER TABLE `postforumv_` ADD `lastedit` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `dateline`;

MySQL Error  : Table 'web1_db1.postforumv_' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, January 13th 2009 @ 12:41:33 PM
Error Date    : Tuesday, January 13th 2009 @ 12:41:33 PM
Script        : http://forum.kajgana.com/admincp/plugin.php?do=productimport
Referrer      : http://forum.kajgana.com/admincp/plugin.php?do=productadd
IP Address    : xx.xx.xx.xx
Username      : Acid
Classname    : vB_Database_MySQLi
MySQL Version : 5.0.22
You have a problem in the installer.
In all the hurry, I suppouse you made a mistake in the ALTER tables command and PREFIX positions... Lemme fix it :)

Edit: Fixed! (not entirely, don't download)
Attachment 92524

Edit2: Note that the product install proccess might take a while..
Since "`post" is the largest table in the forum - it takes a while untill the SQL changes take effect.

Edit3: Works like a charm so far! :)

Edit4: Post editing doesn't work. There's a new DB Error... I'll try to fix it now.
I suggest that you don't need to rush and install the new version yet, untill Coders Shack updates the installer.

Final edit:
Done! I've got all the errors in the installer fixed. Post editing works too.
If you want to, you can download and test the product untill Coders Shack posts the final version.
Attachment 92528

Anyways, how do I translate this text? Do I have to edit livetopic.js?
Attachment 92527
so what was the issue with post editing?

AcidX 01-13-2009 02:24 PM
Quote:
Originally Posted by Coders Shack (Post 1710994)
ohh man :( lol

sorry about that... GAH

let me fix that an also phrase it
Sure. Just download mine's lol :D
Quote:
Originally Posted by Coders Shack (Post 1710994)
so after everything how was the serverload?
I can't tell yet. It needs some testing period... Usually it's around 1.5, and now it's going from 1.7 to 2.7. But, all users seem to be playing with it (chatting), so that might be the reason why the load raised...

Also, if you're administrating a large board as mine, I suggest you turn of your forum while importing the product - because it take a minute or two while editing the "post" table. I also need to mention that the load went from 1.5 to 36 while I was importing the product! :)


All times are GMT. The time now is 04:19 AM.
Page 12 of 125 « First 21011 12 13142262112 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.01862 seconds
  • Memory Usage 1,751KB
  • 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
  • (4)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