vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   help need again please (https://vborg.vbsupport.ru/showthread.php?t=301371)

ninjamaster 08-19-2013 11:13 AM
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

nerbert 08-19-2013 12:18 PM
The table name is "announcement". No "s" at the end

snakes1100 08-19-2013 12:28 PM
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 08-19-2013 12:47 PM
hi mate that didnt work i tried it can you still help

snakes1100 08-19-2013 12:49 PM
Post the code for creating the table from that hack.

nerbert 08-19-2013 01:08 PM
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 08-19-2013 01:13 PM
@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 08-19-2013 01:46 PM
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 08-19-2013 02:36 PM
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 08-19-2013 03:23 PM
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 08-19-2013 06:20 PM
hi guys thanks for the help here is the link for the mod i am having problems with thanks


https://vborg.vbsupport.ru/showthrea...amp%3B+Ladders

ForceHSS 08-19-2013 07:17 PM
run this query
Code:
CREATE TABLE `tmnt_announcements` (
 `id` int(11) NOT NULL auto_increment,
 `title` varchar(50) NOT NULL default '',
 `announcement` text NOT NULL,
 `userid` int(10) NOT NULL,
 `time` int(10) NOT NULL,
 `ip` varchar(50) NOT NULL,
 `le_userid` int(10) NOT NULL,
 `le_time` int(10) NOT NULL,
 `le_ip` varchar(50) NOT NULL,
 PRIMARY KEY  (`id`)
) TYPE=MyISAM;

ninjamaster 08-19-2013 07:39 PM
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 08-19-2013 07:40 PM
It works for me. Where did you run the query from

ninjamaster 08-19-2013 07:56 PM
in php myadmin

Lynne 08-19-2013 08:01 PM
Try:
Code:
CREATE TABLE `tmnt_announcements` (
 `id` int(11) NOT NULL auto_increment,
 `title` varchar(50) NOT NULL default '',
 `announcement` text NOT NULL,
 `userid` int(10) NOT NULL,
 `time` int(10) NOT NULL,
 `ip` varchar(50) NOT NULL,
 `le_userid` int(10) NOT NULL,
 `le_time` int(10) NOT NULL,
 `le_ip` varchar(50) NOT NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM;
If that works, you are going to have to do that for all tables created in the modification where the engine type is specified.

ForceHSS 08-19-2013 08:24 PM
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

ninjamaster 08-19-2013 08:33 PM
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

ForceHSS 08-19-2013 10:04 PM
Will put up a test forum same version as you, to test it. You seem to be having too many problems

--------------- Added [DATE]1376956313[/DATE] at [TIME]1376956313[/TIME] ---------------

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

Lynne 08-19-2013 11:00 PM
Quote:
Originally Posted by ForceHSS (Post 2439830)
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.

Quote:
Originally Posted by ninjamaster (Post 2439831)
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.

ForceHSS 08-20-2013 12:11 AM
Quote:
Originally Posted by ninjamaster (Post 2439831)
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.

ForceHSS 08-20-2013 12:37 AM
1 Attachment(s)
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


All times are GMT. The time now is 05:20 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01978 seconds
  • Memory Usage 1,770KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (22)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete