Log in

View Full Version : Help: db error installing helpcenter


ka99
02-19-2017, 05:25 PM
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_admin.php?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

Dave
02-19-2017, 05:30 PM
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.

ka99
02-19-2017, 05:35 PM
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.

Dr.CustUmz
02-19-2017, 10:04 PM
Should work a ok for ya now =)

Uninstall the old one first and re upload all files

ka99
02-19-2017, 11:18 PM
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