Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2017, 05:25 PM
ka99 ka99 is offline
 
Join Date: Aug 2005
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help: db error installing helpcenter

Hi

I'm trying to install the product help center https://vborg.vbsupport.ru/showthread.php?t=176367

but after uploading the product the tables arent created in the db, I get the error:

=====================
Database error in vBulletin 3.8.9:

Invalid SQL:
SELECT * FROM helpcenter_department ORDER BY displayorder;

MySQL Error : Table 'db_vb3.helpcenter_department' doesn't exist
Error Number : 1146
Request Date : Sunday, February 19th 2017 @ 10:21:27 PM
Error Date : Sunday, February 19th 2017 @ 10:21:27 PM
Script : http://xxx/vb/admincp/helpcenter_adm...do=departments
Referrer : http://xxx/vb/admincp/index.php?do=nav
IP Address : 188.153.230.15
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.6.35-log
=====================

I looked at the db using phpmyadmin and didnt find the tables

how can I create the required tables ?

Thanks for the help
Attached Files
File Type: xml product-helpcenter.xml (45.4 KB, 1 views)
Reply With Quote
  #2  
Old 02-19-2017, 05:30 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well the plugin was made 9 years ago for vBulletin 3.7.*, you're trying to install it on the most recent vBulletin 3 version, no wonder it doesn't work.

You can check the installation XML files for the table structures.
Reply With Quote
  #3  
Old 02-19-2017, 05:35 PM
ka99 ka99 is offline
 
Join Date: Aug 2005
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dave View Post
Well the plugin was made 9 years ago for vBulletin 3.7.*, you're trying to install it on the most recent vBulletin 3 version, no wonder it doesn't work.

You can check the installation XML files for the table structures.
I tried, compared it with other products installed successfully but couldnt find a way to fix it

hope someone can help checking the xml and tell me how to create the tables

Thanks.
Reply With Quote
  #4  
Old 02-19-2017, 10:04 PM
Dr.CustUmz's Avatar
Dr.CustUmz Dr.CustUmz is offline
 
Join Date: Aug 2013
Location: USA
Posts: 647
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Should work a ok for ya now =)

Uninstall the old one first and re upload all files
Attached Files
File Type: zip HelpCenterVB.zip (20.0 KB, 6 views)
Reply With Quote
2 благодарности(ей) от:
ka99, MarkFL
  #5  
Old 02-19-2017, 11:18 PM
ka99 ka99 is offline
 
Join Date: Aug 2005
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dr.CustUmz View Post
Should work a ok for ya now =)

Uninstall the old one first and re upload all files
THANKS a million!!

have been fighting with different versions since yesterday with no luck

appreciate your help
Reply With Quote
2 благодарности(ей) от:
Dr.CustUmz, MarkFL
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:59 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05940 seconds
  • Memory Usage 2,226KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (4)post_thanks_box_bit
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (2)postbit_attachment
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete