Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Aug 2013, 12:13
ninjamaster's Avatar
ninjamaster ninjamaster is offline
 
Join Date: Oct 2006
help need again please

HI CAN ANY ONE HELP PLEASE I tryed installing this about 8 times and still get the same message

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT id, title FROM tmnt_announcements ORDER BY id DESC LIMIT 0, 5;

MySQL Error : Table 'thekarat_forum.tmnt_announcements' doesn't exist
Error Number : 1146
Request Date : Saturday, August 17th 2013 @ 04:17:24 PM
Error Date : Saturday, August 17th 2013 @ 04:17:24 PM
Script : http://XXXXXXXXXXXXXX/forum/competitions.php
Referrer : http://XXXXXXXXXXXX/forum/index.php
IP Address : XXXXXXX
Username : ninja
Classname : vB_Database
MySQL Version : 5.5.30-cll
Reply With Quote
  #2  
Old 19 Aug 2013, 13:18
nerbert nerbert is offline
 
Join Date: May 2008
The table name is "announcement". No "s" at the end
Reply With Quote
  #3  
Old 19 Aug 2013, 13:28
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
If the hack you installed isnt creating the table announcements for you, then you need to find out why its not doing it or create it manually via mysql or phpmyadmin, as your running mysql 5.5.xx, that hack may be to old to have the correct syntax for the table creation.
Reply With Quote
  #4  
Old 19 Aug 2013, 13:47
ninjamaster's Avatar
ninjamaster ninjamaster is offline
 
Join Date: Oct 2006
hi mate that didnt work i tried it can you still help
Reply With Quote
  #5  
Old 19 Aug 2013, 13:49
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Post the code for creating the table from that hack.
Reply With Quote
  #6  
Old 19 Aug 2013, 14:08
nerbert nerbert is offline
 
Join Date: May 2008
Originally Posted by snakes1100 View Post
Post the code for creating the table from that hack.
TABLE_PREFIX . 'announcement' is part of the original vB database. It's not a hack.

@ninjamaster: You should now be getting a different error message. There is no "id" field in the table, you need "announcementid" instead of "id" in both places.
Reply With Quote
  #7  
Old 19 Aug 2013, 14:13
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
@nerbert
If you actually read the db error he posted, you would note the referring script isnt a vbulletin script & in fact a hack.

MySQL Error : Table 'thekarat_forum.tmnt_announcements' doesn't exist
Error Number : 1146
Request Date : Saturday, August 17th 2013 @ 04:17:24 PM
Error Date : Saturday, August 17th 2013 @ 04:17:24 PM
Script : http://XXXXXXXXXXXXXX/forum/competitions.php

Kinda a dead give away when the table is called "tmnt_announcements"
Reply With Quote
  #8  
Old 19 Aug 2013, 14:46
nerbert nerbert is offline
 
Join Date: May 2008
competitions.php isn't a standard vB file but I don't know if it's trying to query the forum announcements or some announcements of its own in its own table.

I would assume "tmnt_" is just the normal TABLE_PREFIX for the whole forum.

But maybe you're right and it's supposed to have its own announcements table and the install code didn't create the table.
Reply With Quote
  #9  
Old 19 Aug 2013, 15:36
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Questions/Problems regarding modifications/styles need to be asked in the modification/style thread. That is where the support for modification/style is - not out here in the main forums. Please note that if a modification/style is unsupported (or even if it says it is supported), you may be on your own if you chose to install it.
__________________
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
  #10  
Old 19 Aug 2013, 16:23
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Originally Posted by ninjamaster View Post
HI CAN ANY ONE HELP PLEASE I tryed installing this about 8 times and still get the same message

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT id, title FROM tmnt_announcements ORDER BY id DESC LIMIT 0, 5;

MySQL Error : Table 'thekarat_forum.tmnt_announcements' doesn't exist
Error Number : 1146
Request Date : Saturday, August 17th 2013 @ 04:17:24 PM
Error Date : Saturday, August 17th 2013 @ 04:17:24 PM
Script : http://XXXXXXXXXXXXXX/forum/competitions.php
Referrer : http://XXXXXXXXXXXX/forum/index.php
IP Address : XXXXXXX
Username : ninja
Classname : vB_Database
MySQL Version : 5.5.30-cll
Can you link us to the plugin being used
Reply With Quote
  #11  
Old 19 Aug 2013, 19:20
ninjamaster's Avatar
ninjamaster ninjamaster is offline
 
Join Date: Oct 2006
hi guys thanks for the help here is the link for the mod i am having problems with thanks


http://www.vbulletin.org/forum/showt...amp%3B+Ladders
Reply With Quote
  #12  
Old 19 Aug 2013, 20:17
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
run this query

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


Last edited by ForceHSS; 19 Aug 2013 at 20:27.
Reply With Quote
  #13  
Old 19 Aug 2013, 20:39
ninjamaster's Avatar
ninjamaster ninjamaster is offline
 
Join Date: Oct 2006
hi mate did it. and here's the result

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 12
Reply With Quote
  #14  
Old 19 Aug 2013, 20:40
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
It works for me. Where did you run the query from
Reply With Quote
  #15  
Old 19 Aug 2013, 20:56
ninjamaster's Avatar
ninjamaster ninjamaster is offline
 
Join Date: Oct 2006
in php myadmin
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 01:34.

Layout Options | Width: Wide Color: