help need again please

[ninjamaster]

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]

run this query

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]

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]

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

[ninjamaster]

in php myadmin

[Lynne]

Try:

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]

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]

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]

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]

Originally Posted by ForceHSS

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

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.