vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=301371

help need again please
by ninjamaster
19 Aug 2013 12:13

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

nerbert 19 Aug 2013 13:18

The table name is "announcement". No "s" at the end

snakes1100 19 Aug 2013 13:28

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.

ninjamaster 19 Aug 2013 13:47

hi mate that didnt work i tried it can you still help

snakes1100 19 Aug 2013 13:49

Post the code for creating the table from that hack.

nerbert 19 Aug 2013 14:08

Quote:

Originally Posted by snakes1100 (Post 2439717)
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.

snakes1100 19 Aug 2013 14:13

@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"

nerbert 19 Aug 2013 14:46

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.

Lynne 19 Aug 2013 15:36

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.

ForceHSS 19 Aug 2013 16:23

Quote:

Originally Posted by ninjamaster (Post 2439700)
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

ninjamaster 19 Aug 2013 19:20

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

ForceHSS 19 Aug 2013 20:17

run this query

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


ninjamaster 19 Aug 2013 20:39

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

ForceHSS 19 Aug 2013 20:40

It works for me. Where did you run the query from

ninjamaster 19 Aug 2013 20:56

in php myadmin


All times are GMT. The time now is 02:46.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.