Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #16  
Old 19 Aug 2013, 21:01
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Try:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If that works, you are going to have to do that for all tables created in the modification where the engine type is specified.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #17  
Old 19 Aug 2013, 21:24
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Do it from inside admincp but first make sure you add your userid to config file so you can run them

Thx lynne but mine works in admincp as well. Just taking what is in the script as it was writen wrong
Reply With Quote
  #18  
Old 19 Aug 2013, 21:33
ninjamaster's Avatar
ninjamaster ninjamaster is offline
 
Join Date: Oct 2006
Now Iam getting this message

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT userid, username, description, title, type, pot, noplayers, id, status, freeslots FROM tmnt_tmnts ORDER BY id DESC LIMIT 0, 5;

MySQL Error : Table 'the1234_forum.tmnt_tmnts' doesn't exist
Error Number : 1146
Request Date : Monday, August 19th 2013 @ 09:28:00 PM
Error Date : Monday, August 19th 2013 @ 09:28:00 PM
Script : http://XXXXXXXXXXXXXXXXX/forum/competitions.php
Referrer : http://XXXXXXXXXXXXXXXXX/forum/index.php
IP Address : XXXXXXXX
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.5.30-cll
Reply With Quote
  #19  
Old 19 Aug 2013, 23:04
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Will put up a test forum same version as you, to test it. You seem to be having too many problems

--------------- Added 19 Aug 2013 at 23:51 ---------------

I have tested this plugin on a new install same version you are using and it installs without a problem.

Last edited by ForceHSS; 19 Aug 2013 at 23:41.
Reply With Quote
  #20  
Old 20 Aug 2013, 00:00
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by ForceHSS View Post
Do it from inside admincp but first make sure you add your userid to config file so you can run them

Thx lynne but mine works in admincp as well. Just taking what is in the script as it was writen wrong
But he may have a different version of MySQL where TYPE has been replaced with ENGINE.

Originally Posted by ninjamaster View Post
Now Iam getting this message

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT userid, username, description, title, type, pot, noplayers, id, status, freeslots FROM tmnt_tmnts ORDER BY id DESC LIMIT 0, 5;

MySQL Error : Table 'the1234_forum.tmnt_tmnts' doesn't exist
Error Number : 1146
Request Date : Monday, August 19th 2013 @ 09:28:00 PM
Error Date : Monday, August 19th 2013 @ 09:28:00 PM
Script : http://XXXXXXXXXXXXXXXXX/forum/competitions.php
Referrer : http://XXXXXXXXXXXXXXXXX/forum/index.php
IP Address : XXXXXXXX
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.5.30-cll
You are getting that after running the query I posted or what? If changing it to ENGINE worked, then as I said, you will need to do this for all the queries where the engine is specified.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #21  
Old 20 Aug 2013, 01:11
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Originally Posted by ninjamaster View Post
Now Iam getting this message

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT userid, username, description, title, type, pot, noplayers, id, status, freeslots FROM tmnt_tmnts ORDER BY id DESC LIMIT 0, 5;

MySQL Error : Table 'the1234_forum.tmnt_tmnts' doesn't exist
Error Number : 1146
Request Date : Monday, August 19th 2013 @ 09:28:00 PM
Error Date : Monday, August 19th 2013 @ 09:28:00 PM
Script : http://XXXXXXXXXXXXXXXXX/forum/competitions.php
Referrer : http://XXXXXXXXXXXXXXXXX/forum/index.php
IP Address : XXXXXXXX
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.5.30-cll
Who you hosting with? On another note you would be best to talk to the coder of this mod where the mod is posted. Enough has been said in this topic.
Reply With Quote
  #22  
Old 20 Aug 2013, 01:37
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
If any use to you here is the sql with all the security changes done. You might have to run one at a time I have done this from navicat
Attached Files
File Type: zip vB_Tournaments+Ladders.sql.zip (1.4 KB, 1 views)
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 09:45.

Layout Options | Width: Wide Color: